Data-导入数据至R

在前一章中,我们描述了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")

©著作权归作者所有,转载或内容合作请联系作者
平台声明:文章内容(如有图片或视频亦包括在内)由作者上传并发布,文章内容仅代表作者本人观点,简书系信息发布平台,仅提供信息存储服务。

推荐阅读更多精彩内容