/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 vote142 views1 answer
How to redirect where requests library downloads file python
Python
0 vote145 views1 answer
Train chatterbot using yml
Python
43 votes140 views4 answers
Conda env
Python
6 votes153 views6 answers
Tuple methods in python
Python
6 votes137 views4 answers
How to encrypt text in python
Python
0 vote144 views1 answer
Check how many letters in a string python
Python
1 vote140 views1 answer
In pandas how to start an index from a specific number
Python
-4 votes150 views4 answers
Latest django version
Python
1 vote128 views2 answers
Add item to tuple
Python
19 votes145 views6 answers
How to sort a list in python
Python