/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 vote107 views1 answer
WxPython wx.Window Connect example
Python
3 votes93 views5 answers
Pandas split column into multiple columns
Python
2 votes104 views1 answer
Armstrong number python
Python
0 vote118 views1 answer
How to append panda columns using loop
Python
4 votes109 views1 answer
Np.random.float
Python
0 vote108 views1 answer
Create array of specific size python
Python
1 vote106 views1 answer
Python detect if tkinter page closed
Python
0 vote114 views1 answer
Rails in groups of
Python
0 vote124 views1 answer
Boston data set to pandas df
Python
2 votes119 views1 answer
Python can't subtract offset-naive and offset-aware datetimes
Python