使用Python将制表符分隔的txt文件转换为csv文件 [英] Convert tab-delimited txt file into a csv file using Python
问题描述
所以我想将一个简单的制表符分隔的文本文件转换为csv文件。如果我使用string.split('\\\
')将txt文件转换为字符串,我得到一个列表,每个列表项作为一个字符串,每个列之间用'\t'。我想我可以用逗号替换'\t',但它不会像字符串一样处理列表中的字符串,并允许我使用string.replace。这里是我的代码的开始,仍然需要一种方法来解析选项卡\t。
So I want to convert a simple tab delimited text file into a csv file. If I convert the txt file into a string using string.split('\n') I get a list with each list item as a string with '\t' between each column. I was thinking I could just replace the '\t' with a comma but it won't treat the string within the list like string and allow me to use string.replace. Here is start of my code that still needs a way to parse the tab "\t".
import csv
import sys
txt_file = r"mytxt.txt"
csv_file = r"mycsv.csv"
in_txt = open(txt_file, "r")
out_csv = csv.writer(open(csv_file, 'wb'))
file_string = in_txt.read()
file_list = file_string.split('\n')
for row in ec_file_list:
out_csv.writerow(row)
推荐答案
csv
支持制表符分隔文件。将 分隔符
参数提供给 reader
:
csv
supports tab delimited files. Supply the delimiter
argument to reader
:
import csv
txt_file = r"mytxt.txt"
csv_file = r"mycsv.csv"
# use 'with' if the program isn't going to immediately terminate
# so you don't leave files open
# the 'b' is necessary on Windows
# it prevents \x1a, Ctrl-z, from ending the stream prematurely
# and also stops Python converting to / from different line terminators
# On other platforms, it has no effect
in_txt = csv.reader(open(txt_file, "rb"), delimiter = '\t')
out_csv = csv.writer(open(csv_file, 'wb'))
out_csv.writerows(in_txt)
这篇关于使用Python将制表符分隔的txt文件转换为csv文件的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!