Programming/Google Data Analytics Certificate19 SQL Practice - populate property address data Select * From portfolio_1.NashvilleHousing Order by ParcelID - Convert date-time to date SELECT SaleDate cast(SaleDate as date) as SaleDateConverted FROM portfolio_1.NashvilleHousing - fill in null(propertyaddress) with that of parcel ID SELECT NH.ParcelID, NH.PropertyAddress, NH2.ParcelID, NH2.PropertyAddress, ifnull(NH.PropertyAddress, NH2.PropertyAddress) FROM.. 2023. 4. 6. SQL - Alex the Analyst portfolio 1 in Big Query SELECT location, MAX(cast(total_deaths as int)) as HighestDeathCount FROM portfolio_1.CovidDeaths Where continent is not null Group by location order by HighestDeathCount DESC limit 1000 SELECT continent, Max(cast(Total_deaths as int)) as TotalDeathCount FROM portfolio_1.CovidDeaths Where continent is null and location not like '%income%' Group by continent order by TotalDeathCount DESC limit 10.. 2023. 4. 5. R install.packages("ggplot2") install.packages("palmerpenguins") library(ggplot2) library(palmerpenguins) data(penguins) View(penguins) ggplot(data= penguins) + geom_point(mapping = aes(x=flipper_length_mm, y =body_mass_g)) ggplot(data = penguins) + geom_point(mapping = aes(x= bill_length_mm, y=bill_depth_mm, color = species)) + facet_wrap(~species) hotel_bookings 2023. 4. 5. [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. 이전 1 2 3 4 5 다음