/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 vote215 views2 answers
Chrome driver selenium python online compiler
Python
0 vote209 views1 answer
Shared a local host django
Python
2 votes204 views1 answer
How to return a value from a function in python
Python
7 votes203 views1 answer
Learn python the hard way pdf
Python
0 vote208 views1 answer
Split by backslash python
Python
1 vote195 views2 answers
Python mp4 to mp3
Python
0 vote189 views1 answer
How to resize image with pillow in django
Python Django
2 votes250 views1 answer
Django EMAIL_BACKEND console
Python Django
0 vote205 views1 answer
Distance of a point from a line python
Python
0 vote202 views1 answer
Analog of join in pathlibn
Python