In this lab, we will load a dataset from a SQLite database into a pandas DataFrame. Once loaded, we will standardize the dataset using the `StandardScaler()` method and write it to a new table within the SQLite database.
Basic Python programming skills will be required for this lab. If you need a refresher, check out the following course:
– [Certified Associate in Python Programming Certification](https://acloud.guru/overview/8169e8e7-91a7-4d92-b278-4dd08c787dc6)
Learning Objectives
Successfully complete this lab by achieving the following learning objectives:
- Load the Data
Load the data from the provided SQLite database (
data.db) into a pandas DataFrame object.- Scale the Data
Use the
StandardScaler()method of the scikit-learn preprocessing package to scale the data such that the distribution is now centered around 0, with a standard deviation of 1.- Save the Data
Write the scaled dataset to a new table named
data-scaledin the SQLite database.
