Value is tryin to be set on a copy of a slice from DF(试图在来自 DF 的切片副本上设置值)
问题描述
我正在用 pandas 和 python 做一些事情.我有下一个代码
I´m doing some stuff with pandas and python. I have the next code
df = pd.read_csv("Request.csv", keep_default_na=False)
df1 = df.loc[(df["Request Status"] == "Closed")]
df1["Request Close-Down Actual"] = pd.to_datetime(df1["Request Close-Down Actual"], errors = 'coerce' )
df3 = df1.loc[(df1["Request Close-Down Actual"] < '2016-11-01') | (df1["Request Close-Down Actual"].isnull())]
df3.set_index("Request ID", inplace = True)
df3.to_csv("Request1.csv")
问题是当我运行代码时,我会收到下一个问题
The issue is when i run the code i receive the next issue
试图在数据帧的切片副本上设置值
A value is trying to be set on a copy of a slice from a DataFrame
df1.loc[请求关闭实际"] = pd.to_datetime(df1[请求Close-Down Actual"], errors = 'coerce')
df1.loc["Request Close-Down Actual"] = pd.to_datetime(df1["Request Close-Down Actual"], errors = 'coerce' )
请有人帮我解决这个问题.谢谢
Can someone give me a hand with this please. Thanks
推荐答案
我测试了它,对我来说效果很好.
I test it and for me it works nice.
问题应该在上面一行:
df1 = df.loc[(df["Request Status"] == "Closed")]
解决方案是 copy代码>:
And solution is copy:
#loc is not necessary
df1 = df[df["Request Status"] == "Closed"].copy()
<小时>
错误显示 loc - 如果需要选择列,请尝试删除它:
Error show loc - try remove it if need select column:
df1.loc["Request Close-Down Actual"] = pd.to_datetime(df1["Request Close-Down Actual"], errors = 'coerce' )
到:
df1["Request Close-Down Actual"] = pd.to_datetime(df1["Request Close-Down Actual"], errors = 'coerce' )
这篇关于试图在来自 DF 的切片副本上设置值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持编程学习网!
本文标题为:试图在来自 DF 的切片副本上设置值
基础教程推荐
- 尝试制作WhatsApp机器人 2022-01-01
- 在 Celery 工作人员中捕获 Heroku SIGTERM 以优雅地关 2022-01-01
- 使用生成器和迭代器时 Python 多循环失败 2022-01-01
- pyserial - 可以从线程 a 写入串行端口,是否阻塞从线程 b 读取? 2022-01-01
- 将 x 轴刻度更改为自定义字符串 2022-01-01
- 与常规 dict 相比,Python manager.dict() 非常慢 2022-01-01
- 由Python将MP3转换为MIDI(类型错误:无法加载插件:mtg-Melodia:Melodia) 2022-01-01
- Discord.py 缺少必需的参数 2022-01-01
- 用 Python 编写 Fortran 无格式文件 2022-01-01
- numpy float:比算术运算中内置的慢 10 倍? 2022-01-01
