Save excel file using python

Question

I have a problem. I perform data cleaning on excel file using python in Jupiter notebook. There are 10 sheets in my excel file. My cleaning is done successfully. But when I open excel it same as before cleaning. How can I save my data permanently in an excel file using python pandas? I import file using import os

Does this answer your question? Dataframe to Excel sheet

sushanth
– sushanth

2020-05-23 10:14:22 +00:00
Commented May 23, 2020 at 10:14 — sushanth
– sushanth, Commented May 23, 2020 at 10:14

Khurram Shehzad · Accepted Answer · 2020-05-23 11:40:53Z

0

First you have to save your clean data and then you can directly open that file

df.to_csv(location,index=False)

answered May 23, 2020 at 11:40

Khurram Shehzad

92 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Talha Imtiaz Over a year ago

But my excel file is of .xlsx type and whenever I tried df.to_excel(location, index=False), it does not save changes that I performed through data cleaning. Any solution?

Khurram Shehzad Over a year ago

df.to_excel("output.xlsx",index=False)

Collectives™ on Stack Overflow

Save excel file using python

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related