Change Data Type

Change Data Type - Problem

Database Easy

You are given a DataFrame called students with the following structure:

Column Name	Type
student_id	int
name	object
age	int
grade	float

The grade column is currently stored as floats, but it should be stored as integers. Write a solution to convert the grade column from float to int data type.

Return the modified DataFrame with the grade column converted to integers.

Input & Output

Example 1 — Basic Grade Conversion

$ Input: students = [{"student_id": 1, "name": "Alice", "age": 20, "grade": 85.0}, {"student_id": 2, "name": "Bob", "age": 21, "grade": 92.0}]

› Output: [{"student_id": 1, "name": "Alice", "age": 20, "grade": 85}, {"student_id": 2, "name": "Bob", "age": 21, "grade": 92}]

💡 Note: The grade column values 85.0 and 92.0 are converted to integers 85 and 92 respectively

Example 2 — Single Student

$ Input: students = [{"student_id": 1, "name": "Carol", "age": 19, "grade": 78.0}]

› Output: [{"student_id": 1, "name": "Carol", "age": 19, "grade": 78}]

💡 Note: Single row conversion: grade 78.0 becomes integer 78

Example 3 — Multiple Students

$ Input: students = [{"student_id": 1, "name": "Dave", "age": 22, "grade": 95.0}, {"student_id": 2, "name": "Eve", "age": 20, "grade": 88.0}, {"student_id": 3, "name": "Frank", "age": 21, "grade": 91.0}]

› Output: [{"student_id": 1, "name": "Dave", "age": 22, "grade": 95}, {"student_id": 2, "name": "Eve", "age": 20, "grade": 88}, {"student_id": 3, "name": "Frank", "age": 21, "grade": 91}]

💡 Note: All grades (95.0, 88.0, 91.0) are converted to their integer equivalents (95, 88, 91)

Constraints

1 ≤ students.length ≤ 10⁴
All grade values are valid floats
Grade values are in range [0.0, 100.0]

Visualization

Tap to expand

Asked in

N Netflix 25 M Microsoft 20

The key insight is to use pandas' built-in astype() method for efficient data type conversion. The optimal approach uses students['grade'].astype(int) to convert the entire column in one vectorized operation. Time: O(n), Space: O(1)

Common Approaches

Approach	Time	Space	Notes
✓ Manual Row-by-Row Conversion	O(n)	O(1)	Iterate through each row and manually convert grade values
Pandas astype() Method	O(n)	O(1)	Use pandas built-in astype() method for efficient column conversion

Manual Row-by-Row Conversion — Algorithm Steps

Step 1: Iterate through each row
Step 2: Convert each grade value to int
Step 3: Update the DataFrame

Visualization

Tap to expand

Step-by-Step Walkthrough

Original Data

DataFrame with float grades

Row Processing

Convert each grade individually

Result

All grades converted to integers

Code -

solution.c — C

#include <stdio.h>
#include <stdlib.h>
#include <string.h>

typedef struct {
    int student_id;
    char name[100];
    int age;
    int grade;
} Student;

Student* solution(Student* students, int size) {
    // Manual row-by-row conversion (already int in C)
    return students;
}

int main() {
    // Read JSON input and parse manually
    Student students[1000];
    int size = 0;
    
    Student* result = solution(students, size);
    // Output JSON format
    return 0;
}

Time & Space Complexity

Time Complexity

⏱️

O(n)

Must visit each of the n rows to convert grade values

✓ Linear Growth

Space Complexity

O(1)

Only modifies existing DataFrame in-place

✓ Linear Space

12.0K Views

Medium Frequency

~5 min Avg. Time

450 Likes

Ln 1, Col 1

Smart Actions

💡 Explanation

AI Ready

💡 Suggestion Tab to accept Esc to dismiss

// Output will appear here after running code

Code Editor Closed

Click the red button to reopen

Input & Output

Constraints

Visualization

Related Problems

Common Approaches

Manual Row-by-Row Conversion — Algorithm Steps

Visualization

Code -

Time & Space Complexity

Select Compiler