DataFrame的空值填充问题，以及由此引发的SettingWithCopy错误？

最新推荐文章于 2024-05-20 15:01:15 发布

weixin_30732825

最新推荐文章于 2024-05-20 15:01:15 发布

阅读量343

点赞数

CC 4.0 BY-SA版权

文章标签： python

原文链接：http://www.cnblogs.com/lyy-totoro/p/6946266.html

本文介绍使用Python Pandas库处理DataFrame中缺失值的方法。通过不同示例演示如何使用fillna()函数填充缺失值，并讨论了使用inplace参数时可能出现的问题及解决办法。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >


dfc = pd.DataFrame({'A': ['aaa', np.nan, 'ccc'], 'B': [1, 2, 3], 'C': [np.nan, np.nan, np.nan], 'D': ['mm', np.nan, 10.0]})
     A  B   C    D
0  aaa  1 NaN   mm
1  NaN  2 NaN  NaN
2  ccc  3 NaN   10

dfc.loc[0][['A']]= 100
SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame
it turns out that assigning to the product of chained indexing has inherently unpredictable results

dfc.loc[0,'A'] = 100
     A  B   C    D
0  100  1 NaN   mm
1  NaN  2 NaN  NaN
2  ccc  3 NaN   10

cc2 = dfc[['A','B']].fillna(0.0,inplace=True)
# SettingWithCopyWarning:
# A value is trying to be set on a copy of a slice from a DataFrame

cc2 = dfc[['A','B']].fillna(0.0) #works, only on copy

cc1 = dfc.loc[:,['A','B']].fillna(0.0,inplace=True)
#  return: None. using .loc indexed to a list of columns won't support inplace operations

dfc.fillna({'A':0, 'C':0}, inplace=True)  #  works
dfc.fillna({x:0 for x in ['A','C']}, inplace=True)  # also works