2

I have the data like this:

name SF
a   {1,23,4,5}
b   {1,3,43,5}
c   {1,23,24,5}
d   {1,23,54,15}

I want to let the SF set to list what I expect output is:

name SF
a   [1,23,4,5]
b   [1,3,43,5]
c   [1,23,24,5]
d   [1,23,54,15]

So,How can I do this?

ileadall42
  • 631
  • 2
  • 7
  • 19

1 Answers1

5

You can use apply(set) and apply(list) to convert the data type back and forth:

df.SF = df.SF.apply(list)
print(df)

#  name               SF
#0    a    [1, 4, 5, 23]
#1    b    [1, 3, 5, 43]
#2    c   [24, 1, 5, 23]
#3    d  [1, 23, 54, 15]

df.SF = df.SF.apply(set)
print(df)

#  name               SF
#0    a    {1, 4, 5, 23}
#1    b    {1, 3, 5, 43}
#2    c   {24, 1, 5, 23}
#3    d  {1, 23, 54, 15}
Psidom
  • 209,562
  • 33
  • 339
  • 356