Working with nested JSON objects
Often, semi-structured data includes nested working with nested objects. In this exercise, you'll practice using the -> and ->> operators to query nested data from the nested_reviews table. As a reminder, this table takes the following form:
Similar to before, pandas has been imported as pd, and a connection object has been created and stored in the db_engine variable. Best of luck!
Deze oefening maakt deel uit van de cursus
Introduction to NoSQL
Praktische interactieve oefening
Probeer deze oefening eens door deze voorbeeldcode in te vullen.
# Build the query to select the object stored at the
# location key
query = """
SELECT
review -> '____'
FROM nested_reviews;
"""
# Execute the query, render results
data = pd.read_sql(query, db_engine)
print(data)