/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 vote153 views1 answer
Python 3 of 4 conditions true
Python
1 vote115 views1 answer
Iterate over pandas series
Python
0 vote216 views2 answers
How to refresh page in flask
Python Flask
0 vote195 views1 answer
From flask_paginate import get_page_parameter
Python Flask
0 vote212 views3 answers
Python matrix condensed to square
Python
1 vote146 views1 answer
Flatten json python
Python
5 votes158 views4 answers
Open mat file in python
Python
3 votes153 views1 answer
Get all indices of a value in list python
Python
0 vote156 views1 answer
Python 123 + 0.00
Python
0 vote159 views1 answer
Tkinter hide widget
Python