Create excel file python

#import openpyxl  # Must be as least installed, import is optional
import pandas as pd
import numpy as np
# Create dataframe with your data; 
df = pd.DataFrame(np.array([[23, 99, 78], [65, 95, 90], [90, 98, 96]]), columns=['Bob', 'Dilan', 'Live'])
df
   Bob  Dilan  Live
0   23     99    78
1   65     95    90
2   90     98    96
# Export the dataframe as Excel File
# sheet_name="Your Sheet Name" is optionnal
df.to_excel(r'C:\Users\Ron\Desktop\File_Name.xlsx', sheet_name="Your Sheet Name" ,index = False)

-1

Similar codes

8 votes128 views2 answers
Combine two dataframe in pandas
Python
0 vote121 views1 answer
Pyqt5 open tab
Python
3 votes81 views1 answer
How to present if statement in dfd
Python
5 votes116 views1 answer
Python put quotes in string
Python
11 votes121 views2 answers
Add reaction discord.py
Python
23 votes122 views6 answers
Check tensorflow version
Python
15 votes108 views1 answer
Function to a button in tkinter
Python
0 vote119 views1 answer
Tyjacsav
Python
0 vote149 views1 answer
Django querset group by sum
Python Django
3 votes127 views2 answers
Pandas check length of string
Python