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