Package index • PFUPipelineTools

All functions

agg_metadata: Metadata information for aggregation groups

aggregation_df_cols: PFUAggPipeline data frame column names

aggregation_file_cols: Aggregation file column names

aggregation_file_tab_names: Aggregation file tab information

all_countries: Country abbreviations

beatles_fk_tables: Example simple database tables

beatles_schema_table: Example database schema table

canonical_countries: Canonical countries

clean_up_beatles(): Clean up Beatles tables

compress_rows(): Execute the compress function on a database table

dataset_info: Column name for datasets

get_db_conn() get_mexerdb_conn() get_sandboxdb_conn() get_scratchmdb_conn() get_scratchedb_conn(): Create a connection to the Mexer database

decode_fk_keys(): Decode a vector of foreign keys according to foreign key parent table

decode_fks(): Decode keys in a database table

dm_fk_colnames: Column names in foreign key tables from dm

dm_pk_colnames: Column names in primary key tables from dm

double_counted_countries: Double-counted countries

decode_matsindf() encode_matsindf(): Encode and decode matsindf data frames for storage in a database

encode_fk_values(): Encode a vector of foreign key values according to a foreign key parent table

encode_fks(): Encode foreign keys in a data frame to be uploaded

encode_version_string(): Encode a version string

exemplar_names: Exemplar table names

filter_countries_years(): Extract specific country and year data

filter_on_version_string(): Filter a database table based on a version string.

get_all_fk_tables(): Get a named list of foreign key tables

hashed_table_colnames: Column names in hashed tables

inboard_filter_copy(): Copy a country, year subset from one table to another

install_compress_function(): Install the compress function to a database

key_col_info: Metadata about table keys

load_fk_tables(): Load foreign key tables for the CL-PFU database from a spreadsheet

load_schema_table(): Read a CL-PFU database schema file

machine_constants: Information about the machine efficiency files

mat_colnames: Unwrapped matrix column names

mat_meta_cols: PSUT matrix formation meta information column names

phi_sources: Sources for phi values

pl_collect_from_hash(): Download a data frame based on its pl_hash()

pl_destroy(): Reset the CL-PFU database pipeline to original condition

pl_filter_collect(): Filter a table from the database using natural expressions

pl_hash(): Calculate hash of pipeline data

pl_upload_schema_and_simple_tables(): Upload a schema and simple tables for the CL-PFU database

pl_upsert(): Upsert a data frame with optional encoding of foreign keys

read_pin_version(): Read a version of a pinned CL-PFU database product

release_target(): Save a single target to a pinboard.

remove_compress_function(): Remove the compress function from a database

round_double_cols(): Round double-precision columns

schema_dm(): Create a data model from an Excel schema table

schema_from_conn(): Get the database schema (a dm object) from a connection

schema_table_colnames: Column names in schema tables

self_name(): Self-name a list

set_not_null_constraints_on_fk_cols(): Set NOT NULL constraints on foreign key columns

tar_ungroup(): Ungroups and removes tar_group column from a data frame

update_schema_table(): Update a schema table in a database.

upload_beatles(): Upload a small database of Beatles information

usual_hash_group_cols: Usual columns to be preserved when hashing target uploads