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.
Questo esercizio fa parte del corso
Introduction to DataLab
Istruzioni dell'esercizio
- Create an Explore cell, choosing "Select data source", "Browse sample data sources", and connecting to
Course Databases. - Browse the available tables in the
cinemaschema and query thereviewstable. - Convert the Explore cell into a SQL cell, then rename it to
reviews.
Esercizio pratico interattivo
Passa dalla teoria alla pratica con uno dei nostri esercizi interattivi
Inizia esercizio