R: Import: Difference between revisions
From OnnoCenterWiki
Jump to navigationJump to search
Onnowpurbo (talk | contribs) Created page with " # Read tab separated values read.delim(file.choose()) # Read comma (",") separated values read.csv(file.choose()) # Read semicolon (";") separated values read.csv2(file..." |
Onnowpurbo (talk | contribs) |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
==Normal== | |||
# Read tab separated values | # Read tab separated values | ||
| Line 7: | Line 8: | ||
read.csv2(file.choose() | read.csv2(file.choose() | ||
==Fast Read== | |||
library("readr") | |||
# Read tab separated values | |||
read_tsv(file.choose()) | |||
# Read comma (",") separated values | |||
read_csv(file.choose()) | |||
# Read semicolon (";") separated values | |||
read_csv2(file.choose()) | |||
==Excel== | |||
# Use readxl package to read xls|xlsx | |||
library("readxl") | |||
my_data <- read_excel("my_file.xlsx") | |||
# Use xlsx package | |||
library("xlsx") | |||
my_data <- read.xlsx("my_file.xlsx") | |||
==Referensi== | |||
* http://www.sthda.com/english/wiki/importing-data-into-r | |||
==Pranala Menarik== | ==Pranala Menarik== | ||
* [[R]] | * [[R]] | ||
Latest revision as of 03:35, 28 November 2019
Normal
# Read tab separated values
read.delim(file.choose())
# Read comma (",") separated values
read.csv(file.choose())
# Read semicolon (";") separated values
read.csv2(file.choose()
Fast Read
library("readr")
# Read tab separated values
read_tsv(file.choose())
# Read comma (",") separated values
read_csv(file.choose())
# Read semicolon (";") separated values
read_csv2(file.choose())
Excel
# Use readxl package to read xls|xlsx
library("readxl")
my_data <- read_excel("my_file.xlsx")
# Use xlsx package
library("xlsx")
my_data <- read.xlsx("my_file.xlsx")