I want to split a column with multiple values as one

Question

So my current column looks like this

So, some field have multiple value and some don't, how do i separate them into a single value.

Does this answer your question? [How to split a dataframe string column into two columns?](https://stackoverflow.com/questions/14745022/how-to-split-a-dataframe-string-column-into-two-columns) — SunilG, Jun 18 '21 at 04:34
@TimBiegeleisen it doesnt, so every value from the original columns gets moved to a new column. — , Jun 18 '21 at 04:39

Anurag Dabas · Accepted Answer · 2021-06-18T04:42:57.300

0

IIUC:

df['New Name']=df['Name'].str.upper().str.split(',').explode(ignore_index=True)[0:len(df)]

output of df:

   Name     New Name
0   A       A
1   B,A     B
2   c       A
3   D,G     C

edited Jun 18 '21 at 04:42

answered Jun 18 '21 at 04:36

Anurag Dabas

score -1 · Answer 2 · answered Jun 18 '21 at 04:33

-1

I’m not super familiar with tables but I’m sure you could still use string.split(“,”)

answered Jun 18 '21 at 04:33

Tony Dean

I tried that, it returns None for fields which don't have multiple values – Jun 18 '21 at 04:34

2 Answers2