Data Engineering, Analysis & Science
1.DSDA 01 Basic Terms
Raw Data: Uncleaned version of data collected from different sourcesVariable: Hold different valuesCategorical variable: Places an individual or an it
2.DSDA_02
It is a process of inspecting, cleaning, transforming data with the goal of discovering useful information suggesting conclusions & supporting a decis
3.DSDA_Excel
Excel Basic functions min =min(A2:A300) max =max(A2:A300) Average =average(A2:A300) count =count(A2:A300) if | nested if =IF(조건,TRUE일때 행동, False일
4.DSDA_Excel_Scatter plot
Categorical VarsNumerical VarsText varsDate varsScatter plotHistogramData cleaningText functions
5.DSDA_Excel_Concat
CONCAT(RANGE)CONCATENATE("A","B")TEXTJOIN("/",RANGE)LEFT("ABCDE",3): ABCRIGHT("ABCDE",3): CDEMID("ABCDE",start_number,HowMany)MID("ABCDE",2,3): BCD
6.[Project] 1. Data Search & Select
Kaggle: https://www.kaggle.com/UCI Machine Learning Repository: https://archive.ics.uci.edu/ml/index.phpLink: https://www.kaggle.com/un
7.[Project] 2. Data Cleaning
Download 5 different Happiness Report Files(2015-2019)Delet attributes which misses most of their valuesFill up values, first make seperate region tab
8.[Project] 3. Data Analyzing
[Project]: Happiness Report Q1. Top 10 highest happiness scores in 5 years Q2. Which region has the highest average happiness rankings? 
[Project]: Happiness Report Dashboard
11.[SQL] #1 select | from | where |
a) 숫자열 (between, 대소비교)b) 문자열 (=, !=, like, in, not in)\--패션이 들어간 데이터 추가a) and 조건