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 vote199 views1 answer
Pttsx3 pip
Python
0 vote283 views1 answer
Aiohttp.client_exceptions.ClientConnectorCertificateError
Python
10 votes198 views2 answers
Python - subset specific columns name in a dataframe
Python
0 vote205 views2 answers
How to avoid inserting duplicate records in orm django
Python Django
0 vote187 views1 answer
Calculate the euler totient of a number python
Python
5 votes199 views4 answers
Python generator function
Python
0 vote178 views1 answer
Readme python convert to pdf
Python
1 vote177 views1 answer
Image delete in django from the folder
Python
1 vote191 views1 answer
Elif in django template
Python
0 vote186 views1 answer
No lapack/blas resources found scipy
Python