/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

2 votes175 views1 answer
Flask if statement
Python
1 vote198 views6 answers
Add item to tuple python
Python
1 vote174 views1 answer
Qspinbox disable wheel python
Python
0 vote183 views1 answer
Bar plot bokeh
Python
0 vote178 views1 answer
Argmin returns one value for 2d array
Python
0 vote184 views1 answer
Delete nans in df python
Python
1 vote177 views2 answers
Django timezone settings
Python Django
1 vote187 views3 answers
Pdf to csv
Python
0 vote205 views1 answer
Lcd screen 3.5 inch to pi
Python
0 vote176 views1 answer
Hsv to rgb python
Python