Import

Quick Guide: R & SQLite

Introduction This is the first post in the series R & Databases. You can find the links to the other two posts of this series below: Data Wrangling with dbplyr SQL for Data Science - Part 1 SQL for Data Science - Part 2 In this post, we will learn to: connect to a SQLite database from R display database information list tables in the database query data read entire table read few rows read data in batches create table in database overwrite table in database append data to table in database remove table from database generate SQL query close database connection Libraries, Code & Data We will use the following libraries in this post:

Importing Data into R - Part 3

Introduction This is the third post in the series Importing Data into R. You can find the link to the previous posts below: Importing Data into R - Part 1 Importing Data into R - Part 2 In the previous post, we explored reading data from excel spreadsheets and files from other statistical softwares such as SAS, SPSS and STATA. In this post, we will learn to read data from:

Importing Data into R - Part 2

Introduction This is the second post in the series Importing Data into R. In the previous post, we explored reading data from flat/delimited files. In this post, we will: list sheets in an excel file read data from an excel sheet read specific cells from an excel sheet read specific rows read specific columns read data from - SAS - SPSS - STATA Libraries, Data & Code We will use the readxl package.

Importing Data into R - Part 1

Introduction This is the first post in the series Importing Data into R. Before we get started, let me talk a bit about what we will learn in this series. I am planning to write 3 posts in which we will explore how to read data from: flat/delimited files (.csv, .txt, .tsv) excel spreadsheets (.xls, .xlsx) statistical softwares JSON/XML There are other ways to get data into R such as databases, APIs etc.

A Complete Guide to Importing Data into R - Part 3

Introduction This is the fifth post in the series Data Wrangling with R. In the previous post, we learnt to import data from flat files, excel spreadsheets and statistical softwares. In this post, we will learn to import data from: JSON XML Libraries, Data & Code We will use the following libraries in this post: jsonlite xml2 XML purrr All the data sets used in this post can be found here and code can be downloaded from here.