£600
Python Programming Beginners Workshop

Python Programming Beginners Workshop

Actions and Detail Panel

£600

Event Information

Share this event
Location

Location

Online event

Refund policy

Refund policy

No Refunds

Event description
Excellent Python Programming Beginners Course, from start to efficient in one session. Hands-on, practical.

About this event

Workshops Description

Day 1 Session 1: Python Data Types and Variables:

  • Primitive types; Characters & Strings; Boolean; Working with variables and its scope; Conversion and casting types in Python.
  • Operators and Expressions:
  • Introduction of operators; Arithmetic operators; Relational operators; Assignment operator; Logical operators; Increment and decrement operators; More in operators.

Day 1 Session 2 : Decision Making & Loops

  • If statement; If - else statement; If- elif - else statement; Nested if - else;
  • The while
  • For loop
  • Jump statements: break, continue;
  • Nesting loops.

Day 1 Session 3: Data Structures

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

Day 2 Session 1: Built in Functions: String, Regex, Math, Random, Dates

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

Day 2 Session 2: OOP

  • Using Modules and functions:
  • Creating and using custom Functions.
  • Creating a Module in class;
  • Calling a Module;
  • Using parameters;
  • Returning value from a Module.
  • Introduction to Classes and Objects:
  • 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.

Day 3 Session 1:

  • Exception Handling, Exception types; Using try and Except.
  • Files, streams: Open, Traverse, Read and Create Files: Csv, txt and Json Files.
  • API: Connecting to API’s.

Day 3 Session 2: Databases

  • Connection details: Connect to a database using access codes.
  • Select Queries: Retrieving records and iterating results sets, using variables and parameters in queries.
  • Working with DDL comands: Create a database, drop a database. Create a table, alter tables, drop a table.
  • Working with DML Commands: Insert, delete, update records, query a database and display results.

Day 3 Session 3: Pandas Dataframe Basics

  • Getting data into a dataframe: 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.

Dataframe basics:

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

Included:

  • PCWorkshops's Python Programming Basics Certification
  • Course notes, exercises and code examples
  • Revision session after the course
Share with friends

Save This Event

Event Saved