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

The gather() function

There are times when our data is considered raw and unstacked (not in chronological order) and a common attribute of concern is used across the columns. To reformat the data so that these common attributes take up a single variable, the gather () function will take multiple columns and break them into key-value pairs, duplicating all other columns if needed.

The following illustration will help us to better understand the implementation of gather() function. The syntax for implementing the gather() function is as follows:

gather(data, key, value, ..., na.rm =   FALSE, convert = FALSE)

Here, the parameters of the function are as follows:

  • data: Data frame
  • key: Name of the key
  • value: Name of the value
  • na.rm: If TRUE, it will remove rows from the output
  • convert: If TRUE, it will automatically convert the specified key column

Suppose we need to gather information relating to the manufacturer and model and display other attributes in same way. In this case, there is a need to present only manufacturers and models in a systematic manner. We can achieve this with the help of the gather() function, demonstrated as follows:

> mpg2 <- mpg %>% gather(mpg, "Year   of Establishment", "year", -manufacturer)   
> View(mpg2)   

The output generated is displayed as follows:

It is clearly visible that the key-value pair is generated for the year of establishment of each and every model included in the dataset.

主站蜘蛛池模板: 朝阳县| 柯坪县| 九龙县| 博白县| 民和| 永州市| 漯河市| 林周县| 赤峰市| 贡山| 宁海县| 金昌市| 革吉县| 息烽县| 衡东县| 盐城市| 常州市| 嘉善县| 噶尔县| 河北省| 石首市| 洛南县| 苏尼特右旗| 永年县| 枣庄市| 吉首市| 灌阳县| 新郑市| 浑源县| 邢台县| 普陀区| 肥城市| 安国市| 高密市| 溧水县| 英山县| 桂东县| SHOW| 缙云县| 宁陕县| 蚌埠市|