[MYSQL] 프로그래머스 SQL 문제풀기
1. SELECT CONCAT('/home','/grep','/src/',BOARD_ID,'/',FILE_ID,FILE_NAME,FILE_EXT) FILE_PATH FROM USED_GOODS_FILE WHERE BOARD_ID = (SELECT BOARD_ID FROM USED_GOODS_BOARD ORDER BY VIEWS DESC LIMIT 1) ORDER BY FILE_ID DESC; 2. SELECT E.DEPT_ID, D.DEPT_NAME_EN, ROUND(AVG(E.SAL),0) AVG_SAL FROM HR_EMPLOYEES E LEFT JOIN HR_DEPARTMENT D USING (DEPT_ID) GROUP BY 1 ORDER BY AVG_SAL DESC; 3. SELECT CAR_ID..
[Sparkle] 서울시 쓰레기통 현황 분석 프로젝트 1
🎯간단한 EDA 1. 데이터 살펴보기 2. folium으로 쓰레기통 위치 시각화 # map 중심점 설정 center = [37.5608237, 127.0647933] m = folium.Map(location=center, tiles='cartodbpositron', zoom_start=12) for i in trash_raw.index: t_lat = trash_raw.loc[i, '위도'] t_long = trash_raw.loc[i, '경도'] title = trash_raw.loc[i, '상세주소'] folium.Circle([t_lat, t_long], color = 'red', radius=4, tooltip = title, fill_opacity = 50).add_to(m) m 💡지도 스타일..
