WEBVTT 00:01.220 --> 00:02.120 All right, everyone. 00:02.750 --> 00:07.150 So let's continue our discussion with working with the ticker. 00:07.800 --> 00:10.740 No, I'm going to read one fine. 00:11.150 --> 00:12.680 That is nothing but a tax fine. 00:13.280 --> 00:17.180 So for that, let us applaud this particular fight and to applaud it. 00:17.270 --> 00:24.440 Just click on this file upload and we have a movie reviews, not peace we find. 00:24.510 --> 00:25.610 So let me just click on it. 00:27.010 --> 00:27.410 Gokey. 00:29.190 --> 00:30.740 And he loses that inspiration. 00:31.700 --> 00:34.150 This particular flight should appear here. 00:35.460 --> 00:36.510 Still, it's uploading. 00:36.960 --> 00:40.620 So just wait for some time to upload finish. 00:42.980 --> 00:45.680 All right, so now you can see new movie reviews. 00:46.110 --> 00:47.550 Yes, we finally got up here. 00:48.080 --> 00:49.520 If you'll just click on it. 00:50.270 --> 00:51.350 Most probably they will. 00:51.360 --> 00:54.240 So some preview on right site. 00:55.250 --> 00:59.270 And then we'll see how you can read this particular file inside of it. 00:59.420 --> 01:00.550 Biton and Worimi. 01:02.780 --> 01:08.980 Hopes it is started playing on my local machine that I was OK, let me open it Twitter. 01:09.380 --> 01:09.940 Not bad. 01:10.710 --> 01:11.180 All right. 01:11.210 --> 01:14.540 So you can see this is a full fledged textual file is only. 01:15.350 --> 01:17.710 And it has a two column visible. 01:17.750 --> 01:18.560 One is a label. 01:18.730 --> 01:25.160 And then one is that even an individual column has been segregated with staff separate. 01:25.370 --> 01:27.180 You can see this is the tap 72. 01:27.890 --> 01:30.290 Then the next line will start. 01:31.070 --> 01:33.310 Here is another tab separator. 01:33.830 --> 01:38.210 So let's see how we can really and for this particular file. 01:38.240 --> 01:40.900 We are going to use this Pinder's liablity. 01:41.390 --> 01:45.500 So let me start with this. 01:45.750 --> 01:46.180 Find us. 01:46.190 --> 01:51.410 So import Pantazis, APD and privily. 01:51.560 --> 01:56.060 We are going to use this as a underscore C suite function. 01:58.790 --> 02:00.440 Let me give the file name. 02:00.770 --> 02:04.850 So in our case, the filing will be movie reviews. 02:07.650 --> 02:08.550 Not D.C.. 02:09.070 --> 02:09.340 No. 02:09.600 --> 02:16.740 We already know that individual record has been separated by less than an individual column here. 02:16.830 --> 02:21.660 The Supplicate might slash D that is nothing like a tax. 02:22.200 --> 02:27.490 So we are going to use this separate to even be let's slash to. 02:28.760 --> 02:31.480 And let me aside to some data. 02:33.360 --> 02:33.750 All right. 02:34.650 --> 02:37.420 So fine reading then. 02:37.740 --> 02:41.200 Now let us verify what data is available in this data. 02:41.210 --> 02:41.670 Read even. 02:42.820 --> 02:46.810 Before that, let me show you what is the type of this idea. 02:48.220 --> 02:51.670 So that will be kind of find us data free object. 02:52.990 --> 02:57.280 Let's see if we want to display first few records of this data. 02:58.210 --> 02:59.920 You can use the head function. 03:01.700 --> 03:04.070 And you will be able to see this is our first. 03:04.670 --> 03:06.200 This is our second column. 03:06.770 --> 03:10.460 And by default, the very first throw, it has taken its index. 03:10.850 --> 03:14.350 So this is one of the advance find reading functions are available. 03:14.480 --> 03:18.620 Now, one of the very important data analysis, library kindness. 03:19.820 --> 03:25.640 If you want to get more information related to this Netafim, you can use like Neeta not. 03:27.230 --> 03:31.430 So it will give us the information that how many rows and how many columns have there. 03:32.000 --> 03:36.320 So will be 2000 rows are available in this data frame objects. 03:36.410 --> 03:37.970 And there will be a two column. 03:39.430 --> 03:44.500 Now, suppose out of this particular fight, some record I want to extricate. 03:45.040 --> 03:50.140 And those records, I just want to say it to some other fine help picking. 03:51.050 --> 03:55.090 So was this particular labels are either negative or it will be a positive. 03:55.510 --> 03:58.660 So let's just extract out all those positive elements. 04:00.090 --> 04:10.080 And to extract a positive limit, I can just simply select data labor and let's say it's equal and to 04:10.800 --> 04:11.890 equal to those. 04:12.750 --> 04:14.580 So that will be compared with the. 04:15.330 --> 04:18.480 And whenever the values pass, it will return. 04:18.660 --> 04:18.980 True. 04:19.260 --> 04:27.600 And we are just going to grab all the data that the label will be equal as that is nothing but a positive. 04:28.650 --> 04:30.630 Let me assign it to some other variable. 04:30.660 --> 04:31.080 Let's see. 04:32.160 --> 04:33.120 Beat your --. 04:33.700 --> 04:39.450 So inside the US variable, now we have all the records that the label is positive. 04:40.760 --> 04:42.110 Now, suppose if you're trying to. 04:44.270 --> 04:46.050 Display forcefield Akos. 04:48.670 --> 04:52.930 You will be able to see the only positive records exist. 04:53.590 --> 04:58.900 Now, suppose I want to write this all positive that goes into some other files. 05:00.250 --> 05:04.930 So earlier we use this arena in this cozy SB function. 05:05.050 --> 05:09.880 Now we are going to use this to underscore CSC function. 05:12.060 --> 05:13.970 And let me give you the file name. 05:14.640 --> 05:20.740 Let's say filing will give like a force and how I want to write it. 05:20.850 --> 05:24.780 So my sceptical will be, let's say, less. 05:25.530 --> 05:27.870 You can use some other separator also. 05:29.440 --> 05:33.610 Let me run it and we can verify it from here. 05:34.980 --> 05:38.910 You can see past by God created if you just. 05:39.940 --> 05:45.920 If you can double click on it, you'll be able to download it and we can really, you know what? 05:46.120 --> 05:46.900 Local editor. 05:48.270 --> 05:49.970 So it's taking good amount of time. 05:53.360 --> 05:58.420 Open, let me go on with a very simple detail, like, let's say not pay. 05:59.740 --> 06:00.070 OK. 06:00.400 --> 06:01.990 And you can see the label. 06:02.890 --> 06:05.320 So label is always people song. 06:06.530 --> 06:08.110 You wont be able to get any other. 06:08.810 --> 06:10.790 So you can see everything will be yours. 06:11.090 --> 06:15.470 So that is how easily you can write Edyta inside the fight. 06:16.010 --> 06:19.150 Now, suppose this appears Beilby created the same fight. 06:19.220 --> 06:26.150 We want to privily so far that we are going to use this same lead in the school CSP function. 06:27.350 --> 06:36.350 And now the new file name I want to give you like a B or S, let's say separate, that will be Celesta. 06:37.600 --> 06:41.560 And let me assign it to some Alan. 06:44.200 --> 06:47.410 And if they try to display this later when. 06:51.130 --> 06:54.370 All right, so all only positive Labor's got up here. 06:56.470 --> 07:04.570 But now one thing you may observe that there will be one more extra column headed why this happens. 07:06.590 --> 07:11.460 Because while writing those file, this indexed column also got written. 07:12.050 --> 07:14.210 So why is reading what we can do? 07:14.360 --> 07:20.630 We can apply one more argument like or we can use like a very first column as the index itself. 07:20.780 --> 07:25.700 So in next column, let's say zero column will be indexed. 07:26.570 --> 07:27.980 So let me add only. 07:30.230 --> 07:33.800 Our largest pipit inside the really a relatively small one. 07:35.250 --> 07:37.210 Let me put in down. 07:39.770 --> 07:47.180 All right, so now you can see all those unnamed column zero column will become on the index and everything 07:47.180 --> 07:48.200 will be positive. 07:49.500 --> 07:49.910 All right. 07:49.940 --> 07:50.650 So that is out. 07:50.660 --> 07:53.930 You can read such as CSB, PSV kind of file. 07:55.620 --> 07:56.940 And that's all about this video. 07:57.060 --> 07:58.230 See you in the next video. 07:58.290 --> 08:00.810 We will see some more stuff related to tax.