我一直被这个问题所困扰(很可能是非常简单的),但我的输出到Excel的结果只打印了最后循环中的值。我相信这与缩进有关,我试过将数值从for循环中删除,但一直没有成功。这里有一些虚拟代码来帮助理解这个问题。
#dummy code
#reads each file in folder, runs through a bunch of functions, and prints output in console
import os,glob
import csv
import pandas as pd
filename ='path to folder'
for filename in glob.glob(os.path.join(folder_path, '*.txt')):
with open(filename, 'r') as f:
text = f.read()
data =function1(file= filename)
data= function2(file= filename)
data = function3(file= filename)
final =pd.DataFrame(data)
print(final)
final.to_excel('output.xlsx')
控制台的输出是这样的,是正确的,也是我想导出为csv的。
0 some text here ...
1 more text...
2 clear text...
3 final data...
0
0 yes no.