Auto fill np.nan for arrays of different size

Question

I want to pass a dictionary of items into Dataframe, but these items can have variable length arrays. What is the most elegant way to append np.nan to the arrays so that they match the sizes? For example:

pd.DataFrame.from_dict({"a":[1,2,3],"b":[1,2], "c":[1]})

should return me

a b c 1 1 1 2 2 nan 3 nan nan

behzad.nouri · Accepted Answer · 2014-03-13 18:19:49Z

5

maybe:

d = {"a":[1,2,3],"b":[1,2], "c":[1]} pd.concat(map(pd.Series, d.values()), keys=d.keys(), axis=1)

answered Mar 13, 2014 at 18:19

behzad.nouri

78.5k18 gold badges130 silver badges127 bronze badges

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

Comments

Shravan · Accepted Answer · 2014-03-13 19:50:55Z

Alternate solution:

d = {"a":[1,2,3],"b":[1,2], "c":[1]} pd.DataFrame({x:pd.Series(d[x]) for x in d})

Collectives™ on Stack Overflow

Auto fill np.nan for arrays of different size

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related