Connecting with files

DataLab with SQL

Jasmin Ludolf

Senior Data Science and AI Content Developer, DataCamp

Instructor & DataLab enthusiast

$$

Our learning journey

$$

Follows on from Introduction to DataLab

• Explore and Chart cells
• AI features
• Accessing data and files

$$

We'll focus on using SQL with DataLab

$$

Environments

$$

$$

                               SQL cells are available in both Python and R environments

Connecting files on DataLab

$$

• No need for installations or databases
• For advanced techniques, check out the documentation
• We'll connect Google Sheets and CSV files

Connecting a data source

Connecting a data source

Querying a Google Sheet

Querying a Google Sheet:

SELECT *
FROM 'Sheet1';

$$

Standard SQL query for tables:

SELECT *
FROM table_name;

Connecting a CSV file

Connecting a CSV file

Querying a CSV file

Automatically generated query:

SELECT *
FROM 'data.csv';

$$

This also works:

SELECT *
FROM data.csv;

Explore cells

Let's practice!

DataLab with SQL