2/14

TMI

 

select year,
	   case when date(date) like '2022-01-%' or date(date) like '2022-02-%' or date(date) like '2022-03-%' then 20221
	   		when date(date) like '2022-04-%' or date(date) like '2022-05-%' or date(date) like '2022-06-%' then 20222
	   		when date(date) like '2022-07-%' or date(date) like '2022-08-%' or date(date) like '2022-09-%' then 20223
	   		when date(date) like '2022-10-%' or date(date) like '2022-11-%' or date(date) like '2022-12-%' then 20222
	   		when date(date) like '2023-01-%' or date(date) like '2023-02-%' or date(date) like '2023-03-%' then 20231
	   		when date(date) like '2023-04-%' or date(date) like '2023-05-%' or date(date) like '2023-06-%' then 20232
	   		when date(date) like '2023-07-%' or date(date) like '2023-08-%' or date(date) like '2023-09-%' then 20233
	   		when date(date) like '2023-10-%' or date(date) like '2023-11-%' or date(date) like '2023-12-%' then 20232
	   end '분기',
	   add1,
	   add2,
	   level,
	   type,
	   size,
	   deposit,
	   rent,
	   building,
	   name
from seoul_estate se
where building <> "아파트"

 

• 오늘 하루종일 한 거: 데이터 전처리
• 내일 드디어 머신러닝을 하게 될 텐데, 튜터님들이 강의 때 매번 강조한 대로 데이터 전처리로 전체 시간의 90%는 쓴다는 것을 매일매일 절감하는 듯.