1 00:00:06,880 --> 00:00:07,530 Hey everyone. 2 00:00:07,820 --> 00:00:14,290 So in the last week we have learned about the adding and deleting of rows and columns in this video. 3 00:00:14,290 --> 00:00:18,460 We are going to London how we can access any element in our data. 4 00:00:19,390 --> 00:00:28,870 So first if we take this one like this the iPhone that is we have fun if you want to access any column 5 00:00:28,870 --> 00:00:35,850 like this horses then accessing the columns is very simple just the F and past the columns. 6 00:00:35,890 --> 00:00:38,130 Make sure you pass the columns in quotes. 7 00:00:38,380 --> 00:00:39,620 Then you will get that one. 8 00:00:39,640 --> 00:00:42,760 Sorry this DLF is dead. 9 00:00:42,790 --> 00:00:44,450 The smiley face is different. 10 00:00:44,530 --> 00:00:47,080 So here you get the horses. 11 00:00:47,080 --> 00:00:53,820 If you did not plastic quote There you will get an awful vise no define because white is not any ready 12 00:00:53,850 --> 00:00:57,910 but its Jester character denoting any column. 13 00:00:58,630 --> 00:01:06,160 So that's how you can access the elements of any column to pass a story to access any element of road 14 00:01:06,160 --> 00:01:08,490 like if I want to access this E. 15 00:01:08,920 --> 00:01:14,940 So I just not simply use like this A here I've been good at. 16 00:01:15,880 --> 00:01:20,530 And if you do this one without court it will still get it. 17 00:01:20,830 --> 00:01:22,000 So how to access Declan. 18 00:01:23,290 --> 00:01:31,120 So that one is something like you have to use dot A.C. next 10 for location and then you do that one 19 00:01:32,260 --> 00:01:40,450 you will get the column that is this one so all the sordid detail all the rows are same. 20 00:01:40,450 --> 00:01:42,430 So we will use this one for the effort. 21 00:01:43,070 --> 00:01:47,580 Hey you get one to two for one to table for W X Y and Z. 22 00:01:47,890 --> 00:01:51,250 So that's how you can access any row. 23 00:01:51,340 --> 00:01:58,520 Now one more thing if you want to access a neutral by using the numeric index is like fun and you try 24 00:01:58,540 --> 00:01:59,070 this one. 25 00:01:59,110 --> 00:02:00,570 You will get better. 26 00:02:01,360 --> 00:02:07,120 So for that you need to use an eye here I LLC you will get five six seven eight. 27 00:02:07,150 --> 00:02:12,920 That is discipline if you try to run the F here. 28 00:02:13,120 --> 00:02:14,050 So this is zero. 29 00:02:14,050 --> 00:02:14,880 This is fun. 30 00:02:14,920 --> 00:02:17,010 That is five six seven eight that you got there. 31 00:02:17,440 --> 00:02:20,950 If you need a you need to pass zero. 32 00:02:20,980 --> 00:02:29,520 So that's all you can access they rose by using numeric indexes and this is about that one. 33 00:02:29,630 --> 00:02:35,420 And if you tried this method for indexes like simply this one you will get added because the indexes 34 00:02:35,420 --> 00:02:38,880 are not for 40 columns they are just for digit rules. 35 00:02:39,950 --> 00:02:47,180 So now we got the idea that how you can access any element of row and column with every element of truth. 36 00:02:47,300 --> 00:02:51,740 Now what if you just want to access any particular element like this fight. 37 00:02:52,610 --> 00:03:00,030 So for that we use something like the F dot LLC if you do this one without DeLuise network. 38 00:03:00,050 --> 00:03:01,260 Let me try first. 39 00:03:01,280 --> 00:03:03,090 You will get at it. 40 00:03:03,140 --> 00:03:08,960 So for that we first need to like if we want to access this one we need this rule and this column. 41 00:03:08,960 --> 00:03:15,350 So we simply write D comma and by here but without the DOT DeLuise you will get there. 42 00:03:15,710 --> 00:03:18,320 You need to pass DOT DeLuise also there. 43 00:03:18,830 --> 00:03:20,020 Now you will get five. 44 00:03:21,290 --> 00:03:25,820 So that's how you can access every element like if you want to access nine. 45 00:03:25,820 --> 00:03:32,690 Just change Dean to e you will get nine if you want to access zero just change right into Z you will 46 00:03:32,690 --> 00:03:34,260 get to zero. 47 00:03:34,310 --> 00:03:38,700 So let me stay on this good data 48 00:03:42,710 --> 00:03:43,830 this one small. 49 00:03:44,600 --> 00:03:46,170 So here we get to nine. 50 00:03:46,670 --> 00:03:53,770 And if you use here the numeric value of that one you will get added Because we are not using now you 51 00:03:53,920 --> 00:04:01,430 see if you write I really see here you will still get data so to access any particular element you just 52 00:04:02,690 --> 00:04:06,320 need to do this one and you can only use this method. 53 00:04:06,950 --> 00:04:09,300 So here three a bite. 54 00:04:09,650 --> 00:04:13,980 So that's how you can access every element in a row and in a column. 55 00:04:14,150 --> 00:04:16,850 And also the rows and columns completely.