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

25 votes223 views6 answers
Python remove spaces
Python
19 votes194 views1 answer
Find root directory of jupyter notebook
Python
4 votes246 views1 answer
Django forms set class
Python Django
11 votes206 views3 answers
Delete row from dataframe python
Python
0 vote229 views1 answer
Serializing nested objects drf,django restframework nested object serialization
Python Django
0 vote225 views1 answer
Lines = paths.read().splitlines()
Python
-1 vote216 views1 answer
How to bubble sort a 2d array in python
Python
9 votes180 views2 answers
Python listen to keyboard input
Python
-1 vote203 views1 answer
Add gaussian noise python
Python
1 vote176 views1 answer
How to store a number in a variable python
Python