1
00:00:00,104 --> 00:00:02,129
Great job exploring how to select data.

2
00:00:02,129 --> 00:00:05,472
If you've used SQL, or
Structured Query Language, before,

3
00:00:05,472 --> 00:00:09,649
that probably felt pretty familiar to
a select statement with a where clause.

4
00:00:09,649 --> 00:00:13,382
In a bit here, we'll look at some more
similarities like merging and joining.

5
00:00:13,382 --> 00:00:16,800
First, though,
let's take a look at manipulation.

6
00:00:16,800 --> 00:00:18,347
When you're working with data,

7
00:00:18,347 --> 00:00:20,620
you definitely want to be
able to manipulate it.

8
00:00:20,620 --> 00:00:25,244
For instance, with the data frame, you'll
most likely wanna update specific values.

9
00:00:25,244 --> 00:00:27,129
You'll probably wanna add a row or

10
00:00:27,129 --> 00:00:29,867
even a brand new column to
an existing data frame.

11
00:00:29,867 --> 00:00:33,277
Well, the great news is
data frames are mutable.

12
00:00:33,277 --> 00:00:37,194
So you can add and remove data, changing
the shape of the original data frame.

13
00:00:37,194 --> 00:00:40,900
You'll find that the big part of dealing
with data involves rejittering it into

14
00:00:40,900 --> 00:00:44,788
exactly what makes the most sense for
whatever goal you're trying to accomplish.

15
00:00:44,788 --> 00:00:48,339
Let's explore some of the more common
methods for manipulating data frames and

16
00:00:48,339 --> 00:00:50,837
build up some of those muscles
that you're gonna need.