Introduction to Data Science with Python Github Link
| Class No. | Lecture Topics | Exercise Topics |
|---|---|---|
| 1 | Introduction to Python | Exercise on input and output operations in Python |
| 2 | Object Oriented Programming in Python | Tower of Hanoi in Python |
| 3 | Classes, Packaging, and Documentation | Reading files into dictionary and searching |
| 4 | Introduction to Database Management Systems | Web crawling/scrapping application |
| 5 | Entity-Relationship Model | ER-model and database design for air pollution data |
| 6 | Structured Query language -1 (Meta-data commands: Create, Alter, Drop) | Storing the air pollution data in the database |
| 7 | Structured Query language-2 (Data commands: Insert, Update, and Delete) | Inserting the data into the database |
| 8 | Structured Query language-3 (Data commands: Select) | Creating the Indexes |
| 9 | Keys and Indexes | Reading the data from the files and inserting into the databases |
| 10 | Object Database Connectivity (ODBC) | Discussion on previous exercises |
| 11 | Data frames | Generating data frames for SQL |
| 12 | Managing data frames | Processing air pollution data that exists in data frames |
| 13 | Knowledge discovery in data | Pattern mining on the data frames |
