官术网_书友最值得收藏!

Importing data in R

Data comes in various formats. Most of the data available online can be downloaded in the form of text documents (.txt extension) or as comma-separated values (.csv). We also encounter data in the tab-delimited format, XLS, HTML, JSON, XML, and so on. If you are interested in working with data, either in JSON or XML, refer to the recipe Constructing a bar plot using XML in R in Chapter 10, Creating Applications in R.

How to do it...

In order to import a CSV file in R, we can use the read.csv() function:

test = read.csv("raw.csv", sep = ",", header = TRUE)

Alternatively, read.table() function allows us to import data with different separators and formats. Following are some of the methods used to import data in R:

How to do it...

How it works…

The first argument in the read.csv() function is the filename, followed by the separator used in the file. The header = TRUE argument is used to instruct R that the file contains headers. Please note that R will search for this file in its current directory. We have to specify the directory containing the file using the setwd() function. Alternatively, we can navigate and set our working directory by navigating to Sessions | Set working directory | Choose directory.

The first argument in the read.table() function is the filename that contains the data, the second argument states that the data contains the header, and the third argument is related to the separator. If our data consists of a semi colon (;), a tab delimited, or the @ symbol as a separator, we can specify this under the sep ="" argument. Note that, to specify a separator as a tab delimited, users would have to substitute sep = "," with sep ="\t" in the read.table() function.

One of the other useful arguments is the row.names argument. If we omit row.names, R will use the column serial numbers as row.names. We can assign row.names for our data by specifying it as row.names = c("Name").

主站蜘蛛池模板: 广昌县| 毕节市| 石阡县| 新民市| 兰溪市| 新河县| 和田市| 和政县| 四子王旗| 建宁县| 马边| 黄浦区| 永川市| 西和县| 灵台县| 达孜县| 新乐市| 雷州市| 富平县| 曲沃县| 潼南县| 高青县| 颍上县| 新兴县| 金秀| 泽普县| 乌什县| 曲阳县| 启东市| 嘉义县| 洱源县| 张北县| 丽水市| 韶关市| 馆陶县| 霍城县| 竹溪县| 宝山区| 新野县| 伊川县| 海宁市|