Summary notes about R, Shiny, SQL, Python, Linux and C++ – pacha.dev/blog

Reading REDATAM databases in R

R

Statistics

Linear models

Read REDATAM databases directly into R using the REDATAM Converter R package.

cpp11eigen 0.1.0 is available on CRAN

R

Statistics

Linear algebra

Linear models

The idea is to pass matrices/vectors from R to C++, write pure C++/Eigen code for the computation, and then export the result back to R with the proper data structures.

cpp11armadillo 0.3.0 is available on CRAN

R

Statistics

Linear algebra

Linear models

The idea is to pass matrices/vectors from R to C++, write pure C++/Armadillo code for the computation, and then export the result back to R with the proper data structures.

Kendallknight: an R package for Kendall’s correlation coefficient

R

C++

Statistics

A solution that took me hours of ‘averaging’ Google search results and using my brain.

CP 1919 / PSR B1919+21 Dataset

R

ggplot2

aka Joy Division’s plot

Advanced International Trade in R

R

Stata

Linear models

A reference for those who come from Stata and want to learn R.

The Hitchhiker’s Guide to Linear Models with codes and datasets sale

R

Linear models

Extras package with codes and datasets.

The Hitchhiker’s Guide to Linear Models

R

Linear models

Some minor corrections.

Install PostGIS on Red Hat Enterprise Linux (RHEL) 8

R

SQL

A solution that took me hours of ‘averaging’ Google search results and using my brain.

If Doom runs everywhere, it must run on Shiny

R

Shiny

I was able to run Doom on Shiny!

Logistic regression is not advanced ‘machine learning’ or ‘artificial intelligence’

R

Statistics

Linear models

Logistic regression is using an exponential function and using the linear model repeated times to predict the probability of a binary outcome.

tabulapdf: Extract Tables from PDF Documents

R

PDF

R bindings to the Tabula java library.

Tetley caffeine meter replication with ggplot2

R

ggplot2

Customizing a ggplot2 object to change backgrounds and other elements.

Canadamaps 0.3.0

R

ggplot2

Plot maps of Canada with ggplot2 at different levels of aggregation.

Introducing cpp11armadillo: R and Armadillo integration using the header-only cpp11 R package

R

Statistics

Linear algebra

Linear models

The idea is to pass matrices/vectors from R to C++, write pure C++/Armadillo code for the computation, and then export the result back to R with the proper data structures.

Introducing Capybara: Fast and Memory Efficient Fitting of Linear Models With High-Dimensional Fixed Effects

R

Statistics

Linear models

C++

Short demonstration.

The Hitchhiker’s Guide to Linear Models is now complete

R

Linear models

An R package with Baltagi’s ‘Econometric Analysis of Panel Data’ datasets

R

Linear models

Tidy datasets to let you focus on the econometric techniques rather than on data wrangling.

The Hitchhiker’s Guide to Econometrics with Available Code in R

R

Linear models

The Hitchhiker’s Guide to Econometrics: Based on the famous R programming language

R

Linear models

Plotting a COVID-19 vaccination map with different projections (with updated versions of canadamaps and tintin)

R

Ggplot2

Using a real dataset from Health Canada to show ggplot’s flexibility.

One Weird Trick to Make Ggplot2 Columns the Same Width

R

Ggplot2

Using “position_dodge” and “position_dodge2” functions for plots alignment.

Text Analysis in R - Exploring Barbie and Oppenheimer Reviews - Part 1

R

NLP

Much of the data proliferating today is unstructured and text-heavy.

Canadian Hansard Live Database

R

SQL

A ready to use SQL database that we can consult with dplyr.

Workshop: Analyzing BarbieHeimer texts with R

R

NLP

Much of the data proliferating today is unstructured and text-heavy.

R and/or Python training - 4 sessions - With discount

R

Python

I’m happy to help you mastering the basics of R and/or Python, and therefore make your daily work easier and more enjoyable.

Step-by-Step Guide to Scrape UN Comtrade metadata with R and Selenium

R

Selenium

Using purrr’s map to combine thousands of tables into one.

A naive simplex phase 2 implementation with C++ 11 and R

R

C++

Combining for and while loops to print the tableau until finding an optimal solution.

Using Custom TeX Fonts (Lucida and Minion Pro) in Quarto

