Difference between revisions of "R: Import"

From OnnoWiki
Jump to navigation Jump to search
(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...")
 
 
(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 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