/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 vote207 views1 answer
Quadratic equation python
Python
0 vote197 views1 answer
Python get num chars
Python
0 vote215 views1 answer
Django command to fetch all columns of a table
Python Django
17 votes220 views5 answers
What is python used for
Python
0 vote203 views1 answer
Python non public method
Python
0 vote217 views2 answers
Loop only to the 6th element python
Python
0 vote188 views1 answer
Generate 50 characters long for django
Python
1 vote232 views1 answer
Make averages on python
Python
2 votes193 views4 answers
Count values in array python
Python
0 vote197 views1 answer
Pandas transform date format?
Python