Breaking News: Grepper is joining You.com. Read the official announcement!

Split pd dataframe to excel files based on a column value

answered on September 1, 2021 Popularity 6/10 Helpfulness 3/10

answer Split pd dataframe to excel files based on a column value

Split pd dataframe to excel files based on a column value

Comment

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.

Popularity 6/10 Helpfulness 3/10 Language python

Source: stackoverflow.com

Tags: python

Link to this answer
Share Copy Link

Contributed on Sep 01 2021

0 Answers Avg Quality 2/10

Split pd dataframe to excel files based on a column value

Contents

More Related Answers

Split pd dataframe to excel files based on a column value

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.