In jbkunst/modflblla: Helpers para el desarrollo de modelos

knitr::opts_chunk$set(
  collapse = TRUE,
  comment = "#>",
  fig.path = "man/figures/README-",
  out.width = "100%"
)

modflblla

The goal of modflblla is to ...

Installation

You can install the released version of modflblla from CRAN with:

install.packages("modflblla")

Example

This is a basic example which shows you how to solve a common problem:

library(tidyverse)
library(dbplyr)
library(DBI)

con <- DBI::dbConnect(odbc::odbc(), driver = "Microsoft SQL Server", dsn = "ve_paris")
DBI::dbSendQuery(con, "USE MATRIX")

data(data, package = "modflblla")

periodos <- c(1, 6, 12)
# data <- sample_n(data, size = 100)

# devtools::load_all()

library(modflblla)

d1 <- get_matriz_vars(con, data, periodos)
glimpse(d1)

d2 <- get_matriz_lineas_vars(con, data, periodos)
glimpse(d2)

data <- structure(list(RUT = c(9008066, 14604390, 6334659, 7275772, 15238798, 
7903691), PERIODO = c(201804L, 201804L, 201804L, 201804L, 201804L, 
201804L)), .Names = c("RUT", "PERIODO"), row.names = c(NA, -6L
), class = c("tbl_df", "tbl", "data.frame"))
# data <- data %>% ungroup %>% rename(periodo = mes_matriz)
d2 <- get_r04_vars(con, data , periodos)