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.
347
6
장
이상 탐지
[그림
6
-
12
]를 보면 깊이 값이 대부분
0
.
05
~
20
에 분포돼 있지만
X
축이
0
~
700
으로 늘어져
모든 깊이 값을 표현하고 있어 분포를 제대로 이해하기가 어렵습니다. 반면 [그림
6
-
13
]과 같
이 로그 스케일로 표현한 깊이 분포를 보면 작은 깊이 값들의 분포를 이해하기가 더 쉽습니다.
그래프를 보면 깊이
10
킬로미터를 로그 스케일로 변환한 값인
1
이 매우 많습니다.
TIP
SQL
에서는 로그 스케일이 아닌 다른 유형의 스케일 변환도 가능합니다. 주로 사용하는 스케일 변환 방법은
다음과 같습니다.
●
제곱근 :
sqrt
함수 사용
●
세제곱근 :
cbrt
함수 사용
●
역변환 :
1
/ 필드명
인 치
inch
를 피트
feet
로, 파운드
pound
를 킬로그램
kilogram
으로 변환하는 등의 단위 변환을 하려면
*
,
/
를 이용해
값에 적절한 변환계수
conversion
factor
를 곱하거나 나눕니다.
리스케일에는
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,
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.