EasyNo. 1294LeetCode Premium
Weather Type in Each Country — LeetCode 1294 Python Solution
- Topics
- Database
- Reading time
- 4 min
- Source
- leetcode.com
Table schema
Table: Countries +---------------+---------+ | Column Name | Type | +---------------+---------+ | country_id | int | | country_name | varchar | +---------------+---------+ country_id is the primary key (column with unique values) for this table. Each row of this table contains the ID and the name of one country.Example
+---------------+---------+
| Column Name | Type |
+---------------+---------+
| country_id | int |
| country_name | varchar |
+---------------+---------+
country_id is the primary key (column with unique values) for this table.
Each row of this table contains the ID and the name of one country.Python solution
import duckdb
import pandas as pd
def solution(countries: pd.DataFrame, weather: pd.DataFrame) -> pd.DataFrame:
con = duckdb.connect()
con.register("Countries", countries)
con.register("Weather", weather)
return con.execute("""SELECT
country_name,
CASE
WHEN AVG(weather_state) <= 15 THEN 'Cold'
WHEN AVG(weather_state) >= 25 THEN 'Hot'
ELSE 'Warm'
END AS weather_type
FROM
Weather AS w
JOIN Countries USING (country_id)
WHERE DATE_FORMAT(day, '%Y-%m') = '2019-11'
GROUP BY 1;""").df()Complexity
- Time
- O(n log n)(typical)
- Space · auxiliary
- O(n)
Related problems
| No. | Problem | Difficulty |
|---|---|---|
| 0175 | Combine Two Tables | Easy |
| 0176 | Second Highest Salary | Medium |
| 0177 | Nth Highest Salary | Medium |
| 0178 | Rank Scores | Medium |
| 0180 | Consecutive Numbers | Medium |
| 0181 | Employees Earning More Than Their Managers | Easy |
Frequently asked questions
- How hard is LeetCode 1294. Weather Type in Each Country?
LeetCode 1294. Weather Type in Each Country is rated Easy on LeetCode.
- What topics does LeetCode 1294. Weather Type in Each Country cover?
LeetCode 1294. Weather Type in Each Country is tagged Database on LeetCode.
- Is LeetCode 1294. Weather Type in Each Country a premium problem?
Yes. LeetCode 1294. Weather Type in Each Country is a LeetCode Premium problem, so the full statement and test cases require a paid LeetCode subscription.