始める無料で始める

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.

実践的なインタラクティブ演習

理論を実践に変える、インタラクティブな演習のひとつをお試しください

演習を開始する