如何使用python将csv文件转换为文本文件? [英] How to convert csv file to text file using python?
问题描述
我想使用python将几个.csv文件转换为.txt文件.在我的.csv文件中,我有几百行数据,如下所示: csv文件的图像
I want to convert a couple of .csv files to .txt files using python. In my .csv files, I have hundreds of lines of data like the bellow: image of the csv file
Value Date Time
919 4/15/2016 19:41:02
551 4/15/2016 19:46:51
717 4/15/2016 19:49:48
2679 4/15/2016 19:52:49
2890 4/15/2016 19:55:43
2897 4/15/2016 19:58:38
1790 4/15/2016 21:39:14
2953 4/15/2016 21:42:10
2516 4/15/2016 21:45:04
2530 4/15/2016 21:47:58
2951 4/15/2016 21:51:02
2954 4/15/2016 21:53:56
2537 4/15/2016 21:56:52
2523 4/15/2016 21:59:45
2536 4/15/2016 22:02:49
2727 4/15/2016 22:05:43
我将波纹管代码用于此目的.
I use the bellow code for this purpose.
csv_file = input('Enter the name of your input file: ')
txt_file = input('Enter the name of your output file: ')
text_list = []
with open(csv_file, "r") as my_input_file:
for line in my_input_file:
line = line.split(",", 2)
text_list.append(" ".join(line))
with open(txt_file, "w") as my_output_file:
my_output_file.write("#1\n")
my_output_file.write("double({},{})\n".format(len(text_list), 2))
for line in text_list:
my_output_file.write(" " + line)
print('File Successfully written.')
我的第一个问题是,当输入文件的名称为(例如)"DFW002_0330PM_Thursday_November_16_2017"时,出现以下错误:
My first problem is that when the name of the input file is (for example) "DFW002_0330PM_Thursday_November_16_2017", I get the bellow error:
Traceback (most recent call last):
File "C:/Users/Behzad/Desktop/run/UTA/cvstotext.py", line 1, in <module>
csv_file = input('Enter the name of your input file: ')
File "<string>", line 1, in <module>
NameError: name 'DFW000_0330PM_Thursday_November_16_2017' is not defined
但是,当我将代码名称更改为(例如)"11"时,该代码定义了文件并转到下一步,但再次返回以下错误:
But, when I change the name of the code to (for example) "11", the code defines the file and goes to the next steps, but again it returns the bellow error:
Traceback (most recent call last):
File "C:/Users/Behzad/Desktop/run/UTA/cvstotext.py", line 6, in <module>
with open(csv_file, "r") as my_input_file:
TypeError: coercing to Unicode: need string or buffer, int found
您能帮我解决这些问题吗?
Would you please help me handle these problems?
推荐答案
使用csv
可以很容易地遍历csv行:
Using csv
it's very easy to iterate over the csv lines:
import csv
csv_file = raw_input('Enter the name of your input file: ')
txt_file = raw_input('Enter the name of your output file: ')
with open(txt_file, "w") as my_output_file:
with open(csv_file, "r") as my_input_file:
[ my_output_file.write(" ".join(row)+'\n') for row in csv.reader(my_input_file)]
my_output_file.close()
这篇关于如何使用python将csv文件转换为文本文件?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!