
Raw Data: Uncleaned version of data collected from different sourcesVariable: Hold different valuesCategorical variable: Places an individual or an it
It is a process of inspecting, cleaning, transforming data with the goal of discovering useful information suggesting conclusions & supporting a decis
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일

Categorical VarsNumerical VarsText varsDate varsScatter plotHistogramData cleaningText functions
CONCAT(RANGE)CONCATENATE("A","B")TEXTJOIN("/",RANGE)LEFT("ABCDE",3): ABCRIGHT("ABCDE",3): CDEMID("ABCDE",start_number,HowMany)MID("ABCDE",2,3): BCD

Kaggle: https://www.kaggle.com/UCI Machine Learning Repository: https://archive.ics.uci.edu/ml/index.phpLink: https://www.kaggle.com/un

Download 5 different Happiness Report Files(2015-2019)Delet attributes which misses most of their valuesFill up values, first make seperate region tab

[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

a) 숫자열 (between, 대소비교)b) 문자열 (=, !=, like, in, not in)\--패션이 들어간 데이터 추가a) and 조건