/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 vote129 views1 answer
Discordpy get role by id
Python
1 vote136 views1 answer
How to add a cooment in python
Python
11 votes129 views3 answers
Import RandomForestClassifier
Python
0 vote118 views1 answer
Pandas dataframe any along row
Python
89 votes117 views6 answers
Sleep python
Python
0 vote121 views1 answer
Python3 call parent constructor
Python
0 vote132 views1 answer
Block encoding request python
Python
0 vote122 views2 answers
How to make a function input optional in python
Python
76 votes152 views6 answers
Python iterate through list
Python
0 vote117 views1 answer
TypeError: add() got an unexpected keyword argument 'kernel_regularizer'
Python