R: Import: Difference between revisions
From OnnoCenterWiki
Jump to navigationJump to search
Onnowpurbo (talk | contribs) No edit summary |
Onnowpurbo (talk | contribs) |
||
| 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") | |||
==Pranala Menarik== | ==Pranala Menarik== | ||
* [[R]] | * [[R]] | ||
Revision as of 03:31, 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")