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")

Pranala Menarik