dataframe操作

目录

dataframe操作

dataframe连接

去重复

---

dataframe操作

dataframe连接

>>> a = np.zeros((3,4))
>>> b = np.ones((3,4))
>>> d= pd.DataFrame(a)
>>> d
     0    1    2    3
0  0.0  0.0  0.0  0.0
1  0.0  0.0  0.0  0.0
2  0.0  0.0  0.0  0.0
>>> e = pd.DataFrame(b)
>>> e
     0    1    2    3
0  1.0  1.0  1.0  1.0
1  1.0  1.0  1.0  1.0
2  1.0  1.0  1.0  1.0
>>> pd.concat([d,e])
     0    1    2    3
0  0.0  0.0  0.0  0.0
1  0.0  0.0  0.0  0.0
2  0.0  0.0  0.0  0.0
0  1.0  1.0  1.0  1.0
1  1.0  1.0  1.0  1.0
2  1.0  1.0  1.0  1.0
>>> pd.concat([d,e], axis=1)
     0    1    2    3    0    1    2    3
0  0.0  0.0  0.0  0.0  1.0  1.0  1.0  1.0
1  0.0  0.0  0.0  0.0  1.0  1.0  1.0  1.0
2  0.0  0.0  0.0  0.0  1.0  1.0  1.0  1.0

去重复

>>> import pandas as pd
>>> df=pd.DataFrame({'a':['dog']*3+['fish']*3+['dog'],'b':[10,10,12,12,14,14,10]})
>>> df
      a   b
0   dog  10
1   dog  10
2   dog  12
3  fish  12
4  fish  14
5  fish  14
6   dog  10
>>> df.duplicated()
0    False
1     True
2    False
3    False
4    False
5     True
6     True
dtype: bool
>>> df.drop_duplicates()
      a   b
0   dog  10
2   dog  12
3  fish  12
4  fish  14
>>> df.drop_duplicates(['a'])
      a   b
0   dog  10
3  fish  12