/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 votes281 views5 answers
Django message framework
Python Django
0 vote181 views3 answers
Hashing in python
Python
1 vote143 views1 answer
Print value of array python
Python
1 vote152 views1 answer
Python check if variables are the same
Python
5 votes152 views4 answers
Ask a question on python
Python
7 votes143 views1 answer
First position dict python
Python
2 votes160 views1 answer
How to run python file in when windows startup
Python
2 votes157 views2 answers
Scipy cosine similarity
Python
16 votes166 views6 answers
List.add in python
Python
9 votes147 views3 answers
Print for loop in same line python
Python