Pandas处理丢失数据

import pandas as pd
import numpy as np
dates = np.arange(20210712, 20210716)
df1 = pd.DataFrame(np.arange(12).reshape(4, 3), index=[dates], columns=['A', 'B', 'C'])
print(df1)
df2 = pd.DataFrame(df1, index=[dates], columns=['A', 'B', 'C', 'D', 'E'])
print(df2)
print()
s1 = pd.Series([3, 4, 6], index=dates[:3])
s2 = pd.Series([32, 5, 2], index=dates[1:])
df2['D'] = s1
df2['E'] = s2
print(df2)  # 填不上值？
print()
print(df2.fillna(value=0))  # 所有的空值都赋值为0
print()
print(df2.isnull())  # 查看哪一个是空值
print(np.any(df2.isnull()))  # 只要有一个或多个空值就会返回真
print(np.all(df2.isnull()))

          A   B   C
20210712  0   1   2
20210713  3   4   5
20210714  6   7   8
20210715  9  10  11
          A   B   C   D   E
20210712  0   1   2 NaN NaN
20210713  3   4   5 NaN NaN
20210714  6   7   8 NaN NaN
20210715  9  10  11 NaN NaN

          A   B   C   D   E
20210712  0   1   2 NaN NaN
20210713  3   4   5 NaN NaN
20210714  6   7   8 NaN NaN
20210715  9  10  11 NaN NaN

          A   B   C    D    E
20210712  0   1   2  0.0  0.0
20210713  3   4   5  0.0  0.0
20210714  6   7   8  0.0  0.0
20210715  9  10  11  0.0  0.0

              A      B      C     D     E
20210712  False  False  False  True  True
20210713  False  False  False  True  True
20210714  False  False  False  True  True
20210715  False  False  False  True  True
True
False