Abraham Mathew abmathewks
abmathewks
/ SQL_Script
Created
October 6, 2024 19:36
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* | |
| #callQ: List of queued members with ZipCode and TimeZoneCode | |
| */ | |
| IF OBJECT_ID('[tempdb]..[#callQ]') IS NOT NULL | |
| DROP TABLE #callQ; | |
| SELECT TOP 50000 | |
| q.MemberAcesId | |
| , ZipCode = c.Zipcode | |
| , TimeZone = c.TimeZoneCode |
abmathewks
/ Get SQL Data
Created
June 8, 2022 06:59
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* | |
| Query collects the reader funnel stats from item views, enters & reader mode | |
| tap actions. Counts the number of events and the distinct count of users per day | |
| */ | |
| WITH | |
| --CTE to declare common variables used in the CTE | |
| vars_cte as ( | |
| select | |
| '2022-05-01'::DATE AS start_date, |
abmathewks
/ LastRunModel.SQL
Created
March 20, 2022 23:00
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT | |
| ob.lead_id, | |
| DATE(ob.create_date), | |
| TIME(ob.create_date), | |
| ob.affiliate_id, | |
| ob.amount AS 'our_cost', | |
| ob.won_ping, | |
| ob.lead_type | |
| FROM our_bids AS ob |
abmathewks
/ SQLData.R
Created
December 29, 2021 15:16
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| GetSqlQuery <- function(SQL_QUERY_FILEPATH, | |
| DEBUG = TRUE){ | |
| if(DEBUG) message("GetSqlQuery: Script Initialized \n") | |
| FUNCTION_OUTPUT <- list() | |
| con = file(SQL_QUERY_FILEPATH, "r") | |
abmathewks
/ AddEngineeredDates.R
Created
December 26, 2021 19:05
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| AddEngineeredDates <- function(AGG_TS_DATA, | |
| DATE_COLUMN = "date", | |
| DEBUG = TRUE){ | |
| if(DEBUG) message("AddEngineeredDates: Function Initialized \n") | |
| if(!data.table::is.data.table(AGG_TS_DATA)){ | |
| stop("AddEngineeredDates: The input data is not a data table \n") | |
| } |
abmathewks
/ PackageCheck.R
Created
December 20, 2021 21:30
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| PackageCheck <- function(USE_THESE_PACKAGES, | |
| DEBUG = TRUE){ | |
| if(DEBUG) message("PackageCheck: Function initialized \n") | |
| if(any(USE_THESE_PACKAGES == "")){ | |
| stop("PackageCheck: An empty string element was passed in USE_THESE_PACKAGES \n") | |
| } |
abmathewks
/ AddMonths.R
Created
December 16, 2021 03:22
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| AddMonths <- function(DATE_VAL, | |
| ADD_N = NULL, | |
| DEBUG = TRUE){ | |
| if(DEBUG) message("AddMonths: Function initialized \n") | |
| if(!lubridate::is.Date(DATE_VAL)){ | |
| stop("AddMonths: DATE_VAL is not a date format \n") | |
| } |
abmathewks
/ CreateProjectFiles.R
Created
December 15, 2021 01:19
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CreateProjectFiles <- function(PROJECT_PATH = rstudioapi::getActiveProject(), | |
| FOLDERS_TO_CREATE = c("data", "docs", "figs", "logs", | |
| "output", "queries", "R", "tests"), | |
| OPEN_NEW_SESSION = TRUE, | |
| DEBUG = TRUE){ | |
| if(DEBUG) message("CreateProjectFiles: Function initialized \n") | |
| if(!dir.exists(PROJECT_PATH)){ |
abmathewks
/ AddMonths.py
Created
December 14, 2021 23:51
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import datetime | |
| import calendar | |
| def AddMonths(DATE_VAL, | |
| ADD_N, | |
| DATE_FORMAT = "%Y-%m-%d"): | |
| print("AddMonths: Function initalized") |
abmathewks
/ CreateProjectFiles.py
Created
December 14, 2021 23:48
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| def CreateProjectFiles(PROJECT_PATH): | |
| print("CreateProjectFiles: Function initalized") | |
| if os.path.exists(PROJECT_PATH) and any(os.scandir(PROJECT_PATH)): | |
| folders = ["data", "deploy", "docs", "models", "notebooks", | |
| "scripts", "tests", "utils"] |
NewerOlder