python開發筆記-DataFrame的使用

   今天詳細做下關于DataFrame的使用，以便以後自己可以翻閱檢視

   DataFrame的基本特征：

1、是一個表格型資料結構

2、含有一組有序的列

3、大緻可看成共享同一個index的Series集合

import pandas as pd  
>>> data={'name':['Wangdachui','Linling','Niuyun'],'pay':[4000,5000,6000]}  
>>> frame=pd.DataFrame(data)  
>>> frame  
         name   pay  
0  Wangdachui  4000  
1     Linling  5000  
2      Niuyun  6000  
           

　　

import pandas as pd  
>>> import numpy as np  
>>> data=np.array([('Wangdachui',4000),('Linling',5000),('Niuyun',6000)])  
>>> frame=pd.DataFrame(data,index=range(1,4),columns=['name','pay'])  
>>> frame  
         name   pay  
1  Wangdachui  4000  
2     Linling  5000  
3      Niuyun  6000  
>>> frame.index  
RangeIndex(start=1, stop=4, step=1)  
>>> frame.columns  
Index(['name', 'pay'], dtype='object')  
>>> frame.values  
array([['Wangdachui', '4000'],  
       ['Linling', '5000'],  
       ['Niuyun', '6000']], dtype=object)  
           

　　

frame.index=[2,4,6]  
>>> frame  
         name   pay  
2  Wangdachui  4000  
4     Linling  5000  
6      Niuyun  6000  　　
           

DataFrame的基本操作

· 取DataFrame對象的行和列可獲得Series：

frame['name']  
2    Wangdachui  
4       Linling  
6        Niuyun  
Name: name, dtype: object  
>>> frame.pay  
2    4000  
4    5000  
6    6000  
Name: pay, dtype: object  
>>> frame.iloc[:2,1]  
2    4000  
4    5000  
Name: pay, dtype: object  
           

　　DataFrame對象的修改和删除：

frame['name']='admin'  
>>> frame  
    name   pay  
2  admin  4000  
4  admin  5000  
6  admin  6000  
>>> del frame['pay']  
>>> frame  
    name  
2  admin  
4  admin  
6  admin  
           

　　DataFrame的統計功能

import pandas as pd  
>>> import numpy as np  
>>> data=np.array([('Wangdachui',4000),('Linling',5000),('Niuyun',6000)])  
>>> frame=pd.DataFrame(data,index=range(1,4),columns=['name','pay'])  
>>> frame  
         name   pay  
1  Wangdachui  4000  
2     Linling  5000  
3      Niuyun  6000  
>>> frame.pay.min()  
'4000'  
           

　　

frame[frame.pay>='5000']  
      name   pay  
2  Linling  5000  
3   Niuyun  6000  
           

　　

轉載于:https://www.cnblogs.com/68xi/p/8564485.html