/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 vote163 views1 answer
Tkinter sin
Python
1 vote155 views1 answer
Renpy scene vs show
Python
0 vote117 views3 answers
How to correct spelling in pandas datafeame
Python
7 votes163 views4 answers
XLRDError: Excel xlsx file; not supported
Python
3 votes192 views3 answers
Generate n different random numbers python
Python
5 votes172 views2 answers
Pandas conditional collumn
Python
5 votes162 views2 answers
Convert response to json python
Python
0 vote183 views2 answers
Python split word into letter pairs
Python
4 votes166 views2 answers
Make binary tree in python
Python
1 vote181 views4 answers
How to input in a list in python
Python