Transforming a dataset

Question

I have a dataframe like so:

ID  | Value1  | Value2  | Tags
1   |    1    |    6    |   Alex/Jason
2   |    6    |    3    |   Miranda
3   |    5    |    9    |   Jose/Rebecca
4   |    2    |    7    |   Max
5   |    0    |    1    |   Lilly

I want to split the Tag column by a delimiter (in this case "/") and then duplicate the rows such that there is only one Tag per row:

ID  | Value1  | Value2  | Tags
1   |    1    |    6    |   Alex
1   |    1    |    6    |   Jason
2   |    6    |    3    |   Miranda
3   |    5    |    9    |   Jose
3   |    5    |    9    |   Rebecca
4   |    2    |    7    |   Max
5   |    0    |    1    |   Lilly

I am using pandas! I know how to split strings by delimiter, but not sure how to then replicate them into separate rows. Any tutorials you might know? — NBC, Mar 07 '18 at 19:23

score 1 · Answer 1 · answered Mar 07 '18 at 19:42

There is one solution

s=df.Tags.str.split('/')

pd.concat([df[['ID','Value1','Value2']].reindex(df.index.repeat(s.str.len()))]).assign(Tags=s.sum())
Out[580]: 
   ID  Value1  Value2     Tags
0   1       1       6     Alex
0   1       1       6    Jason
1   2       6       3  Miranda
2   3       5       9     Jose
2   3       5       9  Rebecca
3   4       2       7      Max
4   5       0       1    Lilly

Transforming a dataset

1 Answers1