WEBVTT 00:00.510 --> 00:01.200 Welcome back. 00:01.200 --> 00:05.520 In this letter let us talk more about the pit unknowable in the previous lecture. 00:05.520 --> 00:11.940 We perform some basic stuff in this letter to let us know more about its keyword and also how to open 00:11.940 --> 00:14.030 a file inside edge or pretend both. 00:14.070 --> 00:16.080 So let me open my jacket and your book 00:21.030 --> 00:22.900 head it is up and running. 00:22.940 --> 00:30.500 Hey you can see I have few files that some of my juice on some of my CSB and other extreme finds. 00:30.500 --> 00:37.230 Also ahead as my previous I buy it on notebook which for your editing in the previous lecture. 00:37.430 --> 00:38.400 These are the come on. 00:38.400 --> 00:39.580 That was autopsy. 00:39.850 --> 00:41.070 Let me delete this one. 00:41.260 --> 00:48.910 All you have to do is select the cell and then best duty itself fresh stupid and notebook. 00:48.910 --> 00:54.790 Also if you want to rename them just click here and give your desired name and the most important thing 00:54.790 --> 00:56.260 is dropdown notebook. 00:56.350 --> 00:56.900 Ah. 00:56.980 --> 00:57.710 Autopsy. 00:57.910 --> 01:03.200 So if you are doing any changes they would be saved automatically at a certain period of time. 01:03.670 --> 01:08.460 And if we want to launch a new notebook all you have to do is click on new and then select the language. 01:08.830 --> 01:14.270 If you are also running BHP or maybe some other languages you will get that option also. 01:14.340 --> 01:18.800 And at this point of time I'm running the script when I bite on inaudible. 01:19.090 --> 01:24.060 Let me get back head and one most important thing is different type of keystrokes. 01:24.250 --> 01:30.820 So if I click on Help Here you can see keyboard shortcuts and if you click it you will see a different 01:30.820 --> 01:34.730 type of shortcuts that you can also customize according to you. 01:34.960 --> 01:40.450 But these are some really important see if you are someone who is going in to data analysis field for 01:40.450 --> 01:44.110 your future Drupal download book is one of the best choice. 01:44.110 --> 01:47.410 Also these are few really important things that you need to remember. 01:47.800 --> 01:49.540 So I hope you will give a look to it. 01:49.900 --> 01:51.820 Now let us do some basic thing. 01:51.850 --> 01:58.980 Let me put my binders and also let me try to dig CSP and redefine so what I produce. 01:58.990 --> 02:03.090 Just import one does once find others imported. 02:03.110 --> 02:10.140 You have to create a data stream I had remembered I am trying to do the CEV so I would be using a method 02:10.140 --> 02:17.220 called greed a nurse cautiously in the previous videos you are directly using our dictionary on a list. 02:17.310 --> 02:23.890 In this lecture we are trying to read a CSU file that is stored in the same folder which is our by bind 02:23.890 --> 02:24.570 us folder. 02:25.260 --> 02:26.820 So how to take care of that. 02:27.180 --> 02:33.780 So if I'm reading any particular file I have to take it load deck read CSP as the method for text file 02:33.870 --> 02:35.370 or C history file. 02:35.630 --> 02:40.200 I had I need to give the location of my file since they both are in the same Paula. 02:40.260 --> 02:42.120 All I have to give this file name. 02:42.240 --> 02:46.810 Otherwise I have to define C drive or D drive all the required folder. 02:47.040 --> 02:48.890 So have the more time the same folder. 02:48.900 --> 02:53.540 I just need to pass my file name press or plus enter to execute this line 02:56.760 --> 02:57.070 here. 02:57.080 --> 03:03.140 Now you can see I'm able to get mad as hell so I'm just basically reading CSU file at this point of 03:03.140 --> 03:03.730 time. 03:03.920 --> 03:08.840 We'll be reading all the different table formats in the next lecture at this point of time you have 03:08.840 --> 03:09.310 to see. 03:09.320 --> 03:10.650 This is a tablet form. 03:11.020 --> 03:16.350 And let me open my CSU file. 03:16.610 --> 03:18.800 So this is the main file. 03:19.100 --> 03:21.490 We are reading it in our Joe Paterno book. 03:22.540 --> 03:24.850 I hope now you are able to understand that. 03:24.990 --> 03:32.190 Let me open my Excel file so let me create a new machine that is all pleasant to create my data frame 03:32.230 --> 03:35.890 to use my binders and then read excel 03:38.680 --> 03:46.790 and then I need to pass my file name let me execute this one with the help of control and enter and 03:46.790 --> 03:49.400 you can see I got an error. 03:49.440 --> 03:51.960 Now you need to think that why we are going to get the center. 03:52.010 --> 03:53.440 Let me do this one. 03:53.630 --> 03:58.390 So here we have an error on one you name X allowed in our cone. 03:58.520 --> 04:05.540 So basically recently Bond does got updated and we need to install this particular dependency to run 04:05.660 --> 04:08.530 our excel file so not a big issue. 04:08.540 --> 04:13.130 All you have to do is use pip install and then give the dependency name. 04:13.160 --> 04:14.340 So let me do that. 04:14.480 --> 04:20.310 Also before doing that let me talk about my exit sheet because now we are going to work on it. 04:20.330 --> 04:26.950 What I've done is after getting a report off my site attended a board in which I'm taking six feet. 04:26.990 --> 04:30.600 That is my date the number of visitors to. 04:30.890 --> 04:35.030 Most popular country number of ad clicks and then the. 04:35.420 --> 04:42.320 So this is the date that is date first number of visitors that well fifteen hundred bombs data is 20 04:42.470 --> 04:49.410 most popular and three was USA number of ad picks who are 20 and the day was too steam seeing photos 04:49.430 --> 04:50.390 with all the data. 04:50.690 --> 04:55.550 So this is a basic data which I am taking and the same data lies in different format. 04:55.970 --> 05:02.090 So you can talk about Jesus on you can talk about the sixty five you can talk about CSB by the same 05:02.090 --> 05:04.820 day that is stored in different formats. 05:04.820 --> 05:09.170 I hope no you understand these data and basically destroys in next number. 05:09.170 --> 05:10.210 That is by default. 05:10.550 --> 05:11.650 And this is my head. 05:12.230 --> 05:14.030 I hope below you are fine. 05:14.180 --> 05:17.180 Look we installed this dependency and on my ex and fi 05:22.060 --> 05:27.610 you can also check the background and you can see we have a connection at this point of time because 05:27.610 --> 05:29.990 we have to stop to put a notebook. 05:30.220 --> 05:32.510 It's done liquid on my doctor notebook again. 05:36.320 --> 05:37.380 And this works fine. 05:37.370 --> 05:44.180 Let me close to overdubs and open my script 1. 05:44.250 --> 05:45.650 Now let me execute this one. 05:45.710 --> 05:52.030 All you have less control less enter the normal you might get an error because of the panels. 05:52.350 --> 06:00.450 So all you have to do is either you need to execute import by again if you are getting an error Okay 06:00.490 --> 06:02.590 let me execute this one and then 06:08.240 --> 06:10.110 yeah this works fine for me. 06:10.510 --> 06:16.970 And one table to read my ex is fine so that's all for this lecture in the next left gender display in 06:17.070 --> 06:22.880 other different type of formats and you will also learn more things regarding Jason or reading from 06:22.900 --> 06:23.430 data. 06:23.480 --> 06:27.140 EPA will be doing that in the next lecture for this lecture. 06:27.140 --> 06:32.640 My main motive was to make you understand how to read a file and to make you more comfortable with it 06:32.670 --> 06:33.360 download notebook. 06:33.770 --> 06:39.320 So if you want to know more about different types of keywords all you have to do is just move to hell 06:39.440 --> 06:44.800 and use keyboard shortcuts that would create hell for you to understand to put down notebook. 06:45.020 --> 06:46.310 So that's all for this lecture. 06:46.310 --> 06:47.570 See you in the next one.