/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

1 vote308 views1 answer
'set' object is not reversible
Python
48 votes314 views6 answers
Python to exe
Python
6 votes367 views1 answer
Run py file in another py file
Python
1 vote324 views3 answers
List of prime numbers in python
Python
0 vote301 views1 answer
Python regeression line
Python
0 vote325 views2 answers
Phow to install python modules in no internet in sercer
Python
3 votes303 views1 answer
Datetimes to day of year python
Python
0 vote334 views1 answer
Access kwargs in template django
Python
0 vote299 views2 answers
Remove nans and infs python
Python
58 votes404 views6 answers
Python class
Python