Scribd
Upload
22 views2 pages

Pandas DataFrame Checklist Student Worksheet

This document is a checklist and worksheet for Class 12 Informatics Practices focused on Data Handling using Pandas DataFrames. It includes a learning checklist of key concepts and skills related to DataFrames, as well as practice questions to reinforce understanding. The worksheet covers creating, modifying, and analyzing DataFrames, along with coding exercises and matching functions to their uses.

Uploaded by

Ekta Verma
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
22 views2 pages

Pandas DataFrame Checklist Student Worksheet

This document is a checklist and worksheet for Class 12 Informatics Practices focused on Data Handling using Pandas DataFrames. It includes a learning checklist of key concepts and skills related to DataFrames, as well as practice questions to reinforce understanding. The worksheet covers creating, modifying, and analyzing DataFrames, along with coding exercises and matching functions to their uses.

Uploaded by

Ekta Verma
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

Pandas DataFrame – Student Learning

Checklist & Worksheet


Subject: Informatics Practices – Class 12 (CBSE 2025–26)

Unit: Data Handling Using Pandas – DataFrame

📝 Part A: Learning Checklist


S. No. Concept / Skill Completed (✓)
1 Understand what a
DataFrame is
2 Difference between Series
and DataFrame
3 Create DataFrame using
dictionary of lists
4 Create DataFrame using list
of dictionaries
5 Create DataFrame from
Series
6 Create empty DataFrame
7 Create DataFrame using
scalar value
8 Assign column names and
index to DataFrame
9 Access data using column
name (df['col'])
10 Access rows using .loc[] and
.iloc[]
11 Use head(), tail() functions
12 Use attributes like shape,
size, columns, index, dtypes
13 Add a new column
14 Modify values in DataFrame
15 Delete a column using del,
pop(), drop()
16 Perform arithmetic
operations on columns
17 Filter data using Boolean
indexing
18 Sort data using
sort_values() and
sort_index()
19 Use functions like sum(),
mean(), describe()
20 Import/export DataFrame
using CSV files

📄 Part B: Worksheet – Practice Questions


1. Q1. Fill in the blanks:

1. A DataFrame is a __________ dimensional labeled data structure.

2. The function used to create a DataFrame is __________.

3. The default column names in a DataFrame are derived from __________.

2. Q2. Write code to:

1. Create a DataFrame for students with Name and Marks.

2. Add a column “Grade” with values of your choice.

3. Display only names of students who scored more than 80.

3. Q3. Answer the following:

1. Differentiate between `.loc[]` and `.iloc[]` with an example.

2. What will be the output of the following code?

import pandas as pd
data = {'Name': ['Ravi', 'Meena', 'Amit'], 'Marks': [87, 93, 76]}
df = pd.DataFrame(data)
print(df.loc[1, 'Marks'])

4. Q4. Match the following:

Function / Attribute Use


.head() A. Structure of DataFrame
.shape B. First few rows
.drop() C. Remove rows/columns
.describe() D. Summary statistics
5. Q5. Write code to:

- Create a DataFrame with product name and price.

- Filter and display products costing less than ₹1000.

- Add a column "Discount" with flat ₹100 off.

You might also like