August 2022
Beginner to intermediate
436 pages
9h 43m
Korean
Content preview from SQL로 시작하는 데이터 분석
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
113
3
장
시계열 분석
3.3
데이터 트렌드 분석
시계열 데이터에서 데이터의 트렌드를 분석해보고 싶은 경우가 있습니다. 여기서 트렌드란 데
이터가 움직이는 방향을 의미합니다. 값은 시간에 따라 증가하기도 하고 감소하기도 합니다.
또한 변화의 기울기가 더 평평해지기도 하고 덜 평평해지기도 하며, 오르락내리락 불규칙적으
로 움직일 수도 있습니다. 따라서 트렌드를 파악하는 일은 쉽지 않습니다. 이 절에서는 그래프
를 이용한 간단한 트렌드 분석, 각 요소가 전체에서 차지하는 비율을 이용한 요소별 트렌드 비
교 분석, 시간 윈도우 기반의 트렌드 분석 등 여러 가지 시계열 분석 기법을 알아봅니다.
3.3.1
간단한 트렌드
트렌드 분석은 데이터 프로파일링 수단일 수도 있고, 트렌드 파악 자체가 목적일 수도 있습니
다. 트렌드 분석에서 결과 데이터는 날짜 또는 타임스탬프와 이에 해당하는 수치값으로 이뤄져
있습니다. 시계열 데이터로 그래프를 그릴 때 날짜 또는 타임스탬프는
X
축에 놓이며, 수치값은
Y
축에 놓입니다. 예를 들어, 다음 코드와 같이 미국 전체 소매업과 외식업의 매출 트렌드를 검
토해봅시다.
SELECT
sales_month
,sales
FROM
retail_sales
WHERE
kind_of_business = ‘Retail and food services sales, ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.