时间戳

首页 > 解决方案 > 将 Jupyter Notebook 数据框导入 Google 表格，无需重新排列行

python - 将 Jupyter Notebook 数据框导入 Google 表格，无需重新排列行

问题描述

当我使用gspread_dataframe并将gspread数据从 Jupyter Notebook 导出到 Google 电子表格时，行会被打乱，这不是我想要的。任何人都可以帮忙吗？

emp_uniq = gspread_df['E_code'].unique() dict_e_code = {} x_df = pd.DataFrame() 

for emp in list(emp_uniq):
    dict_e_code[emp] = gspread_df[gspread_df['E_code']==emp]
    a = dict_e_code[emp][["Month","E_code","Allocation_ID","Project","Effective_days","Percentage_Util","Onsite/Offshore","Mapping","Payroll"]]
    a_fin = a.groupby(['Month','E_code','Project','Allocation_ID','Percentage_Util','Onsite/Offshore']).sum()['Effective_days']
    new_df = a_fin.to_frame().reset_index()
    new_df['Percentage_Util'] = (new_df['Effective_days']/new_df['Effective_days'].sum())*100
    x_df = x_df.append(new_df)
    x_df.reset_index(inplace=True)
    x_df.drop(['index'],axis=1,inplace=True)


sheet = client.open(input("Please Enter Main Spreadsheet as Output Data: ")) worksheet_new = sheet.worksheet(input("Please Enter Sheet Name as Output Data:"))
existing = get_as_dataframe(worksheet_new) 
a = existing.append(x_df) 
gsdf.set_with_dataframe(worksheet_new, a)

标签： pythongoogle-sheetsgspread

解决方案

推荐阅读