Creating a new column with concatenated values from another column

I am trying to create a new column in this data frame. The data set has multiple records for each PERSON because each record is a different account. The new column values should be a combination of the values for each PERSON in the TYPE column. For example, if John Doe has four accounts the value next to his nae in the new column should be a concatenation of the values in TYPE. An example of the final data frame is below. Thanks in advance.

enter image description here

https://stackoverflow.com/questions/67051361/creating-a-new-column-with-concatenated-values-from-another-column April 12, 2021 at 08:28AM