memory - MemoryError in Python when saving list to dataframe

Question

I was trying to do the following, which is to save a python list that contains json strings into a dataframe in jupyternotebook

df = pd.io.json.json_normalize(mon_list)
df[['gfmsStr','_id']]

But then I received this error:

MemoryError

Then if I run other blocks, they all start to show the memory error. I am wondering what caused this and if there is anyway I can increase the memory to avoid the error.

Thanks!

update: what's in mon_list is like the following:

mon_list[1]

[{'id': 1, 'name': {'first': 'Coleen', 'last': 'Volk'}},
        {'name': {'given': 'Mose', 'family': 'Regner'}},
        {'id': 2, 'name': 'Faye Raker'}]

Answer 1

Do you really have a list? Or do you have a JSON file? What format is the "mon_list" variable?

This is how you convert a list to a Dataframe

# import pandas as pd 
import pandas as pd 
  
# list of strings 
lst = ['Geeks', 'For', 'Geeks', 'is',  
            'portal', 'for', 'Geeks'] 
  
# Calling DataFrame constructor on list 
df = pd.DataFrame(lst)

https://www.geeksforgeeks.org/create-a-pandas-dataframe-from-lists/