Extracting document data
In this exercise, you'll practice using the json_extract_path and json_extract_path_text functions to query the review column of the nested_reviews table, which is shown below.
A connection object has been created and stored in the variable db_engine, and pandas has been imported as pd. Best of luck!
Bu egzersiz
Introduction to NoSQL
kursunun bir parçasıdırEgzersiz talimatları
- Query the value stored in the
statementfield in thereviewcolumn of thenested_reviewstable, using thejson_extract_pathfunction. - Query the nested
reviewerfield, using thejson_extract_path_textfunction. - Refine your query to include only those records where the
branchinformation, extracted as text from the JSON data, matches'Disneyland_California'. Use the appropriate function to parse through the JSON structure and isolate this particular field to be filtered.
Uygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
# Return the statement and reviewer fields, filter by the
# nested branch field
query = """
SELECT
____(review, '____'),
____
FROM nested_reviews
WHERE ____(____, '____', '____') = 'Disneyland_California';
"""
data = pd.read_sql(query, db_engine)
print(data)