/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

2 votes329 views2 answers
Subplots matplotlib examples
Python
66 votes422 views6 answers
Python virtual environment
Python
0 vote353 views1 answer
Python tkinter colored line
Python
0 vote328 views1 answer
Python download video from instagram
Python
9 votes341 views6 answers
Pattern in python
Python
0 vote379 views1 answer
Pysimplegui themes
Python
0 vote406 views1 answer
Import tsv as dataframe python
Python
3 votes372 views1 answer
For e in p.event.get(): pygame.error: video system not initialized
Python
0 vote335 views1 answer
Python3 boto3 put object to s3
Python
23 votes345 views6 answers
Check tensorflow version
Python