開始使用免費開始

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.

本練習屬於課程

Google Sheets 的資料分析

檢視課程

練習說明

  • In column E, extract the day of the week as a number, where Sunday returns 1.
  • In column F, extract the short weekday name to match column E.

動手互動練習

將理論付諸實踐,立即體驗我們的互動練習

開始練習