Exercise

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:

nested_reviews table, showing sample data.

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!

Instructions 1/3

undefined XP

1

2

3

Query the object stored at location field, returning the value as JSON.

.css-6su6fj{-webkit-flex-shrink:0;-ms-flex-negative:0;flex-shrink:0;}Exercise

Instructions 1/3

Exercise