learn-co-students / dsc-obtaining-your-data-lab-sea01-dtsc-ft-051120

Obtaining Your Data - Lab

Introduction

In this lab you'll practice your munging and transforming skills in order to load in your data to solve a regression problem.

Objectives

You will be able to:

• Perform an ETL process with multiple tables and create a single dataset

Task Description

You just got hired by Lego! Your first project is going to be to develop a pricing algorithm to help set a target price for new lego sets that are released to market. To do this, you're first going to need to start mining the company database in order to collect the information you need to develop a model.

Start by investigating the database stored in lego.db and joining the tables into a unified dataset!

Hint: use this SQL query to preview the tables in an unknown database:

SELECT name FROM sqlite_master
            WHERE type='table'
            ORDER BY name;

# Your code here

Summary

Nice work! You're working more and more independently through the workflow and ensuring data integrity! In this lab, you successfully executed an ETL process to merge different tables!