/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

0 vote274 views1 answer
Save model history keras
Python
1 vote240 views1 answer
How to only print final iteration of a for loop pyhton
Python
0 vote256 views1 answer
Python diffie hellman
Python
15 votes258 views5 answers
Throw error in python
Python
0 vote296 views1 answer
Glob read multiple images
Python
22 votes253 views4 answers
How to remove all characters after a specific character in python?
Python
0 vote213 views1 answer
Df get columnvalues
Python
0 vote265 views1 answer
Getting python class from string
Python
0 vote298 views1 answer
Access django server from another machine
Python Django
0 vote255 views1 answer
Split by backslash python
Python