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 vote49 views1 answer
Python set literal
Python
0 vote35 views1 answer
Split a pd dataframe
Python
2 votes43 views1 answer
Pandas append index ignore
Python
0 vote38 views1 answer
How to check if a variable in python is a specific data type
Python
0 vote50 views1 answer
Ord python3
Python
3 votes39 views1 answer
Count occurrences of value in array python
Python
0 vote42 views1 answer
How to get the percentage accuracy of a model in python
Python
5 votes35 views1 answer
Mutable and immutable in python
Python
3 votes47 views1 answer
Django flush
Python Django
0 vote55 views1 answer
Stack error: command failed: import sys; print "%s.%s.%s" % sys.version_info[:3];
Python