怎么去除多余的引号啊？

Question

怎么去除多余的引号？最好能把分号改成逗号，源文件是挤在一个单元格里，想要提出出来的文件刚好在三个单元格里

Answer 1

要解析数据的话，试下re吧。

运行前：

import csv
import re

with open("test.csv", mode='r') as f:
    reader = csv.reader(f)
    obj = re.compile(r'''(?P<UserID>\d+);"(?P<ISBN>\w+)";"(?P<BookRating>\d)"''')
    with open("test2.csv", mode='a', newline='') as file:
        writer = csv.writer(file)
        for row in reader:
            row_content = obj.search(row[0])
            writer.writerow((
                    row_content.group("UserID"),
                    row_content.group("ISBN"),
                    row_content.group("BookRating")
            ))

运行后：