Given the school result data, analyses the performance of the students on different parameters, e.g subject wise or class wise

 

Replace all missing values in a DataFrame with a 999.

 

12IP-pract-10

 

Generate the following patterns using nested loop

 

Filter out rows based on different criteria such as duplicate rows

 

 

Create a data frame for examination result and display row labels, column labels data types of each column and the dimensions.

 

import pandas as pd

result_data= {

    'Eng':[90,85,72,69,86],

    'Phy':[85,82,73,56,96],

    'Chem':[88,65,70,36,35],

    'Maths':[90,56,45,36,42],

    'Comp Sci':[85,85,65,23,66],

    'Marks':[406,450,390,480,450],

    'Percentage':[96.5,85.2,48,79,68]

    }

result_df=pd.DataFrame(result_data,

        index=["Amit","Soham","Mohan","Neha","Sachin"])

print(result_df)

print(result_df.index)

print(result_df.column)

print(result_df.dtypes)

print(result_df.ndim)

print(result_df.size)

print(result_df.shape)

print(result_df.T)

12th IP

 

Create a Data Frame quarterly sales where each row contains the item category, item name, and expenditure. Group the rows by the category and print the total expenditure per category.

 

Program

Output

12th IP Practical list 2024-25

 

Data Handling​

1. Create a panda’s series from a dictionary of values and a ndarray: Click here (Reference video: Click Here)

 

2. Given a Series, print all the elements that are above the 75th percentile. Click here (Reference video Click Here)

 

3. Create a Data Frame quarterly sales where each row contains the item category, item name, and expenditure. Group the rows by the category and print the total expenditure per category.Click here  (Reference video: Click Here )

 

4. Create a data frame for examination result and display row labels, column labels data types of each column and the dimensions. Click Here

 

5. Filter out rows based on different criteria such as duplicate rows. click Here (Reference video: Click Here)

 

6. Importing and exporting data between pandas and CSV file.Click Here

7. Find the sum of each column with Lowest mean Click here (Reference Video: click here)

8. Locate the 3 largest values in a dataframe click Here (Reference video: click here)

9. Subtract the mean of row from each element of the row in a DataFrame: Click here (Reference video: click here)

10. Replace all negative values in a DataFrame with a 0. click here (Reference video: click here)

11. Replace all missing values in a DataFrame with a 999. Click Here  (Reference video:  click here)

______________________________________________

5.2 Visualization

1. Given the school result data, analyses the performance of the students on different parameters, e.g subject wise or class wise. Click Here

2. For the Data frames created above, analyze, and plot appropriate charts with title and legend.

3. Take data of your interest from an open source (e.g. data.gov.in), aggregate and summarize it. Then plot it using different plotting functions of the Matplotlib library. Click Here

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

5.3 Data Management

\c;

create database urname;

use urname;

1. Create a student table with the student id, name, and marks as attributes where the student id is the primary key.

2. Insert the details of a new student in the above table.

3. Delete the details of a student in the above table.

4. Use the select command to get the details of the students with marks more than 80.

5. Find the min, max, sum, and average of the marks in a student marks table.

6. Create a customer table with the customer ID, customer Name and country as attributes.

7. Insert the details of a new customer in the above table.

8. Find the total number of customers from each country in the table (customer ID, customer Name, country) using group by.

9. Write a SQL query to order the (student ID, marks) table in descending order of the marks.

​

12th CS Python Program list 2024-25

   As per CBSE Practical List 2024-25

Suggested Practical List:

Python Programming
● Read a text file line by line and display each word separated by a #.
● Read a text file and display the number of vowels/consonants/uppercase/lowercase characters in the file.

● Remove all the lines that contain the character 'a' in a file and write it to another file.

● Create a binary file with name and roll number. Search for a given roll number and display the name, if not found display appropriate message.

● Create a binary file with roll number, name and marks. Input a roll number and update the marks.

● Write a random number generator that generatesrandom numbers between 1 and 6 (simulatesa dice).

● Write a Python program to implement a stack using list.

● Create a CSV file by entering user-id and password, read and search the password for given user-id.

Database Management

● Create a student table and insert data. Implement the following SQL commands on the student table:

