尝试在DF的切片副本上设置值的值 [英] Value is tryin to be set on a copy of a slice from DF
本文介绍了尝试在DF的切片副本上设置值的值的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在用熊猫和蟒蛇做一些事情.我有下一个代码
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
试图在DataFrame的切片副本上设置一个值
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"],错误='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的切片副本上设置值的值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文