Python Coding Basics Course Webinar

Primitive types; Characters & Strings; Boolean; Working with variables and its scope; Conversion and casting types in Python.

Introduction of operators; Arithmetic operators; Relational operators; Assignment operator; Logical operators; Increment and decrement operators; More in operators.

If statement; If - else statement; If- elif - else statement; Nested if - else;

The while, while-else;
For loop;
Jump statements: break, continue;
Nesting loops.

Lists.
Tuples.
Sets.
Dictionary. Nested Dictionary.
Json Files.

Using Built-in modules and functions:
Strings functions.
Pattern matching with Regex.
Maths functions.
Random Functions.
Working with dates using Python date functions.

Creating and using custom Functions.
Creating a Module in class;
Calling a Module;
Using parameters;
Returning value from a Module.

Creating a Class; Creating an Object; Using an Object; Adding Instance variables; Controlling accessibility; Naming conventions for class members. Inner Classes.
Class Constructors; Parameterized Constructors.
Inheritance. Overload.

Fundamentals of exception handling; Exception types; Using try and Except.

Open, Traverse, Read and Create Files: Csv, txt and Json Files.

Connecting to API’s.

Connect to a database using access codes.

Retrieving records and iterating results sets, using variables and parameters in queries.

Create a database, drop a database.
Create a table, alter tables, drop a table.

Insert, delete, update records, query a database and display results.

Dict to Dataframe, Dataframe to Dict.
Excel To Dict, Dict to Excel , working with Excel data, multiple Excel sheets.

Slicing Dataframes,
Getting information about the dataframe,
Filter, sort and query a Dataframes,
Duplicate values,
Working with null-values,
Sampling,
Group by,
Join.

This is only covering an introduction to Dataframes, more is covered in the data anlytics course.