문제
Table: Cinema
+----------------+----------+
| Column Name | Type |
+----------------+----------+
| id | int |
| movie | varchar |
| description | varchar |
| rating | float |
+----------------+----------+
id is the primary key (column with unique values) for this table.
Each row contains information about the name of a movie, its genre, and its rating.
rating is a 2 decimal places float in the range [0, 10]
Write a solution to report the movies with an odd-numbered ID and a description that is not "boring".
Return the result table ordered by rating in descending order.
https://leetcode.com/problems/not-boring-movies/description/?lang=pythondata
예시
Input:
Cinema table:
+----+------------+-------------+--------+
| id | movie | description | rating |
+----+------------+-------------+--------+
| 1 | War | great 3D | 8.9 |
| 2 | Science | fiction | 8.5 |
| 3 | irish | boring | 6.2 |
| 4 | Ice song | Fantacy | 8.6 |
| 5 | House card | Interesting | 9.1 |
+----+------------+-------------+--------+
Output:
+----+------------+-------------+--------+
| id | movie | description | rating |
+----+------------+-------------+--------+
| 5 | House card | Interesting | 9.1 |
| 1 | War | great 3D | 8.9 |
+----+------------+-------------+--------+
Explanation:
We have three movies with odd-numbered IDs: 1, 3, and 5. The movie with ID = 3 is boring so we do not include it in the answer.
문제 풀이
import pandas as pd
def not_boring_movies(cinema: pd.DataFrame) -> pd.DataFrame:
filtered = cinema.loc[(cinema['id']%2==1) & (cinema['description']!='boring')]
result = filtered.sort_values(by='rating', ascending=False)
return resultimport pandas as pd
def not_boring_movies(cinema: pd.DataFrame) -> pd.DataFrame:
filtered = cinema.loc[(cinema['id']%2==1) & (~cinema['description'].str.contains('boring',case=False))]
result = filtered.sort_values(by='rating', ascending=False)
return resultDataFrame.str.contains(pat, case=True, na=None, regex=True)
pat = 포함 여부를 확인할 문자열/패턴
case = 대소문자 구분 여부
na = 결측치를 처리하는 방법
regex = 패턴이 정규 표현식인지 여부 설정
파이썬을 독학하시는 분들에게 도움이 되길 바라며,
혹 더 좋은 방법이 있거나 오류가 있다면 편하게 말씀 부탁드립니다.
