Crash course: Data analytics in Python using Pandas

Name: Crash course: Data analytics in Python using Pandas
Rating: 4.6 (593 reviews)

Let's get to grips with the Python Pandas library for data analytics / analysis

Created byKieran Keene

Last updated 9/2023

English

What you'll learn

Perform data analysis with the Pandas library
Learn about dataframes and how to conduct data analysis in Python
Understand how to handle missing values in your data
Understand how to handle & clean up messy data

Course content

5 sections • 21 lectures • 59m total length

Introduction0:39

Project introduction: What's the data & what do we want to achieve?0:55
Analyze sample data with pandas in Python to compare salaries by gender across jobs and cities, calculating max and average salaries to explore location and gender pay patterns.
Ingesting data & cleaning it up9:12
Import pandas, load a comma-separated values file into a data frame, clean salary by removing the dollar sign and converting to float, then group by gender to compute mean salary.
Initial insight from the data7:37
Explore how to compute and compare average salaries by gender across job titles in pandas, creating female and male salary columns and using group by for insights.
Extracting a little more insight1:50
Extend pandas analysis by grouping by job title, city, and gender to compare average salaries across groups. Adjust pandas display options to show all columns in the terminal.

Importing data5:00
Inspecting our dataframe - what do we have to work with?3:13
Learn to inspect a pandas dataframe with head and tail to view records, shape for size, and describe and info for numeric stats, data types, and memory usage.
Handling missing values3:34
Removing duplicated data2:00
Learn how to identify and remove duplicate rows in a dataset using Pandas, including whole-row duplicates and non-unique first name cases, and understand how the shape changes after dropping duplicates.
Where Statements3:55
Selecting specific fields from the dataframe1:15
Replacing values in our dataframe1:57
Group By1:49
Apply group by to summarize salaries by gender and city, using mean, sum, median, or max. Group by multiple fields yields max salaries by gender in each city.
Ranking our dataframes on a specific field value2:57
The Apply function: data cleanup & additional insight2:42
Write dataframes back to files1:11

Your challenge, if you accept it1:50
Practice data analytics in Python with pandas by analyzing a weblog dataset to compute bytes per domain, add gender-based totals, and compare bytes by country.
Challenge solution5:02
Learn to analyze data with pandas by reading a CSV into a data frame, applying groupby, reset_index, and sort, then create gender-based bytes columns and summarize by URL and country.

A real world example of using Pandas2:20
Use pandas to process contract data, rename columns, compute days until renewal with format_date, apply a status_calc to flag overdue or urgent renewals, and email results via the grid API.
Where do I go from here?0:23
Thank you0:36
Celebrate completing the course by applying pandas to real business problems using the building blocks provided. Engage with the Q&A and leave a review to share feedback and keep coding.

Requirements

Basic Python - from my FREE No Nonsense Python Course
The Pandas library should be installed - which you can do using 'pip install python'
Python should already be installed

Description

Unleash Data Magic with Python Pandas:

Ready to supercharge your data skills? Dive into our Python Pandas course, where data becomes your playground and insights are your treasure.

Why Choose This Course?

Elevate Your Data Game: Python Pandas is the secret sauce behind cutting-edge data analysis. Become a data virtuoso in just a few clicks!

Unlock Hidden Insights: I'll teach you to cleanse, manipulate, and analyze data like a pro. Say goodbye to messy datasets, and hello to crystal-clear conclusions!

Real-World Experience: Dive into captivating, real-world projects that put your newfound skills to the test. Learn by doing and conquer any data challenge.

What's In Store For You?

Data Transformation Mastery: Harness Python Pandas to transform raw data into invaluable insights. You'll wonder how you ever lived without it!
Data Wizardry: Learn the art of data ingestion, where you'll effortlessly extract, clean, and prepare data for analysis. No more data headaches!
Data Brilliance: By the course's end, you'll have the power to wield Python and Pandas like a seasoned pro, extracting untold gems of wisdom from your own datasets.

Join me and embark on a journey where data isn't just numbers; it's your passport to making data-driven decisions with confidence. Get ready to chart your course in the data-driven world. Enroll now and let your data adventures begin!

You will need to have Python installed and the Pandas library installed - which you can do using 'pip install pandas'.

Who this course is for:

Beginner Python Developers
Those interested in data analytics

Crash course: Data analytics in Python using Pandas

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 1min

A project to get us started4 lectures • 20min

The Pandas Essentials11 lectures • 30min

Practicing what we have learned2 lectures • 7min

Conclusion3 lectures • 3min

Requirements

Description

Who this course is for: