/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 vote260 views2 answers
Pyqt message box set detailed text
Python
20 votes280 views3 answers
Accommodation
Python
0 vote221 views1 answer
Get parameter value dynamo python
Python
2 votes245 views1 answer
Save file python tkinter
Python
0 vote226 views1 answer
Gfrequency listing in pandas
Python
72 votes237 views5 answers
How to run for loop in python
Python
-1 vote257 views1 answer
Transpose 3d matrix pytorch
Python
1 vote264 views3 answers
Accessing data on django sessionstore
Python
0 vote250 views1 answer
Play Audio File In Background Python
Python
2 votes306 views2 answers
Localize timezone python
Python