pandas内容df.fillna()NaN转换
NaN转0 df.fillna(0)
import numpy as npimport pandas as pd# 全部列df = df.fillna(0)df.fillna(0, inplace=True)# 2句区别是新增与不新增# 指定列trans={"A":9,"B":8,"C":7,"D":6}df.fillna(value=trans)
data_df = pd.DataFrame(data=[{"A":"bike", "B":"bike"},{"A":"car", "B":np.nan},{"A":"bus", "B":np.nan}])
|
A |
B |
| 0 |
bike |
bike |
| 1 |
car |
NaN |
| 2 |
bus |
NaN |
df = df.fillna(0)
|
A |
B |
| 0 |
bike |
bike |
| 1 |
car |
0 |
| 2 |
bus |
0 |
B列NAN空值由A列填补
data_df["B"].fillna(data_df["A"], inplace=True)
data_df = pd.DataFrame(data=[{"A":"bike", "B":"bike"},{"A":"car", "B":np.nan},{"A":"bus", "B":np.nan}])
|
A |
B |
| 0 |
bike |
bike |
| 1 |
car |
NaN |
| 2 |
bus |
NaN |
data_df["B"].fillna(data_df["A"], inplace=True)
|
A |
B |
| 0 |
bike |
bike |
| 1 |
car |
car |
| 2 |
bus |
bus |
-NaN%E8%BD%AC%E6%8D%A2.png&w=3840&q=85)