pandas使用小技巧--那些不为注意的默认参数

1.按行插入

aa =pd.DataFrame([1,2,3])
aa
   0
0  1
1  2
2  3
 

aa.append([4])
   0
0  1
1  2
2  3
0  4
 

aa.append([4],ignore_index=True)
   0
0  1
1  2
2  3
3  4

2.定位到某行某列

aa.at[0,0]

1

3.写入csv不带index和columns

item_similarity.to_csv('./itemsimilarity.csv',header=False,index=False)

4.读取csv不默认第一行为行名

itemsimu = pd.read_csv('DataMining/CollaborativeFiltering/itemsimilarity.csv',header=None)

5.map操作不忽略nan值

s = pd.Series([1, 2, 3, np.nan])

s2 = s.map('this is a string {}'.format, na_action=None)
0    this is a string 1.0
1    this is a string 2.0
2    this is a string 3.0
3    this is a string nan
dtype: object

6.map操作忽略nan值

s3 = s.map('this is a string {}'.format, na_action='ignore')
0    this is a string 1.0
1    this is a string 2.0
2    this is a string 3.0
3                     NaN
dtype: object