Using .SD (I)

.SD together with .SDcols is an incredibly powerful feature that makes computing on multiple columns so much easier.

.SD is a special symbol which stands for Subset of Data
.SDcols holds the columns that should be included in .SD

Diese Übung ist Teil des Kurses

Data Manipulation with data.table in R

Kurs anzeigen

Anleitung zur Übung

For each month, find the row corresponding to the shortest trip (by using which.min() on duration).
The result should contain the month, start_station, end_station, start_date, end_date, and duration columns.

Interaktive Übung

Vervollständige den Beispielcode, um diese Übung erfolgreich abzuschließen.

relevant_cols <- c("start_station", "end_station", 
                   "start_date", "end_date", "duration")

# Find the row corresponding to the shortest trip per month
shortest <- batrips[, ___, 
                    by = month(start_date), 
                    .SDcols = ___]
shortest

Code bearbeiten und ausführen