머리말 Ⅰ
차례 Ⅲ
▶ 파이썬 ················································· 1
01 Python 개요 ·························································3
02 변수의 설정 ··························································8
03 연산자와 복합연산자 ··················································13
04 주석 처리하기 ·······················································15
05 들여쓰기(indent)와 콜론(:) ············································16
06 Data Type·························································17
07 if 문 ·······························································36
08 for 문 ·····························································38
09 사용자 함수 ·························································51
10 문자열(string) 처리 함수 ··············································62
11 연산 결과를 나타내는 함수 ············································67
12 중복 값을 제외한 결과를 보여주는 함수 ··································68
13 range(), enumerate(), zip() 함수 ······································69
14 all(), any() 함수 ····················································73
15 filter() 함수 ························································76
16 문자열 포맷팅 ·······················································77
17 예외 처리 ···························································79
이론 실기 - 객관식ㆍ주관식 문제 ··········································84
ⅡⅣ
제1회 기출문제 - 파이썬 ···············································107
제2회 기출문제 - 파이썬 ···············································113
▶ Fraudit을 활용한 데이터분석 ····························· 121
01 Fraudit 개요 ·······················································123
02 Fraudit 기초 ·······················································125
03 Fraudit의 테이블(Table) ·············································134
04 Fraudit의 데이터 타입 ···············································137
05 Fraudit의 기본 메뉴 ·················································142
06 Fraudit의 Select 메뉴 ···············································154
07 Fraudit의 Join 메뉴 ·················································160
08 Fraudit의 Group 메뉴 ···············································164
09 Fraudit의 Summarize 메뉴 ···········································168
10 Fraudit의 Remove Duplicates 메뉴 ····································174
11 Fraudit의 Merge 메뉴 ···············································175
12 Fraudit의 Pivot Table 메뉴 ··········································176
13 Fraudit의 Chart 메뉴 ················································177
14 Fraudit의 Analyze 메뉴 ··············································178
15 사례 분석(1) : 분개장 분석 ···········································199
16 사례 분석(2) : 송장 분석 ············································224
17 사례 분석(3) : 급여 분석 ············································230
18 사례 분석(4) : 기타 ·················································235
실기 - 주관식 문제 ····················································240
제1회 기출문제 - Fraudit ···············································255
제2회 기출문제 - Fraudit ···············································266
