Mike Johnson Jr Mike Johnson Jr - 7 months ago 53
Python Question

Merging rows in pandas

Say I have a dataframe that looks something like this

Line VarA VarB
345 Something abc
346 Something2 def
347 Something ghi
348 Something2 jkl
349 Something mno
350 Something2 pqr
351 Something stu
352 Something2 vwx

How can I turn this dataframe into something that looks like this:

VarA VarB
Something abcghimnostu
Something2 defjklpqrvwx


You can just groupby and sum

something     abcghimnostu
something2    defjklpqrvwx
Name: VarB, dtype: object