Skip to content

Instantly share code, notes, and snippets.

View aravindhebbali's full-sized avatar
🏠
Working from home

Aravind Hebbali aravindhebbali

🏠
Working from home
View GitHub Profile
@aravindhebbali
aravindhebbali / import_data_part_2.R
Created September 23, 2017 17:23
A Complete Guide to Importing Data into R - Part 2
# install
install.packages('readxl')
# library
library(readl)
# list sheets
excel_sheets('sample2.xls')
# read data from sheet 1
@aravindhebbali
aravindhebbali / import_data_part_3.R
Created September 23, 2017 17:41
A Complete Guide to Importing Data into R - Part 3
# install
install.packages('jsonlite')
install.packages('XML')
install.packages('purrr')
install.packages('xml2')
# library
library(jsonlite)
library(XML)
library(purrr)
@aravindhebbali
aravindhebbali / pipes.R
Last active September 23, 2017 18:02
Readable Code with R
# install
install.packages('magrittr')
install.packages('readr')
# library
library(magrittr)
library(readr)
# read data
ecom <- readr::read_csv('https://raw.githubusercontent.com/rsquaredacademy/datasets/master/web.csv')
@aravindhebbali
aravindhebbali / dplyr_verbs.R
Last active September 24, 2017 07:10
Data Wrangling with dplyr
# install
install.packages('dplyr')
install.packages('readr')
# library
library(dplyr)
library(readr)
# read data
ecom <- readr::read_csv('https://raw.githubusercontent.com/rsquaredacademy/datasets/master/web.csv')
@aravindhebbali
aravindhebbali / dplyr_join.R
Last active September 24, 2017 07:36
Joining Tables with dplyr
# install
install.packages('dplyr')
install.packages('readr')
# library
library(dplyr)
library(readr)
# import order data
order <- readr::read_csv('https://raw.githubusercontent.com/rsquaredacademy/datasets/master/order.csv')
@aravindhebbali
aravindhebbali / dplyr_part_3.R
Last active September 24, 2017 07:51
Data Wrangling with dplyr - Part 3
# install
install.packages('dplyr')
install.packages('readr')
# library
library(dplyr)
library(readr)
# import data
ecom <- readr::read_csv('https://raw.githubusercontent.com/rsquaredacademy/datasets/master/web.csv')
@aravindhebbali
aravindhebbali / lubridate.R
Last active September 24, 2017 08:09
Working with Date & Time in R
# install
install.packages('lubridate')
install.packages('readr')
install.packages('dplyr')
install.packages('magrittr')
# library
library('lubridate')
library('readr')
@aravindhebbali
aravindhebbali / stringr.R
Last active September 24, 2017 08:26
Working with strings in R
# install
install.packages('stringr')
install.packages('readr')
install.packages('tibble')
install.packages('magrittr')
install.packages('purrr')
install.packages('dplyr')
# library
library(stringr)
@aravindhebbali
aravindhebbali / forcats.R
Last active September 24, 2017 08:50
Working with Categorical Data in R
# install
install.packages('forcats')
install.packages('readr')
install.packages('dplyr')
install.packages('ggplot2')
# library
library(forcats)
library(readr)
library(dplyr)
@aravindhebbali
aravindhebbali / rsqlite.R
Last active September 25, 2017 06:46
Quick Guide: R & SQLite
# install
install.packages('DBI')
install.packages('RSQLite')
install.packages('dplyr')
install.packages('dbplyr')
# library
library(DBI)
library(RSQLite)
library(dbplyr)