Crash course: Data analytics in Python using Pandas

Let's get to grips with the Python Pandas library for data analytics / analysis
Rating: 4.5 out of 5 (171 ratings)
11,915 students
Crash course: Data analytics in Python using Pandas
Rating: 4.5 out of 5 (171 ratings)
11,923 students
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

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

The demand for data engineers is greater than ever. So, there is no better time to upskill; learn Python and specifically data engineering.

I'll take you through the core concepts of dataframes, which are a key data structure within Pandas. We'll learn to ingest, clean and analyse the data and by the end of the course, you'll be in a position to use Python & Pandas on your own data to extract valuable insight.

The idea isn’t to become an expert through this course. The idea is to become confident in the core concepts of Python and Pandas so you can solve real-world problems today and so you can continue your learning by doing.

Because, nobody becomes an expert through taking a course (no matter how long they are), you only truly become an expert by getting out there & solving problems.

For this course, you'll need some basic Python knowledge, which you can gain from my FREE No Nonsense Python course here on Udemy.

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
Course content
5 sections • 21 lectures • 59m total length
  • Introduction
    00:39
  • Project introduction: What's the data & what do we want to achieve?
    00:55
  • Ingesting data & cleaning it up
    09:12
  • Initial insight from the data
    07:37
  • Extracting a little more insight
    01:50
  • Importing data
    05:00
  • Inspecting our dataframe - what do we have to work with?
    03:13
  • Handling missing values
    03:34
  • Removing duplicated data
    02:00
  • Where Statements
    03:55
  • Selecting specific fields from the dataframe
    01:15
  • Replacing values in our dataframe
    01:57
  • Group By
    01:49
  • Ranking our dataframes on a specific field value
    02:57
  • The Apply function: data cleanup & additional insight
    02:42
  • Write dataframes back to files
    01:11
  • Your challenge, if you accept it
    01:50
  • Challenge solution
    05:02
  • A real world example of using Pandas
    02:20
  • Where do I go from here?
    00:22
  • Thank you
    00:36

Instructor
Data Engineer at Kodey
Kieran Keene
  • 4.5 Instructor Rating
  • 376 Reviews
  • 18,323 Students
  • 3 Courses

Hey guys! I am a data engineer by trade and specialize in Python, SQL, Spark, Hive, MongoDB and more. I've come on Udemy to try and make simple, short crash courses into these technologies as I personally find the longer courses too drawn out & I often lose interest. The idea is to keep it short and sharp!


For loads of advanced Spark, Python & Big Data topics, please visit my website (the button on this page will take you there) - where I talk about scaling up to enterprise grade solutions.