python - Concat and merge dataframe

Question

This question already has answers here: question from:https://stackoverflow.com/questions/65949099/concat-and-merge-dataframe

Answer 1

You can try the following approach:

# import pandas library 
import pandas as pd 
  
# concatenate the string 
df['Subblock'] = df.groupby(['Blocks'])['Subblock'].transform(lambda x : ','.join(x)) 
  
# drop duplicate data 
df = df.drop_duplicates()    
  
# show the dataframe 
print(df)