/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 vote137 views1 answer
Python read xls
Python
10 votes129 views2 answers
English to japanese
Python
5 votes154 views6 answers
Dict comprehension python
Python
60 votes147 views6 answers
Python list length
Python
40 votes181 views5 answers
New line print python
Python
6 votes133 views2 answers
Jupyter display all columns
Python
8 votes92 views1 answer
How to check if string exists in array pytohn
Python
0 vote167 views1 answer
How to find out the max and min date on the basis of property id in pandas
Python
18 votes162 views3 answers
Download pyautogui
Python
1 vote136 views1 answer
Handler.setLevel(logging.DEBUG) not working python
Python