我想使用Python将几个.csv文件转换为.txt文件。在我的.csv文件中,有数百行数据,如下所示:csv文件的图片。
我使用下面的代码来实现这个目的。
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
我使用下面的代码来实现这个目的。
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”时,我收到以下错误:
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”时,该代码会定义文件并执行下一步操作,但仍会返回以下错误:
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
你能帮我处理这些问题吗?
TypeError
错误? - PYAcsv_file = str(input('请输入输出文件名:'))
将您的输入转换为字符串,或许可以解决问题。 - PYAinput()
正在尝试评估您的输入,这就是为什么您会收到NameError的原因。请改用raw_input()
。这是一个重复的问题。 - wwii