All Downloads are FREE. Search and download functionalities are using the official Maven repository.

g2801_2900.s2880_select_data.readme.md Maven / Gradle / Ivy

There is a newer version: 1.30
Show newest version
2880\. Select Data

Easy

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 1: Input:** 

    +------------+---------+-----+ 
    | student_id | name    | age | 
    +------------+---------+-----+ 
    | 101        | Ulysses | 13  | 
    | 53         | William | 10  | 
    | 128        | Henry   | 6   | 
    | 3          | Henry   | 11  | 
    +------------+---------+-----+

**Output:** 

    +---------+-----+ 
    | name    | age | 
    +---------+-----+ 
    | Ulysses | 13  | 
    +---------+-----+

**Explanation:** Student Ulysses has student_id = 101, we select the name and age.




© 2015 - 2024 Weber Informatics LLC | Privacy Policy