在前一章中,我们描述了R编程的要点。在这里,您将学习如何将数据从txt、csv、Excel(xls、xlsx)导入R。
Best practices in preparing data files for importing into R
Reading data from txt|csv files: R base functions
Fast Reading of Data From txt|csv Files into R: readr package
Reading data From Excel Files (xls|xlsx) into R
Best practices in preparing data files for importing into R
Reading data from txt|csv files: R base functions
用于导入数据的R基函数:read.table()、read.delim()、read.csv()、read.csv2()
读取本地文件
从internet读取文件
# 读取制表符分隔
> read.delim(file.choose())
#读取逗号(“,”)分隔
> read.csv(file.choose())
# 读取分号(“;”)分隔的值
> read.csv2(file.choose())
Fast Reading of Data From txt|csv Files into R: readr package
用于读取txt | csv文件的函数:read_delim(), read_tsv(), read_csv(), read_csv2()
读取文件
读取本地文件
从internet读取文件
在解析问题的情况下
指定列类型
从文件读取行:read_lines()
读取整个文件:read_file()
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())
Reading data From Excel Files (xls|xlsx) into R
Copying data from Excel and import into R
Importing Excel files into R using readxl package
Importing Excel files using xlsx package
# 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")