Hi Team How do I concatenate certain rows in my input as shown below Input - [Capture57] Output - [Capture58] Attaching excel sheet below - Example.xlsx (9.5 KB) Regards Arjun

Below is the solution in python import pandas as pd xls = pd.ExcelFile(r’File_Location.xlsx’) df = pd.read_excel(xls, ‘Sheet2’) df[‘subject’] = df.groupby([‘Name’])[‘subject’].transform(lambda x : ’ '.join(x)) df[‘Marks’] = df.groupby([‘Name’])[‘Marks’].transform(lambda x : ’ '.join(x)) df = d…

Concatenating rows

Help Activities

lakshman (Ganta lakshman) September 16, 2021, 4:12pm 2

@shekhawat.arjun1307

Have a look below thread and follow the same steps.

1 Like

Topic		Replies	Views
How to merge duplicate rows and add values of other columns Activities database	4	3395	September 19, 2021
Merging duplicate rows in a data table Activities excel	5	2275	April 2, 2022
Help adding rows to each other in data table Activities datatable , excel , activities , question	8	1796	October 20, 2021
Datatable duplicate manipulation with Enumerables? - GROUP_CONCAT() Activities datatable , excel , activities , data_manipulation	4	1019	June 12, 2022
Concatenate column values where duplicates using linq Activities datatable , excel , activities , studio	7	71	October 31, 2024

Concatenating rows

Related topics