Pandas series flatten array to csv [duplicate]

Question

I have following pandas series

0    [1, 11283, 1, 5]
1        [2, 5, 1, 1]
2      [6, 33, 21, 2]
3    [11283, 1, 5, 1]
4     [8430, 1, 2, 2]
5        [2, 1, 1, 1]

I need to right this to csv. But I need each item in a list as separate column. For example: In fist row, 1, 11283, 1, 5 should be separate column

user3483203 · Accepted Answer · 2018-08-17 04:53:37Z

2

Assuming your series is called s, you may create a new DataFrame using tolist:

out = pd.DataFrame(s.values.tolist())

       0      1   2  3
0      1  11283   1  5
1      2      5   1  1
2      6     33  21  2
3  11283      1   5  1
4   8430      1   2  2
5      2      1   1  1

And save to csv.

pd.to_csv(out)

edited Aug 17, 2018 at 4:53

answered Aug 17, 2018 at 4:38

user3483203

51.3k10 gold badges72 silver badges104 bronze badges

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

1 Comment

user3483203 Over a year ago

@user2805885 added an explanation

Collectives™ on Stack Overflow

Pandas series flatten array to csv [duplicate]

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related