数据原貌见图,提取了所属地区字段,使用drop_duplicates去重,能够正常运行,但是报错,同时参数变红,请教大神是什么情况?
import pandas as pd
data = pd.read_excel(r'C:\Users\Administrator.SC-202103092248\Desktop\新建文件夹\test\test.xlsx')
print(data)
data1 = data[['所属地区']]
data1.drop_duplicates(subset=['所属地区'],keep='first',inplace=True)
print(data1)
所属地区
0 广州
5 上海
6 深圳
15 兰州
D:\py project\main.py:6: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
data1.drop_duplicates(subset=['所属地区'],keep='first',inplace=True)
data1.drop_duplicates(subset=['所属地区'],keep='first',inplace=True)
改为
data1.drop_duplicates(['所属地区'])
A value is trying to be set on a copy of a slice from a DataFrame
您好,我是有问必答小助手,您的问题已经有小伙伴解答了,您看下是否解决,可以追评进行沟通哦~
如果有您比较满意的答案 / 帮您提供解决思路的答案,可以点击【采纳】按钮,给回答的小伙伴一些鼓励哦~~
ps:问答VIP仅需29元,即可享受5次/月 有问必答服务,了解详情>>>https://vip.csdn.net/askvip?utm_source=1146287632
非常感谢您使用有问必答服务,为了后续更快速的帮您解决问题,现诚邀您参与有问必答体验反馈。您的建议将会运用到我们的产品优化中,希望能得到您的支持与协助!
速戳参与调研>>>https://t.csdnimg.cn/Kf0y
data1 = data[['所属地区']].copy()