/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 vote151 views1 answer
Python invalid syntax for no reason
Python
1 vote160 views2 answers
Python split string on char
Python
5 votes161 views2 answers
Write in entry() in tkinter
Python
4 votes178 views4 answers
Speech to write anything python code
Python
0 vote177 views1 answer
Python tkinter AttributeError: 'NoneType' object has no attribute 'insert'
Python
0 vote191 views1 answer
Transpose 3d matrix pytorch
Python
1 vote189 views1 answer
Os remove entire folder python
Python
5 votes181 views1 answer
How to get a dataframe column as a list
Python
0 vote189 views1 answer
Import models
Python
1 vote169 views2 answers
Open choose files from file explorer python
Python