将Python脚本封装为可执行文件：将CSV文件合并并处理为Excel表格

这篇文章将教你如何将一段Python代码封装成可执行文件，代码的功能是将多个CSV文件合并成一个Excel表格。

代码

import pandas as pd
csv_files = ['D:/python3.8.0/installlocation/05/接收/01.csv', 'D:/python3.8.0/installlocation/05/接收/02.csv','D:/python3.8.0/installlocation/05/接收/03.csv','D:/python3.8.0/installlocation/05/接收/04.csv','D:/python3.8.0/installlocation/05/接收/05.csv','D:/python3.8.0/installlocation/05/接收/06.csv','D:/python3.8.0/installlocation/05/接收/07.csv','D:/python3.8.0/installlocation/05/接收/08.csv','D:/python3.8.0/installlocation/05/接收/09.csv','D:/python3.8.0/installlocation/05/接收/10.csv','D:/python3.8.0/installlocation/05/接收/11.csv','D:/python3.8.0/installlocation/05/接收/12.csv','D:/python3.8.0/installlocation/05/接收/13.csv','D:/python3.8.0/installlocation/05/接收/14.csv','D:/python3.8.0/installlocation/05/接收/15.csv','D:/python3.8.0/installlocation/05/接收/16.csv','D:/python3.8.0/installlocation/05/接收/17.csv','D:/python3.8.0/installlocation/05/接收/18.csv','D:/python3.8.0/installlocation/05/接收/19.csv','D:/python3.8.0/installlocation/05/接收/20.csv','D:/python3.8.0/installlocation/05/接收/21.csv','D:/python3.8.0/installlocation/05/接收/22.csv','D:/python3.8.0/installlocation/05/接收/23.csv','D:/python3.8.0/installlocation/05/接收/24.csv','D:/python3.8.0/installlocation/05/接收/25.csv','D:/python3.8.0/installlocation/05/接收/26.csv','D:/python3.8.0/installlocation/05/接收/27.csv','D:/python3.8.0/installlocation/05/接收/28.csv','D:/python3.8.0/installlocation/05/接收/29.csv','D:/python3.8.0/installlocation/05/接收/30.csv','D:/python3.8.0/installlocation/05/接收/31.csv','D:/python3.8.0/installlocation/05/接收/32.csv']
df_merged = pd.DataFrame()
for file in csv_files:
	df = pd.read_csv(file, skiprows=7)
	data1 = df.iloc[:, 0].iloc[0:]
	data2 = df.iloc[:, 1].iloc[0:]
	df_merged = pd.concat([df_merged, data1, data2], axis=1)


df_merged.to_excel('接收值原始数据1.xlsx', index=False)
from openpyxl import load_workbook
workbook = load_workbook('D:/python3.8.0/installlocation/接收值原始数据1.xlsx')
worksheet = workbook.active
column_count = worksheet.max_column
for column in range(column_count, 0, -1):
	if column % 2 != 0:
		worksheet.delete_cols(column)


workbook.save('接收值原始数据2.xlsx')

步骤

保存代码： 将上述代码保存到一个名为script.py的Python脚本文件中。
安装依赖库： 确保你已经安装了pandas和openpyxl库。如果你没有安装，请在命令提示符中执行以下命令进行安装：

pip install pandas openpyxl

使用PyInstaller封装： 打开命令提示符，切换到script.py所在的目录，然后执行以下命令：

pyinstaller --onefile --windowed script.py

运行可执行文件： 执行完上述命令后，pyinstaller将在当前目录下生成一个名为dist的文件夹。在这个文件夹中，你会找到生成的可执行文件script.exe。现在，你可以直接运行script.exe来执行代码，并生成相应的Excel文件。

说明：

--onefile选项将所有依赖项打包到一个单独的可执行文件中，方便分发。
--windowed选项将生成一个带有窗口的可执行文件。

希望这篇文章能够帮助你将Python脚本封装为可执行文件。如果你有任何问题，请随时提问！