Sponsored
Sponsored
Explanation: Iterator Filtering
This approach involves iterating through each record (or row) in the DataFrame and checking the 'student_id' against the specified value (101). Once a match is found, we can extract the 'name' and 'age' and return it as the result.
Time Complexity: O(n), where n is the number of students. We may have to check each student in the worst case.
Space Complexity: O(1), as no additional space beyond input storage is used.
using System.Collections.Generic;
public class Student {
public int student_id;
public string name;
public int age;
public Student(int student_id, string name, int age) {
this.student_id = student_id;
this.name = name;
this.age = age;
}
}
public class SelectData {
public static void Main() {
List<Student> students = new List<Student> {
new Student(101, "Ulysses", 13),
new Student(53, "William", 10),
new Student(128, "Henry", 6),
new Student(3, "Henry", 11)
};
foreach (var student in students) {
if (student.student_id == 101) {
Console.WriteLine("+---------+-----+");
Console.WriteLine("| {0,7} | {1,3} |", student.name, student.age);
Console.WriteLine("+---------+-----+");
break;
}
}
}
}This approach leverages a List to hold student objects in C#. Using a simple foreach loop, it searches for the student with ID 101 and prints their 'name' and 'age' using formatted strings.
Explanation: Lookup with Map/Dictionary
This approach involves using a hash table, such as a Dictionary in Python or HashMap in Java, to store each student record with their student_id as the key. This enables direct access to a record based on student_id with average O(1) complexity, extracting 'name' and 'age' immediately.
Time Complexity: O(1), as hash table operations (get) average constant time.
Space Complexity: O(n), space usage increases with input size.
1const studentMap = {
2 101: { name: 'Ulysses', age: 13 },
3 53: { name: 'William', age: 10 },
4 128: { name: 'Henry', age: 6 },
5 3: { name: 'Henry', age: 11 }
6};
7
8const student = studentMap[101];
9if (student) {
10 console.log('+---------+-----+');
11 console.log(`| ${student.name} | ${student.age} |`);
12 console.log('+---------+-----+');
13}JavaScript objects provide a way to define a mapping of student_id to student information. Directly accessing the property of the object with studentMap[101] retrieves the student efficiently.