在Python中将csv文件转换为管道分隔文件 [英] Convert csv file to pipe delimited file in Python

问题描述

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

I want to convert a comma-delimited CSV file to a pipe-delimited file with Python:

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

This is how I am reading my csv file:

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

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

How would I write it as pipe delimited file?

推荐答案

这符合我的要求:

import csv

with open('C:/Path/InputFile.csv', 'rb') as fin, \
     open('C:/Path/OutputFile.txt', 'wb') as fout:
    reader = csv.DictReader(fin)
    writer = csv.DictWriter(fout, reader.fieldnames, delimiter='|')
    writer.writeheader()
    writer.writerows(reader)

这篇关于在Python中将csv文件转换为管道分隔文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！