How to Replace DataFrames with Lists of Dictionaries

Pandas DataFrames can be a very convenient way to read, edit and visualize small tabular data. But they also come with a few major downsides:

• They don’t work well with Python native data types
• They are not convenient with nested data
• Some operations can be very slow
• They take a lot of space

When fetching data from an API, the API will likely return a JSON string. Although there is a way to convert …

dataframes json lists pandas python