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 vote129 views1 answer
Xmlrpc get all posts
Python
2 votes137 views1 answer
Python convert a string to a list of words
Python
2 votes123 views1 answer
How to get all index of a char of a string in python
Python
20 votes122 views4 answers
Generate a random number in python between 0 and 1
Python
1 vote134 views1 answer
Make a list from 0 to n python
Python
1 vote112 views1 answer
List set python
Python
20 votes134 views2 answers
How to create string in python
Python
0 vote165 views1 answer
Discord python bot how to change someone's nickname
Python
17 votes128 views6 answers
Convert numpy array to dataframe
Python
2 votes145 views1 answer
How to make file to curent dir python
Python