Extract data from an Explore cell
Explore cells allow you to interactively browse database tables, but often, you'll want to extract data from these cells for further analysis.
In this exercise, you'll locate the reviews
table (in the cinema
schema, part of the Course databases
database) and load its data into a DataFrame named reviews
.
Diese Übung ist Teil des Kurses
Introduction to DataLab
Anleitung zur Übung
- Create an Explore cell, choosing "Select data source", "Browse sample data sources", and connecting to
Course Databases
. - Browse the available tables in the
cinema
schema and query thereviews
table. - Convert the Explore cell into a SQL cell, then rename it to
reviews
.
Interaktive Übung
In dieser interaktiven Übung kannst du die Theorie in die Praxis umsetzen.
