Run
import pandas as pd # Create dataframe df_marks = pd.DataFrame({'name': ['Somu', 'Kiku', 'Amol', 'Lini'], 'physics': [68, 74, 77, 78], 'chemistry': [84, 56, 73, 69], 'algebra': [78, 88, 82, 87]}) # Create excel writer object writer = pd.ExcelWriter('output.xlsx') # Write dataframe to excel df_marks.to_excel(writer) # Save the excel writer.save() print('DataFrame is written successfully to Excel File.')
Output