Skip to content

Instantly share code, notes, and snippets.

@zhangpengGenedock
zhangpengGenedock / group_gddata_daily_stats_account_name_and_date.js
Created July 7, 2017 07:51
group gddata daily stats account name and date
var match = {
'date': {
'$gte': '2017-06-24',
'$lte': '2017-06-30',
}
}
var group = {
'_id': {'account_name':'$account_name','region':'$region'},
@zhangpengGenedock
zhangpengGenedock / staging_mongo_run_js
Last active July 10, 2017 03:14
staging environment mongo run javascript
mongo --host dds-2ze14d04d8fb07e42.mongodb.rds.aliyuncs.com:3717 --authenticationDatabase admin -u root -p zhihuishe1201 staging-beijing < group.js > result.csv
(*
Open Terminal Here
A toolbar script for Mac OS X 10.3/10.4
Written by Brian Schlining
*)
test_file = 'test.csv'
test_data = pd.read_csv(test_file)
predictions = predictions_3(test_data)
result = open('result.csv', 'w')
for item in predictions:
result.write("%s\n" % item)
@zhangpengGenedock
zhangpengGenedock / du_calculate_folder_size
Created July 26, 2017 14:47
查看一个文件夹大小
du -h -d=1 .
@zhangpengGenedock
zhangpengGenedock / pandas_drop_dataframe.py
Last active August 17, 2017 06:49
pandas drop nan on specific columns
df.dropna(subset=[1])
sudo lsof -iTCP -sTCP:LISTEN -n -P
@zhangpengGenedock
zhangpengGenedock / dataframe_add_column_if_not_exist
Last active August 28, 2017 06:58
dataframe_add_column_if_not_exist
if 'Met' not in df:
df['Met'] = df['freqC'] * df['coverage']
@zhangpengGenedock
zhangpengGenedock / account_support_chinese
Created September 1, 2017 02:35
docker 登入account, 支持中文
docker exec -it account env LANG=C.UTF-8 bash
@zhangpengGenedock
zhangpengGenedock / git_remove_track_of_file
Created September 6, 2017 06:07
remove track of file
git rm --cached config-dev.php && git commit -m "config-dev.php"
echo config-dev.php >> .gitignore
git add .gitignore
git commit -m "adding config-dev.php to .gitignore"