如何在Pandas中读取带有引号和逗号的CSV文件？

Question

我有一个这样的数据集：

ISIN,"MIC","Datum","Open","Hoog","Laag","Close","Number of Shares","Number of Trades","Turnover","Valuta"
NL0011821202,"Euronext Amsterdam Brussels","04/09/2017","14.82","14.95","14.785","14.855","7482805","6970","111345512.83","EUR"
NL0011821202,"Euronext Amsterdam Brussels","05/09/2017","14.91","14.92","14.585","14.655","15240971","12549","224265257.14","EUR"
NL0011821202,"Euronext Amsterdam Brussels","07/09/2017","14.69","14.74","14.535","14.595","15544695","15817","227478163.74","EUR"

但是我不能正确地读入文件pd.read_csv文件('文件名.csv') 我试过各种组合，比如：

^{pr2}$

但一点运气都没有！ 我希望第一行是列，并删除引号字符和逗号。在

我如何有效地完成这项工作？在

Answer 1

问题是有时存在双"，解决方案是在,前后更改匹配零或更多"的分隔符：

df = pd.read_csv('ING_DAILY - ING_DAILY.csv',  sep='["]*,["]*', engine='python')

然后有必要从列名以及第一列和最后一列中删除"：

^{pr2}$