/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

3 votes217 views2 answers
How to print last element in a list python
Python
1 vote201 views1 answer
Python dictionary if not found
Python
13 votes233 views2 answers
Self calling function
Python
1 vote200 views1 answer
Remove columns that contain certain names in pandas
Python
0 vote222 views1 answer
Flask return 404
Python Flask
-1 vote201 views1 answer
Python iterate over instances of class
Python
-3 votes252 views1 answer
ValueError: With n_samples=0, test_size=0.2 and train_size=None, the resulting train set will be empty. Adjust any of the aforementioned parameters.
Python
18 votes212 views4 answers
Python compiler and shell online
Python
0 vote218 views1 answer
How to make bak files with python
Python
0 vote206 views1 answer
Using csv module how to read perticular lines in csv
Python