开始使用免费开始使用

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.

动手互动练习

通过我们的互动练习之一,将理论转化为实践

开始练习