/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

1 vote238 views1 answer
Flask error f = open(f'{getcwd()}/haikus/{haiku}',"r") ^ SyntaxError: invalid syntax
Python Flask
18 votes206 views6 answers
Remove punctuation from string python
Python
0 vote168 views1 answer
Python difference between filter and map
Python
0 vote179 views1 answer
Python tensorflow is not defined
Python
0 vote162 views1 answer
Random Average
Python
2 votes192 views2 answers
Label encoder python
Python
0 vote143 views1 answer
How to use randon in python
Python
0 vote165 views1 answer
Rounding values in pandas dataframe
Python
0 vote173 views1 answer
Change group box title font size
Python
125 votes179 views6 answers
How to take input from user in python
Python