/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 vote285 views1 answer
Python dictionary get vs setdefault
Python
2 votes340 views1 answer
Database default code in settings django
Python
0 vote335 views1 answer
Example python
Python
17 votes297 views4 answers
Flask render_template
Python
1 vote344 views1 answer
Return result from exec python
Python
3 votes308 views3 answers
Extract domain name from url python
Python
17 votes301 views1 answer
Np.save function
Python
33 votes314 views4 answers
Change dataframe column type
Python
4 votes322 views1 answer
What is cleaned data in django
Python
0 vote327 views1 answer
Description of imdb dataset python
Python