get_proquest: Load ProQuest data

In f-hafner/magutils: Utilities for loading data from MAG-Proquest database

Load ProQuest data

Description

This function loads data on PhD graduates or their advisors from ProQuest. It is based on metadata from ProQuest, and automatically adds the likely gender of the person, using define_gender, and for graduates, their field using define_field.

Usage

get_proquest(conn, from, start_year = 1985, end_year = 2005, ...)

Arguments

conn	An object of class SQLiteConnection to a sqlite database.
from	A string with options to be queried: "advisors" or "graduates".
start_year	Lowest graduation year to consider. Default: 1985.
end_year	Highest graduation year to consider. Default: 2005.
...	Additional arguments to be passed to make_tbl_output. If not specified, a lazily evaluated table without limit is returned. Partially specified arguments are completed with dots_tbl_output.

Details

For simplicity, does not return the degree year and university information to advisors. You can add this information to advisors by joining the output of get_proquest(from = "graduates") to the output of get_proquest(from = "advisors").

Value

For graduates, returns a table with degree year, university id, fieldname and gender. For advisors, returns a table with gender and relationship id.

Examples

conn <- connect_to_db(db_example("AcademicGraph.sqlite"))
d_graduates <- get_proquest(conn = conn, from = "graduates")
d_advisors <- get_proquest(conn = conn, from = "advisors")

f-hafner/magutils documentation built on Sept. 20, 2023, 5:05 a.m.