pivot_longer (wide to long) in R Programming - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to load the tidyr package.

R Programming

library([1])

Drag options to blanks, or click blank then click option'

Adplyr

Btidyr

Cggplot2

Dstringr

Attempts:

3 left

💡 Hint

Common Mistakes

Loading the wrong package like dplyr or ggplot2 instead of tidyr.

The tidyr package contains the pivot_longer() function used to reshape data from wide to long format.

2fill in blank

medium

Complete the code to reshape the data frame df from wide to long format using pivot_longer().

R Programming

df_long <- pivot_longer(df, cols = [1], names_to = "variable", values_to = "value")

Drag options to blanks, or click blank then click option'

Ac(col1, col2)

Bc(1, 2)

Ccol1:col2

Dc("col1", "col2")

Attempts:

3 left

💡 Hint

Common Mistakes

Using unquoted column names or numeric indices instead of strings.

The cols argument expects column names as strings inside a vector, so c("col1", "col2") is correct.

3fill in blank

hard

Fix the error in the code to correctly specify the columns to pivot.

R Programming

df_long <- pivot_longer(df, cols = [1], names_to = "variable", values_to = "value")

Drag options to blanks, or click blank then click option'

Acol1:col2

Bc(col1, col2)

Cc("col1", "col2")

Dc('col1', 'col2')

Attempts:

3 left

💡 Hint

Common Mistakes

Using unquoted column names or colon notation which is invalid here.

The columns must be specified as a character vector with double quotes, so c("col1", "col2") is correct. Single quotes also work in R but the question expects double quotes for consistency.

4fill in blank

hard

Fill both blanks to create a long format data frame with columns named "key" and "val".

R Programming

df_long <- pivot_longer(df, cols = [1], names_to = [2], values_to = "val")

Drag options to blanks, or click blank then click option'

Ac("A", "B")

B"variable"

C"key"

Dc("col1", "col2")

Attempts:

3 left

💡 Hint

Common Mistakes

Swapping the order of columns and names_to arguments.

The cols argument should be the columns to pivot, here c("col1", "col2"). The names_to argument sets the new column name for the original column names, here "key".

5fill in blank

hard

Fill all three blanks to pivot columns "X1" and "X2" into a long format with names in "variable" and values in "value".

R Programming

df_long <- pivot_longer(df, cols = [1], names_to = [2], values_to = [3])

Drag options to blanks, or click blank then click option'

Ac("X1", "X2")

B"value"

C"variable"

D"val"

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing up the names_to and values_to argument values.

The columns to pivot are c("X1", "X2"). The new column for names is "variable" and for values is "value".