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
Download: anaconda.com
Duration: 2 consecutive days, 10am - 5pm
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:
Indexing, Re-indexing,
Reorder,
Sorting, Stastitics,
Transforming data using
Dataframe Joins, Merging, Concatenation, Overlap, Append, zip.
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.
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
Our experienced trainers are award winners.
