/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

20 votes177 views2 answers
Plot data python
Python
0 vote169 views1 answer
Python coding for y, you will also display a “bar” of ‘X’ characters to represent the number. For example, the prime number 2 would be represented as “X 2”.
Python
0 vote168 views1 answer
Python string iterate 3 characters at a time
Python
1 vote198 views1 answer
Flask error f = open(f'{getcwd()}/haikus/{haiku}',"r") ^ SyntaxError: invalid syntax
Python
36 votes179 views6 answers
Requirement.txt for python
Python
0 vote169 views1 answer
Fetch image url discord py
Python
9 votes185 views1 answer
Create models in django
Python
0 vote161 views1 answer
Find common string in two strings python
Python
0 vote174 views1 answer
Pytorch cuda tensor in module
Python
-1 vote191 views1 answer
Python mean ndarray
Python