Question: Wrote the code: array = pd.DataFrame(np.object, index=[], columns=[]) array = array.append({‘Project’: b.name, ‘Summary’: card.name, \ ‘Key’: card.id, ‘Assignee’: m, ‘Points’: s}, \ ignore_index=True) array1 = pd.read_excel(‘ProjectCostUCP.xlsx’, ‘Лист1’) result = array[[‘Project’, ‘Assignee’, ‘Points’]].groupby([‘Project’, ‘Assignee’]).sum(axis=1) print(result.columns.tolist()) result = result.merge(array1, on=[‘Project’]) result[‘Value’] = result.Points * result.Price writer = pd.ExcelWriter(‘third.xlsx’) array.to_excel(writer, “June”) result.to_excel(writer, …
python – Merge two DataFrame tables, aggregate data using pandas Read More »