pandas用法记录

1、多个csv、excel表格进行合并拼接，concat（）函数

df1 = pd.read_csv("F:/xjl_docunment/Graduation_Project/data/201804_ssu/ssu_Mar01_2018.csv",index_col = None)
df2 = pd.read_csv("F:/xjl_docunment/Graduation_Project/data/201804_ssu/ssu_Mar02_2018.csv",index_col = None)
df3 = pd.read_csv("F:/xjl_docunment/Graduation_Project/data/201804_ssu/ssu_Mar03_2018.csv",index_col = None)
df4 = pd.read_csv("F:/xjl_docunment/Graduation_Project/data/201804_ssu/ssu_Mar04_2018.csv",index_col = None)
。。。
frame = [df1,df2,df3,df4,df5,df6,df7,df8,df9,df10,df11,df12,df13,df14,df15,df16,df17,df18,df19,df20,df21,df22]
result = pd.concat(frame)

2、特定标识

TA_SNP_SHP[TA_SNP_SHP['FN_PDI_SN']==17294020]