Skip to main content
 首页 » 编程设计

python之Pandas 数据框到 csv 引号

2025年02月15日13dflying

我尝试使用将 pandas 数据框转换为 csv

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

然后我得到了有 5 列的 csv 文件,第一列是文本,我打开 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

请您参考如下方法:

您需要将quoting=True 添加到dataframe.to_csv,如下所示:

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

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


这是一个完整的例子

import pandas as pd  
from StringIO import StringIO  
 
st = """ 
"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 
""" 
data =pd.read_csv(StringIO(st), delimiter=",", header=None)  
data.to_csv("final_processed.csv", encoding="utf-8", index=False, quoting=True) 

输出看起来像这样:

 "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"