使用Python/Pandas将未知长度的表格打印到CSV文件
使用Python/Pandas将未知长度的表格打印到CSV文件
提问于 2020-08-11 00:42:59
我有一个表格，我想用pandas把它打印成csv文件。此表是从其他excel文件中提取的。我的问题是表的长度是未知的。我应该如何将此表打印到csv文件中以显示所有内容，而不是仅显示在一行上
for x in ABC:
print()
print(f"{x}:")
try:
df = pd.read_csv(x + "/File.csv")
df_filter= df[['A','B','C', "D", "E"]]
if df_filter['D'].str.contains('Fail').any():
noSC= df_filter[df_filter.DUTId != 'SC_INFO']
finalTable= noSC[noSC.D == 'Fail']
if finalTable.empty:
print("Did not complete")
sheet1['A16'] = finalTable
else:
filterTable= finalTable[['A','B','C', "E"]]
fullfinalTable = filterTable.to_string()
print(fullfinalTable)
else:
print("Run Successful")
except FileNotFoundError:
print("File does not exist")我知道sheet1['A16'] = finalTable是错的，但我不确定我会怎么做。它确实输出表，但仅在A16上，所以它是一个很长的行。有没有办法将未知的表格格式化到新的excel中？
Stack Overflow用户
回答已采纳
发布于 2020-08-11 01:24:33
试试这个吧。
from pathlib import Path
import pandas as pd
dir_path = r"yourFolderPath"
files_list = [str(p) for p in dir_path.glob("**/*.csv")]
if files_list:
source_dfs = [pd.read_csv(file_) for file_ in files_list]
df = pd.concat(source_dfs, ignore_index=True)
df = df[['A','B','C', "D", "E", "DUTId"]]
if df['D'].str.contains('Fail').any():
df = df_filter[df_filter.DUTId != 'SC_INFO']
finalTable = df[df.D == 'Fail']
if finalTable.empty:
print("Did not complete. Dataframe is empty.")
else:
print("Dataframe written to .csv")
finalTable = finalTable[['A','B','C','E']]
finalTable.to_csv(dir_path + r"/finaltable.csv")
else:
print(f"No .csv files in {dir_path}")页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/63344403
复制相关文章
相似问题
腾讯云开发者
