Pandas

Handle structured data efficiently using Pandas for data cleaning, transformation, analysis, and visualization.

40 Problems Available
Add New Column
Beginner

Add a new column 'passing' that is True if score >= 80.

50 points Solve
Add New Employee
Beginner

Add a new employee to the DataFrame.

50 points Solve
Apply Simple Function
Beginner

Create a new column with score percentages (score/100).

50 points Solve
Basic Pivot Table
Beginner

Create a pivot table showing total revenue by product and month.

60 points Solve
Calculate Mean Score
Beginner

Calculate and print the average score of all students.

30 points Solve
Calculate Total Inventory Value
Beginner

Calculate total value (price * stock) for each product.

50 points Solve
Calculate Total Salary
Beginner

Calculate the total salary of all employees.

30 points Solve
Count Non-Null Values
Beginner

Count non-null values in each column of the products DataFrame.

20 points Solve
Count Products by Category
Beginner

Count how many products are in each category.

40 points Solve
Count Students by Grade
Beginner

Count how many students have each grade.

40 points Solve
Delete Row by Index
Beginner

Remove the employee at index 3 from the DataFrame.

40 points Solve
Display Column Names
Beginner

Print the column names of the employees DataFrame.

20 points Solve
Display First 3 Rows
Beginner

Show the first 3 rows of the students DataFrame.

20 points Solve
Display Last 2 Rows
Beginner

Show the last 2 rows of the products DataFrame.

20 points Solve
Drop Column
Beginner

Drop the 'age' column from the DataFrame.

40 points Solve
Filter and Select Columns
Beginner

Show names of IT department employees.

40 points Solve
Filter Rows by Condition
Beginner

Show students with score greater than 85.

40 points Solve
Filter with Multiple Conditions
Beginner

Show students who are 18 years old AND have grade 'A'.

50 points Solve
Find Average Price
Beginner

Calculate the average price of all products.

30 points Solve
Find Maximum Age
Beginner

Find and print the maximum age in the students DataFrame.

30 points Solve
Find Minimum Stock
Beginner

Find the product with the lowest stock quantity.

40 points Solve
Get DataFrame Shape
Beginner

Print the shape (rows, columns) of the students DataFrame.

20 points Solve
Group by and Mean
Beginner

Calculate average score by grade.

50 points Solve
Handle Missing Data
Beginner

Fill missing values in a DataFrame with 0.

50 points Solve
Load CSV File
Beginner

Load the students.csv file into a pandas DataFrame.

20 points Solve
Rename Columns
Beginner

Rename the 'grade' column to 'letter_grade'.

40 points Solve
Rename Index
Beginner

Change the DataFrame index to employee IDs.

40 points Solve
Select Cell by Row/Column
Beginner

Select the salary of employee at index 1 (second row).

30 points Solve
Select Columns by Position
Beginner

Select first 2 columns of the employees DataFrame.

30 points Solve
Select Multiple Columns
Beginner

Select and display just the 'name' and 'grade' columns.

30 points Solve
Select Row by Index
Beginner

Select and display the row at index 2 from the employees DataFrame.

30 points Solve
Select Rows by Position
Beginner

Select first 3 rows of the products DataFrame.

30 points Solve
Select Single Column
Beginner

Select and display just the 'name' column from the students DataFrame.

30 points Solve
Select Specific Rows and Columns
Beginner

Select name and price for first 2 products.

40 points Solve
Show Data Types
Beginner

Display the data types of each column in the products DataFrame.

20 points Solve
Show DataFrame Info
Beginner

Display the info() of the employees DataFrame.

20 points Solve
Sort by Column
Beginner

Sort the students DataFrame by age in ascending order.

40 points Solve
Sort Descending
Beginner

Sort the students DataFrame by score in descending order.

40 points Solve
Update Employee Salary
Beginner

Increase John's salary by 10%.

50 points Solve
Use isin() Method
Beginner

Show students whose names are either Alice or Bob.

50 points Solve