Select Data — LeetCode 2880 Python Solution
EasyPandas
- Problem
- #2880
- Reading time
- 2 min
- Source
- leetcode.com
Table schema
SQL
DataFrame students +-------------+--------+ | Column Name | Type | +-------------+--------+ | student_id | int | | name | object | | age | int | +-------------+--------+ Write a solution to select the name and age of the student with student_id = 101. The result format is in the following example.Example
SQL
DataFrame students
+-------------+--------+
| Column Name | Type |
+-------------+--------+
| student_id | int |
| name | object |
| age | int |
+-------------+--------+Python solution
Python
import pandas as pd
def selectData(students: pd.DataFrame) -> pd.DataFrame:
return students[students['student_id'] == 101][['name', 'age']]Complexity
| Measure | Complexity |
|---|---|
| Time | O(n) |
| Space | O(1) to O(n) auxiliary |
Related problems
Frequently asked questions
- How hard is LeetCode 2880. Select Data?
- LeetCode 2880. Select Data is rated Easy on LeetCode.
- What topics does LeetCode 2880. Select Data cover?
- LeetCode 2880. Select Data is tagged Pandas on LeetCode.