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

Published: 28 March 2023
on channel: Lighton Phiri

142

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

On this page of the site you can watch the video online Using pandas to Read Database (SQLite), JSON, Excel, HTML & CSV Data | Data Mining | Demonstrations with a duration of hours minute second in good quality, which was uploaded by the user Lighton Phiri 28 March 2023, share the link with friends and acquaintances, this video has already been watched 142 times on youtube and it was liked by 6 viewers. Enjoy your viewing!

310