我正在使用下面的代码来创建一个具有多个选项卡的excel,它基于path上存在的csv文件。我的路径中有两个文件。因此,不是在一个excel中得到两个制表符,而是得到一个空白的制表符。请帮我修复这个代码。
import os
import glob
import xlsxwriter
import csv
import pandas
path='/axp/buanalytics/csgsn/dev/GSN/VGEN_Files/Test/Tulu/VG/Data/'
flist = [os.path.basename(x) for x in glob.glob(os.getcwd() + '/axp/buanalytics/csgsn/dev/GSN/VGEN_Files/Test/Tulu/VG/Data/*.csv')]
workbook = xlsxwriter.Workbook('/axp/buanalytics/csgsn/dev/GSN/VGEN_Files/Test/Tulu/VG/Data/split_book.xlsx')
for sh in flist:
worksheet = workbook.add_worksheet(sh)
with open(sh, 'rb') as f:
reader = csv.reader(f)
for r, row in enumerate(reader):
for c, col in enumerate(row):
worksheet.write(r, c, col)
workbook.close()发布于 2020-03-13 13:30:50
三个问题:
1) '/axp/buanalytics/csgsn/dev/GSN/VGEN_Files/Test/Tulu/VG/Data/*.csv') = os.path.basename(x),x在glob.glob(os.getcwd() + flist )中
假设os.getcwd()与您的路径相同,您将得到两个路径名。这意味着flist将为空。既然你已经经历了设置路径的麻烦,为什么不直接
flist = [os.path.basename(x) for x in glob.glob(path + '*.csv')]2)同上
workbook = path + 'split_book.xlsx'3)文件应作为文本文件打开
with open(sh, 'r') as f试一试,你的程序应该可以工作了。你不需要熊猫来做这件事--这是以后的事吗?
发布于 2020-03-13 13:42:59
使用pandas读取这些文件,并将它们组合在一起
import os
import pandas as pd
csv_names = [files for files in os.listdir("Your Directory/")] #get names of csv files in directory "Directory/"
writer = pd.ExcelWriter('Multiple Workbooks.xlsx', engine='xlsxwriter')
for files in csv_names:
df = pd.read_csv(os.path.join("Your Directory",files)) #read csv file
filename = files[:-4] #remove ".csv" from filename
df.to_excel(writer, sheet_name=filename) #add to workbook
writer.save()简而言之,您可以使用以下命令向dataframe添加选项卡
writer = pd.ExcelWriter('Multiple Workbooks.xlsx', engine='xlsxwriter')
df1.to_excel(writer, sheet_name="SheetName")
df2.to_excel(writer, sheet_name="SheetName2")https://stackoverflow.com/questions/60665060
复制相似问题