Python Data Course
Course details
Python Data Analytics Course

    Python Data Course. Data Analytics with Python using Numpy, Pandas, Dataframes.
    Most attendees are in-work Data Professional.
    Private individuals are very welcome.
    Our Style: Hands-on, Practical
    Location: Online, Instructor-led
    Duration: 2 consecutive days, 10am - 5pm
    Times: arrange a time for your time zone

Python Data Analytics Course

Session 1: Database:

Linking with SQL Database.
Create, Amend and Drop Tables.
Insert, Update and delete records.
Select queries.
Traverse and display query results.
Using parameters in queries.
Get metadata about tables and columns.

Session 2: Data Structures

Data Structures:
Dictionary. Nested Dictionary.
Json Files.

Session 3: Python Numpy

The Python NumPy Module:
Working with arrays, create data using arrays.
Array manipulation.
String functions on arrays.
Math, arithmetic and statistical functions.

Session 4: Python Pandas Dataframes and data importing

Python Dataframes
Data Series. Date/ Time Functionality. Time series.
Creating Dataframes, Indexing.
Dict to Dataframe, Dataframe to Dict.
Csv to Dataframe, Dataframe to csv.
Excel to Dataframe, Dataframe to Excel.

Session 5: Data Cleaning and preparation

Data Cleaning and preparation
Finding, replacing and filtering missing data.
Remove Duplicates.
Replacing values.
Renaming Axis Indexes.

Session 6: Pandas Data Wrangling

Data Wrangling:
Indexing, Re-indexing,
Sorting, Stastitics,
Transforming data using
Dataframe Joins, Merging, Concatenation, Overlap, Append, zip.

Week 6: Pandas Data Analysis

Data Analysis:
Analysing and finding data using filter, slicing and dataframe queries.
Finding data by Iteration.
Find statistics: Functions, Aggregate functions.
Unique values.
String objects, Regex.

Included with the Python Course
  • PCWorkshops Course Certificate on completion
  • Python Course Notes
  • Python Code Examples
  • Practical Python Course exercises and Code Samples
  • After the course: 1-Hour personalised online revision session
Book the Python Course
About us

Free Python Course Trial



Special Offers
learn Python
Special Offer on the 'Visual Data with Power BI' Webinar
Read More
learn Python
Special Offer: Python 3-weeks online Boot Camp
Read More
learn Python
Special Offer on the 'SQL Queries in 1-Day' webinar
Read More
PCWorkshops Southend-on-Sea
Special Offer on the 'Java Cross-Over for Coders' Webinar
Read More