Extracting weekday components
One common date and time component that is difficult to calculate or extract manually is the day of the week. Part of the problem with extracting the day of the week is that different cultures define the start of the week differently, but Sunday and Monday are the most common.
In this exercise, you'll be preparing the film data for an analysis to determine if films released on particular days of the week gross larger amounts.
Diese Übung ist Teil des Kurses
Datenanalyse in Google Sheets
Anleitung zur Übung
- In column
E
, extract the day of the week as a number, where Sunday returns1
. - In column
F
, extract the short weekday name to match columnE
.
Interaktive Übung zum Anfassen
Setzen Sie die Theorie mit einer unserer interaktiven Übungen in die Tat um
