Skip to content

Instantly share code, notes, and snippets.

View ShichenXie's full-sized avatar

Shichen ShichenXie

198 followers · 104 following
View GitHub Profile
@ShichenXie
ShichenXie / h2o_xgboost_grid_example.R
Created October 12, 2018 03:40 — forked from ledell/h2o_xgboost_grid_example.R
Demo of how to use grid search on H2O's XGBoost: http://docs.h2o.ai/h2o/latest-stable/h2o-docs/data-science/xgboost.html
library(h2o)
h2o.init()
# Load the HIGGS dataset
train <- h2o.importFile("https://s3.amazonaws.com/erin-data/higgs/higgs_train_10k.csv")
test <- h2o.importFile("https://s3.amazonaws.com/erin-data/higgs/higgs_test_5k.csv")
y <- "response"
x <- setdiff(names(train), y)
family <- "binomial"
@ShichenXie
ShichenXie / mysql-docker.sh
Created September 7, 2018 10:06 — forked from spalladino/mysql-docker.sh
Backup and restore a mysql database from a running Docker mysql container
# Backup
docker exec CONTAINER /usr/bin/mysqldump -u root --password=root DATABASE > backup.sql
# Restore
cat backup.sql | docker exec -i CONTAINER /usr/bin/mysql -u root --password=root DATABASE
@ShichenXie
ShichenXie / Backup, restore postgres in docker container
Created September 7, 2018 10:06 — forked from gilyes/Backup, restore postgres in docker container
Backup/restore postgres in docker container
Backup:
docker exec -t -u postgres your-db-container pg_dumpall -c > dump_`date +%d-%m-%Y"_"%H_%M_%S`.sql
Restore:
cat your_dump.sql | docker exec -i your-db-container psql -Upostgres