/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 vote196 views1 answer
How to open chrome console in selenium webdriver
Python
0 vote185 views1 answer
Python types generator
Python
0 vote203 views1 answer
Provide a script that prints the sum of every even numbers in the range [0; 100].
Python
3 votes189 views1 answer
Datetime.timedelta months
Python
0 vote214 views1 answer
What is require_self
Python
6 votes185 views2 answers
Python re search print
Python
1 vote219 views1 answer
Django loop index
Python Django
0 vote187 views1 answer
Robust scaler
Python
0 vote201 views1 answer
Download python libraries offline
Python
0 vote174 views3 answers
How to compare the two key from constant value to list of string in python
Python