/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 vote113 views1 answer
Sqlite3 python parameterized query insert into
Python
0 vote109 views1 answer
Sound alerts in Jupyter for code completion and exceptions
Python
0 vote106 views2 answers
How to use information from env variables in python
Python
0 vote146 views3 answers
Django prevent duplicate entries
Python Django
0 vote161 views1 answer
Gpt2 simple restore_from
Python
1 vote110 views1 answer
Discord get bot profile picture
Python
14 votes121 views4 answers
Plt subplots figsize
Python
0 vote71 views1 answer
Actualizar pip
Python
19 votes145 views4 answers
How to create an auto clicker in python
Python
17 votes123 views4 answers
How to check python version linux
Python