TEAM EDA

본 포스터는 한빛미디어에서 [나는 리뷰어다]를 통해 책을 지원받아 작성한 리뷰 포스터입니다. 먼저 저는 대학원생이고 대학원에서 파이썬과 파이토치를 이용해서 딥러닝 연구를 하고 있음을 미리 밝힙니다. 책을 읽고 난 느낌부터 말하자면 파이썬을 이용해서 데이터 분석을 하는 학생, 입문자분들에게는 추천드리지 않습니다. 하지만 파이썬을 이용해서 개발을 하시는 분들은 3번쯤은 읽어보면 좋은 책으로 생각합니다. 1. 책소개 많은 분들이 아시겠지만 "진지한 파이썬"은 페이스북과 블로그들에서 몇번 언급되었던 책입니다. 저희 경우도 페이스북의 친구분과 구독하고 있는 블로그 분들의 글을 통해서 책을 처음 접했습니다. 많은 주변 개발자분들이 좋은 평을 해줘서 기대한 점도 있었지만 사실 이 책을 리뷰로 선택한 이유는 책의 소개..

Input Format The STATION table is described as follows: where LAT_N is the northern latitude and LONG_W is the western longitude. Q1. Query the following two values from the STATION table: The sum of all values inLAT_Nrounded to a scale ofdecimal places. The sum of all values inLONG_Wrounded to a scale ofdecimal places. Output Format Your results must be in the form: lat lon where lat is the sum..

We define an employee's total earnings to be their monthly salary x months worked, and themaximum total earningsto be the maximum total earnings for any employee in the Employee table. Write a query to find the maximum total earnings for all employees as well as the total number of employees who have maximum total earnings. Then print these values as 2space-separated integers. Input Format T..

Samantha was tasked with calculating the average monthly salaries for all employees in the EMPLOYEES table, but did not realize her keyboard's 0 key was broken until after completing the calculation. She wants your help finding the difference between her miscalculation (using salaries with any zeroes removed), and the actual average salary. Write a query calculating the amount of error (i.e.:act..

Input Format The CITY table is described as follows: Q1. Query the total population of all cities in CITY where Districtis California. SELECT SUM(POPULATION) FROM CITY WHERE DISTRICT = 'California' Q2. Query the average population of all cities in CITY where District is California. SELECT AVG(POPULATION) FROM CITY WHERE DISTRICT = 'California' Q3. Query the average population for..

Julia just finished conducting a coding contest, and she needs your help assembling the leaderboard! Write a query to print the respectivehacker_idandnameof hackers who achieved full scores formore than onechallenge. Order your output in descending order by the total number of challenges in which the hacker earned a full score. If more than one hacker received full scores in same number of chall..

You are given two tables: Students and Grades. Students contains three columns ID, Name and Marks. Grades contains the following data: Ketty gives Eve a task to generate a report containing three columns: Name, Grade and Mark. Ketty doesn't want the NAMES of those students who received a grade lower than 8. The report must be in descending order by grade -- i.e. higher grades are entered fir..

Given the CITY and COUNTRY tables, query the names of all the continents (COUNTRY.Continent) and their respective average city populations (CITY.Population) rounded down to the nearest integer. Note: CITY.CountryCode and COUNTRY.Code are matching key columns. Input Format The CITY and COUNTRY tables are described as follows: 풀이 SELECT O.CONTINENT, FLOOR(AVG(C.POPULATION)) FROM CITY AS C JOIN COU..

Given the CITY and COUNTRY tables, query the names of all cities where the CONTINENT is 'Africa'. Note: CITY.CountryCode and COUNTRY.Code are matching key columns. Input Format The CITY and COUNTRY tables are described as follows: 풀이 SELECT C.NAME FROM CITY AS C JOIN COUNTRY AS O ON C.COUNTRYCODE = O.CODE WHERE O.CONTINENT = 'Africa';

Given the CITY and COUNTRY tables, query the sum of the populations of all cities where the CONTINENT is 'Asia'. Note: CITY.CountryCode and COUNTRY.Code are matching key columns. Input Format The CITY and COUNTRY tables are described as follows: 풀이 SELECT SUM(C.POPULATION) FROM CITY AS C JOIN COUNTRY AS O ON C.COUNTRYCODE = O.CODE WHERE O.CONTINENT = 'Asia';