pandas series to csv

Question

I have following pandas series:

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

I need to save this as csv but csv rows should be something similar to following:

1, 11283, 01, 5
2,5, 1, 1
6, 33, 21, 2
11283, 01, 5,1
8430, 01, 2, 2
2, 1, 1, 1

You have a `pandas.Series` of a list of lists? – Jon Clements Aug 16 '18 at 12:35 — Jon Clements, Aug 16 '18 at 12:35
yes. pandas.series of list of list, – user2805885 Aug 16 '18 at 12:37 — user2805885, Aug 16 '18 at 12:37

Scott Boston · Accepted Answer · 2018-08-16T13:06:42.237

4

Try:

df = pd.Series([[[1, 11283, 1, 5], [2,5, 1, 1]], 
                [[6, 33, 21, 2], [11283, 1, 5,1]], 
                [[8430, 1, 2, 2],[2, 1, 1, 1]]])

df.apply(pd.Series).stack().reset_index(drop=True)

As @jezrael, @coldspeed, and many other pandas gods have suggested use the following over apply(pd.Series):

pd.DataFrame(df.values.tolist()).stack().reset_index(drop=True)

Output:

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]
dtype: object

edited Aug 16 '18 at 13:06

answered Aug 16 '18 at 12:44

Scott Boston

147,308
15
139
187

3

`df.apply(pd.Series)` rather not, because slow - check [this](https://stackoverflow.com/a/35491399/2901002) – jezrael Aug 16 '18 at 12:45
such a beauty ! – Yuca Aug 16 '18 at 12:45
1

`df = pd.DataFrame(s.values.tolist()).stack().reset_index(drop=True)` – jezrael Aug 16 '18 at 13:04
2

@jezrael Thanks, I will drill that into my skull one of these days. I appreciate the advice. – Scott Boston Aug 16 '18 at 13:07

score 1 · Answer 2 · answered Aug 16 '18 at 12:41

If you don't care about 01 becoming 1:

df = pd.Series([[[1, 11283, 1, 5], [2,5, 1, 1]], 
                [[6, 33, 21, 2], [11283, 1, 5,1]], 
                [[8430, 1, 2, 2],[2, 1, 1, 1]]])
flat_list = [item for sublist in df.tolist() for item in sublist if item not in (',','[',']')]
pd.DataFrame(flat_list).to_csv('your_path')

pandas series to csv

2 Answers2