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!
This exercise is part of the course
Introduction to NoSQL
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# 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)