Python Data Course
Course details
Java 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
    Download: anaconda.com
    Duration: 6 weeks, 1 evening per week, 6pm - 8pm
    Times: arrange a time for your time zone

Python Data Analytics Course


Session 1: Database:

SQLite3:
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:
Tuples.
Sets.
Dictionary. Nested Dictionary.
Json Files.

Session 3: Python Numpy

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:
Discretization and Binning,
Random Sampling.
Transforing data using function and mapping,
Hierarchical Indexing,
Reorder,
Sorting, Stastitics,
Dataframe Joins, Merging, Concatenation, Overlap.
Reshaping and pivoting.

Week 6: Pandas Data Analysis

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

What is included
  • 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
DOWNLOAD A CATALOGUE
Special Offers
PCWorkshops London
Special Offer on the 'Visual Data with Power BI' Webinar
Read More
PCWorkshops Manchester
Special Offer: Python 3-weeks online Boot Camp
Read More
PCWorkshops Birmingham
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

Request a Free Webinar Demo

Try a 30 minutes webinar free. Choose you own topic from our course list.