Python Data Analytics Course
Learn Python data analytics effectively with our instructor-led online Python course. Whether you're a beginner or looking to enhance your programming skills, this course is designed to provide hands-on experience in data manipulation, visualization, and analysis. Join us to gain practical knowledge and industry-relevant expertise in Python.
Our excellent Python Data Course is a must for in-work data professionals looking to enhance their skills and stay ahead in the industry. The Python Data Course provides practical, hands-on training in Python, designed specifically for professionals tackling real-world data challenges. By enrolling in the Python Data Course, you'll gain advanced expertise in data manipulation, visualization, and analysis, giving you the tools to excel in your career.
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 day, nenotiate your date and time
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.
