WEBVTT

00:01.130 --> 00:02.800
Welcome to coding exercise 5.

00:02.830 --> 00:11.520
We Are Young on the Tubular dashboard and our exercise file is still on the desktop and we have the

00:11.520 --> 00:14.760
file and we are still in Part 1.

00:15.560 --> 00:19.020
And let's open up the exercise 5.

00:19.050 --> 00:19.890
To put a notebook

00:23.710 --> 00:31.330
so coding exercise 5 is all about the sorting and filtering data frames and we have to sort our data

00:31.330 --> 00:39.680
frame by one column and also by two columns then we have to sort a data frame also by the index and

00:39.680 --> 00:46.210
you should get to the number of unique values in all columns then you should select the 10 listing service

00:46.230 --> 00:53.960
to the highest market capitalization and the 15 listings with the lowest stock prices and then you have

00:53.960 --> 01:01.240
to filter the data frame for all listings on the Investec and for all listings where the prices are

01:01.250 --> 01:02.240
less so than 1.

01:02.240 --> 01:08.690
So these are penny stocks and finally you have to filter their listings data frame for all penny stocks

01:08.690 --> 01:10.610
on the Nasdaq.

01:10.610 --> 01:12.920
So that's the accounting exercise 5.

01:13.040 --> 01:18.620
I hope we have fun and feel free to have a look at these solutions notebook and these solutions video

01:18.680 --> 01:19.010
by.