| mpg | cyl | disp | hp | drat | wt | qsec | vs | am | gear | carb | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Mazda RX4 | 21.0 | 6 | 160 | 110 | 3.90 | 2.620 | 16.46 | 0 | 1 | 4 | 4 |
| Mazda RX4 Wag | 21.0 | 6 | 160 | 110 | 3.90 | 2.875 | 17.02 | 0 | 1 | 4 | 4 |
| Datsun 710 | 22.8 | 4 | 108 | 93 | 3.85 | 2.320 | 18.61 | 1 | 1 | 4 | 1 |
| Hornet 4 Drive | 21.4 | 6 | 258 | 110 | 3.08 | 3.215 | 19.44 | 1 | 0 | 3 | 1 |
| Hornet Sportabout | 18.7 | 8 | 360 | 175 | 3.15 | 3.440 | 17.02 | 0 | 0 | 3 | 2 |
groupby1
paper
todo
Question
Betrachten Sie den Datensatz mtcars (die ersten fünf Zeilen):
Gesucht ist die korrekte Syntax, um folgenden zusammengefassten Datensatz zu erhalten:
| cyl | schluckspecht | ps_mw | ps_sd |
|---|---|---|---|
| 4 | TRUE | 83 | 21 |
| 6 | FALSE | 132 | 30 |
| 6 | TRUE | 110 | 0 |
| 8 | FALSE | 209 | 51 |
Vier Syntaxvarianten stehen zur Auswahl:
A
mtcars %>%
select(1:2, hp) %>%
group_by(cyl, mpg > 20) %>%
summarise(ps_mw = round(mean(hp)),
ps_sd = round(sd(hp)))
B
mtcars %>%
select(1:2, hp) %>%
group_by(cyl, mpg > 20) %>%
summarise(ps_mw = mean(hp)),
ps_sd = sd(hp)))
C
mtcars %>%
select(1:2, hp) %>%
group_by(cyl, schluckspecht = mpg > 20) %>%
summarise(ps_mw = round(mean(hp)),
ps_sd = round(sd(hp)))
D
mtcars %>%
select(1:2, hp) %>%
group_by(cyl, schluckspecht = mpg) %>%
summarise(ps_mw = round(mean(hp)),
ps_sd = round(sd(hp)))
Answerlist
- A
- B
- C
- D
Solution
mtcars %>%
select(1:2, hp) %>%
group_by(cyl, schluckspecht = mpg > 20) %>%
summarise(ps_mw = round(mean(hp)),
ps_sd = round(sd(hp)))Aufgabenname: groupby1
Answerlist
- Falsch
- Falsch
- Wahr
- Falsch
Meta-information
exname: groupby1 extype: schoice expoints: 1 exsolution: 0010 exshuffle: false