关于Pandas的基本用法_04

import numpy as np
import pandas as pd
dates = pd.date_range('20210329',periods=6)
df = pd.DataFrame(np.arange(24).reshape((6, 4)), index=dates,columns=np.array(['a', 'b', 'c' ,'d']))
df.iloc[1,1] = np.nan
df.loc['20210402','a':'d'] = np.nan
print(df)
print(df.dropna(how='any'))
# 删除空数据 how取值为any，all any表示只要有NaN就drop，all表示均为NaN才drop，
# 通过axis来判断是按横向还是竖向进行处理,默认是全部处理
'''
              a     b     c     d
2021-03-29   0.0   1.0   2.0   3.0
2021-03-30   4.0   NaN   6.0   7.0
2021-03-31   8.0   9.0  10.0  11.0
2021-04-01  12.0  13.0  14.0  15.0
2021-04-02   NaN   NaN   NaN   NaN
2021-04-03  20.0  21.0  22.0  23.0
----------------------------------
               a     b     c     d
2021-03-29   0.0   1.0   2.0   3.0
2021-03-30   4.0   NaN   6.0   7.0
2021-03-31   8.0   9.0  10.0  11.0
2021-04-01  12.0  13.0  14.0  15.0
2021-04-03  20.0  21.0  22.0  23