pandas学习过程-01

每天一点点，记录工作中实操可行

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