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 vote141 views1 answer
Python monitor directory for files count
Python
1 vote115 views1 answer
Robot framework log from python
Python
0 vote139 views1 answer
Find length of all G.keys() in dict
Python
1 vote165 views1 answer
How to add captcha in django forms
Python Django
4 votes124 views1 answer
Pandas fill empty
Python
27 votes133 views6 answers
Delete spaces in string python
Python
1 vote112 views1 answer
Python eval set variable
Python
0 vote126 views1 answer
Dictionary default value python if key not found
Python
-1 vote137 views1 answer
Import http response in django
Python
0 vote150 views1 answer
Python interface kenee
Python