README.md

convor

The goal of convor is to make data science at Convo easier!

Installation

You can install the released version of convor from GitHub with:

devtools::install_github("convo/convor")

Connections

Chiefly this package provides easy ways to connect to Convo's databases using the RMariaDB package. You'll need to configure that and your my.cnf file on your local machine.

# To connect to reporting database
convor::connect_reporting()
#> Connected to reporting.

Data Munging

parse_phone_number() quickly strips all non-numeric characters from phone numbers.

get_live_tdns() will pull a list of all TDNs that were "live" - that is, in our locations table - on a specific date. Useful for historical customer base comparisons.

get_urd_regs() pulls a table of the latest URD registration data for each TDN. Useful for URD compliance purposes.

write_csv_rla() writes CSV files in RLA-friendly format.



convo/convor documentation built on Nov. 4, 2019, 9:12 a.m.