/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 vote118 views4 answers
Food
Python
1 vote178 views1 answer
Django return only part of string
Python Django
0 vote120 views1 answer
Site:*.instagram.com
Python
0 vote158 views1 answer
Pandas save csv list as columns
Python
-2 votes131 views1 answer
Switch in python'
Python
1 vote132 views1 answer
Frequency of occurrence of that element in the list and the positions
Python
1 vote141 views1 answer
Plotly line plot
Python
2 votes146 views2 answers
Pandas replace null values with values from another column
Python
1 vote137 views1 answer
Two elements at a time in list comprehension
Python
2 votes133 views4 answers
Count values in array python
Python