Python数据分析基础

Excel

文件

｜

113

import

pandas

as

pd

import

glob

import

os

import

sys

input_path = sys.argv[1]

output_file = sys.argv[2]

all_workbooks = glob.glob(os.path.join(input_path,'*.xls*'))

data_frames = []

for

workbook

in

all_workbooks:

all_worksheets = pd.read_excel(workbook, sheetname=None, index_col=None)

for

worksheet_name, data

in

all_worksheets.items():

data_frames.append(data)

all_data_concatenated = pd.concat(data_frames, axis=0, ignore_index=True)

writer = pd.ExcelWriter(output_file)

all_data_concatenated.to_excel(writer, sheet_name='all_data_all_workbooks',\

index=False)

writer.save()

要运行这个脚本，在命令行中输入以下命令，然后按回车键：

python pandas_concat_data_from_multiple_workbooks.py ...