python pandas DataFrame 数据替换

python pandas DataFrame 替换

import pandas as pd
import numpy as np

df1 = pd.DataFrame(
    {
        '日期': ['2021-7-2', '2021-8-2', '2021-9-2', '2021-10-2'],
        'A': [1, 2, '', 4],
        'B': [5, 6, '', 8],
        'C': [9, 10, np.nan, 12],
        'D': [13, np.nan, 15, 16]
    },
    index=[0, 1, 2, 3])
print(df1)

         日期  A  B     C     D
0   2021-7-2  1  5   9.0  13.0
1   2021-8-2  2  6  10.0   NaN
2   2021-9-2         NaN  15.0
3  2021-10-2  4  8  12.0  16.0

df2 = df1.replace(
    ['', np.nan],  # 替换前的数据
    [0, 0]  # 替换前的数据
)
print(df2)

          日期  A  B     C     D
0   2021-7-2  1  5   9.0  13.0
1   2021-8-2  2  6  10.0   0.0
2   2021-9-2  0  0   0.0  15.0
3  2021-10-2  4  8  12.0  16.0