Data Manipulation with dplyr MCQ question and answer with solution

21.
What is the purpose of the ungroup() function in dplyr?

A. Retains the grouping of the data frame

B. Removes the grouping of the data frame

C. Unpacks nested data frames

D. Reorders the rows based on a specific column

Answer & Solution Discuss in Board Save for Later

22.
How do you select distinct values from a column named category in dplyr using distinct()?

A. distinct_values(category)

B. select_distinct(category)

C. unique(category)

D. distinct(category)

Answer & Solution Discuss in Board Save for Later

23.
In dplyr, what does the slice() function do?

A. Extracts specific rows from a data frame

B. Selects specific columns from a data frame

C. Slices a data frame into smaller data frames

D. Sorts the data frame in ascending order

Answer & Solution Discuss in Board Save for Later

24.
What does the rename_all() function do in dplyr?

A. Renames all variables in a data frame

B. Renames all columns in a data frame

C. Renames all levels in a factor variable

D. Renames all rows in a data frame

Answer & Solution Discuss in Board Save for Later

25.
How do you calculate the median of a numeric variable named price for each group in dplyr?

A. summarize(median_price = median(price))

B. calculate_median(price)

C. median_group(price)

D. median(price)

Answer & Solution Discuss in Board Save for Later

26.
In dplyr, how do you select columns that match a specific pattern using the select() function?

A. select(pattern = "specific_pattern")

B. choose_cols(matches("specific_pattern"))

C. select(columns = matches("specific_pattern"))

D. pick_cols(pattern = "specific_pattern")

Answer & Solution Discuss in Board Save for Later

27.
What function is used to remove missing values from a dplyr data frame?

A. clean_na()

B. remove_missing()

C. na_omit()

D. filter_na()

Answer & Solution Discuss in Board Save for Later

28.
In dplyr, how do you calculate the cumulative sum of a variable named sales within each group?

A. cumulative_sum(sales)

B. summarize(cumsum = cumsum(sales))

C. calculate(cumulative = cumsum(sales))

D. mutate(cumsum = cumsum(sales))

Answer & Solution Discuss in Board Save for Later

29.
How is the case_when() function used in dplyr?

A. To create a switch case statement in a column

B. To filter rows based on multiple conditions

C. To select specific columns from a data frame

D. To perform case-sensitive matching in a column

Answer & Solution Discuss in Board Save for Later

30.
In dplyr, what does the slice_sample() function do?

A. Samples random rows from a data frame

B. Extracts specific rows based on conditions

C. Slices a data frame into smaller data frames

D. Sorts the data frame in ascending order

Answer & Solution Discuss in Board Save for Later

Data Manipulation with dplyr MCQ question and answer with solution | R Programming MCQs

21. What is the purpose of the ungroup() function in dplyr?

Answer & Solution

22. How do you select distinct values from a column named category in dplyr using distinct()?

Answer & Solution

23. In dplyr, what does the slice() function do?

Answer & Solution

24. What does the rename_all() function do in dplyr?

Answer & Solution

25. How do you calculate the median of a numeric variable named price for each group in dplyr?

Answer & Solution

26. In dplyr, how do you select columns that match a specific pattern using the select() function?

Answer & Solution

27. What function is used to remove missing values from a dplyr data frame?

Answer & Solution

28. In dplyr, how do you calculate the cumulative sum of a variable named sales within each group?

Answer & Solution

29. How is the case_when() function used in dplyr?

Answer & Solution

30. In dplyr, what does the slice_sample() function do?

Answer & Solution

Read More Section(Data Manipulation with dplyr)

21.
What is the purpose of the ungroup() function in dplyr?

22.
How do you select distinct values from a column named category in dplyr using distinct()?

23.
In dplyr, what does the slice() function do?

24.
What does the rename_all() function do in dplyr?

25.
How do you calculate the median of a numeric variable named price for each group in dplyr?

26.
In dplyr, how do you select columns that match a specific pattern using the select() function?

27.
What function is used to remove missing values from a dplyr data frame?

28.
In dplyr, how do you calculate the cumulative sum of a variable named sales within each group?

29.
How is the case_when() function used in dplyr?

30.
In dplyr, what does the slice_sample() function do?