我正在尝试编写一个简单的python程序(在Eclipse Juno中使用Pydev)来加载多个.CSV文件,以便通过CSV复制和重新输出。(最终"复制"功能将被替换为选择某些列,然后重新输出CSV文件)
到目前为止,我已经得到了程序上传一个CSV文件,并在用户通过保存对话框指定的地方输出它(现在只是复制文件)。弹出一个对话框,要求选择文件(多个选择工作),但我不确定如何解释/解析并将多个csv输入文件静态地保存到我计算机上的指定位置(C:/)。
下面是程序任务的简单运行:
输入CSV文件->复制->输出CSV文件到计算机上的静态位置
我将在这篇文章中包含我的代码,
任何帮助都是非常感激的!: -)
代码:
文件上传
from Tkinter import Tk
from tkFileDialog import askopenfilenames
Tk().withdraw()
filenames = askopenfilenames()
print(filenames)
文件复制/操纵
import csv
import tkFileDialog
ifile = open(filenames)
reader = csv.reader(ifile)
另存为对话框
ofile = tkFileDialog.asksaveasfilename()
print filenames
writer = csv.writer(open(ofile, 'wb'))
for row in reader:
writer.writerow(row)
状态对话框
import tkMessageBox
tkMessageBox.showinfo(title="Conversion Successful", message="CSV File has been successfully converted")
在不知道要做什么的情况下,您可以尝试这样做:
from Tkinter import Tk
from tkFileDialog import askopenfilenames
Tk().withdraw()
filenames = askopenfilenames()
# askopenfilenames() returns a list of filenames. Loop through them one at a time
for fin in filenames:
ifile = open(fin)
reader = csv.reader(ifile)
# For each file, ask where to save it, then write it out.
ofile = tkFileDialog.asksaveasfilename()
writer = csv.writer(open(ofile, 'wb'))
for row in reader:
# Whatever you modify probably goes here.
writer.writerow(row)
tkMessageBox.showinfo(title="Conversion Successful", message="CSV File '{0}' has been successfully converted and was written to '{1}'".format(fin,ofile)
ifile.close()