/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

8 votes133 views3 answers
Linear search python
Python
0 vote145 views2 answers
If list of columns exist pandas
Python
0 vote150 views1 answer
See you tomorrow in italian
Python
0 vote140 views2 answers
Iris data pandas scatterplot
Python
0 vote138 views1 answer
Python difference between consecutive element in list
Python
5 votes134 views2 answers
Isnotin python
Python
1 vote148 views1 answer
Change shortcuts in pychar,
Python
3 votes134 views1 answer
Selenium other item would revieve click
Python
0 vote193 views2 answers
How to refresh page in flask
Python Flask
0 vote158 views2 answers
Split a list based on a condition
Python