Saturday, August 2, 2025

11th & 12th UT-1, UT-2 Question Papers & JEE NEET Papers

11th & 12th UT-1, UT-2 Question Papers     Download

_____________________________________________________

JEE NEET Papers           Download

Monday, February 3, 2025

Monday, December 16, 2024

Projects Printouts

  1. Click below link
  2. Find your file (check your name file only)
  3. Download it
  4. Check alignment for your downloaded file 
  5. Print it

IP Record with Dates

Informatics Practices(065) Index with dates
S.No Content Date
1 Create a pandas series from a dictionary of values and ndarray 19/06/2026
2 Given a series, print all the elements that are above the 75th percentile 26/06/2026
3 Create a Data Frame quarterly sales 10/07/2026
4 Create a Data Frame based on ecommerce data and generate descriptive statistics 17/07/2026
5 Create a Data Frame for examination result & display attributes 03/08/2026
6 Filter out rows based on different criteria such as duplicate rows 20/08/2026
7 Find the sum of each column, or find the column with the lowest mean 29/08/2026
8 Locate the 3 largest values in a Data Frame 11/09/2026
9 Substract the mean of a row from each element of row in a Data Frame 18/09/2026
10 Replace all negaive values in a Data Frame with a 0 25/09/2026
11 Replace all missing values in a Data Frame with a 999 09/10/2026
12 Importing and exporting data between pandas and csv file 23/10/2026
13 Importing and exporting data between pandas and MySQL database 27/10/2026
14 Given the school result data, analyse the performance of students on parameters 30/10/2026
15 For the Data Frame, analyze and plot appropriate charts with title and legend 03/11/2026
16 Take data of your interest from an open source, aggregate,summarize it and plot 21/11/2026
17 Create a student table with student_id,name and marks as columns, set primary key 24/11/2026
18 Insert the details of a new student in the table 28/11/2026
19 Delete the details of a particular student in the table 04/12/2026
20 Use the select command to get the details of the students with marks>80 18/12/2026
21 Find the min,max,sum & avg of marks in student table 18/12/2026
22 Find the total no of customers from each country in the table using group by 22/12/2026
23 Write a SQL query to order the table in descending order of the marks 28/12/2026

 

Thursday, November 14, 2024

Unit-1 Data handling using pandas

Unit 1: Data Handling using Pandas -I

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

 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. 

 Click to download Notes Part-1:  Data Handling using Pandas -I

 Click to download Notes Part-1.2  CSV  Boolean Indexing

Click to download Notes Part -2 : Notes DataFrames

Click to download Notes Data Visualization-II

Monday, September 23, 2024

IP Project Work Report and Project

Instructions to do project:

Step-1:  Refer any project websites ( For example: github.com,.......etc)

Step-2:  Choose any one project and download it

Step-3:  Open Downloads Folder and Extract the downloaded project (zip)

Step-4:  Execute the project using python software (IDLE- choose latest python 3.12)

Step-5:  After execution submit your project title in the given link

Step-6: Download the project work report format file in the given link and edit it as per your needs.


Refer Link - 1:  Project Title Submission link           Click Here

Refer Link - 2: Project Work Report Format     Download

To submit your project code and report       Click Here

Note: To see your usernames and password Refer Link-1