Quarto

Latex

Making Latex documents look elegant.

Linear Models in R - Part 1

R

RStudio

Linear models

Keeping the examples aligned with changes in R since 2016.

Linear Models in R - Part 2

R

RStudio

Linear models

Keeping the examples aligned with changes in R since 2016.

Linear Models in R - Part 3

R

RStudio

Linear models

Keeping the examples aligned with changes in R since 2016.

The Hitchhiker’s Guide to GGplot2 and Plotnine Updated and With Discount

R

Python

Ggplot2

Plotnine

Keeping the examples aligned with changes in R since 2016.

Credible intervals with Capybaras, Python and Stan (cmdstanpy interface)

Python

Stan

Obtaining a credible interval with cmdstanpy.

Credible intervals with Capybaras, R and Stan (rstan and cmdstanr interfaces)

R

Stan

Obtaining a credible interval with rstan and then the same credible interval with cmdstanr.

Building a basic Shiny app with Golem - Part II (Video)

R

Shiny

Golem is a framework for Robust Shiny Applications.

Write a function with Python and R

R

Python

The goal here is to write a function that tells us if a number is prime or not.

Tidy Freedom Index as an R Package

R

A concrete example about reshaping data to simplify the posterior analysis.

Student’s t-test explained with R and Pokemon

R

Statistics

Gotta Test ’Em All!

(Update) How to install RStudio, RStudio Server and Quarto with ‘apt install’

R

Ubuntu

RStudio

RStudio Server

Quarto

Install R packages as you would do on Windows.

Building a basic Shiny app with Golem - Part I (Video)

R

Shiny

Golem is a framework for Robust Shiny Applications.

Moving from bookdown to Quarto (and the corresponding GitHub Actions changes)

R

Quarto

GitHub

What I did to keep R4DS-ES simple.

Debunking the idea that cpp11 does not offer OpenMP support

R

C++

A concrete example with lists to debunk a common myth.

Tidying the Freedom Index

R

A concrete example about reshaping data to simplify the posterior analysis.

‘ggplot2’ Palettes From Tintin Comic Books

R

Ggplot2

A few examples using head trauma data from the comic itself.

Moving from Blogdown to Quarto

R

Blogdown

Quarto

Pelican

What worked and what didn’t work immediately, and how to get everything running.

Cpp11 (R package) vendoring

R

VSCode

Linear models

C++

Linux

Copying the code for the dependencies into my project’s source tree.

An introductory workshop in Shiny, June 1st from 17.30 to 18.30 (FREE)

R

Shiny

Personalised training to learn R and Shiny.

A step by step guide to write an R package that uses C++ code (Ubuntu)

R

VSCode

Linear models

C++

Linux

Using cpp11 (R package) on Ubuntu.

Using bookdown with gh-pages

R

GitHub

Deploying bookdown to gh-pages with GitHub Actions

(Update) How to install RStudio and Quarto with ‘apt install’

R

Ubuntu

RStudio

Quarto

Install R packages as you would do on Windows.

Modifying the shinydashboard theme with one line

R

Shiny

How to apply organizational/corporate themes to shinydashboard.

The Perfect Setup for Ubuntu and R (and how to install/update RStudio with apt install rstudio/apt update)

R

Ubuntu

Install R packages as you would do on Windows.

Install the sf package on Ubuntu 20.04

R

Ggplot2 effective visualization.

Export in Bananen in Tonnen von 1994-2005 (Banana exports in tonnes from 1994-2005)

R

Ggplot2

Ggplot2 effective visualization.

R and Shiny Training

R

Shiny

Personalised training to learn R and Shiny.

SQL Databases for Students and Educators

R

Personalised training to learn R and Shiny.

R and Shiny Training

R

Personalised training to learn R and Shiny.

Clases de R y Shiny en Castellano

R

Shiny

Clases personalizadas para aprender R y Shiny.

Entrevista con la Dra. Julia Silge

R

Interviews

NLP

PLN, flujos de trabajo reproducibles, papel de la ciencia de los datos, y más. Esta es la mejor entrada que encontrarás en mi blog.

¿Es Pi Aleatorio?

R

Una simulación con supuestos ficticios para obtener una estimación razonable y cómo conectar el método con las encuestas.

Un extraño truco para obtener el máximo (o el mínimo)

