From the course: Hands-On Analytics Engineering Project
Join today to access over 24,700 courses taught by industry experts.
Preparing our Python environment
From the course: Hands-On Analytics Engineering Project
Preparing our Python environment
- [Instructor] For this project, we needed a place to house our data. Keeping your data in some form of a database is a standard across most industries. Databases are secure, reliable, easily accessible, and scalable. As such, we want to take data and store it in a database. There are dozens of options for data storage, but today we'll be using SQLite as it can be quickly set up in our browser environment. Let's take a look at a CSV file of data that I've provided for us. Click the file in the left-hand navigation called customer_orders.csv. This file contains data around customer orders for our fake company, Two Trees Olive Oil. You'll notice various columns including things such as order number, order date, and customer name. In the left-hand File Explorer, you should also see a Jupyter Notebook file called python_script. Let's click on that file. You'll notice I've preloaded a couple of cells with some Python code. This first cell imports a library called pandas that helps us…
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.
