在Python中将csv文件转换为管道分隔文件

2024-01-15

我想使用 Python 将逗号分隔的 CSV 文件转换为管道分隔的文件:

这就是我读取 csv 文件的方式:

with open('C://Path//InputFile.csv') as fOpen:
    reader     =     csv.DictReader(fOpen)

    for row in reader:
        for (k, v) in row.items():
            columns[k].append(v)

c = csv.writer(open("C://Path//OutputFile.txt","wb"), delimiter="|")

我如何将其写为管道分隔文件?


适应马蒂诺的回答 https://stackoverflow.com/a/27553098/3357935 to fix 换行问题 https://stackoverflow.com/a/3348664/3357935在Python 3中。

import csv

with open('C:/Path/InputFile.csv') as fin:
    # newline='' prevents extra newlines when using Python 3 on Windows
    # https://stackoverflow.com/a/3348664/3357935
    with open('C:/Path/OutputFile.txt', 'w', newline='') as fout:
        reader = csv.DictReader(fin, delimiter=',')
        writer = csv.DictWriter(fout, reader.fieldnames, delimiter='|')
        writer.writeheader()
        writer.writerows(reader)
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)

在Python中将csv文件转换为管道分隔文件 的相关文章

随机推荐