当我使用带条件的熊猫DataFrame DROP方法时，如何摆脱恼人的警告？

link管理

链接快照平台

输入网页链接，自动生成快照
标签化管理网页链接

相关文章推荐

不羁的书签 · 【pandas基础】--数据拆分与合并 - ...· 2 周前 ·

威武的帽子 · 在 Pandas DataFrame ...· 2 周前 ·

曾经爱过的吐司 · pandas.core.groupby.Da ...· 4 天前 ·

光明磊落的墨镜 · pandas ...· 4 天前 ·

性感的鸵鸟 · pyspark.sql.GroupedDat ...· 4 天前 ·

飘逸的肉夹馍 · 5月16日起，北京公共交通实现“一码通乘”· 3 周前 ·

内向的鞭炮 · 博客來-蠻荒記.1，力破蒼穹· 3 周前 ·

气宇轩昂的硬盘 · ProtectiveClean 5100 ...· 2 月前 ·

失眠的遥控器 · 《死屋：沙皇统治时期的西伯利亚流放制度》电子 ...· 6 月前 ·

豪情万千的板凳 · 聚焦昆虫世界，动画电影《疯狂小世界》定档端午节· 7 月前 ·

from datetime import datetime
df_students_ages = df_students.dropna()
df_students_ages.loc[:, ['birth_year']] = df_students_ages.birthday.apply(lambda x : x.split('-')[0])
#conditional drop
df_students_ages.drop(df_students_ages[df_students_ages.birth_year > '2015'].index, inplace=True)
df_students_ages.drop(df_students_ages[df_students_ages.birth_year < '1920'].index, inplace=True)
df_students_ages.drop(columns='birth_year', inplace=True)
df_students_ages.loc[:, ['birthday']] = df_students_ages.birthday.apply(pd.to_datetime)
def from_dob_to_age(born):
    today = pd.to_datetime(datetime.now().date())
    return today.year - born.year - ((today.month, today.day) < (born.month, born.day))
df_students_ages.loc[:, ['age']] = df_students_ages.birthday.apply(lambda x: from_dob_to_age(x))
df_students_ages.sort_values('age')

~/opt/anaconda3/lib/python3.8/site-packages/pandas/core/indexing.py:659: 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.obj[k] = np.nan
~/opt/anaconda3/lib/python3.8/site-packages/pandas/core/indexing.py:1745: 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
  isetter(ilocs[0], value)
~/opt/anaconda3/lib/python3.8/site-packages/pandas/core/frame.py:4163: 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
  return super().drop(

#conditional drop
df_students_ages.drop(df_students_ages[df_students_ages.birth_year > '2015'].index, inplace=True)
df_students_ages.drop(df_students_ages[df_students_ages.birth_year < '1920'].index, inplace=True)
df_students_ages.drop(columns='birth_year', inplace=True)
df_students_ages.loc[:, ['birthday']] = df_students_ages.birthday.apply(pd.to_datetime)

#conditional drop
df_students_ages = df_students_ages.drop(df_students_ages[df_students_ages.birth_year > '2015'].index, inplace=True)
df_students_ages = df_students_ages.drop(df_students_ages[df_students_ages.birth_year < '1920'].index, inplace=True)
df_students_ages = df_students_ages.drop(columns='birth_year', inplace=True)
df_students_ages = df_students_ages.loc[:, ['birthday']] = df_students_ages.birthday.apply(pd.to_datetime)

from datetime import datetime
# this is what has actually changed
df_students_ages = df_students
df_students_ages.dropna(inplace=True)
# new column creation without .loc
df_students_ages['birth_year'] = df_students_ages.birthday.apply(lambda x : x.split('-')[0])
# dropping inplace
df_students_ages.drop(df_students_ages[df_students_ages.birth_year > '2015'].index, inplace=True)
df_students_ages.drop(df_students_ages[df_students_ages.birth_year < '1920'].index, inplace=True)
df_students_ages = df_students_ages.drop(columns='birth_year')
df_students_ages.birthday = df_students_ages.birthday.apply(pd.to_datetime)
def from_dob_to_age(born):
    today = pd.to_datetime(datetime.now().date())

当我使用带条件的熊猫DataFrame DROP方法时，如何摆脱恼人的警告？ 内容来源于 Stack Overflow，遵循 CC BY-SA 4.0 许可协议进行翻译与使用。IT领域专用引擎提供翻译支持 腾讯云小微IT领域专用引擎提供翻译支持

2 个回答