Aan de slagGa gratis aan de slag

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.

Deze oefening maakt deel uit van de cursus

Introduction to DataLab

Cursus bekijken

Oefeninstructies

  • 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 the reviews table.
  • Convert the Explore cell into a SQL cell, then rename it to reviews.

Praktische interactieve oefening

Zet theorie om in actie met een van onze interactieve oefeningen.

Begin met trainen