题目
题目

COMM_V 205 101 102 103 2025W1 R Review Quiz

多项填空题

Please create the following data frame: library(tidyverse)student <- tibble(  sid = c(66666,66666,66666,66666,66666,66666,22222,22222,22222,22222,22222,           11111,11111,11111,11111,11111,44444,44444,44444,44444,44444, 44444,           55555,55555,55555,55555,55555,55555, 33333,33333,33333,33333,33333,33333, 77777),   course = c("COMM101", "COMM102", "COMM103", "COMM201", "COMM204","COMM205", "COMM101",              "COMM102", "COMM103", "COMM201","COMM204", "COMM101", "COMM102", "COMM103",              "COMM201", "COMM205", "COMM101", "COMM102", "COMM103", "COMM201","COMM204",              "COMM205", "COMM101", "COMM102", "COMM103","COMM201", "COMM204", "COMM205",             "COMM101", "COMM102", "COMM103", "COMM201", "COMM204","COMM205", "COMM205"),   year = c(2016, 2016, 2016, 2017, 2017, 2017, 2016, 2016, 2017, 2017,2017,2016, 2016,            2016, 2017, 2017, 2016, 2016, 2016, 2016, 2017, 2017,2016, 2016, 2016, 2016,            2017, 2017,2016, 2016, 2016, 2017, 2017, 2017, 2017),  grade = c(85, 88, 72, 67, 80, 90, 77, 77, 77, 77, 77, 78, 82, 82, 80, 90, 80, 80, 80,             85, 85, 85, 79, 80, 81, 82, 83, 84, 90, 88, 95, 80, 80, 80, 99))   You wanted to find out how many unique students have taken courses in 2016.  student %>%   filter(year == 2016) %>%   XXXX(sid) %>% summarise(XXXX(sid)) The result of your code should look something like this: # A tibble: 1 × 1             XXXXXXXXXX                                <int> 1                    6 Please complete the code below. student %>%   filter(year == 2016) %>%   [Fill in the blank] (sid) %>% summarise([Fill in the blank] (sid))  

查看解析

查看解析

标准答案
Please login to view
思路分析
We start by restating the problem in our own words to ensure we understand the task: we have a tibble of student course registrations with columns sid, course, year, and grade, and we want to count how many unique student IDs (sids) appear in the year 2016. Option 1: select - The first blank appears after filter(year == 2016) and before the next pipe to summarise. If we insert select(sid), we are narrowing the data frame to just the sid column for the 2016 observations. - Keeping only sid is reasonable because we only care about distinct student identifiers; it reduces ......Login to view full explanation

登录即可查看完整答案

我们收录了全球超50000道考试原题与详细解析,现在登录,立即获得答案。

类似问题

This function in the library of Pandas allows you to manipulate data and create new variables (please choose all the correct answers, one or more):

Question at position 17 ________ is a set of commands used to update and query a database.DDL DML DPL DCL

Question at position 51 A database is maintained and queried using the data mapping language (DML).TrueFalse

Question at position 33 INSERT INTO is an example of ________ code.DDL DCLDMLTIO

更多留学生实用工具

加入我们，立即解锁 海量真题 与 独家解析，让复习快人一步！