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 (2254) 4778 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
Welcome Message00:01
IntroductionPreview00:10
Introduction00:03
Course Curriculum Overview00:03
Overview of Databases00:08
Course FAQs00:02
Windows Installation - PostGreSQL and PgAdmin with Database Setup00:25
MacOS Installation - PostgreSQL and PgAdmin with First Query00:24
pgAdmin Overview00:10
Overview of Challenges!00:02
SQL Cheat Sheet00:01
SQL Statement Fundamentals 00:01
SELECT Statement00:08
Challenge: SELECT00:05
SELECT DISTINCT00:05
Challenge: SELECT DISTINCT00:02
COUNT00:07
SELECT WHERE - Part OnePreview00:05
SELECT WHERE - Part Two00:08
ORDER BY00:08
LIMIT00:05
Challenge: ORDER BY00:05
BETWEEN00:07
IN00:05
LIKE and ILIKEPreview00:10
General Challenge 100:10
Introduction to GROUP BY00:01
Aggregation Functions00:08
GROUP BY - Part One00:08
GROUP BY - Part Two00:11
GROUP BY - Challenge00:05
HAVING00:06
HAVING - Challenge Tasks00:05
Overview of JOINS00:01
Introduction to JOINs00:02
AS Statement00:08
Inner Joins00:15
Full Outer Joins00:14
Left Outer Join00:12
Right Joins00:05
UNION00:02
JOIN Challenge Tasks00:13
Overview of Advanced SQL Commands00:01
Timestamps and Extract - Part One00:08
Timestamps and Extract - Part Two00:10
Quick Note on TO_CHAR00:01
Timestamps and Extract - Challenge Tasks00:04
Mathematical Functions and Operators00:05
String Functions and Operators00:09
SubQuery00:15
Self-Join00:11
Introduction to Section00:01
Data Types00:07
Primary Keys and Foreign Keys00:09
Constraints00:05
CREATE Table00:18
INSERT00:09
UPDATE00:08
DELETE00:04
ALTER Table00:07
DROP Table00:04
CHECK Constraint00:09
Conditional Expressions and Procedures Introduction00:01
CASE00:23
CASE - Challenge Task00:03
COALESCE00:06
CAST00:08
NULLIF00:11
Views00:07
Import and Export00:15
Overview of Python and PostgreSQL00:01
Psycopg2 Example Usage00:11
Psycopg2 Resources00:01

$6500

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