Pandas数据帧到csv报价单m

Question

我试图用

dataframe.to_csv('final_processed.csv', encoding='utf-8', index=False)

然后我得到了一个csv文件，它有5列，第一列是文本，我打开csv文件，发现有些行以第一列的引号开头和结尾，而其他行没有（如下所示）。我想让他们都以引号开头和结尾，我该怎么办？非常感谢。在

"Pt come to ER with chest pain ..... PT/INR and PTT be check at 0324, PT/INR as 92 .5/8 .8 and PTT wa 249.",administer/monitor,notprescribe/order,administer/monitor,notadr

"Patient wa see in office on 05/04/2015 ....... Thi wa catch by another caregiver and report to my clinic manager.",transcribe/prepare/dispense,notprescribe/order,notadminister/monitor,notadr

Multiple medication enter on Med Rec by different provider with inaccurate dose and ......hospital admission,prescribe/order,prescribe/order,notadminister/monitor,notadr

Answer 1

您需要将quoting=True添加到dataframe.to_csv中，如下所示：

dataframe.to_csv('final_processed.csv', encoding='utf-8', index=False, quoting=True)

您可以在官方文档here中找到更多详细信息。在

---

这是一个完全有效的例子

^{pr2}$

输出如下：

 "0","1","2","3","4"
"Pt come to ER with chest pain ..... PT/INR and PTT be check at 0324, PT/INR as 92 .5/8 .8 and PTT wa 249.","administer/monitor","notprescribe/order","administer/monitor","notadr"
"Patient wa see in office on 05/04/2015 ....... Thi wa catch by another caregiver and report to my clinic manager.","transcribe/prepare/dispense","notprescribe/order","notadminister/monitor","notadr"
"Multiple medication enter on Med Rec by different provider with inaccurate dose and ......hospital admission","prescribe/order","prescribe/order","notadminister/monitor","notadr"