R

Uso eficiente de las funciones vectorizadas

Leaving a PhD Program

Education

A personal view about the challenges Iberoamerican students face when studying a PhD program abroad.

Generalized Linear Models, Part I: The Logistic Model

R

Linear models

An applied short approach to Generalized Linear Models.

Comparing CENSO 2017 versions for Python and R

R

Using DuckDB with different languages

One Weird Trick to Obtain the Maximum (or Minimum)

R

Efficient use of vectorized functions

leaRn! (learn R)

R

I’m offering R training

RStudio on Kubernetes

R

Kubernetes

DigitalOcean

One click application you can deploy on Kubernetes clusters

Shinywordle: A shiny app to solve the game Worldle and the power of regular expressions

R

Shiny

A quick demo of regular expressions in R and their power.

Using Arrow with Shiny

R

SQL

Arrow

A quick exploration of different technologies to work with medium/large datasets.

Comparing SQLite, DuckDB and Arrow with UN Trade Data

R

SQL

Arrow

A quick exploration of different technologies to work with medium/large datasets.

Using the R-Universe

R

R-Universe

The R-Universe provides a very simple way to create personal CRAN-like repos, which means a way to show your collection of tools in use to the community.

Usando el R-Universe

R

R-Universe

El R-Universe proporciona una forma muy sencilla de crear repositorios personales tipo CRAN, lo que significa una forma de mostrar su colección de herramientas en uso a la comunidad.

analogsea: Using Arrow, S3 and DigitalOcean for efficient model fitting in RStudio

R

DigitalOcean

Arrow

How to fit models by using the cloud with a minimal data transfer to your laptop.

Wes McKinney InteRview

R

Interviews

Arrow

The road to ease data access easier and making research results more reproducible.

Microeconomic Theory and Linear Regression

R

Linear models

Linear models and models comparison to estimate apples production.

Hyperplane Separation Theorem

Linear models

A proof made under a “divide and conquer” approach.

The Hitchhiker’s Guide to Ggplot2 and Plotnine Flash Sale

R

Python

Ggplot2

Plotnine

These books will help you master R and Python plots the easy way.

SQL Databases for Students and Educators

R

SQL

Different SQL engines to cover small edge cases when moving between DB back ends

A Crash Course on PostgreSQL for R Users

R

SQL

How to read and write data in efficient ways

The Hitchhiker’s Guide to Ggplot2 is for sale at $10.00

R

Ggplot2

The Hitchhiker’s Guide to Ggplot2 is for sale at $10.00

Dr. Julia Silge InteRview

R

Interviews

NLP

NLP, reproducible workflows, data science role, and more. This is the best blog entry that you’ll ever find in my blog.

Thomas Lumley InteRview

R

Interviews

Survey analysis in R, community contributions, and more.

Apply for the Google Summer of Code and Help Us Improving The R Code Optimizer

R

Contribute to open-source while earning some cash.

LP and Tidy Data Principles

R

NLP

Searching keywords and patterns in LP songs.

A full RStudio Server setup for Package Development in 5 minutes

R

DigitalOcean

Go from zero to a full setup to fit models in a few clicks.

The Hitchhiker’s Guide to Ggplot2 + The Hitchhiker’s Guide to Plotnine

R

Python

Ggplot2

Plotnine

This book will help you master Python plots the easy way.

The Hitchhiker’s Guide to Plotnine

Python

This book will help you master Python plots the easy way.

A full RStudio Server setup to use H2O in 5 minutes

R

RStudio

RStudio Server

DigitalOcean

Go from zero to a full setup to fit models in a few clicks.

d3po: R package for easy interactive D3 visualization with Shiny

R

Shiny

The definitive htmlwidget is a combination of existing ideas, blended in a different way.

Open Trade Statistics: An Independent project that values reproducible research and provides tidy trade data

R

Shiny

A nice example of R in production, in my opinion.

Hyde Mod: A blogdown theme with full XML feed and custom MathJax for equation numbering

R

Blogdown

A customized theme for blogdown and hugo.

An updated version of The Hitchhiker’s Guide to Ggplot2

R

Ggplot2

This book will help you master R plots the easy way.

A new image on DigitalOcean to start using RStudio Server without waiting more than 2 minutes

R

RStudio

RStudio Server

