WEBVTT

00:00.660 --> 00:02.480
Welcome to coding exercise.

00:02.770 --> 00:08.850
We are here on the Jupiter dashboard and our exercises file is still on the desktop here.

00:08.910 --> 00:15.750
So yes the finance data exercises the file and we open the Jupiter notebook for exercise.

00:15.790 --> 00:16.290
Three

00:23.500 --> 00:28.780
and actually this exercise is all about analyzing columns and penned series.

00:28.780 --> 00:34.550
And at this stage you should already know how to import pen us and how to import a CSP file.

00:34.810 --> 00:41.320
Then you should select a column or slice a column and create a copy.

00:41.320 --> 00:48.400
Then you should get some summary statistics and get the minimum value and also the absolute frequency

00:48.400 --> 00:50.790
and the relative frequency.

00:50.830 --> 00:56.110
Next you have to start a panda series from high to low and from low to high.

00:57.130 --> 01:01.120
And you should be able to use that the in-place parameter appropriately.

01:02.620 --> 01:09.150
And then you have to sort a pen that serious by the index and finally you will also have the opportunity

01:09.150 --> 01:16.830
to analyze a non numerically column and uh use also your described method get the unique values and

01:16.830 --> 01:20.580
also absolute and relative frequencies.

01:20.820 --> 01:22.710
So that's a coding exercise.

01:22.720 --> 01:28.680
3 I hope you have fun and feel free to have a look also at these solutions video and these solutions

01:28.750 --> 01:29.580
notebook by.