Convert a list of dictionaries to a table (numpy matrix)? [duplicate]

Question

Let the given dictionaries are

d = [{'a':1,'b':4},{'b':2}]

So basically I want a matrix like this

  | 'a' | 'b'  |
 _______________
  |  1  |  4   |
  |  na |  2   |

How can I efficiently achieve this ?

John Zwinck · Accepted Answer · 2016-07-03 16:56:25Z

15

The Pandas DataFrame constructor will immediately give you the result you are looking for:

import pandas as pd
pd.DataFrame(d).values

The .values part on the end converts the result to a NumPy array, which is what you asked for. Some people would just work directly with the DataFrame instead.

answered Jul 3, 2016 at 16:56

John Zwinck

252k44 gold badges346 silver badges459 bronze badges

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

1 Comment

Regorsmitz Over a year ago

Using DataFrame might be convenient, but if speed is a concern it seems like overkill. I've read a (hopefully credible) article that specifically warns about the cost of creating a DataFrame: linkedin.com/pulse/…. So, I'm curious what the most efficient method would be if we wanted to avoid the overhead of creating a Pandas DataFrame.

Collectives™ on Stack Overflow

Convert a list of dictionaries to a table (numpy matrix)? [duplicate]

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related