/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

3 votes118 views2 answers
Extract pdf text with python
Python
0 vote119 views1 answer
Code suggestion html not working in django-html
Python
0 vote163 views1 answer
Sns save chart
Python
0 vote137 views2 answers
How to get username discord ext python
Python
0 vote117 views1 answer
Get first not null value from column dataframe
Python
0 vote134 views1 answer
Python string name out of mail
Python
2 votes184 views1 answer
Truncate templat tag django
Python Django
1 vote130 views1 answer
Ipykernel pip
Python
6 votes134 views3 answers
Pythin taking input for array
Python
0 vote113 views1 answer
Enormous input test codechef solution
Python