Querying document databases

Using Postgres JSON to query document data is similar to querying relational data with Postgres. In this exercise, you'll practice building a query to retrieve document data from the nested_reviews table, with Postgres JSON. Happy querying!

Bu egzersiz

Introduction to NoSQL

kursunun bir parçasıdır

Kursu Görüntüle

Egzersiz talimatları

Update the query to return the review column from the nested_reviews table.
Use the appropriate pandas function to create a DataFrame using the logic stored in the query variable.
Output the first record in the DataFrame returned after executing the query.

Uygulamalı interaktif egzersiz

Bu örnek kodu tamamlayarak bu egzersizi bitirin.

# Update the query to select the review field
query = """
	SELECT 
    	____
    FROM nested_reviews;
"""

# Execute the query
data = ____.____(query, db_engine)

# Print the first element of the DataFrame
____(data.iloc[0, 0])

Kodu Düzenle ve Çalıştır