How to convert list of values in a series into dataframe pandas

Question

I have a series like below,

0    [1, 12, 23]
1    [2, 23, 54]
2        [3, 23]
3            [4]
dtype: object

I want to convert this single series in to dataframe based on the values in list(explode).

Expected Output:

    0   1   2
0   1   12  23
1   2   23  54
2   3   23  None
3   4   None    None

I tried,

s=pd.Series([[1,12,23],[2,23,54],[3,23],[4]])
s=s.astype(str)
s.str.replace('\[|\]','').str.split(', ',expand=True)

My above code does the job though I'm looking for good way to solve this.

@Rakesh - assume that s is fixed, Don't change anything on s — Mohamed Thasin ah, Mar 13 '19 at 11:42
I already referred the duplicated post, it's something different from what I want — Mohamed Thasin ah, Mar 13 '19 at 11:44

anky · Accepted Answer · 2019-03-13T11:46:34.013

3

Use the below:

m = pd.DataFrame(s.values.tolist(), index= s.index)
print(m)

   0     1     2
0  1  12.0  23.0
1  2  23.0  54.0
2  3  23.0   NaN
3  4   NaN   NaN

edited Mar 13 '19 at 11:46

answered Mar 13 '19 at 11:42

anky

Thanks for the solution what's df here? – Mohamed Thasin ah Mar 13 '19 at 11:45
@MohamedThasinah thats the series name, editing it for better understanding. :) – anky Mar 13 '19 at 11:46

1 Answers1