1 00:00:05,810 --> 00:00:13,190 Hey everyone soon the last video we have learned the concatenation in the studio we will covering the 2 00:00:13,190 --> 00:00:17,210 marching for that also we need some example dictionary. 3 00:00:17,360 --> 00:00:22,580 And this time we just tightly defined the data types that is being taught. 4 00:00:23,000 --> 00:00:23,990 Data frame 5 00:00:26,720 --> 00:00:34,970 and David going to do the frame and here the values like a dictionary. 6 00:00:34,970 --> 00:00:42,380 And in that one we have a key element that is key. 7 00:00:42,710 --> 00:00:54,660 And for one it's given it has values like One two three then we have another one that is like eight. 8 00:00:54,980 --> 00:00:56,270 And it has value. 9 00:00:56,370 --> 00:01:07,020 Three four similarly be with values like five six seven. 10 00:01:07,150 --> 00:01:17,050 And this is with the seven now copy this whole command C and then come on V change the values if you 11 00:01:17,050 --> 00:01:19,820 want to like eight there. 12 00:01:19,840 --> 00:01:20,490 That's OK. 13 00:01:20,500 --> 00:01:28,750 Now four nine two and one and these two men. 14 00:01:29,650 --> 00:01:32,160 And this one also be keyword. 15 00:01:33,280 --> 00:01:35,600 And now change the indexes. 16 00:01:35,640 --> 00:01:40,800 So right column that is this one see and this one. 17 00:01:40,800 --> 00:01:51,000 Be sure to know if you've been D F one you will get this one and F to disband and this is a little different. 18 00:01:51,050 --> 00:01:52,590 Maybe it's from previous one. 19 00:01:52,700 --> 00:01:53,810 This is deserve to know. 20 00:01:54,560 --> 00:02:04,220 So this is the abridged defunded gay Kevin C. And now merging is very easy even you have to just write 21 00:02:04,270 --> 00:02:05,480 Billy don't much. 22 00:02:05,480 --> 00:02:08,330 There is this index for this one. 23 00:02:08,330 --> 00:02:10,270 And then panties nine panties. 24 00:02:10,280 --> 00:02:18,620 Like the previous one concatenation we require these brackets and in DMV the IDF one and then we do. 25 00:02:19,130 --> 00:02:26,510 But in case of March if you press shift then you will see here that you required the left right. 26 00:02:26,510 --> 00:02:27,090 Both. 27 00:02:27,410 --> 00:02:29,710 So wouldn't it be denoted by hair backwards. 28 00:02:29,720 --> 00:02:34,170 We just required the DFL on the left and left then on the right. 29 00:02:34,250 --> 00:02:35,740 Then we have something. 30 00:02:35,780 --> 00:02:40,130 This is how that we have also learned in joining. 31 00:02:40,130 --> 00:02:47,180 After that we have this on which have some particular key here and then left us by default. 32 00:02:47,360 --> 00:02:50,760 But this required any value that is known as key. 33 00:02:50,850 --> 00:02:55,530 That's where we have taken the column value here. 34 00:02:55,580 --> 00:02:59,930 Now here if you do this thing you will get this. 35 00:02:59,940 --> 00:03:10,600 Here the Bundy F2 and the the how is by default the input. 36 00:03:10,950 --> 00:03:12,500 That is this one. 37 00:03:12,690 --> 00:03:16,230 And here we get it because of Monday. 38 00:03:16,440 --> 00:03:18,470 Now we will get this one same. 39 00:03:18,810 --> 00:03:25,290 And then here we have the own which is again the key. 40 00:03:25,380 --> 00:03:25,830 Fun. 41 00:03:25,860 --> 00:03:27,410 That is the common in both. 42 00:03:27,450 --> 00:03:38,640 You will get disciplined and if you do something like define this key in the last two you 43 00:03:41,930 --> 00:03:45,900 and do the thing you will get the same. 44 00:03:46,190 --> 00:03:47,690 So it doesn't matter what you do. 45 00:03:47,750 --> 00:03:55,860 You have defined this key but if you define both of them in the last like here and let me move this 46 00:03:55,880 --> 00:04:02,480 one you will get them in middle after the first one where you have defined like a B. 47 00:04:02,510 --> 00:04:03,350 Then keep on. 48 00:04:03,650 --> 00:04:05,530 Then you will get the March 1. 49 00:04:05,750 --> 00:04:13,820 Here on this one and if you have more than one keys like if I make another one that is and one more 50 00:04:13,820 --> 00:04:14,060 thing. 51 00:04:14,090 --> 00:04:15,730 If the elements of these are different. 52 00:04:15,730 --> 00:04:16,610 Like here. 53 00:04:16,640 --> 00:04:20,900 If I have four and you tried to do that you will not get that one. 54 00:04:20,900 --> 00:04:23,020 That is the different element there. 55 00:04:24,050 --> 00:04:32,090 And if you do this more like outer you will get this one where the elements for the different one are 56 00:04:32,090 --> 00:04:38,420 and then like in the first one we have four but in DFT we do not have four. 57 00:04:38,420 --> 00:04:42,770 So here we have CND net in India after we have three. 58 00:04:42,890 --> 00:04:50,030 So for three we have the values of Kiki even that is nine and nine but of the Seven are men. 59 00:04:50,150 --> 00:04:58,700 So that's worked for the outer is and if you do the left then only the left key that is for will be 60 00:04:58,700 --> 00:04:59,500 considered right. 61 00:04:59,500 --> 00:05:07,340 Give a lot we consider if you do write you will get only the right key with the element the left key 62 00:05:07,350 --> 00:05:09,480 that is for will not reconsider. 63 00:05:09,990 --> 00:05:12,390 So that's the key here. 64 00:05:12,630 --> 00:05:15,980 And let me make them against him now. 65 00:05:15,990 --> 00:05:17,100 Copy this one. 66 00:05:17,100 --> 00:05:17,560 Come on. 67 00:05:17,560 --> 00:05:18,150 See. 68 00:05:18,190 --> 00:05:22,160 And there we go with this one again. 69 00:05:23,760 --> 00:05:29,320 So come on we know that home just this part. 70 00:05:29,340 --> 00:05:30,880 Come on. 71 00:05:30,900 --> 00:05:32,220 See. 72 00:05:32,430 --> 00:05:33,130 Come on. 73 00:05:33,600 --> 00:05:34,710 And in this one also. 74 00:05:34,710 --> 00:05:40,430 Come on beat and change this one to keep to change the element. 75 00:05:40,530 --> 00:05:44,340 So it will be looked like changed. 76 00:05:44,460 --> 00:05:46,580 Now if you do that one you will get this round. 77 00:05:46,590 --> 00:05:48,430 So that is five two three. 78 00:05:48,440 --> 00:05:51,060 They both Dickies here but this one is here. 79 00:05:51,140 --> 00:05:53,520 So if you have noticed. 80 00:05:53,520 --> 00:05:59,570 So we have just Kiki one that is first accessed or so it was terminated on the third position. 81 00:05:59,610 --> 00:06:06,920 So here on third position after that we have key to this one and this key too for the F two also here. 82 00:06:06,960 --> 00:06:09,250 So why did you not get merged. 83 00:06:09,480 --> 00:06:13,680 Because we did not have passed that one here. 84 00:06:13,680 --> 00:06:20,850 If we want to march the board we have to do something like this one postie back at first and then in 85 00:06:20,850 --> 00:06:25,910 that bracket pass the key to and David go with this one.