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.