시작하기무료로 시작하기

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.

실습형 인터랙티브 연습문제

이론을 실습으로 바꾸는 인터랙티브 연습 중 하나를 만나보세요

연습 시작