How to write into Excel using Pandas?

Question

The first code below works and allows me to read my excel file, as a test, I added a new column.

import numpy as np
import pandas as pd

excl = pd.read_excel (r'C:\Users\Family\Desktop\Anaconda\Book1.xlsx')
excl['new_pop'] = (excl.Pop2010 + excl.Pop2020)
print (excl)

Now, I would like to write the older data with the new column to a new excel file. Based on my online web research, I know I need to use the "to_excel" function in Pandas but I can't seem to find an example of how to bring over 'excl' file with the new data.

I previously had State, Country, Pop2010, Date, Pop2020 as columns, I added new_pop as a new column with new information in the cells beneath it.

Does this answer your question? [how to save a pandas DataFrame to an excel file?](https://stackoverflow.com/questions/55170300/how-to-save-a-pandas-dataframe-to-an-excel-file) — Trenton McKinney, Dec 24 '20 at 02:47

score 1 · Accepted Answer · answered Dec 23 '20 at 18:01

1

excl.to_excel("new-file.xlsx")

Scroll down until you see examples: https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.to_excel.html

Examples are always documented in the pandas doc.

answered Dec 23 '20 at 18:01

programmar

594
6
19

score 0 · Answer 2 · answered Dec 23 '20 at 18:02

0

You can make use of the 'to_excel' method. In your case, it would look like this:

excel.to_excel('name of file.xlsx')

For more on the to_excel method, here's the pandas documentation.

answered Dec 23 '20 at 18:02

konnichiwa

50
6

How to write into Excel using Pandas?

2 Answers2