[MUSIC]

[SOUND] When it comes to describing our tie by the type of fabric,

we have a lot of different options.

But how can we easily identify the ones made with a cashmere blend?

We can look through the description and see if it lists cashmere.

We're gonna create a function now that creates a new column for

our data of boolean type.

Let's go ahead and open up a new file.

[SOUND] Let's import our

work from the previous.

[BLANK_AUDIO]

There we go.

Okay, so let's create a function

create boolean field from search term.

And let's pass in the data_sample and also the search_term.

And we're gonna pass back a new list that we're just gonna call new_array.

[BLANK_AUDIO]

We need to make sure that this new array,

which will be the new column, has the data header.

We want to make sure this new column has the header of the search term

that we're looking for.

So let's add that in.

So it's new_array.append and

then the data_samples of the existing set of headers,

but we wanna add one more at the end.

So we wanna append cashmere or search_term, I should say.

[BLANK_AUDIO]

When we create a new column for our new data sample,

we wanna have the headers from before, but adding in the new column's header.

So we do that by taking in the data_sample's header and

adding to the very end of the list the search_term.

And then we add that to the new temporary array, just so we have it in there.

And now we can go through the rest of the data sample, all 5,000 or so lines.

[BLANK_AUDIO]

Starting from the second row, within this loop we're going to set the boolean value.

So first of all, we're going to default to false.

[BLANK_AUDIO]

If there is a search term in, well,

we're going to have as the description,

we want to say it's true because it exists.

There we go.

[BLANK_AUDIO]

And whatever that boolean value is for the new field, I wanna append it to the row.

[BLANK_AUDIO]

And then we wanna save that row into the new array.

[BLANK_AUDIO]

All right, so this will build up everything we have, plus the new column.

[BLANK_AUDIO]

Okay, let's try running this cuz this will be really, really fun.

Okay, so we have my_new_csv equals,

my_new_csv equals create boolean field from search term,

passing in the data sample and our search term.

[BLANK_AUDIO]

So that didn't actually filter it, but it did create the new field, right?

So, let's see how to filter so that we can actually count the number

of boolean values and see how many of the ties match the search term.

So we're gonna have to create a new function.

Oh, and this function we're going to call it filter_col_by_bool,

and we're gonna pass in the data_sample and

the column number of the boolean.

[BLANK_AUDIO]

Actually, instead of filtered_rows,

maybe we'll call this matches_search_term.

And for each item in data_sample,

starting with the second row,

if items search term column

matches the value true.

If is true, if it exists, or if it's true,

then matches_search_term should

include that item, append(item).

And at the end of that loop,

we want to return all the items that matches_search_term.

[BLANK_AUDIO]

Okay.

Now, now we can say, here,

number_of_cashmere_ties.

[BLANK_AUDIO]

Equals my_new_csv and

then filter that,

filter_ col_ by_bool.

So you want to filter that, and

then we want the number of records in that.

Now we want the number of records, and we can print that.

And let's see how many cashmere ties we found.

Oops, we forgot the column.

We wanna say, column 11, the last one.

[BLANK_AUDIO]

We have 56 ties that were made with cashmere in our data set.