Python Course | Python Data Course

Python Data Course Description

Master data analytics with our comprehensive Python Data Analytics Course. Whether you're a beginner or an experienced professional, this instructor-led online course is designed to give you hands-on expertise in Python programming, data manipulation, and analysis.
Get to grips with essential tools like NumPy, Pandas, Dataframes, and SQLite, and gain practical skills that will elevate your career.
With all this technical Python, Pandas and NumPy knowledge at your fingertips, our Python Data Course will empower you to excel in your role as a Python data analyst. By mastering the skills taught in the Python Data Course, you’ll boost your career prospects and open the door to higher salary opportunities. Don’t miss the chance to transform your career with the Python Data Course!

Who should attend the Python Data Course?

Most attendees are in-work Data Professional. Private individuals are very welcome.

Python Data Course Details

Our Style: Hands-on, Practical
Location: Online, Instructor-led
Download: anaconda.com, install Pandas and NumPy.
Duration: 1 Data
Times: check the booking link

Why choose this course?

Hands-on Learning: Get practical Python experience through real-world examples and exercises.
Expert Python Instructors: Learn from industry Python professionals with proven expertise.
Career Advancement: Boost your resume with valuable Python data analytics skills, making you more competitive in the job market.
Flexible Scheduling: Choose a time that works for you, with our online, instructor-led Python sessions available worldwide.

Python Data Course Outline

Real-world Python data analysis techniques
How to manipulate and clean data with Python Pandas
Visualize and analyze large datasets using Python
Integrate Python with SQL for powerful data management

Session 1: Connecting to a database:

Using SQLite3 with Python:

Embed SQL commands within Python to retrieve and display data, e.g. products or user information, or get large datasets from a database to analyse. Can you imagine any app that does not use a database? User information, user log-ins, user images, activity history, all are in a database. Product information, purchasing information, etc.
Learn to work with a database within Python:
Connecting your Python code to a 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: Python Data Structures

Python Data Structures:

Tuples in Python.

Sets in Python.

Dictionaries in Python. Nested Dictionary.

Json Files in Python.

Session 3: Python Numpy

Numpy:

The Python NumPy Module:

Working with Python arrays, create data using arrays.

Array manipulation in Python.

Using Python Built-in String functions on arrays.

Python Math, arithmetic and statistical functions.

Session 4: Python Pandas Dataframes and data importing

Python Pandas Dataframes

Python Numpy Data Series. Python Date/ Time Functionality. Time series.

Creating Python Pandas Dataframes, Indexing.

Dict to Dataframe, Dataframe to Dict.

Using Csv files in Python. Converting Csv files to and from Python Dataframes.

Using Excel and Python Dataframes Convert Excel from and to Python Dataframes.

Session 5: Data Cleaning and preparation in Python

Data Cleaning and preparation in Python.

Finding, replacing and filtering missing data in Python Dataframes.

Remove Duplicates.

Replacing values.

Renaming Axis Indexes.

Use Python Dataframes for Data Wrangling:

Python Pandas Dataframe Indexing, Re-indexing,

Python Pandas Dataframe Reordering,

Python Pandas Dataframe Sorting. Getting Statistics from data in a Python Pandas Dataframe.

Transforming Python Pandas Dataframe data using

Dataframe Joins, Merging, Concatenation, Overlap, Append, zip functions

Session 6: Python Pandas Data Analysis

Use Python Dataframes for Data Analysis:

Sorting data in Python Dataframes.

Analyse and find data using filters, slicing and DataFrame queries..

Finding data by Iteration.

Python Dataframes for statistical functions, aggregate functions.

Find Unique values in Python Dataframes.

Using String objects and Regex in Python Dataframes.

Customise Python Courses

Powered by

EMF HTML Contact Form

Where is our London Classroom

Golden Cross House, 8 Duncannon Street, London, WC2n 4JF

More About Our Python Courses

Instructor-led Experienced Python trainers adapt to audience and address questions directly, delivering directly, live.

Practical Python Course All Python skills are illustrated and thoroughly practiced with comprehensive, explanatory, practical exercises.

Personlised Python Courses Courses are fully customisable with relevant sample data via pre-course arrangement. The maximum number of delegates per group is 4.

Live online, London Classroom, or Onsite Normally we teach online, instructor-led. You can arrange Python training onsite or in the London classroom by emailing us about it.

Contact PCWorkshops

Python Data Course