Sept. 12, 2022, 7:37 p.m. | Ji Wei Liew

Towards Data Science - Medium towardsdatascience.com

Supercharged Pandas: Reading from and Writing to Excel

Enhancing .read_excel & .to_excel methods to allow you to focus on data exploration

Reading from and writing to Excel (Image by the author)

Who should read this?

If you have used the python pandas library to read Excel files, analyze/transform data, and write the pandas DataFrame to Excel, then what I am about to share is likely to benefit you. You could have been through one or more of these situations:

  • Use …

data science excel pandas python reading tkinter writing

AI Research Scientist

@ Vara | Berlin, Germany and Remote

Data Architect

@ University of Texas at Austin | Austin, TX

Data ETL Engineer

@ University of Texas at Austin | Austin, TX

Lead GNSS Data Scientist

@ Lurra Systems | Melbourne

Lead Data Scientist, Commercial Analytics

@ Checkout.com | London, United Kingdom

Data Engineer I

@ Love's Travel Stops | Oklahoma City, OK, US, 73120