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

0 vote158 views1 answer
Python program for printing fibonacci numbers
Python
0 vote157 views3 answers
Calling a function in python upon entry content changing tkinter
Python
0 vote165 views1 answer
Gui apps
Python
0 vote163 views1 answer
How to create simple window in wxPython
Python
0 vote121 views2 answers
Numerical laplace in python
Python
0 vote155 views1 answer
Getting vocab from a text file python
Python
0 vote228 views1 answer
Pandas df represent a long column name with short name
Python
1 vote134 views1 answer
Python in
Python
0 vote161 views1 answer
Divide a column value in pandas dataframe
Python
1 vote165 views1 answer
How to make multiple place holders in a string with %s python
Python