pandas - noypeban/noypeban.github.io GitHub Wiki

read data

csv

pd.read_csv('../input/train.csv')

tsv

pd.read_table('../input/train.tsv')

column

select by dtype

X.select_dtypes(include='object').columns

get column number

df.columns.get_loc('age')

filter

targets = list(df.filter(like='winPlacePerc').columns)

dtype

Change dtype

data['matchType'] = data['matchType'].astype('category')

submit

df.to_csv('submission.csv', index=False)