Getting started with Python - Klaymatrix Data Labs

Getting started with Python - Klaymatrix Data Labs

Python for Business Analysts – From Data to Insights Getting started with Python

Python for Business Analysts – From Data to Insights

0% Completed

Get going with Python

Getting started with Python

Video - 00:9:04 mins

Python Installation and IDEs

Video - 00:6:33 mins

Using Spyder IDE from Anconda Installation

Video - 00:6:02 mins

Quiz-Get Going With Python

Data types used in Python

Video - 00:7:02 mins

Strings - Part 1

Video - 00:8:36 mins

Strings - Part 2

Video - 00:9:43 mins

Quiz-Data Types

Operators in Python

Arithmetic Operator

Video - 00:4:31 mins

Assignment operators

Video - 00:3:53 mins

Comparison operators

Video - 00:2:54 mins

Logical operators

Video - 00:4:51 mins

Identity operators

Video - 00:3:05 mins

Membership operators

Video - 00:3:27 mins

Data structures used in Python

Video - 00:15:03 mins

Quiz - Python Lists

Video - 00:8:33 mins

Video - 00:15:29 mins

Video - 00:3:27 mins

List and Dictionary Comprehension

Video - 00:00:00 mins

Conditions and Loops

If Else conditional statement

Video - 00:19:33 mins

Video - 00:23:40 mins

Quiz: Loops and Conditional Statements

Functions

How to write, call and other basics of functions (article)

Video - 00:00 mins

Creating functions in python

Video - 00:12:07 mins

Quiz- Functions

Pandas Library

Introduction to pandas library (article)

Basics of Pandas, Series and Dataframes

Video - 00:11:52 mins

Import csv file with pandas read_csv()

Video - 00:16:26 mins

Dataframes (article)

Indexing and Selection (article)

Pandas DataFrame Concatenate

Video - 00:9:24 mins

Pandas DataFrame Join

Video - 00:14:45 mins

Pandas DataFrame Merge

Video - 00:5:56 mins

Working with DataFrames

Video - 00:13:32 mins

Quiz-Pandas Library and DataFrames

Exceptional Handling

Exceptional Handling- Try, Except, Raise

Video - 00:4:48 mins

Quiz-Exception Handling

SQL within Python

Introduction to SQLite

SELECT, WHERE, ORDER BY

Import Query Result into Pandas

Mini Exercise: Query Orders

Mini Case Study: Merge & Clean Datasets

Clean Column Names

Handle Missing Values

Assignment: Clean & Summarize Multi-File Dataset

Merge 3–4 CSV/Excel Files

Handle Missing Values

Generate Summary

Automate Excel Cleanup

Real-World Business Applications

Cleaning Messy Sales Data

Combining Data Sources

Automating Reports

Identifying Top Customers

Forecasting Demand

Exploratory Data Analysis & Visualization

Handle Missing Values & Duplicates

groupby & Descriptive Stats

Create Visualizations

Visualization Hands-On

Final Assignment

End-to-End ETL, SQL, Python & Power BI Skills Assessment

Announcements Reviews Live Classes Gradebook Certificate Course Info