o ALTER table to add new attributes / modify data type / drop attribute

o UPDATE table to modify data

o ORDER By to display data in ascending / descending order

o DELETE to remove tuple(s)

o GROUP BY and find the min, max, sum, count and average

● Similar exercise may be framed for other cases.

● Integrate SQL with Python by importing suitable module.

1. file line by line and display each word separated by a #.                             click here  

2. Read a text file and display the number of                                                                   vowels/consonants/uppercase/lowercase characters in the file.                                           Click here

3. Remove all the lines that contain the character 'a' in a file and write it to another file. Click here 

4. Create a binary file with name and roll number. Search for a given roll number and display the name, if not found display appropriate message.                                                    Click here  

5. Create a binary file with roll number, name and marks. Input a roll number and update the marks. Click here 

 6. Write a random number generator that generates random numbers between 1 and 6 (simulates a dice). Click here 

7. Write a Python program with function to count the number of lines in a text file ‘ 'STORY.TXT’ which is starting with an alphabet ‘A’ or 'a'.                                                                     Click here  

8. Write a Python program with method/function DISPLAYWORDS() to read lines from a text file STORY.TXT, and display those words, which are less than 4 characters.   Click Here 

9. Text Files Menu Driven Program: Click Here  

Choice = 1. Read a text file line by line and display each word             

 separated by a '#'. 
 Choice = 2.Python program with function to count the number of lines 
  in a text file ‘ 'STORY.TXT’ which is starting with an alphabet ‘A’ or 'a'.
  Choice= 3. Python program with method/function DISPLAYWORDS() 
  to read lines from a text file STORY.TXT, and display those words, 
   which are less than 4 characters.
10. Text Files Menu Driven Program: Click Here  date:  Choice= 1. Remove all the lines that contain the character `a’ in a file and write it to another file. 
Choice= 2. Read a text file and display the number of vowels/                        consonants/ uppercase/ lowercase characters in the file.                                  


11. Create a CSV file by entering user-id and Password, read and search the password for given user-id.  Click here date: 


12. Write a program to input the value of x and n and print the sum of the
series: x + x^2/2! - x^3/3! + x^4/4! + ............ x^n/n! click here   Date: 


13. Determine whether a number is a perfect number, an armstrong number or a  palindrome.  Click here  Date: 
14. Input a number and check if the number is a prime or composite number.               click here   Date: 
15. Display the terms of a Fibonacci series.  click here  Date: 
Data Structure
01 Stack Program 1 Write a python program to implement a stack using a list data-structure. Click Here (Reference Video: Click Here)   
02. Stack Program 2 Write a menu based python program to implement the the operations insert, delete, peek and display on stack(Member number, Member Name and Age).Click Here 

03. Stack based program 3 Write a Python Program to implement a Stack for the book details (bookno,bookname). That is, each item node of the stack contains two types of information- a book number and its name. Implement all the operations of Stack.Click Here

MySQL/SQL programmes

04. SQL Queries:-1 – Minimum 5 sets using one table / two tables. Click Here 

05. SQL Queries:-2 – Minimum 5 sets using one table / two tables. Click Here  

06. SQL Queries:-3- Create the following student table and answer the following queries. Click Here

Connectivity Programmes (Mysql with Python)

07. Find the total number of customers from each country in the table (customer ID, customer name, country) using group by( python interface through MYSQL). Click Here

08. INSERT, UPDATE, AND DELETE (PYTHON INTERFACE THROUGH MYSQL)ppt slides(RKS):ClickHer​e and Reference: INSERT, UPDATE, AND DELETE (PYTHON INTERFACE THROUGH  MYSQL)video: Click Here

09.fetchall(), fetchone(), fetchmany() and rowcount( python interface through MYSQL) ppt slides (RKS): Click Here

Reference: fetchall(), fetchone(), fetchmany() and rowcount( python interface through MYSQL video: Click Here

10. Find the min, max, sum, and average of the marks in a student marks table( python interface through MYSQL). Click here  







Project

Websites link(subject)

1.Pythontrends

https://pythontrends.wordpress.com/

​

2.pythonmykvs

http://python.mykvs.in/index.php