Creating an API for 4.2M texts with tidytext, RSQLite, dbplyr and plumber
Background
Libraries
Open Data
Historical Job Postings
Job Ontologies
Prototyping
Munging
Extracting the terms
Extracting the relevant adverts
Extracting related skills
Conclusions
Creating a database
Populating our database
Using the database
Functions for querying
Getting the jobid’s
Trying it out
dbplyr and SQL syntax
Turning it all into an ...
[Read more...]