Python_DataFrame

Pandas包之DataFrame，类似Excel或SQL中的表。

 

#创建
import pandas as pd
import numpy as np

# numpy.random.rand(m,n) : 从 [ 0,1 )中随机返回 m行 n列个样本
df0=pd.DataFrame(np.random.rand(7,5))      
df0

#创建日期型索引 
dates=pd.date_range('2018-09-01',periods=7) 
dates

Out:
DatetimeIndex(['2018-09-01', '2018-09-02', '2018-09-03', '2018-09-04',
               '2018-09-05', '2018-09-06', '2018-09-07'],
              dtype='datetime64[ns]', freq='D')

df1=pd.DataFrame(np.random.rand(7,5),index=dates)
df1

dct1={'a':1,'b':2,'c':3,'d':4,'e':'foo'}
df2=pd.DataFrame(dct1,index=[0])

df22=pd.DataFrame(dct1,index=['x','y','z'])
df22

dct2={'水果':['苹果','梨','草莓'],'数量':[1,2,3],'价格':[10.2,7.8,30.4]}
dct2

dct4={'水果':pd.Series(['苹果','梨','草莓']),'数量':pd.Series([1,2,3]),'价格':pd.Series([10.2,7.8,30.4])}
df4=pd.DataFrame(dct4)

df5=pd.DataFrame(np.random.randn(3,4),columns=['a','b','c','d'],index=['x','y','z'])
df5