/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 vote99 views1 answer
Python insert sorted
Python
0 vote101 views1 answer
Mask and then fillnan#
Python
0 vote102 views1 answer
Import argv python
Python
0 vote112 views1 answer
Get a list of ids from queryset django
Python
1 vote98 views1 answer
Module "django.contrib.auth.hashers" does not define a "BcryptPasswordHasher" attribute/class
Python
0 vote161 views1 answer
Default stride value in keras
Python
0 vote104 views1 answer
Decimal characters python
Python
0 vote109 views1 answer
Trends in yearly data python
Python
0 vote101 views1 answer
Undef variable
Python
0 vote90 views1 answer
Ping all IP addresses in a network
Python