This is an amazing course from A to Z which will be taking you from scratch level to advance one by one with a code implementation.This course covers from Python IDLE basic codes to Google colab code.

It includes all basic as well as advance concepts like variable creation,simple and multiple numerical operations,conditional statements,loops,data visualization,pandas data structure,Data science, Sql Connectivity and Face Recognization.

At the end of this course students will be getting a course work with many mini projects in the last lecture.

This is a one stop course on Python which provides a perfect package covering all possible things in python

Course Work-

Lecture 1

1. Introduction to python

2. Opening IDLE

3. Writing first code on IDLE

4. Accessing function

5. Simple and complex numerical's

6. Control Statements

7. Saving and execution of code

8.Basics of Python programming

9.Python interpreter - interactive and script mode

10. The structure of a program, indentation, identifiers, keywords, constants, variables, types of operators, precedence of operators, data types, statements, expressions, evaluation of expressions, comments, input and output statements, data type conversion, debugging,

Recapitalization and implementation of codes on  Google Colab

1. Introduction to google colab

2. Installing and opening google colab

3. Writing first code

4. Accessing function

5. Simple and complex numerical's

6. Control Statements

7. Saving and execution of code on google colab

Lecture 2-

1. Implementation of conditional statements using 2 or more variables.

2. Implementation of for loop,while loop using different possibilities

3.Printing series

Lecture 3-

1.Implementation of list .

2.Functions on List

3.Execution of List

List operations - creating, initializing, traversing and manipulating lists, list methods and built-in functions.: len(), list(), append(), extend(), insert(), count(), find(), remove(), pop(), reverse(), sort(), sorted(), min(), max(), sum()

Lecture 4-

Introduction to Python libraries- Pandas, Matplotlib. ● Data structures in Pandas - Series and data frames.Series: Creation of series from dictionary, scalar value; mathematical operations; series attributes, head and tail functions; selection, indexing and slicing.

Lecture 5-

Data Frames: Creation of data frames from dictionary of series, list of dictionaries, text/CSV files, display, iteration. Operations on rows and columns: add ( insert /append) , select, delete (drop column and row), rename, Head and Tail functions, indexing using labels, Boolean indexing.

Lecture 6-

Data Visualization : Purpose of plotting, drawing and saving of plots using Matplotlib (line plot, bar graph, histogram). Customizing plots:; adding label, title, and legend in plots.

Lecture 7-

-Accessing ,uploading and reading csv files through python.

-Structured Query Language: Data Definition Language, Data Query Language and Data Manipulation Language, Introduction to MySQL: Creating a database, using database, showing tables using MySQL, Data Types : char, varchar, int, float, date.

-Data Definition Commands: CREATE, DROP, Data Query ,INSERT, UPDATE and  DELETE.

-Creation and doping of Databases

-Connecting my sql to Python - Install sql connector,pip commands on google colab.

-Face Recognization project at the end