From the course: Complete Guide to Analytics Engineering
Join today to access over 25,500 courses taught by industry experts.
Connecting to our database and API
From the course: Complete Guide to Analytics Engineering
Connecting to our database and API
- [Instructor] All right. Let's jump back into our GitHub codespace. If you're just joining us, navigate to our GitHub repo for this course with the link in the description below. There's a branch specific to this video called 05_03_B, which will bring you right up to speed on our current state in this course. In the file explorer in the left-hand navigation, you'll see a file called database.db. That's what we're looking for. If you open that database up, you'll notice there's nothing in there. That's because we haven't loaded our CSVs of data into the database just yet. We can do that with a simple Python script. Let's create a new script and call it data_load.ipynb. In a new cell, let's import pandas and connect to our CSV of data. The CSB we're going to start with is us_sales_statistics_by_associate. Let's run that cell. We'll have to reconnect to our kernel, choose Python environments, and Python 3.12.1. Now that we've connected to our kernel, run that again. Great. That worked…
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.