Difference between revisions of "R: Import"
Jump to navigation
Jump to search
Onnowpurbo (talk | contribs) |
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 10: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")