728x90
world 테이블
+-------------+-----------+---------+------------+--------------+
| name | continent | area | population | gdp |
+-------------+-----------+---------+------------+--------------+
| Afghanistan | Asia | 652230 | 25500100 | 20343000000 |
| Albania | Europe | 28748 | 2831741 | 12960000000 |
| Algeria | Africa | 2381741 | 37100000 | 188681000000 |
| Andorra | Europe | 468 | 78115 | 3712000000 |
| Angola | Africa | 1246700 | 20609294 | 100990000000 |
+-------------+-----------+---------+------------+--------------+
Q. area가 3000000이상이거 population이 25000000 이상인 name, population, area를 출력하시오
+-------------+------------+---------+
| name | population | area |
+-------------+------------+---------+
| Afghanistan | 25500100 | 652230 |
| Algeria | 37100000 | 2381741 |
+-------------+------------+---------+
A.
result_df = world[(world['area']>=3000000) | (world['population']>=25000000)]
return result_df[[ 'name','population','area']]
728x90
'• data analysis > PYTHON' 카테고리의 다른 글
[leetcode] 182. Duplicate Emails (0) | 2024.02.16 |
---|---|
* 조건에 부합하는 중고거래 댓글 조회하기 (1) | 2023.12.28 |
재구매가 일어난 상품과 회원 리스트 구하기 (0) | 2023.12.28 |
1757. Recyclable and Low Fat Products (1) | 2023.12.28 |
183. Customers Who Never Order (0) | 2023.12.28 |