Difference between revisions of "R: Import"

From OnnoWiki
Jump to navigation Jump to search
 
Line 27: Line 27:
 
  library("xlsx")
 
  library("xlsx")
 
  my_data <- read.xlsx("my_file.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 10: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")

Referensi

Pranala Menarik