写入数据帧中的特定值，而不覆盖 csv

Question

我有一个这样的数据帧：

master_contact_id  Agent_Disposition        QA_Disposition Comments
0           37284773    Not Serviceable       Not Serviceable      NaN
1           37284829  Existing Customer      Customer Service      NaN
2           37284880      Closed - Sale         Closed - Sale      NaN
3           37284887  Existing Customer  Hang up/Disconnected      NaN
4           37284943      Closed - Sale         Closed - Sale      NaN

我正在浏览每个联系人ID，找到特定索引，并编写注释以将" NaN"替换为：

df.at[1, 'Comments'] = "Test Comment"

但是，当我写信给csv时，用

export = df.to_csv('set1_output.csv')

导出的 CSV 会不断覆盖。我希望能够不断附加评论。

Answer 1

如果我正确理解您的问题，您希望将新数据附加到 csv。

创建数据帧的副本，执行操作，将新数组追加到旧数组，然后保存整个副本。

dfcopy = df.copy()
dfcopy.at[1,"Comments"] = "Test Comment"
df.append(dfcopy)
export = df.to_csv('set1_output.csv')