convert a string delimited by comma into list in pandas

Question

I have a dataframe which has two columns. Each column has comma separated string. I am trying to convert this string into list and hence I can subtract two lists as a_b = list(set(a) - set(b)) for each row for the following dataset.

  Col1      Col2
  a,b,c,f   d,f,g
  d,g       w,a,d
  f,g,h     f,g,h

I tried converting items into list as below

df1['Col1']tolist()

But it doesn't seem to work. Thanks.

Check str.split : df['Col1'].str.split(',')

Chris Adams
– Chris Adams

2019-12-11 10:03:20 +00:00
Commented Dec 11, 2019 at 10:03 — Chris Adams
– Chris Adams, Commented Dec 11, 2019 at 10:03

Chris Adams · Accepted Answer · 2019-12-11 10:15:45Z

5

You can use str.split to split a comma-separated string to list. You can also use apply(set) for your specific purposes IIUC:

(df['Col1'].str.split(',').apply(set) - df['Col2'].str.split(',').apply(set)).tolist()

[out]

[{'a', 'b', 'c'}, {'g'}, set()]

answered Dec 11, 2019 at 10:15

Chris Adams

18.7k4 gold badges26 silver badges44 bronze badges

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

Collectives™ on Stack Overflow

convert a string delimited by comma into list in pandas

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related