Querying JSON and JSONB data from Postgres
With Postgres' built-in JSON and JSONB data types, it's easy to store and interact with semi-structured data in a Postgres table. In this exercise, you'll observe some of the tooling that Postgres offers to query data of type JSON from the nested_reviews table. Best of luck!
Questo esercizio fa parte del corso
Introduction to NoSQL
Istruzioni dell'esercizio
- Create a connection to the
disneylanddatabase with userrepl, usingsqlalchemy. - Execute the query stored in the
queryvariable, using the previously-defineddb_engine. - Output the
reviewcolumn of theresultsDataFrame, and observe the data that was returned.
Esercizio pratico interattivo
Prova a risolvere questo esercizio completando il codice di esempio.
import pandas as pd
import sqlalchemy
# Create a connection to the reviews database
db_engine = sqlalchemy.create_engine("postgresql+psycopg2://____:password@localhost:5432/____")
query = """SELECT * FROM nested_reviews;"""
# Execute the query, check out the results
results = pd.____(____, ____)
# Print the review column from the results DataFrame
____(results["review"])