使用此代碼，我將 3 個檔案合并在一起：
import pandas as pd
import openpyxl as op
from openpyxl import load_workbook
from openpyxl import Workbook
import numpy as np
path = r"users.xlsx"
data = pd.read_excel(path, engine='openpyxl')
df = pd.DataFrame(data)
NumberOfChild = df.groupby('Parent ID')['Parent ID'].count().to_frame('Employees Number')
NC = pd.DataFrame(NumberOfChild)
NumberOfBooking = df.groupby('Parent ID')['Reservations Count'].sum().to_frame('Total employees bookings')
NB = pd.DataFrame(NumberOfBooking)
result = df.merge(NC, left_on=['ID'], right_on=['Parent ID'], how='left').merge(NB, left_on=['ID'], right_on=['Parent ID'], how='left')
result.drop(result.columns[0], axis=1)
with pd.ExcelWriter('NC_Merge.xlsx') as writer:
result.to_excel(writer, sheet_name='WorkSheet')
合并后，在表的開頭會添加一個額外的列。我試圖用這個命令洗掉它，但不能。
result.drop(result.columns[0], axis=1)
有什么想法嗎？有點像照片的第一列
uj5u.com熱心網友回復：
我相信您要問的是分配給新資料框的索引。你可以看看這個對類似問題的回答：
轉載請註明出處，本文鏈接：https://www.uj5u.com/gongcheng/346959.html
上一篇：方法在呼叫時動態添加到類中