create a dataframe in python from variable size lists

Question

I have multiple lists like following

a = [(1,1),(2,2),(3,3),(3, 4)]
b = [("foo", "bar")]
c = [(4938,1203), (329,213)]

I want to convert this to data frame like following

a       b      c
(1,1)  ("foo","bar")  (4938,1203)
(2,2)   NA            (329,213)
(3,3)  NA              NA
(3,4)   NA              NA

Like pd.DataFrame([a,b,c], index=list('abc')).T?

fsl
– fsl

2019-11-10 22:09:34 +00:00
Commented Nov 10, 2019 at 22:09 — fsl
– fsl, Commented Nov 10, 2019 at 22:09

willeM_ Van Onsem · Accepted Answer · 2019-11-10 22:09:24Z

1

You can just create a dataframe like:

df = pd.DataFrame({'a': pd.Series(a), 'b': pd.Series(b), 'c': pd.Series(c)})

This then will yield:

>>> df = pd.DataFrame({'a': pd.Series(a), 'b': pd.Series(b), 'c': pd.Series(c)})
>>> df
        a           b             c
0  (1, 1)  (foo, bar)  (4938, 1203)
1  (2, 2)         NaN    (329, 213)
2  (3, 3)         NaN           NaN
3  (3, 4)         NaN           NaN

answered Nov 10, 2019 at 22:09

willeM_ Van Onsem

482k33 gold badges483 silver badges624 bronze badges

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

Collectives™ on Stack Overflow

create a dataframe in python from variable size lists

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related