Ubuntu

DigitalOcean

I initially made an image for DigitalOcean because I wanted to spend my lectures and workshops giving useful examples and not solving software installation issues.

How to install R on Mac, Ubuntu and Windows

R

OS X

Linux

Windows

This is a beginner guide that is designed to save yourself a headache and valuable time if you decide to install R yourself.

Creating LaTeX figures with Inkscape

Latex

Inkscape

Searching keywords and patterns in the TV show.

Compiling R with multi-threaded linear algebra libraries on Ubuntu

R

Linux

A guide for multithreaded R performance

How many sticker envelopes do I need to complete the FIFA World Cup album?

R

A simple simulation written in R

Writing tables into a PostgreSQL database using R

R

SQL

A short guide to install and use RPostgreSQL and/or odbc packages.

Is Microsoft R Open faster than CRAN R?

R

Installing R with different numerical libraries and benchmarking them.

Rick and Morty and Tidy Data Principles (Part 3)

R

Rick and Morty

NLP

Searching keywords and patterns in the TV show.

Rick and Morty and Tidy Data Principles (Part 2)

R

Rick and Morty

NLP

Searching keywords and patterns in the TV show.

Quickly Install R on Ubuntu 17.10

R

Linux

Ubuntu

Install R on Ubuntu the fast way and without missing dependencies.

Rick and Morty and Tidy Data Principles (Part 1)

R

Rick and Morty

NLP

Searching keywords and patterns in the TV show.

Quickly Install R on Ubuntu 16.04

R

Linux

Ubuntu

Install R on Ubuntu the fast way and without missing dependencies.

Install R, Python and Pelican Blog Tool on Windows

R

Python

Pelican

Windows

Install R and more tools using Chocolatey package manager.

Install GNU and non-GNU Tools via Homebrew

OS X

Install GNU and non-GNU tools using Homebrew, and save yourself a headache and valuable time when you need newer software versions.

Working With SPSS Data in R

R

SPSS

Work with SPSS format and labelled data in R.

Linear Regression and ANOVA shaken and stirred (Part 2)

R

Linear models

These concepts are understood as separate concepts most of the times. The truth is they are extremely related to each other.

Linear Regression and ANOVA shaken and stirred (Part 1)

R

Linear models

These concepts are understood as separate concepts most of the times. The truth is they are extremely related to each other.

Structural Equation Modelling in R (Part 2)

R

Latex

Linear models

Here we explain how to estimate SEM models coefficients without a theoretical introduction

Install R and Python via Homebrew

R

Python

OS X

Install R and more tools using Homebrew, and save yourself a headache and valuable time when you need newer software versions.

Using googlesheets and mailR packages in R to automate reporting

R

Google Sheets

Using Excel for reporting has its drawbacks, here I share a way to solve some of those drawbacks.

Mauricio “Pachá” Vargas S.

Structural Equation Modelling in R (Part 1)

R

Latex

Linear models

Here I explain how to estimate CFA models coefficients without a theoretical introduction

Mauricio “Pachá” Vargas S.

RStudio Server on OS X Sierra

R

RStudio

RStudio Server

OS X

I had to install RStudio Server in a computer recently upgraded to OS X Sierra.

Mauricio “Pachá” Vargas S.

Joy Division’s Unknown PleasuRes

R

Ggplot2

I wanted to create a wallpaper and here’s how I solved white borders and some difficulties.

Mauricio “Pachá” Vargas S.

RStudio Server on OS X El Capitan

R

RStudio

RStudio Server

OS X

This is the result of trial and error until I got RStudio Server working in my network.

Mauricio “Pachá” Vargas S.

Beamer template to write in english and chinese

Latex

Very basic tutorial with downloadable examples.

Mauricio “Pachá” Vargas S.

Creating a timeline using R

R

Step by step tutorial to create a timeline that you can open on any browser.

Mauricio “Pachá” Vargas S.

Using Rmd Markdown in Pelican

R

Python

A definitive setup for OSX.

Mauricio “Pachá” Vargas S.

LaTeX Quick Tutorial

Latex

Very basic tutorial with downloadable examples.

Mauricio “Pachá” Vargas S.

LaTeX Thesis Template

Latex

Very basic tutorial with downloadable examples.

Mauricio “Pachá” Vargas S.