/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 vote145 views1 answer
How to average only positive number in array numpy
Python
133 votes154 views6 answers
How to use input in python
Python
0 vote174 views1 answer
The grandest staircase of them all foobar solution
Python
5 votes162 views4 answers
Python get last key in dict
Python
0 vote159 views1 answer
How to plot side by side bar horizontal bar graph in python
Python
2 votes154 views1 answer
Python get all variables in class
Python
0 vote132 views1 answer
Ordenar lista decrescente python
Python
0 vote134 views1 answer
Calculate time python
Python
31 votes140 views5 answers
How to loop through files in a directory python
Python
1 vote142 views1 answer
Paradigm meaning in python
Python