Convert elements of a list in Dataframe to a column

Question

I have a Dataframe as below:

                                 2021-02-01 00:00:00
0  [0.22081292351898762, 0.22248217707309176, 0.2...

I'd like to change it to:

   2021-02-01 00:00:00
0  0.22081292351898762
1  0.22248217707309176
2  0.2...
3  00000

Please give me some advises. Thank you.

Does this help? stackoverflow.com/questions/27263805/…

vojtam
– vojtam

2021-03-22 08:20:40 +00:00
Commented Mar 22, 2021 at 8:20 — vojtam
– vojtam, Commented Mar 22, 2021 at 8:20

SiNcSaD · Accepted Answer · 2021-03-22 08:22:06Z

1

Sample:

data = {'my_column': [
    [1, 2, 3],
    [4, 5, 6],
]}
df = pd.DataFrame(data)
print(df)
   my_column
0  [1, 2, 3]
1  [4, 5, 6]

Use explode:

df_explode = df.explode('my_column', ignore_index=True)
print(df_explode)
  my_column
0         1
1         2
2         3
3         4
4         5
5         6

answered Mar 22, 2021 at 8:22

SiNcSaD

112 bronze badges

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

Comments

Rikky Bhai · Accepted Answer · 2021-03-22 09:25:10Z

1

lst = [] //your list
Use df = pd.DataFrame(lst)

edited Mar 22, 2021 at 9:25

answered Mar 22, 2021 at 8:22

Rikky Bhai

1,0183 gold badges16 silver badges40 bronze badges

2 Comments

Gino Mempin Over a year ago

Don't name your variables list, because it can shadow the built-in type list.

Syscall Over a year ago

Thank you for this code snippet, which might provide some limited, immediate help. A proper explanation would greatly improve its long-term value by showing why this is a good solution to the problem and would make it more useful to future readers with other, similar questions. Please edit your answer to add some explanation, including the assumptions you’ve made.

Collectives™ on Stack Overflow

Convert elements of a list in Dataframe to a column

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related