/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

23 votes254 views1 answer
Python get minute from datetime
Python
0 vote306 views1 answer
Compute confusion matrix using python
Python
1 vote261 views1 answer
Connecting Kaggle to Google Colab
Python
5 votes316 views3 answers
How to run flask in port 80
Python
1 vote244 views1 answer
Python all letters capital
Python
35 votes280 views6 answers
Create pandas dataframe from dictionary
Python
1 vote286 views2 answers
Python how to print variable value
Python
1 vote323 views1 answer
How to filter queryset with foreign key in django
Python Django
0 vote261 views1 answer
Dataframe time index convert tz naive to tz aware
Python
0 vote297 views1 answer
If settings.debug
Python