新手提问：使用drop_duplicates去重，出现错误提示

Question

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

 

Answer 1

data1.drop_duplicates(subset=['所属地区'],keep='first',inplace=True)

改为

data1.drop_duplicates(['所属地区'])