/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 vote312 views2 answers
Generate secret key python
Python
33 votes295 views2 answers
Python b to string
Python
1 vote370 views1 answer
How to remove plotly toolbar
Python
1 vote322 views1 answer
Convert mp3 to wav python
Python
0 vote305 views1 answer
Pandas dexcribe only one column
Python
1 vote294 views1 answer
Python trick big numbers visualisation
Python
2 votes288 views1 answer
Jinja inheritance
Python
1 vote318 views1 answer
Square of numbers in non-decreasing order
Python
1 vote368 views1 answer
Flask api with parameter
Python Flask
43 votes301 views2 answers
For loop in df rows
Python