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

1 vote306 views2 answers
Convert string representation of dict to dict python
Python
0 vote311 views1 answer
How to scale an array between two values python
Python
0 vote314 views2 answers
Python code for fibonacci
Python
0 vote302 views1 answer
No module named 'bootstrap4' django
Python
2 votes303 views4 answers
Eval function
Python
0 vote318 views1 answer
Open chrome in pyhton
Python
8 votes322 views2 answers
Python get public ip address
Python
0 vote276 views1 answer
Unhapppy man with monwy
Python
0 vote306 views1 answer
Windows python absolute path
Python
0 vote299 views1 answer
IsADirectoryError: [Errno 21] Is a directory: '/'
Python