新手提问:使用drop_duplicates去重,出现错误提示

数据原貌见图,提取了所属地区字段,使用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()