How to export from Python to Excel?

[jpy]

Hi everyone, I found the example below online that creates an excel file for you. I am currently working with a workbook in Python (using read_excel function), I added columns to it and edited some of the data. How would I export the new information to excel? Where would I add that to the code below?

excl = pd.DataFrame([['a', 'b'], ['c', 'd']],
                    index=['row 1', 'row 2'],
                    columns=['col 1', 'col 2'])
excl.to_excel("output.xlsx")

This is the code I used to rad the excel file:

excl = pd.read_excel (r'C:\Users\Family\Desktop\Anaconda\Book1.xlsx')

and the column names - State, Country
Pop2010, Date and Pop2020.

[jefsummers]

Can you explain further? You have the command to export to excel already, line 4 of the first code snippet. Not sure of your question.

[codeto]

Hi everyone, I found the example below online that creates an excel file for you. I am currently working with a workbook in Python (using read_excel function), I added columns to it and edited some of the data. How would I export the new information to excel? Where would I add that to the code below?

excl = pd.DataFrame([['a', 'b'], ['c', 'd']],
                    index=['row 1', 'row 2'],
                    columns=['col 1', 'col 2'])
excl.to_excel("output.xlsx")

Pandas lets you write Excel. After modifying or creating a new data frame, just call the to_excel() function again on that data frame.

Something like this:

import pandas as pd

# create test
excl = pd.DataFrame([['a', 'b'], ['c', 'd']],
                    index=['row 1', 'row 2'],
                    columns=['col 1', 'col 2'])
excl.to_excel("output.xls")

# now read and modify
excl = pd.read_excel("output.xls")
excl['State'] = ['a','b']
excl['Country'] = ['a','b']
excl['Pop2010]'] = ['a','b']
excl['Date'] = ['a','b']
excl['Pop2020'] = ['a','b']

# write dataframe
excl.to_excel("example.xlsx")

[deanhystad]

There is no "export to excel". You can read and write Excel format files. If you read a file, modify the data, and write the data back to the same file descriptor it will look like you "modified" the file, but you really just replaced the file. To see any changes from Excel you need to load the file (in Excel) after the changes are made.

[jpy]

Codeto, this is exactly what I was looking for, thank you.