Convert multiple columns into a single column, To combine numerous data frame columns into one column, use the union() function from the tidyr package.
Convert multiple columns into a single column
The basic syntax used by this function is as follows.
unite(data, col, into, sep)
where:
data: Name of the data frame
col: Name of the new united column
… : names for the columns to be combined in a vector
sep: How to create a new united column and combine the data
The practical application of this function is demonstrated in the examples that follow.
5 Free Books to Learn Statistics For Data Science – Data Science Tutorials
Example 1: Unite Two Columns into One Column
Let’s say we have the R data frame shown below:
Let’s create a data frame
df <- data.frame(player=c('P1', 'P1', 'P2', 'P2', 'P3', 'P3'), year=c(1, 2, 1, 2, 1, 2), points=c(202, 290, 180, 101, 312, 219), assists=c(92, 63, 76, 88, 65, 52))
Now we can view the data frame
df
 player year points assists 1    P1   1   202     92 2    P1   2   290     63 3    P2   1   180     76 4    P2   2   101     88 5    P3   1   312     65 6    P3   2   219     52
The “points” and “assists” columns can be combined into a single column using the union() function.
library(tidyr)
combine the columns for points and assists into one column.
Best Books on Data Science with Python – Data Science Tutorials
unite(df, col='points-assists', c('points', 'assists'), sep='-')
 player year points-assists 1    P1   1        202-92 2    P1   2        290-63 3    P2   1        180-76 4    P2   2        101-88 5    P3   1        312-65 6    P3   2        219-52
Example 2: Unite More Than Two Columns
Let’s say we have the R data frame shown below:
Let’s create a data frame
df2 <- data.frame(player=c('P1', 'P1', 'P2', 'P2', 'P3', 'P3'), year=c(1, 2, 1, 2, 1, 2), points=c(228, 229, 198, 151, 412, 325), assists=c(82, 93, 66, 45, 89, 95), blocks=c(28, 36, 32, 82, 18, 12))
Let’s view the data frame
df2
player year points assists blocks 1Â Â Â Â P1Â Â Â 1Â Â Â 228Â Â Â Â Â 82Â Â Â Â 28 2Â Â Â Â P1Â Â Â 2Â Â Â 229Â Â Â Â Â 93Â Â Â Â 36 3Â Â Â Â P2 Â Â Â 1Â Â Â 198Â Â Â Â Â 66Â Â Â Â 32 4Â Â Â Â P2Â Â Â 2Â Â Â 151Â Â Â Â Â 45Â Â Â Â 82 5Â Â Â Â P3Â Â Â 1Â Â Â 412Â Â Â Â Â 89Â Â Â Â 18 6Â Â Â Â P3Â Â Â 2Â Â Â 325Â Â Â Â Â 95Â Â Â Â 12
The points, assists, and blocks columns can be combined into a single column using the union() function.
library(tidyr)
combine the columns for scoring, assists, and blocks into one
unite(df2, col='stats', c('points', 'assists', 'blocks'), sep='/')
player year    stats 1    P1   1 228/82/28 2    P1   2 229/93/36 3    P2   1 198/66/32 4    P2   2 151/45/82 5    P3   1 412/89/18 6    P3   2 325/95/12
Best Books to learn Tensorflow – Data Science Tutorials
Have you liked this article? If you could email it to a friend or share it on Facebook, Twitter, or Linked In, I would be eternally grateful.
Please use the like buttons below to show your support. Please remember to share and comment below.