Difference between revisions of "R: Import"

From OnnoWiki
Jump to navigation Jump to search
 
(One intermediate revision by the same user not shown)
Line 16: Line 16:
 
  read_csv(file.choose())
 
  read_csv(file.choose())
 
  # Read semicolon (";") separated values
 
  # Read semicolon (";") separated values
  read_csv2(file.choose())  
+
  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 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