Answers for "pandas open excel as dataframe"

7

export pandas dataframe as excel

df.to_excel(r'C:UsersRonDesktopFile_Name.xlsx', index = False)

#if you omit the file path (must also omit 'r') and 
#enter only file_name.xlsx, it will save to your default file location,
# that is, where the file you're reading from is located.
Posted by: Guest on June-25-2021
9

pandas read excel

import pandas as pd
pd.read_excel('tmp.xlsx', index_col=0)
Posted by: Guest on May-31-2020

Code answers related to "pandas open excel as dataframe"

Python Answers by Framework

Browse Popular Code Answers by Language