zhangpengGenedock’s gists

zhangpengGenedock / mac_listening_port.sh

Created August 17, 2017 07:29

mac listening port

sudo lsof -iTCP -sTCP:LISTEN -n -P

zhangpengGenedock / pandas_drop_dataframe.py

Last active August 17, 2017 06:49

pandas drop nan on specific columns

df.dropna(subset=[1])

zhangpengGenedock / du_calculate_folder_size

Created July 26, 2017 14:47

查看一个文件夹大小

du -h -d=1 .

zhangpengGenedock / process_data_for_kaggle.py

Created July 17, 2017 11:11

process data for kaggle

	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 / open_iterm_in_current_folder

Created July 10, 2017 05:36

open iterm in current folder http://hohonuuli.blogspot.de/2016/02/iterm2-version-3-open-iterm-here-script.html

	(*

	Open Terminal Here

	A toolbar script for Mac OS X 10.3/10.4

	Written by Brian Schlining
	*)

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

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 / gddata_daily_stats_delete_duplicate.js

Created July 7, 2017 04:04

gddata daily stats delete duplicate

	var bulk = db.gddata_daily_stats.initializeOrderedBulkOp(),
	count = 0;

	// List "all" fields that make a document "unique" in the `_id`
	// I am only listing some for example purposes to follow
	db.gddata_daily_stats.aggregate([
	{ "$group": {
	"_id": {
	"account_name" : "$account_name",
	"date": "$date",

zhangpengGenedock / mongodb_remove_duplicates.js

Created July 7, 2017 03:12

mongodb create multi field unique index and remove duplicates

	var bulk = db.testkdd.initializeOrderedBulkOp(),
	count = 0;

	// List "all" fields that make a document "unique" in the `_id`
	// I am only listing some for example purposes to follow
	db.testkdd.aggregate([
	{ "$group": {
	"_id": {
	"duration" : "$duration",
	"protocol_type": "$protocol_type",

zhangpengGenedock / iterm2_execute_pyenv_activate

Created July 5, 2017 08:26

当打开iterm的terminal时，pyenv激活virtualenv


	In iTerm2, preferences>profiles>tab general, there is an option in Command called send text at start that executes any command you put there after login.
	pyenv activate zhangpeng

zhangpeng zhangpengGenedock