inkrement

Reproducibility in R and Marketing Research

Ensuring reproducibility in R-based marketing research projects involves adopting practices that enable others (or your future self) to replicate and extend your analysis.

Language-Agnostic Tips

• Version Control (e.g., Git):
  • Use Git to track changes in your project files. This keeps the project history intact and makes collaboration easier.
• Always create clear commit messages to describe changes effectively.

inkrement

h3_indices
844c985ffffffff
841f40bffffffff
84f0e05ffffffff
84ef209ffffffff
8454a37ffffffff
841e747ffffffff
8410d3bffffffff
8458457ffffffff
84c0ec9ffffffff

inkrement

SQL Introduction (DuckDB)

Expressions: Values, Operators and Functions

Expressions are the elementar building-blocks of SQL-Queries; most SQL-Clauses (e.g., SELECT, WHERE) use them as arguments. An expression is either a value (e.g., 3, 2.3, 'hello world' or column_name), an operator (e.g., +, -, /), or a function (e.g., my_function()).

Some operations, and most functions, work only on specific data types. For example, there are a number of operators and functions specifically for dates and strings.

Data types

inkrement

cosine_similarity <- function(a,b){
    # assuming unit vectors
    # the cosine is just the dot-product
    a %*% b
}


most_similar <- function(embeddings, ref_item, n_top = 10){
    # calculate cos similarity to ref_item for all elements
    cos_sims <- eapply(embeddings, cosine_similarity, b = ref_item)

inkrement

load_embedding <- function(file_path){
    # load full file
    lines <- readLines(file_path)
 
    # create new environment
    embeddings_env <- new.env(hash = TRUE, parent = emptyenv())
 
    # this function is used to convert vectors to unit vectors
    # by dividing their components by vector length
    normalize_vector <- function(a){

inkrement

load_embedding <- function(file_path){
    
    # load full file
    lines <- readLines(file_path)
    
    # create new environment
    embeddings_env <- new.env(hash = TRUE, parent = emptyenv())

    # this function is used to convert vectors to unit vectors
    # by dividing their components by vector length

inkrement

version: '2'
services:
  caddy:
    image: joshix/caddy
    links:
      - rstudio
    volumes:
      - ./site/:/var/www/html
      - ./.caddy/:/.caddy
    ports:

inkrement

#!/bin/bash

OUTDIR=.

while read -r db ; do
  while read -r table ; do

  if [ "$db" == "system" ]; then
     echo "skip system db"
     continue 2;

inkrement

UCgefQJC5UgbWJHDxBqB4qVg
UC0v-tlzsn0QZwJnkiaUSJVQ
UCo_IB5145EVNcf8hw1Kku7w
UC-lHJZR3Gqxm24_Vd_AJ5Yw
UCGjylN-4QCpn8XJ1uY-UOgA
UCGCPAOQDZa_TTTXDr5byjww
UC4PooiX37Pld1T8J5SYT-SQ
UCJZ7f6NQzGKZnFXzFW9y9UQ
UCfm4y4rHF5HGrSr-qbvOwOg
UCHUE4ypXKp7ZkmdWbGJNgJg

inkrement

<?php

date_default_timezone_set('UTC');

require 'vendor/autoload.php';

use Monolog\Logger;
use Monolog\Handler\StreamHandler;
use GuzzleHttp\Pool;
use GuzzleHttp\Client;