Python for Data Analytics

Use Python to obtain, clean and prepare data, then describe, visualize and model it to answer real business questions.

$2,000.00

Description

Use Python to obtain, clean and prepare data, then describe, visualize and model it to answer real business questions.

Price$2,000Per person
Time20 course hoursOn-demand video and labs, plus 2 hours of coaching
DeliveryOn-demand asynchronous trainingWith online support and 2 hours of coaching
CredentialCertificate of completionFrom We Can Code IT

About this course

This course teaches the analysis side of data work in Python. You will get data in from files, spreadsheets, databases and web APIs, clean and prepare it, describe it with statistics and show it in clear charts. You finish with simple predictive and classification models, so you can turn a business question into an answer backed by data.

Who it is for

This course is for analysts, finance and operations staff, and reporting teams who already know some Python and want to replace manual spreadsheet analysis.

Prerequisites

Basic Python: variables, lists, dictionaries, loops and functions (an introductory Python course or equivalent)

Comfort with spreadsheets and basic statistics such as averages and percentages

Requirements

Works on Windows, macOS or Linux

Anaconda with Jupyter, pandas, Matplotlib and scikit-learn (free)

What you will be able to do

  • You will be able to load data from CSV, Excel, JSON, a SQL database and a web API into a pandas DataFrame.
  • You will be able to clean and prepare data by handling missing values, fixing data types, removing duplicates and merging and reshaping tables.
  • You will be able to summarize data with descriptive statistics, groupby, pivot tables and correlation.
  • You will be able to build labeled charts with pandas and Matplotlib that a business reader can understand.
  • You will be able to train and evaluate a linear regression and a basic classifier with scikit-learn and explain their accuracy and error.

Syllabus

1

The analyst's Python setup 1.5 hours

Anaconda and Jupyter, Notebook habits for analysis, The pandas DataFrame.

Lab: You will set up an analysis notebook and explore a first dataset as a pandas DataFrame.
2

Obtaining data 2.5 hours

CSV, Excel and JSON files, Reading from a SQL database, Pulling data from a web API.

Lab: You will bring sales data from a spreadsheet, a database table and a web API into pandas and combine them.
3

Cleaning and preparing data 4 hours

Missing values, Data types and formatting, Duplicates and outliers, Normalization and binning, Merging and reshaping tables.

Lab: You will take a messy real-world dataset and produce a clean, analysis-ready table, documenting each fix you make.
4

Describing data 3 hours

Descriptive statistics, groupby and pivot tables, Correlation, Telling a real difference from noise.

Lab: You will summarize performance by region and product and test whether an apparent difference between groups holds up.
5

Visualizing data 2.5 hours

Choosing the right chart, Charts with pandas and Matplotlib, Labeling for a business reader.

Lab: You will build a small set of labeled charts that answer three questions from your cleaned dataset.
6

Predicting and categorizing 4 hours

Train and test splits, Linear regression for prediction, A basic classifier, Accuracy and error metrics with scikit-learn.

Lab: You will predict a numeric outcome with linear regression, sort records into categories with a classifier, and report how well each model performs.
7

Capstone 2.5 hours

Framing a business question, End-to-end analysis, Notebook report.

Lab: You will answer a business question end to end on a real dataset and present your findings in a short notebook report, then review it with your coach.
+

Coaching sessions 2 hours

One-on-one or small-group coaching, scheduled with your coach.

How it is delivered

How you learn

On-demand asynchronous training with online support, plus 2 hours of coaching.

Live or in person

Live online or in-person sessions are available for an additional fee. Email admissions@wecancodeit.org for details.

TechCred

Eligible credential

Python for Data Analytics

Reimbursement applies only to the credential approved in your TechCred application, so use the exact credential name shown on this page.

Funding

Ohio's TechCred program may reimburse eligible Ohio employers up to $1,000 per person, per credential, and up to $30,000 per application, for eligible costs such as tuition and certification costs.

TechCred's maximum is $1,000 per person, per credential, toward this price.

Timeline

The current application period opens at 9:00 a.m. on October 1, 2026 and closes at 3:00 p.m. on October 30, 2026.

Training must start no earlier than the first day of the application period and be completed within 12 months of the award date.

What we provide

For each learner, We Can Code IT provides an itemized per-person invoice that shows the exact credential name, and a certificate that shows the learner's name, the credential and the date earned (or the vendor's exam record for certifications). We can also send a written quote to include with your TechCred application.

Pricing is the same for all customers, whether or not you use TechCred.

We Can Code IT is an independent training provider. Being listed as an eligible TechCred provider is not an endorsement by the State of Ohio and does not guarantee funding. The Ohio Department of Development makes all TechCred decisions, so check the state's current program guidelines before you apply. Program details: the State of Ohio’s TechCred page.

Enroll your team

One or a few learners

Choose the number of seats, add the course to your cart and check out.

A group, or a written quote

Send the form below for group enrollment or a written quote to include with your TechCred application. We reply within one business day. You can also email admissions@wecancodeit.org.

Request group enrollment or a written quote

Tell us about your team and we will reply within one business day.

← Back

Thank you for your response. ✨

We Can Code IT, LLC, 26300 Cedar Rd, Suite 1105, Beachwood, OH 44122. Registered with the Ohio State Board of Career Colleges and Schools, Registration No. 15-03-2064T.

Syllabus