2018/7/8 pandas学习笔记

DataFrame

In [6]: from pandas import Series,DataFrame

In [7]: frame = DataFrame(data)

In [8]: frame
Out[8]:
   pop   state  year
0  1.5    Ohio  2000
1  1.7    Ohio  2001
2  3.6    Ohio  2002
3  2.4  Nevada  2001
4  2.9  Nevada  2002

In [9]: DataFrame(data,columns=['year','state','pop'])   指定列的顺序，但并不改变本身的顺序
Out[9]:
   year   state  pop
0  2000    Ohio  1.5
1  2001    Ohio  1.7
2  2002    Ohio  3.6
3  2001  Nevada  2.4
4  2002  Nevada  2.9

In [10]: frame
Out[10]:
   pop   state  year
0  1.5    Ohio  2000
1  1.7    Ohio  2001
2  3.6    Ohio  2002
3  2.4  Nevada  2001
4  2.9  Nevada  2002

In [11]: frame2 = DataFrame(data,columns=['year','state','pop','debt'],index=['one','two','three','four','five'])
                                                                不存在的列为NA值
In [12]: frame2
Out[12]:
       year