熊猫csv读取器不认识甜度仪

Question

这是csv文件的一个片段：

"tac,""vendor"",""platform"",""type"""
"00100429,""PROTO"",""Proprietary"",""Phone"""
"00100430,""PROTO"",""Proprietary"",""Phone"""
"00100431,""PROTO"",""Proprietary"",""Phone"""

我读它的时候：

pd.read_csv("path/name.csv", sep=",")

但是它返回一个带有one合并列的数据格式。

    tac,"vendor","platform","type"
0   00100429,"PROTO","Proprietary","Phone"
1   00100430,"PROTO","Proprietary","Phone"
2   00100431,"PROTO","Proprietary","Phone"
3   00100432,"PROTO","Proprietary","Phone"
4   00100433,"PROTO","Proprietary","Phone"
5   00100434,"PROTO","Proprietary","Phone"
6   00100435,"PROTO","Proprietary","Phone

很明显，我需要所有的文件都用"，“

Answer 1

使用不同的quotechar

pd.read_csv("path/name.csv", quotechar="'") \
    .replace('"', '', regex=True).rename(columns=lambda x: x.strip('"'))

        tac vendor     platform   type
0  00100429  PROTO  Proprietary  Phone
1  00100430  PROTO  Proprietary  Phone
2  00100431  PROTO  Proprietary  Phone
​