/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 vote310 views1 answer
Autopytoexe
Python
0 vote286 views1 answer
How ti maek a prinyt comnad i pyuthon
Python
0 vote294 views1 answer
Update numpy in python
Python
0 vote238 views1 answer
Python google docs api how to get doc index
Python
4 votes296 views2 answers
Mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
Python
0 vote285 views1 answer
Check if number is divisible without remainder python
Python
1 vote299 views1 answer
A list inside a list python
Python
5 votes281 views3 answers
Strptime python
Python
0 vote286 views1 answer
Gdscript tween
Python
0 vote290 views1 answer
Python if index in list exists
Python