In this video I provide a introduction to R language and SQLite. A complete walk through is provide beginning with (1)creating a SQLite database, (2)creating a SQLite databases table and Index, Using SQLite Query to pull data from the data base and using it to create a new data.frame. and of course plotting new data.frame.
R And SQLite
COVID-19 SQLite DB
Github:
https://github.com/davidjayjackson/CO...
https://github.com/davidjayjackson/CO...
R Code for today video:
https://github.com/davidjayjackson/BA...
https://github.com/davidjayjackson/BA...
DB Browser for SQLite:
https://sqlitebrowser.org/