pandas SettingWithCopy

啥也不会的炼丹师

于 2022-03-06 18:17:44 发布

阅读量842

点赞数

分类专栏：我的文章标签： python

本文链接：https://blog.csdn.net/weixin_43370733/article/details/123314334

版权

我的专栏收录该内容

5 篇文章 1 订阅

订阅专栏

df = pd.DataFrame(np.arange(15).reshape(3, 5), columns=list('ABCDE'))
part_df = df.iloc[:, :3]
part_df.iloc[0, :] = np.zeros(3) #  

# SettingWithCopyWarning: 
# A value is trying to be set on a copy of a slice from a DataFrame.
# Try using .loc[row_indexer,col_indexer] = value instead
# See the caveats in the documentation: https://pandas.pydata.org/pandas
# docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
# self._setitem_single_column(loc, v, pi)

原因在于发生了 chained indexing, 对于part_df的修改并没有作用于df上.
消除warning, 仅需要:

part_df = df.iloc[:, :3].copy()

保证了是对copy的内容进行修改，不作用于原df。

另一个例子：

def do_something(df):
    foo = df[['bar', 'baz']]  # Is foo a view? A copy? Nobody knows!
    # ... many lines here ...
    # We don't know whether this will modify df or not!
    foo['quux'] = value
    return foo

参考文献：

pandas offical document about settingwithcopywarning