Basic dataframe operations

Basic dataframe operations

1. Select

(1), select Column

In [11]: df[‘a‘]Out[11]:0   -1.3552631    0.0108882    1.5995833    0.0045654    0.460270Name: a, dtype: float64

(2), select row by label

In [15]: df.loc[1]Out[15]:a    0.010888b   -0.900427c   -0.397198Name: 1, dtype: float64

 

(3) Select row by integer location

In [19]: df.iloc[1]Out[19]:a    0.010888b   -0.900427c   -0.397198Name: 1, dtype: float64

(4) slice rows

In [24]: df[1:3]Out[24]:          a         b         c1  0.010888 -0.900427 -0.3971982  1.599583  0.662713  0.943103

(5) Select rows by Boolean Vector

In [27]: df[df[‘a‘]>0.5]Out[27]:          a         b         c2  1.599583  0.662713  0.943103

2. Delete

In [28]: del df[‘a‘]In [29]: dfOut[29]:          b         c0  1.451534 -0.4977931 -0.900427 -0.3971982  0.662713  0.9431033 -0.505622  1.1569414  0.333584 -1.260798

 

In [32]: df.pop(‘b‘)Out[32]:0    1.4515341   -0.9004272    0.6627133   -0.5056224    0.333584Name: b, dtype: float64In [33]: dfOut[33]:          c0 -0.4977931 -0.3971982  0.9431033  1.1569414 -1.260798

3. insert

In [35]: df[‘e‘]=[‘e‘,‘w‘,‘t‘,‘e‘,‘d‘]In [36]: dfOut[36]:          c  e0 -0.497793  e1 -0.397198  w2  0.943103  t3  1.156941  e4 -1.260798  d