/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 vote325 views1 answer
Compress image pillow
Python
0 vote302 views1 answer
Discord embed colors python
Python
0 vote342 views1 answer
Convert \x unicode utf 8 bytes to \u python
Python
0 vote312 views1 answer
Import nifti to numpy
Python
0 vote314 views1 answer
Foreign key django createview
Python
0 vote356 views1 answer
Form_valid
Python
0 vote313 views1 answer
Python -m pip install -u pip
Python
8 votes333 views3 answers
Remove the First Character From the String in Python Using the Slicing
Python
1 vote334 views1 answer
Django filter by category
Python
1 vote324 views1 answer
Python sqlite dict
Python