Programming84 [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. [웹 스크래핑] 1. 웹 크롤링 웹 페이지 내 허용된 링크를 마구잡이로 가져옴 2. 웹 스크래핑 웹 페이지에서 다양한 방법으로 필요한 부분만 가져오는 것 head(diamonds) str(diamonds) glimpse(diamonds) colnames(diamonds) rename(diamonds, carat_New = carat) ggplot(data = diamonds, aes(x = carat, y = price, color = cut)) + geom_point() + facet_wrap(~cut) 2023. 4. 1. [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. 이전 1 ··· 3 4 5 6 7 8 9 ··· 21 다음
