Data Analysis - from zero to hero

Analyze data quickly and easily with Python's powerful pandas library! All datasets included --- beginners welcome!
Category : Data Analysis
4.5 (2387) 4088 Students

What you'll learn

Perform a multitude of data operations in Python's popular "pandas" library including grouping, pivoting, joining and more!
Learn hundreds of methods and attributes across numerous pandas objects
Possess a strong understanding of manipulating 1D, 2D, and 3D data sets
Resolve common issues in broken or incomplete data sets

Requirements

Basic / intermediate experience with Microsoft Excel or another spreadsheet software (common functions, vlookups, Pivot Tables etc)
Basic experience with the Python programming language
Strong knowledge of data types (strings, integers, floating points, booleans) etc

Description

Welcome to the most comprehensive Pandas course available on Udemy! An excellent choice for both beginners and experts looking to expand their knowledge on one of the most popular Python libraries in the world!

Data Analysis with Pandas and Python offers 19+ hours of in-depth video tutorials on the most powerful data analysis toolkit available today. Lessons include:

installing

sorting

filtering

grouping

aggregating

de-duplicating

pivoting

munging

deleting

merging

visualizing

Course content

LecturesHH:MM
Introduction Preview 00:10
Welcome Message 00:01
Introduction 00:03
Course Curriculum Overview 00:03
Overview of Databases 00:08
Course FAQs 00:02
Windows Installation - PostGreSQL and PgAdmin with Database Setup 00:25
MacOS Installation - PostgreSQL and PgAdmin with First Query 00:24
pgAdmin Overview 00:10
Overview of Challenges! 00:02
SQL Cheat Sheet 00:01
SQL Statement Fundamentals 00:01
SELECT Statement 00:08
Challenge: SELECT 00:05
SELECT DISTINCT 00:05
Challenge: SELECT DISTINCT 00:02
COUNT 00:07
SELECT WHERE - Part One Preview 00:05
SELECT WHERE - Part Two 00:08
ORDER BY 00:08
LIMIT 00:05
Challenge: ORDER BY 00:05
BETWEEN 00:07
IN 00:05
LIKE and ILIKE Preview 00:10
General Challenge 1 00:10
Introduction to GROUP BY 00:01
Aggregation Functions 00:08
GROUP BY - Part One 00:08
GROUP BY - Part Two 00:11
GROUP BY - Challenge 00:05
HAVING 00:06
HAVING - Challenge Tasks 00:05
Overview of JOINS 00:01
Introduction to JOINs 00:02
AS Statement 00:08
Inner Joins 00:15
Full Outer Joins 00:14
Left Outer Join 00:12
Right Joins 00:05
UNION 00:02
JOIN Challenge Tasks 00:13
Overview of Advanced SQL Commands 00:01
Timestamps and Extract - Part One 00:08
Timestamps and Extract - Part Two 00:10
Quick Note on TO_CHAR 00:01
Timestamps and Extract - Challenge Tasks 00:04
Mathematical Functions and Operators 00:05
String Functions and Operators 00:09
SubQuery 00:15
Self-Join 00:11
Introduction to Section 00:01
Data Types 00:07
Primary Keys and Foreign Keys 00:09
Constraints 00:05
CREATE Table 00:18
INSERT 00:09
UPDATE 00:08
DELETE 00:04
ALTER Table 00:07
DROP Table 00:04
CHECK Constraint 00:09
Conditional Expressions and Procedures Introduction 00:01
CASE 00:23
CASE - Challenge Task 00:03
COALESCE 00:06
CAST 00:08
NULLIF 00:11
Views 00:07
Import and Export 00:15
Overview of Python and PostgreSQL 00:01
Psycopg2 Example Usage 00:11
Psycopg2 Resources 00:01

$6500

$7500
This course includes
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion