WEBVTT 00:00.960 --> 00:01.710 Welcome back. 00:01.710 --> 00:08.280 Now in this election year this talk about CSU find juice on file Excel is filing the 60 filing and also 00:08.320 --> 00:14.820 audits almost a printed file or maybe semicolons a printed file so there are different neighbor files 00:14.850 --> 00:15.780 that we need to blame. 00:16.620 --> 00:19.920 And remember I'm just taking 10 days of data. 00:19.920 --> 00:24.700 Usually if someone tried to audit they might take a 360 five days of data. 00:24.900 --> 00:31.050 Or maybe you are trying to work on a country population file that can be a big data so thing from a 00:31.050 --> 00:37.530 perspective all of them say donor because I usually go to a lot of caution that we can perform everything 00:37.590 --> 00:38.640 on Excel. 00:38.640 --> 00:43.400 Still why we are using pine nuts thing from the perspective of a say donor. 00:43.890 --> 00:49.830 So when we do some clicks on a website and they automatically calculate all the different type of thing 00:50.190 --> 00:51.840 how do that happen. 00:51.990 --> 00:57.180 Because maybe a farm does a script on maybe some different type of script is already running in the 00:57.180 --> 00:59.990 background so that is done automatically. 01:00.000 --> 01:04.350 There is no real human that is doing calculation on an Excel sheet. 01:04.350 --> 01:10.620 They have done everything automatic in their web framework or maybe they have created an EPA send a 01:10.620 --> 01:14.510 request to farm does do some calculation and take response. 01:14.880 --> 01:17.690 So that's the main reason that we are learning this. 01:17.700 --> 01:20.610 So once you have come for the well you know what you are going to do. 01:20.910 --> 01:23.560 You try and tested on Jupiter in your book. 01:23.610 --> 01:30.320 See if that code and create script dot one and then you can upload it on solar so that can be done. 01:30.330 --> 01:36.180 Now hold that give you enough motivation and let us get back to our top downloadable and create a new 01:36.180 --> 01:39.090 cell and just open my Jason File. 01:39.360 --> 01:45.420 Let me clear data from three binders and then read JS on method and then the file name 01:52.250 --> 01:54.400 same follows with my days on file. 01:54.510 --> 02:01.790 Per day you can see I'm getting a different result from what I was expecting from my CSB an excel file. 02:01.790 --> 02:04.810 Hey you can see the sequence of column is not dead. 02:04.910 --> 02:08.750 Since we have a defined and label column there is not a big issue. 02:08.940 --> 02:10.650 But why this is happening. 02:10.910 --> 02:13.350 Because Jason is just like additionally. 02:13.490 --> 02:19.450 And if you remember additionally you don't have sequence or indexes so they are known with the key. 02:19.460 --> 02:21.980 So this is the key and this is their value. 02:22.580 --> 02:29.900 Let me open a Jason File so this is our Jason File looks you can see this is our dictionary in which 02:30.230 --> 02:32.450 these are keys and these outer value. 02:32.780 --> 02:36.380 And this is another additionally and that are stored in our type of list. 02:36.710 --> 02:43.280 So there is an open list and then all the elements are additionally here you will see 10 different dictionaries 02:43.350 --> 02:44.380 with all the data. 02:44.750 --> 02:47.660 And as you know there is no sequence for our dictionary. 02:47.660 --> 02:49.160 So we are getting the result. 02:49.970 --> 02:55.640 The other thing that I want to talk about is how do my files that does how do my job are download book 02:55.640 --> 02:56.030 result. 02:56.030 --> 03:02.740 Note that this was the header because I've just given the result I've given just 11 fields. 03:02.780 --> 03:05.340 How do they know that this was my head out. 03:05.360 --> 03:07.250 And these are all my fields. 03:07.250 --> 03:12.190 So we have a barometer here which is quite header and which is by default to. 03:12.290 --> 03:17.640 That means they will come to our first line as a and if I try to make header as none. 03:17.690 --> 03:20.330 They will definitely include that in the value at 03:23.840 --> 03:28.090 let me execute this one. 03:28.180 --> 03:29.590 You can see our result now. 03:29.800 --> 03:33.260 So what actually happened is I just did a header as none. 03:33.310 --> 03:36.350 Now they're considering them as the other value. 03:36.370 --> 03:40.170 So now we have 10 different values which was different. 03:40.240 --> 03:44.110 But I have five tried to remove this header which is by default. 03:44.110 --> 03:45.120 That's true. 03:45.140 --> 03:47.670 And I need to execute both the files. 03:47.980 --> 03:49.520 You can see we are back with the design. 03:49.850 --> 03:52.230 And you can play with Jupiter upside down. 03:52.330 --> 03:56.430 So whenever you want to edit any line you just need to jump on that line. 03:56.470 --> 04:03.160 I hope you understand about of field also Excellency as we find follows the same rule but Jason File 04:03.220 --> 04:08.520 we have key in the loop here so they can radically differentiate ligament alert this too. 04:08.620 --> 04:16.770 And let me work more with my excel and file so all you have to do is Didi now I have a part. 04:16.820 --> 04:23.940 What if I try to remove this index and try to use data as index since I know this is not useful for 04:23.940 --> 04:24.290 me. 04:24.300 --> 04:27.240 The 0 1 2 all I need is dead. 04:27.390 --> 04:28.400 And then there is art. 04:28.650 --> 04:29.760 So we can do that. 04:29.820 --> 04:37.140 We can change this date into our index that is into our old field so to perform that we just need to 04:37.140 --> 04:44.340 do a simple task create a data frame and then use a method as set index and then positive value here 04:44.410 --> 04:49.170 and my value will be Dixons I want my indeed to be treated as index. 04:49.200 --> 04:50.850 Now check our output. 04:51.060 --> 04:54.510 Hey you guys you've seen now you can compare both the result. 04:54.510 --> 05:00.310 Now we have dead as our index and we're only dealing with five major columns. 05:00.450 --> 05:03.480 Sixth is our date but it is treated as index. 05:03.480 --> 05:05.430 We don't have the 0 1 2 3. 05:05.430 --> 05:08.040 We have our index as one booty. 05:08.100 --> 05:10.560 You can also boss different type of values. 05:10.560 --> 05:15.870 So if I tried to make these as index it logged fine. 05:15.870 --> 05:23.630 Now my data is included in our column and this data is working as index so you can treat them accordingly. 05:23.700 --> 05:27.390 The next thing I want to talk about is you can also check their shape. 05:27.610 --> 05:31.750 So if you remember while doing math we used to do math took shape. 05:31.750 --> 05:33.990 We can also lose shape of our table. 05:33.990 --> 05:35.750 So let me do that. 05:35.850 --> 05:37.860 You can see it's currently 10 by 6. 05:37.860 --> 05:40.190 That means 10 rows and six column. 05:40.490 --> 05:42.750 But if I tried to bring my D F to 05:45.810 --> 05:49.320 this is printing the default deal because we are not saving this. 05:49.320 --> 05:50.520 We are just printing that. 05:50.850 --> 05:56.610 So if I want to see this result all I have to do is either save in a new variable that is my new data 05:56.610 --> 06:03.230 frame or just overwrite my previous variable I tried to bring the F two. 06:03.380 --> 06:05.320 You can see this is the permanent change. 06:05.750 --> 06:08.240 Earlier I was not being the permanent change. 06:08.240 --> 06:10.510 I was just trying to change these thing. 06:10.560 --> 06:15.770 Test them out bring them but I was not storing them in my variable. 06:15.770 --> 06:18.540 I hope aloud things are looking fine. 06:18.560 --> 06:23.750 This might be confusing but with practice you can easily extend them. 06:23.750 --> 06:28.990 Also I'm attaching all these files in the resource section so you can play with them. 06:29.030 --> 06:32.830 Let me create a new cell and then play with my DLC files. 06:35.240 --> 06:43.420 Remember whenever we're going to need any DST file we need to use CSP and CSP as comma separated values 06:45.210 --> 06:47.700 before needing both the text files look at them. 06:47.760 --> 06:50.000 Here I am digging comma separated file. 06:50.040 --> 06:55.260 You can see all the values as a play date with the help of comma and the second DST file that I'm taking 06:55.530 --> 06:58.070 is separated with the help of semicolon. 06:58.140 --> 07:02.590 So that is a barometer called separate and by default a comma. 07:02.900 --> 07:06.050 So if I tried to run this file this would run perfectly. 07:06.150 --> 07:17.860 So make me lose my traffic dot com as. 07:17.940 --> 07:23.440 You can see I was able to get my result for my degree in food because here we have a part of me stuck 07:23.450 --> 07:26.020 on a ship and have a value by default. 07:26.020 --> 07:26.880 Best karma. 07:27.270 --> 07:31.180 So they just separated all the commas and give us the reason. 07:31.490 --> 07:35.150 But if I tried to run the semicolon failed you'd get an error. 07:35.250 --> 07:45.670 Let me do that. 07:45.760 --> 07:50.110 You can see what I'm getting I'm getting an index and then wonder. 07:50.140 --> 07:53.770 This is the complete rule and all the results in a complete rule. 07:53.830 --> 08:00.490 So there are 10 different draws and one column so that recognizing this as a complete column so I need 08:00.490 --> 08:06.380 to add up that only took one sip and then pass on my semicolon. 08:06.400 --> 08:11.450 Now if I died to execute this one you can see I was able to get the result. 08:11.710 --> 08:14.690 So that's how we play with different parameters. 08:14.710 --> 08:19.850 The next thing is to read our file directly from online source in the next left children historically 08:19.850 --> 08:22.680 use our online links and perform the same.