/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 vote273 views1 answer
Django oauth toolkit permanent access token
Python
0 vote273 views1 answer
Pandas filter column greater than
Python
0 vote254 views1 answer
Python increment filename by 1
Python
-1 vote271 views1 answer
Using comma as the thousand separator
Python
0 vote259 views1 answer
Paschat opposite sanskrit
Python
4 votes302 views2 answers
Python read array line by line
Python
0 vote261 views1 answer
Socket python how to check if server alive
Python
0 vote273 views1 answer
Pandas group by multiple columns and count
Python
0 vote248 views1 answer
Python pandas how to select range of data
Python
3 votes266 views1 answer
WKUP2 in stm32 microcontroller
Python