当值不存在时（使用 inplace=T ），从 df 中删除行会引发SettingWithCopyWarning 错误（Pandas、Python）？

发布于 2025-01-16 20:19:35 字数 567 浏览 1 评论 0原文

我试图根据数据帧的特定值删除一些行：

dd = {'ae': pd.DataFrame(dict(a=[1,2,4], b=[4,5,6])),
      'be': pd.DataFrame(dict(a=[13,21,413], b=[456,54,62]))}
def test_remove(dd, val):
      test = dd.get('ae')
      test.drop(test.loc[test['a']==val].index, inplace=True)
test_remove(dd, 24242)

但我收到以下错误：

/Library/Frameworks/Python.framework/Versions/3.9/lib/python3.9/site-packages/pandas/core/frame.py:4906: SettingWithCopyWarning：正在尝试在某个副本上设置一个值从 DataFrame 中切片

请告知这里出了什么问题？我有一个数据帧字典，我试图进入每个数据帧并根据特定的列值删除一行。

原文

I am trying to drop some rows based on a specific value of a dataframe:

dd = {'ae': pd.DataFrame(dict(a=[1,2,4], b=[4,5,6])),
      'be': pd.DataFrame(dict(a=[13,21,413], b=[456,54,62]))}
def test_remove(dd, val):
      test = dd.get('ae')
      test.drop(test.loc[test['a']==val].index, inplace=True)
test_remove(dd, 24242)

But I am getting the following error:

/Library/Frameworks/Python.framework/Versions/3.9/lib/python3.9/site-packages/pandas/core/frame.py:4906:
SettingWithCopyWarning: A value is trying to be set on a copy of a
slice from a DataFrame

Please advise what is wrong here? I have a dictionary of dataframes, I am trying to get into each of them and remove a row based on a specific column value.

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

作死小能手 2025-01-23 20:19:35

与其就地进行删除，不如执行以下操作：

dd = {'ae': pd.DataFrame(dict(a=[1,2,4], b=[4,5,6])),
      'be': pd.DataFrame(dict(a=[13,21,413], b=[456,54,62]))}
def remove_rows(dd, key, val, col):
    dd[key] = dd[key].drop(dd[key].loc[dd[key][col]==val].index)
    return dd
dd = remove_rows(dd, 'ae', 413, 'a')

Rather than doing the remove in place, it would be better to do something like this:

dd = {'ae': pd.DataFrame(dict(a=[1,2,4], b=[4,5,6])),
      'be': pd.DataFrame(dict(a=[13,21,413], b=[456,54,62]))}
def remove_rows(dd, key, val, col):
    dd[key] = dd[key].drop(dd[key].loc[dd[key][col]==val].index)
    return dd
dd = remove_rows(dd, 'ae', 413, 'a')

回复收藏 0 原文

~没有更多了~