我的导入文件夹中有多个文本文件,其中,我希望读取每个文本文件的所有行,并仅将其存储在一个文本文件中。我将测试python是否读取所有行,并最终将其存储在mysql数据库中。如何使用fileinput实现这一点?我似乎无法启动,我的文件是动态的:以下是我的代码:
for i in range(1, 4):
dateNow = datetime.datetime.today().date()
strNow = dateNow.strftime('%Y%m%d') + ".Dat"
cstrNow = pathA + str(i) + "\\" + strNow
dateYesterday = datetime.datetime.today().date() - timedelta(days = 1)
strYesterday = dateYesterday.strftime('%Y%m%d') + ".Dat"
cstrYesterday = pathA + str(i) + "\\" + strYesterday
try:
with open(cstrNow):
shutil.copy(cstrNow, pathImport + "\A" + str(i) + "_" + strNow)
pathNow = pathImport + "\A" + str(i) + "_" + strNow
except IOError:
print "No Dat file: " + pathImport + "\A" + str(i) + "_" + strNow
try:
with open(cstrYesterday):
shutil.copy(cstrYesterday, pathImport + "\A" + str(i) + "_" + strYesterday)
pathYesterday = pathImport + "\A" + str(i) + "_" + strYesterday
except IOError:
print "No Dat file: " + pathImport + "\A" + str(i) + "_" + strYesterday
for line in fileinput.input(pathNow):
print line
for line in fileinput.input(pathYesterday):
print line
我试过用这个,但失败了。。你知道吗
with fileinput.input(files=(pathNow, pathYesterday)) as f:
for line in f:
//HOW TO OUTPUT TO TEXT FILE?
现在我对mysql没有问题,但是如果你能给我指出一个好的教程,现在我读了这个,看起来不错:http://www.jeremymorgan.com/tutorials/python-tutorials/how-to-connect-to-mysql-with-python/
编辑:我使用的是python2.7,如何获取多个动态文本文件的内容并将其存储在一个文本文件和mysql中?你知道吗
我希望这能帮助某人。。。你知道吗
相关问题 更多 >
编程相关推荐