/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

16 votes232 views6 answers
Django forms
Python Django
0 vote242 views2 answers
How to use django-filters with viewset
Python Django
13 votes213 views3 answers
Find the factorial of a given integer in python
Python
0 vote238 views1 answer
ModuleNotFoundError: No module named 'rest_auth'
Python
0 vote210 views1 answer
How to import flask restful using pip
Python
0 vote163 views2 answers
Python union type
Python
0 vote250 views2 answers
How to schedule python script in windows
Python
32 votes199 views4 answers
Python pip install matplotlib
Python
0 vote231 views1 answer
Installing intel python
Python
0 vote221 views1 answer
Python returning rows and columns from a matrix string
Python