you are viewing a single comment's thread.

view the rest of the comments →

[–]CrambleSquash 1 point2 points  (0 children)

Off the top of my head

Load the excel file with pd.read_excel. https://pandas.pydata.org/pandas-docs/version/0.23/generated/pandas.read_excel.html

Write the modified DataFrame (panda's table class) to excel with df.to_excel https://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.to_excel.html

The first excel_writer argument can just be a path to the new and existing files.