This document covers how to set up a MySQL database on your local desktop using the terminal and MySQL workbench.
Martin J Frigaard mjfrigaard
🏠
mjfrigaard
/ RDBMS_RStudio_setup.Rmd
Last active
September 14, 2018 01:04
This file contains 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
| 2-RDBMS connections in RStudio | |
| ================ | |
| Martin Frigaard | |
| 2018-09-13 | |
| # Motivation | |
| This document will walk through how to setup and query a relational | |
| database from RStudio with MySQL and SQLite. |
mjfrigaard
/ 1-setup-MySQL-cmd-line.md
Last active
September 13, 2018 04:30
mjfrigaard
/ RStudio_MPROJECT_setup.md
Last active
August 30, 2018 18:35
Setting up RStudio on Ubuntu (UCSF PHDI)
mjfrigaard
/ secure_file_priv_issue_MySQL8.md
Last active
August 24, 2018 01:49
Setting secure_file_priv to local folder in MySQL 8.0 (Mac OSX) - SO post
I am working on this portion of the MySQL tutorial for loading data from a .TSV file.
I have this data file:
[pet_file][1]
name owner species sex birth death
Fluffy Harold cat f 1993-02-04
Claws Gwen cat m 1994-03-17
Buffy Harold dog f 1989-05-13
mjfrigaard
/ ICD9_Dx_dummy.md
Last active
June 14, 2017 19:16
Creating Dummy Variables from Multiple Character (string) Variables
https://stackoverflow.com/q/44550649/4926446?sem=2
I need to create a dummy variable (binary) from a character (string) variable The data that I have look like this:
dat <- tribble(
mjfrigaard
/ stata_examples.ipynb
Created
October 13, 2016 06:22
— forked from masnick/stata_examples.ipynb
SARIMAX - Stata Examples
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
NewerOlder