/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 vote68 views1 answer
How to sort subset of rows in pandas df
Python
0 vote138 views1 answer
How to deploy to heroku djangorest framework app
Python Django
6 votes114 views5 answers
12 hour clock to 24 hour clock in python
Python
7 votes106 views1 answer
// meaning in python
Python
2 votes113 views1 answer
Python create hash from string
Python
0 vote103 views1 answer
Python execute echo to file
Python
0 vote111 views1 answer
Sql like equivalent in python
Python
10 votes125 views10 answers
Hello
Python
1 vote113 views1 answer
Rabbitmq pika username password
Python
2 votes100 views1 answer
Fromkeys in python
Python