/Python/Split pd dataframe to excel files based on a column value

Split pd dataframe to excel files based on a column value

import pandas as pd
    
data = pd.read_excel('anyexcelfile.xlsx', engine='openpyxl') # creates a dataframe called 'data'; pick any spreadsheet you can add paths to 'x:/folder/subfolder/anyexcelfile.xlsx' to be explict. 

grouped = data.groupby("Column Header Name") # change "Column Header Name" to the name of the column needed to categorise or group the rows in the dataframe, 

keys = grouped.groups.keys() #create a dictionary list of the each group unique varibles in the specifed column of the dataframe.   

print(keys) #a cheeky debug to check it's working

for key in keys: #looping through each key 
        splitdf = grouped.get_group(key) # creating a temporary dataframe with only the values of the current key. 
        splitdf.to_excel(str(key)+".xlsx", engine='xlsxwriter') #write the temporary dataframe called 'splitdf' to an excel file named after the key. At the end of the loop the temporary dataframe 'splitdf' is overwritten for use with the next key.

Source: stackoverflow.com

Similar codes

1 vote285 views1 answer
How to open local html file in python
Python
0 vote250 views2 answers
Pandas profile report
Python
5 votes271 views1 answer
Get hour in python
Python
0 vote302 views1 answer
Set pytesseract cmd path
Python
0 vote334 views1 answer
Listing of django model types
Python Django
0 vote316 views1 answer
Boto3 rename file s3
Python
0 vote294 views1 answer
Print a commans in python
Python
1 vote288 views1 answer
Two for loops in list comprehension
Python
1 vote321 views1 answer
R2 score sklearn
Python
1 vote305 views1 answer
Model checkpoint keras
Python