WEBVTT 00:00.650 --> 00:02.380 Welcome to coding exercise 1. 00:02.450 --> 00:08.390 In this video you will learn how to download open and use the Jupiter notebooks and data sets for decoding 00:08.510 --> 00:09.770 exercises. 00:09.770 --> 00:15.680 And I highly recommend doing the coding exercises as it significantly increases your learning experience 00:15.710 --> 00:17.480 and your learning success. 00:17.480 --> 00:19.510 So learning by doing is key. 00:19.730 --> 00:25.280 Throughout the course you will have the opportunity to impart and analyze your own data sets and in 00:25.280 --> 00:31.850 part one of this course it is the list things data set containing all current stock listings on the 00:31.880 --> 00:35.030 three major U.S. stock exchanges. 00:35.040 --> 00:35.540 All right. 00:35.540 --> 00:41.510 The basic assumption and requirement for this video is that you have successfully downloaded and installed 00:41.540 --> 00:49.080 Anaconda and if this is not the case then please go back and have a look at the Getting Started s.. 00:49.190 --> 00:56.240 We are now here on the cost dashboard and we can see here overview and you can also click to cost content 00:56.270 --> 00:58.280 and let's have a look here. 00:58.280 --> 01:06.410 So currently we are in section 3 Panda's basics and we have successfully finished the quiz 1 first steps 01:06.950 --> 01:15.440 and now we are here and lecture 60 and explore your own dataset coding exercise 1 intro and you can 01:15.440 --> 01:22.550 see here on the right hand side the resources and if you click here then you can find here a set fire 01:22.580 --> 01:23.540 that you can download. 01:23.540 --> 01:26.750 So here the sub five finance data exercises. 01:26.810 --> 01:34.760 So let's click on that here and then Udemy asks you to download the zip file and you can simply go here 01:34.760 --> 01:41.900 to safe safe s and then I recommend to download and save the zip file on your desktop. 01:41.900 --> 01:51.050 So here and I've already done this so I go now to my desktop I am now on my desktop and you can see 01:51.050 --> 01:54.940 the zip file finance data exercises and. 01:55.030 --> 01:58.250 This is still in a set format and. 01:58.280 --> 02:06.290 First of all we have to answer the file and we can do this by having a right click and then we go to 02:06.290 --> 02:11.470 extract all and we can see now that we can extract the zip file. 02:11.480 --> 02:13.800 Also here on our desktop. 02:13.800 --> 02:17.250 And uh that's exactly what we are doing here. 02:17.270 --> 02:19.310 So we click here on extract 02:24.640 --> 02:27.190 and if we see now on the left hand side. 02:27.220 --> 02:29.530 The answer fire. 02:29.530 --> 02:34.060 So here we have the unsub file and let's open the Ansett file. 02:34.060 --> 02:38.830 So that's the finance data exercises and we we've actually here two parts. 02:38.830 --> 02:45.460 So here we have the tubular notebooks and the data sets the four part one of the cost panel space six 02:46.000 --> 02:49.880 and also for part two financial data analysis. 02:50.110 --> 02:52.360 And we can simply have a look here. 02:52.360 --> 02:53.930 So this is part 1. 02:54.040 --> 02:56.460 And here we have in total nine exercises. 02:56.500 --> 03:02.530 And uh we can see for each and every exercise the exercise notebook where you have to make your own 03:02.530 --> 03:09.730 code here and we also have these solutions notebook with the the solutions already in place and you 03:09.730 --> 03:16.790 can also see here them all of the data sets that we use throughout the exercises. 03:16.810 --> 03:18.830 So that's part one. 03:19.080 --> 03:20.990 And here we have part two. 03:21.010 --> 03:25.060 And also here we can see the two button notebooks and three data sets. 03:25.510 --> 03:25.990 All right. 03:25.990 --> 03:33.270 Our plan is now to do a coding exercise one and therefore we have to open the anaconda navigator. 03:33.340 --> 03:38.140 We are now here and the anaconda navigator and we actually go to a job in a notebook 03:41.820 --> 03:47.240 we are now here on the Jupiter dashboard and we know that our fire finance data exercises is on our 03:47.240 --> 03:49.880 desktop and therefore we click on desktop 03:52.380 --> 03:54.710 so that's a view on our desktop. 03:54.750 --> 04:01.390 We are for example the Microsoft Edge browser and the Opera browser and we also have fear the fights 04:01.460 --> 04:06.690 UM THE FIRE finance data exercises and our concept folder. 04:06.720 --> 04:14.580 So let's click here on finance data exercises and here we have Part 1 and Part 2 and we want to do the 04:14.580 --> 04:16.620 very first coding exercise. 04:17.070 --> 04:23.340 So here we have all of the notebooks for part 1 and the data sets and we are starting right now with 04:23.340 --> 04:24.660 exercise 1. 04:24.690 --> 04:31.200 So here we have the solution but the before we have a look at this solution of course we tried to code 04:31.230 --> 04:32.120 on our own. 04:32.610 --> 04:33.690 So let's open here. 04:33.720 --> 04:41.710 The exercise and that's the very first coding exercise and you have the opportunity to analyze your 04:41.710 --> 04:48.490 own data set and it's best to follow the instructions and insert your code and actually two different 04:48.490 --> 04:49.780 kind of questions. 04:50.170 --> 04:57.700 So either you have to complete the code by uh filling the gaps and gaps are marked with uh three dashes 04:57.730 --> 04:59.440 or minuses. 04:59.440 --> 05:03.670 And uh this actually place holders for your own code fragment. 05:03.670 --> 05:06.590 So let's have a look at other example. 05:06.660 --> 05:14.250 So for example here the very first the exercise import pandas and fill in the gaps and you can see two 05:14.250 --> 05:19.980 gaps and in the first gap you have to fill import pandas. 05:20.160 --> 05:22.410 And then the second gap as PD. 05:22.920 --> 05:25.600 So that's the uh solution here. 05:25.770 --> 05:32.760 And there's also a second kind of exercise in many exercises you have to write your code completely 05:32.760 --> 05:33.950 on your own. 05:34.080 --> 05:36.000 And it's also if I look here. 05:36.000 --> 05:44.100 So for example a coding exercise for here can see a completely blank uh line or cell and you have to 05:44.100 --> 05:47.130 include uh your own code right. 05:49.900 --> 05:56.170 And in some exercises you will find questions that can only be answered if your code is correct and 05:56.260 --> 05:58.420 returns to the right output. 05:58.420 --> 06:02.000 And actually the correct answer is provided below the coding side. 06:02.290 --> 06:04.900 And this is simply to check whether your code is correct. 06:04.900 --> 06:07.320 So let's have a look at an example here. 06:07.510 --> 06:10.250 We have fear coding exercise 6. 06:10.720 --> 06:17.980 And here you are asked to get some summary statistics on our data frame and if you do this correctly 06:17.980 --> 06:23.370 then you can answer the question What is the maximum value in the column last prize. 06:23.650 --> 06:26.150 And here you are required to make your own code. 06:26.350 --> 06:33.010 And if your code is correct then you can answer the question that the maximum value in that column last 06:33.010 --> 06:36.310 prize is about four thousand three hundred 06:41.420 --> 06:46.020 from time to time it might be the case that you have problems with a question. 06:46.130 --> 06:50.660 And therefore I have provided the hint section at the end of this notebook. 06:50.660 --> 06:52.140 So let's have a look here. 06:53.410 --> 07:00.130 So here we have the hint section and here we can find for each and every exercise a hint that might 07:00.130 --> 07:02.570 be a pretty helpful actually. 07:02.760 --> 07:07.440 And if you need some further help or if you want to check your code you can also watch the solutions 07:07.470 --> 07:12.510 video or you can check the solutions notebook and maybe a very last hint. 07:12.540 --> 07:21.180 So we have gaps that are marked with the three dashes here and actually the code fragment can be everything. 07:21.210 --> 07:26.150 So from a variable to a number but also a more complex code. 07:26.280 --> 07:29.810 But I would rather expect to have a shorter code here. 07:29.820 --> 07:30.240 All right. 07:30.240 --> 07:34.380 With this we are finished here and I hope you have fun with the exercises by.