pip install pandas openpyxl xlrd

import pandas as pd

# 讀取兩個Excel文件
df1 = pd.read_excel('file1.xlsx')
df2 = pd.read_excel('file2.xlsx')

# 縱向合并（按行追加）
combined_df = pd.concat([df1, df2], ignore_index=True)

# 保存為新文件
combined_df.to_excel('combined.xlsx', index=False)

print("縱向合并完成！")

import pandas as pd

# 讀取兩個Excel文件
df1 = pd.read_excel('file1.xlsx')
df2 = pd.read_excel('file2.xlsx')

# 按UserID列橫向合并
merged_df = pd.merge(df1, df2, on='UserID', how='inner')

# 保存為新文件
merged_df.to_excel('merged.xlsx', index=False)

print("橫向合并完成！")

pip install openpyxl

from openpyxl import Workbook, load_workbook

# 加載第一個Excel文件
wb1 = load_workbook('file1.xlsx')
ws1 = wb1.active

# 加載第二個Excel文件
wb2 = load_workbook('file2.xlsx')
ws2 = wb2.active

# 創(chuàng)建新工作簿
new_wb = Workbook()
new_ws = new_wb.active

# 復(fù)制第一個文件的所有行
for row in ws1.iter_rows(values_only=True):
    new_ws.append(row)

# 復(fù)制第二個文件的所有行（跳過標(biāo)題行）
for row in ws2.iter_rows(min_row=2, values_only=True):
    new_ws.append(row)

# 保存新文件
new_wb.save('combined_openpyxl.xlsx')

print("使用openpyxl合并完成！")

import pandas as pd

all_dfs = []
for file in ['file1.xlsx', 'file2.xlsx', 'file3.xlsx']:
    df = pd.read_excel(file)
    all_dfs.append(df)

combined = pd.concat(all_dfs, ignore_index=True)

df = pd.read_excel('file.xlsx', sheet_name='Sheet2')

combined_df.dropna(inplace=True)