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] • 2022/23 CSC 5741 | Lecture Series #03: Kn...
[3] http://lis.unza.zm/~lightonphiri/teac...
[4] https://www.unza.zm