Data Mining Module 4: Manage RDS in Python

Lecture 4.1 Set up a Jupyter Notebook Instance and GitHub Repository

Lecture 4.2 Review of Python Basics

Lecture 4.3 Create the Config.ini file

Lecture 4.4 Connect to a Relational Database

Lecture 4.5 Use pandas to Query and Visualize Data

Lecture 4.6 Modify Data in Python

Lab 4: Analyze and Visualize Relational Database data in Python

Objectives:

  • To learn how to use Python codes to execute SQL statements

Data:

  • The database created from lab3.