Converting string of strings to list in dataframe

Question

I have a dataframe as following:

id|words
1|ant,bat,cat
2|mat,rat,pat

I want the words column to be as follows:

id|words
1|['ant','bat','cat']
2|['mat','rat','pat']

How could I do it? I tried with literaleval but it shows exception

@jezrael why you think that is not dup ? from what I saw only the sep is different — BENY
– BENY, Commented Jun 2, 2020 at 14:09
@YOBEN_S - Answer is about first value of splitted separator. — jezrael
– jezrael, Commented Jun 2, 2020 at 14:19
@jezrael before they get the first value , it save whole list I think — BENY
– BENY, Commented Jun 2, 2020 at 14:22

jezrael · Accepted Answer · 2020-06-02 13:49:36Z

3

df['words'] = df['words'].str.split(',')

answered Jun 2, 2020 at 13:49

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1