Querying nested documents with Postgres JSON
With Postgres JSON, querying semi-structured data is a breeze! Postgres provides built-in operators, such as ->. In this example, you'll practice using this operator to query reviews data from a column of type JSON. This table takes the form below:
pandas has been imported as pd, and a sqlalchemy connection object has been configured, and made available for you via the db_engine variable. Best of luck!
Questo esercizio fa parte del corso
Introduction to NoSQL
Esercizio pratico interattivo
Prova a risolvere questo esercizio completando il codice di esempio.
# Build the query to select the statement field
query = """
SELECT
review -> '___' AS statement
FROM nested_reviews;
"""
# Execute the query, render results
data = pd.read_sql(query, db_engine)
print(data)