# 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.​

Syllabus

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.
Ranges

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.
Parameters

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.
Bins

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