每天一点点,记录工作中实操可行
pandas学习过程-01
1:导入库
import numpy as np
import pandas as pd
2.1:生成对象:用值列表生成Series时,pandas默认自动生成整数索引
s = pd.Series([1,3,5,np.nan,6,8])
s
Out[74]:
0 1.0
1 3.0
2 5.0
3 NaN
4 6.0
5 8.0
dtype: float64
2.2 用含日期时间索引与标签的NumPy数组生成DataFrame
dates = pd.date_range('20200101',periods=6)
dates
Out[75]:
DatetimeIndex(['2020-01-01', '2020-01-02', '2020-01-03', '2020-01-04','2020-01-05', '2020-01-06'],
dtype='datetime64[ns]', freq='D')
以上边日期为行,ABCD为列,随机生成6行4列的DataFrame
df = pd.DataFrame(np.random.randn(6,4),index=dates,columns=list('ABCD'))
df
Out[77]:
A B C D
2020-01-01 -0.186522 -0.110911 -0.677208 -1.510193
2020-01-02 -1.037148 0.848960 -0.248920 -0.424194
2020-01-03 -0.307357 0.057476 -0.492490 0.842967
2020-01-04 -0.0