/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 vote305 views3 answers
COVID-19)
Python
0 vote273 views1 answer
How to add find the smallest int n in a list python
Python
11 votes271 views2 answers
How to create progress bar python
Python
0 vote291 views8 answers
Javascript loop Tool
Python
2 votes261 views6 answers
How to merge more than 2 dataframes in python
Python
0 vote273 views1 answer
Multiple sub in single regex
Python
148 votes318 views10 answers
Grepper
Python
0 vote296 views1 answer
Compress excel file in python
Python
0 vote281 views1 answer
Degree symbol in python
Python
10 votes303 views1 answer
Pandas dataframe creation column names
Python