Working with DataFrames Course

In this course, you will learn how to create DataFrames that will allow you to perform a variety of useful operations.

1 hour, 34 minutes

Course description

A DataFrame is similar to a table in a spreadsheet, consisting of rows and columns, with each cell containing a data value.​ You can create a DataFrame by importing data from various sources, such as CSV or Excel files, or by manually defining the data using dictionaries or lists.​ DataFrames allow you to perform various operations, such as filtering, sorting, and grouping data, as well as calculating statistical measures.​


Introduction to loc and iloc

Video - 00:04:00

We'll introduce you to working with the loc and iloc functions in DataFrames.
Finding records in DataFrames

Video - 00:05:00

How do you find a record in DataFrames? Watch this video to find out where to begin!
Rows and columns

Video - 00:06:00

Rows and columns are basic elements of working in DataFrames that we will explore in this video.

Video - 00:05:00

Dartanion defines and demonstrates ranges in DataFrames.
Numeric indexes and iloc

Video - 00:09:00

In this video you will learn how to use iloc with numeric indexes.
Labeled indexes and loc

Video - 00:04:00

Using labeled indexes with loc is covered in this video.
Appending a record

Video - 00:06:00

What do you do when you need to append a record in DataFrames? We'll show you!
Greater than and equal to in DataFrames

Video - 00:03:00

Explore how to use greater than or equal to in DataFrames.
Wild cards

Video - 00:06:00

In this video, we'll get wild ... with wild cards in DataFrames.

Video - 00:03:00

Setting parameters in DataFrames is the focus of this video.
Loc and iloc practice

Video - 00:05:00

Let's do a bit of practice using the loc and iloc functions in this video.
Groupby function

Video - 00:05:00

We'll begin our exploration of using the groupby function.
Groupby for a single column

Video - 00:05:00

In this lesson, we'll contine using the groupby function for a single column.
Groupby for multiple columns

Video - 00:04:00

Now we'll use the groupby function for multiple columns.

Video - 00:10:00

Discover how to use bins in DataFrames.
Groups and bins practice

Video - 00:07:00

Practice using groups and bins in DataFrames.
Bin output

Video - 00:03:00

See what using bins will output in DataFrames.
Multi-dimensional objects

Video - 00:03:00

We'll get into using multi-dimensional groups in this video.
Groupby to a DataFrame

Video - 00:02:00

How do you use groupby to a DataFrame? Dartanion shows you in this video.
DataFrames conclusion

Video - 00:01:00

We conclude this course on working in DataFrames.

Unlock 7 days of free training

  • 1,400+ hands-on courses and labs
  • Certification practice exams
  • Skill assessments

Plans & pricing

Infosec Skills Personal

$299 / year

  • 190+ role-guided learning paths (e.g., Ethical Hacking, Threat Hunting)
  • 100s of hands-on labs in cloud-hosted cyber ranges
  • Custom certification practice exams (e.g., CISSP, Security+)
  • Skill assessments
  • Infosec peer community support

Infosec Skills Teams

$799 per license / year

  • Team administration and reporting
  • Dedicated client success manager
  • Single sign-on (SSO)
    Easily authenticate and manage your learners by connecting to any identity provider that supports the SAML 2.0 standard.
  • Integrations via API
    Retrieve training performance and engagement metrics and integrate learner data into your existing LMS or HRS.
  • 190+ role-guided learning paths and assessments (e.g., Incident Response)
  • 100s of hands-on labs in cloud-hosted cyber ranges
  • Create and assign custom learning paths
  • Custom certification practice exams (e.g., CISSP, CISA)
  • Optional upgrade: Guarantee team certification with live boot camps

Learn about scholarships and financing with

Affirm logo

Award-winning training you can trust