Ashish Joshi, PGT Comp. Sc., KV Baran (KVS RO – Jaipur) [ashishjoshi88@gmail.com]

CLASS: XII IP

(As per Latest CBSE 2020-21 Syllabus)

 

1. Introduction to python pandas, Creation of Series Data Structure, Numpy Array Vs Series 2. Pandas Series Data Structure Operation in Series (Access, Modify, Addition, Deletion, Slicing, Head(), Tail(), Vector/ Arithmetic operation)
3. Data Frame Creation from List of Dictionaries , Dictionary of Series in in Python Pandas 4. Accessing Columns in Data Frame Python Pandas
5. Accessing values and columns on DataFrame in Python Pandas. 6. Accessing particular columns, inserting new column, new row.loc() function Python Pandas DataFrame
7. iloc() and insert() function in Dataframe Python Pandas 8. rename() function in DataFrame Python Pandas
9. rename() and reindex() function in DataFrame Python Pandas 10. Descriptive statistics functions max(), min(), mean(), median(), mode() in DataFrame Python Pandas…
11. Descriptive statistics functions count(), sum(), var(), std() in DataFrame Python Pandas. 12. Descriptive statistics functions quantile(), quartile function in Dataframe Python Pandas
13. Sorting in DataFrame Python Pandas-XII IP CBSE using sort_values and sort_index function 14. pivot, pivot table function in Dataframe Python Pandas (with PRACTICE QUESTIONS )
15. Groupby Function in Dataframe – Python Pandas XII IP CBSE with Practice Questions 16. Pandas DataFrame to/ from mysql table database- Importing/ Exporting using read_sql,to_sql function
17. Data Visualization using matplotlib pyplot module of python,  Line plot, Bar Graph 18. Boxplot using matplotlib in python
19. Histogram in python using matplotlib 20. Frequency Polygon from Histogram in python using matplotlib
21. Pie chart , subplot concept in python using matplotlib 22. Scatter Chart in python using matplotlib
23. SQL Function :- Single row function / Scalar Function , Aggregate Functions / Multiple Row Function/ Group Functions SQL Math Functions

CLASS: XII IP

CBSE BOARD BASED QUESTIONS PRACTICE

1. 10 CBSE Question Practice on Dataframe Python Pandas (loc , ilic, rename , reindex, output based) 2. 05-CBSE Practice Questions on Statistic function in Dataframe Python Pandas…
3. CBSE PRACTISE QUESTIONS ON pivot, pivot table function in Dataframe Python Pandas 4. CBSE PRACTISE QUESTIONS ON groupby Function in Dataframe- Python Pandas
5. 38 – CBSE QUESTIONS PRACTICE ON DATA VISUALIZATION | CBSE XII IP | CBSE XII CS | DATA VISUALIZATION

CLASS: XI IP

(As per Latest CBSE 2020-21 Syllabus)

1. Introduction of Python-CBSE Class XI IP/CS Students ( Part-1) 2. Introduction of Python-CBSE XI IP/CS Students(Part 2)