/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 vote187 views1 answer
Python lane angle detection
Python
5 votes188 views2 answers
Pygame flip image
Python
-2 votes193 views1 answer
Python web server shell
Python
0 vote201 views1 answer
Using replace() method to remove newlines from a string
Python
0 vote205 views1 answer
Python child class init
Python
0 vote253 views4 answers
Concat dicts python
Python
10 votes201 views3 answers
Accessing element from csv file in python
Python
9 votes185 views1 answer
How to create a keylogger in python
Python
0 vote215 views1 answer
How to check if two strings are same in Python
Python
0 vote267 views1 answer
Flask session auto logout in 5 mins
Python Flask