save to xlsx in python 1

save to xlsx in python

import pandas as pd
df = pd.read_excel()

>>> df
      User Name Country      City Gender  Age
0  Forrest Gump     USA  New York      M   50
1     Mary Jane  CANADA   Tornoto      F   30
2  Harry Porter      UK    London      M   20
3     Jean Grey   CHINA  Shanghai      F   30


df.to_excel('saved_file.xlsx')

Here is what the above code is Doing:
1. We import the pandas library and read the excel file.
2. We create a dataframe from the excel file.
3. We save the dataframe to an excel file.

Similar Posts