Programming/Google Data Analytics Certificate19 [GA] 구글 애널리틱스 프로그램 - R 기초 To check the bias of the data, we need dataframes. > colnames(diamonds) [1] "carat" "cut" "color" "clarity" "depth" "table" "price" "x" "y" [10] "z" > library(tidyr) > library(tidyverse) > mutate(diamonds, carat_2 = carat* 100) head(diamonds) str(diamonds) glimpse(diamonds) colnames(diamonds) rename(diamonds, carat_New = carat) ggplot(data = diamonds, aes(x = carat, y = price, color = cut)) + ge.. 2023. 4. 4. [GA] 구글 애널리틱스 프로그램 - R 기초 To check the bias of the data, we need dataframes. > colnames(diamonds) [1] "carat" "cut" "color" "clarity" "depth" "table" "price" "x" "y" [10] "z" > library(tidyr) > library(tidyverse) > mutate(diamonds, carat_2 = carat* 100) head(diamonds) str(diamonds) glimpse(diamonds) colnames(diamonds) rename(diamonds, carat_New = carat) ggplot(data = diamonds, aes(x = carat, y = price, color = cut)) + ge.. 2023. 4. 3. [GA] SQL 정리 1. CASE in SELECT Statement SELECT _FirstName, _LastName, _Age, _JobTitle, CAST(_Salary as int64), CASE When _JobTitle = "Salesman" Then _Salary + (_Salary * .10) When _JobTitle = "Accountant" Then _Salary + (_Salary * .05) ELSE _Salary END FROM `onyx-smoke-380601.alex.EmployeeDemographics` as D JOIN `onyx-smoke-380601.alex.EmployeeSalary` as S on D.EmployeeID = S.EmployeeID 2. HAVING (where 사용 .. 2023. 4. 1. [GA] Google Analytics Certificate Program (GA Day) Course 5 Data Aggregation- SQL JOIN 사용 Select DATE, Region, Small_Bags, Large_Bags, XLarge_Bags, Total_Bags, (Small_Bags / Total_Bags)*100 as SB_percent From avocado_data.avocado_prices WHERE Total_Bags 0 or Total_Bags != 0 -- values we are calculating does not equal to 0 How to use TEMPORARY TABLE With trips_over_1_hr as ( SELECT * FROM `bigquery-public-data.new_york_citibike.citibike_trips` WHERE tripduration >=60 ) -- this is a de.. 2023. 3. 27. 이전 1 2 3 4 5 다음
