/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 vote233 views1 answer
Remove grid from 3d plots
Python
18 votes216 views3 answers
Python ascii code to string
Python
1 vote242 views1 answer
Pygame mute import message
Python
3 votes261 views3 answers
Django.db.utils.OperationalError: no such table:
Python Django
27 votes190 views2 answers
Draw a line pygame
Python
0 vote250 views1 answer
Numpy python 3.10
Python
11 votes190 views2 answers
Python cls statement using os module
Python
0 vote230 views1 answer
Ordered dict
Python
63 votes178 views3 answers
Iterate through a list
Python
33 votes223 views4 answers
Python error handling
Python