IP Class 12 Full Course In One Video | One Shot Video IP Class 12 | Information Practices Tutorial
#techtipnow #iptutorial #ipclass12course
One Shot Video IP Class 12, CBSE Class 12 Information Practice Tutorial, IP Tutorial class 12
Timestamp
00:58 Course Outline
02:48 Python Panda-I
03:14 What is Python Panda
09:24 Difference between Python Series and dataframe
12:25 Python Series Definition and Properties
16:00 Creating Python Series (using list, np array etc)
25:00 Defining Series using Dictionary
28:30 Series Using Scalar value
32:30 Data and Index Argument in Series (Explicit Indexing of Python Series)
35:00 Creating Python Series with Missing Values
36:00 Python Series Mathematical Operations
39:00 Python Series Attributes (index, values, size, hasnans, empty, nbyte, dtype etc)
43:50 len and count method in pythn Series object
46:30 Python Series Slicing
49:17 head and tail method in Python Series
50:52 Sorting of Python Series (sort_values, sort_index)
53:19 Python Series Operations
54:01 Python Series Filter
56:49 Python DataFrame Definition and Properties
01:01:59 Creating Python Dataframe
01:03:58 Creating Dataframe using 2D Dictionary
01:11:5 Creating Dataframe using nested list or 2d list
01:14:49 Creating dataframe using list of dictionaries
01:15:30 Dataframe attributes (index, column, axes, dtype, size, shape, T etc.)
01:19:08 len and count method in dataframe
01:21:30 Selecting and Accessing python dataframe values
01:24:14 Subset of dataframe using index labels
01:25:04 loc in dataframe
01:28:00 iloc in dataframe
01:31:38 at and iat method in dataframe (selecting individual values)
01:33:22 boolean indexing dataframe
01:36:50 Modifying Dataframe values
01:39:52 deleting dataframe values (deleting column and row values)
01:41:20 drop in dataframe
01:43:28 importing and exporting between csv files and dataframe
01:43:50 what is csv files
01:47:29 read_csv() importing data from csv to dataframe
01:52:38 importing csv without header in dataframe (header argument)
01:53:30 skiprows in read_csv
01:59:31 to_csv exporting dataframe to csv file
02:05:54 na_rep in to_csv
02:07:00 Data Visualization Plotting with PyPlot Introduction
02:10:50 Chart and Its Component
02:12:40 Types of chart line chart, bar chart, pie chart, histogram
02:19:00 pyplot module and matplotlib library
02:21:37 creating charts in python, xlabel, ylabel, plot size, figure
02:30:40 changing color and width of data series in chart
02:31:00 Python Chart Practical
02:34:40 legend in chart
02:38:36 creating histogram using pyplot
02:45:50 MySql revision Tour
02:56:06 RDBMS Terminologies
02:58:25 Referential Integrity
03:00:00 MySQL and SQL
03:04:00 DDL and DML
03:07:00 Create database, create table, data type,
03:16:25 MySQL Constraints, Primary key, Foreign Key, Not Null, Default, Unique Key
03:22:56 Select Command, Where Clause, Like, In, Between and, Not Null
03:34:30 Alter Table, delete table, update table
03:49:15 MySQL Functions
04:08:35 Querying using SQL
=========================================
Useful Links to Learn More
========================================
Information Practice Class 12 Sumita Arora Textbook Solution
• Sumita Arora Solutions IP Class 12
Information Practice IP Class 11 NCERT Textbook Solution CBSE 2020-21
• NCERT Solutions IP Class 11
For New and Latest Videos Check This
/ @techtipnow
Data Structure and algorithm
• Data Structure And Algorithm
Algorithm Example
• Algorithm Examples
Design and Analysis of Algorithm DAA
• Design And Analysis of Algorithm (DAA)
Data structure using C
• Data structure Using C
Programming In C
• C Programming Language
Python Programming
• Python Programming
Python Examples
• Python Program Examples
========================================
Support Me By (It’s Free)
========================================
Comment – If you have any query
Like – If this video is helpful
Share – if anyone wants to learn
Subscribe – Help & Motivate Me to Do Well
========================================
Get In Touch
========================================
My Youtube Channel - / techtipnow
========================================
Thanks For Watching and Appreciation…..