/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 vote181 views1 answer
From future import division
Python
0 vote142 views1 answer
Pyqt5 qpush button pressed
Python
16 votes145 views6 answers
Printing in python
Python
0 vote150 views1 answer
Openpyxl iter_rows skip first
Python
0 vote127 views1 answer
R stagazer html knit
Python
0 vote159 views1 answer
Why python stops after plt.show()
Python
0 vote186 views1 answer
Dev.to flask heroku
Python Flask
0 vote182 views1 answer
Request.build_absolute_uri django
Python Django
0 vote163 views1 answer
Sample one point from distribution python
Python
9 votes177 views4 answers
For if else one line python
Python