WEBVTT

00:00.550 --> 00:02.310
Welcome to coding exercise 6.

00:02.330 --> 00:07.600
We're here to put out our sport and our folder is still on the desktop

00:10.320 --> 00:11.720
and we are still in Part 1.

00:12.420 --> 00:16.670
And uh we open uh the exercise six uh chip in a notebook

00:21.110 --> 00:26.930
and encoding exercise six that we will identify and handle and they are missing values and we will also

00:26.930 --> 00:34.710
calculate some summary statistics so first of all we will identify the columns where we have missing

00:34.710 --> 00:40.890
values then we try to drop the rows and columns with missing values.

00:40.900 --> 00:45.250
Next we will filter all rows are listings with the missing values.

00:45.250 --> 00:53.760
And the last price column and we will also handle the missing values and the last price column then

00:53.760 --> 01:00.140
next we will examine the missing values in the IPO year column and we will handle the missing values

01:03.320 --> 01:07.240
and finally we will also transform the data type in the IPO year.

01:07.250 --> 01:09.070
Column 2 integer.

01:09.230 --> 01:15.080
And then we will save and export the clean to data frame to a new C as we file listings cleaned out

01:15.100 --> 01:15.890
CSP.

01:16.130 --> 01:23.060
And then we get some summary statistics on the clean listings data frame and we calculate the mean and

01:23.060 --> 01:24.500
the standard deviation.

01:24.980 --> 01:32.060
And also for non Ameritrade columns we get some statistics here and then we get the maximum values per

01:32.060 --> 01:32.960
column.

01:33.140 --> 01:38.040
And we also calculate the a sum for a complete column.

01:38.120 --> 01:44.930
And finally we will also create a correlation matrix so that scoring exercise 6 I hope you have fun

01:44.960 --> 01:48.700
and feel free to have a look at these solutions notebook.

01:48.800 --> 01:50.420
These solutions video by.