/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 vote342 views1 answer
List square python
Python
3 votes344 views1 answer
PackagesNotFoundError: The following packages are not available from current channels: - python==3.6
Python
0 vote379 views1 answer
Python multiline comment using docstrings
Python
1 vote420 views1 answer
Python print no end of line
Python
12 votes364 views2 answers
Read excel file spyder
Python
0 vote347 views1 answer
Python pandas convert comma separated number string to integer list
Python
0 vote357 views1 answer
Modules django
Python
2 votes370 views2 answers
How to convert string to byte without encoding python
Python
2 votes360 views4 answers
How to add column to np array
Python
1 vote349 views1 answer
Python find first duplicate numbers
Python