Using pandas to Read Database (SQLite), JSON, Excel, HTML & CSV Data | Data Mining | Demonstrations

In this screencast snippet, spliced from a live lecture, we demonstrate how to use Pandas [1] to read data from different sources: Databases, HTML Web pages, JSON responses, Excel files, and CSV files.

## Timeline
00:00:00 Options for Reading Data Using pandas
00:02:09 Reading Web Page Content: pandas.read_html([…])
00:06:14 Reading CSV Files: pandas.read_csv([…])
00:11:14 Reading Excel Files: pandas.read_excel([…])
00:13:03 Reading JSON Data: pandas.read_json([…])
00:19:16 Other Interesting Ways of Reading Data
00:19:44 Reading Data from Databases
00:20:00 Reading Data from Databases: Creating a Database Using SQLite
00:22:08 Reading Data from Databases: pandas.read_sql_query([…])
00:25:06 Exporting Pandas Dataframes

This segment is part of a screencast [2] produced for the 2022/23 CSC 5741 course [3] offered at The University of Zambia [4].

[1] https://pandas.pydata.org
[2] https://youtu.be/E9pMs9J5MKw
[3] http://lis.unza.zm/~lightonphiri/teaching/unza/2023/csc5741
[4] https://www.unza.zm