Write into Excel by pandas

ExcelW = pd.ExcelWriter('Data/Volume.xlsx', engine='openpyxl', mode='a', if_sheet_exists='overlay')
Volume_Agent.to_excel(ExcelW, sheet_name='Volume_Agent', index=False)
ExcelW.close()

Comments

Post a Comment

Most searched

WHERE or IF function in Numpy

Script union['CH'] = np.where(union['Invoice Type'] == 'Normal Sales', union['Channel Name'],'Wedding & Function') Explanation IF "Invoice Type" = "Normal Sales" then union['CH'] = union['Channel Name'] Else union['CH'] = "Wedding & Function"
Read more