Data Handling using Pandas – 1 Case Study Questions for CBSE Class 12 Informatics Practices Chapter 2

Data Handling using Pandas – 1 Case Study Questions for CBSE Class 12 Informatics Practices Chapter 2

Here we are providing case study questions for class 12 informatics practices Chapter 2 Data Handling using Pandas – 1. Students are suggested to solve the questions by themselves first and then check the answers for reference.

Data Handling using Pandas – 1 Case Study

Case Study Question 1:

Related Posts

Chapter List

Chapter 1 Querying and SQL Functions Case Study
Chapter 2 Data Handling using Pandas – 1 Case Study
Chapter 3 Data Handling using Pandas – II Case Study
Chapter 4 Plotting Data using Matplotlib Case Study
Chapter 5 Internet and Web Case Study
Chapter 6 Societal Impacts Case Study
Chapter 7 Project Based Learning Case Study
Chapter 8 Extensible Markup Language Case Study
Chapter 9 IT Applications Case Study
Chapter 10 Web Application Development Case Study

You May Also Like

Informatics Practices Syllabus

Unit-1: Data Handling using Pandas-I

Introduction to Python libraries-Pandas, Matplotlib.
Data structures in Pandas – Series and Data Frames.

Series: Creation of Series from – ndarray, dictionary, scalar value; mathematical operations; Head and Tail functions; Selection, Indexing and Slicing.

Data Frames: creation – from dictionary of Series, list of dictionaries, Text/CSV files; display; iteration; Operations on rows and columns: add, select, delete, rename; Head and Tail functions; Indexing using Labels, Boolean Indexing;
Importing/Exporting Data between CSV files and Data Frames.

Data Visualization
Purpose of plotting; drawing and saving following types of plots using Matplotlib – line plot, bar graph, histogram

Customizing plots: adding label, title, and legend in plots.

Unit-2: Database Query using SQL

Math functions: POWER (), ROUND (), MOD ().

Text functions: UCASE ()/UPPER (), LCASE ()/LOWER (), MID ()/SUBSTRING ()/SUBSTR (), LENGTH (), LEFT (), RIGHT (), INSTR (), LTRIM (), RTRIM (), TRIM ().

Date Functions: NOW (), DATE (), MONTH (), MONTHNAME (), YEAR (), DAY (), DAYNAME ().

Aggregate Functions: MAX (), MIN (), AVG (), SUM (), COUNT (); using COUNT (*).
Querying and manipulating data using Group by, Having, Order by.
Working with two tables using equi-join

Unit-3: Introduction to Computer Networks

Introduction to networks, Types of network: LAN, MAN, WAN.
Network Devices: modem, hub, switch, repeater, router, gateway
Network Topologies: Star, Bus, Tree, Mesh.
Introduction to Internet, URL, WWW, and its applications- Web, email, Chat, VoIP.
Website: Introduction, difference between a website and webpage, static vs dynamic web page, web server and hosting of a website.
Web Browsers: Introduction, commonly used browsers, browser settings, add-ons and plug-ins, cookies.

Unit-4: Societal Impacts

Digital footprint, net and communication etiquettes, data protection, intellectual property rights (IPR), plagiarism, licensing and copyright, free and open source software (FOSS), cybercrime and cyber laws, hacking, phishing, cyber bullying, overview of Indian IT Act.
E-waste hazards and management.
Awareness about health concerns related to the usage of technology.

Download CBSE Books