1 00:00:05,950 --> 00:00:11,170 Hey everyone in this video we are going to learn about joining joining in something when we need to 2 00:00:11,410 --> 00:00:15,490 join two or more data frames into one than we used to join. 3 00:00:15,850 --> 00:00:21,490 Similar to joining we have two more little concept that is merging and concatenation that are also used 4 00:00:21,490 --> 00:00:24,640 for the same purpose but something different. 5 00:00:25,120 --> 00:00:31,940 So that's what we are going to learn later to know we have learned all the concepts about the data frame 6 00:00:31,990 --> 00:00:35,170 but not the something that can join two or more different. 7 00:00:35,590 --> 00:00:42,190 So here we will take example of two data frames that are built by using two dictionaries that are excellent 8 00:00:42,220 --> 00:00:43,420 and waiver. 9 00:00:43,540 --> 00:00:49,370 So here we have X1 and any random dictionary like a column name. 10 00:00:49,480 --> 00:00:52,220 And then the values like One two three. 11 00:00:52,330 --> 00:00:55,120 Then we have something B. 12 00:00:55,810 --> 00:00:59,250 And the values will be like five six and seven. 13 00:01:00,670 --> 00:01:06,580 Now for y we have seen so we have different column names. 14 00:01:06,640 --> 00:01:08,820 And here we have three four five. 15 00:01:10,810 --> 00:01:12,940 And then we have these. 16 00:01:13,780 --> 00:01:19,630 Here we have this one like two three five or six. 17 00:01:20,080 --> 00:01:21,640 So here we go with this one. 18 00:01:21,640 --> 00:01:24,860 Now we will convert these two in to redefine. 19 00:01:24,940 --> 00:01:32,050 That is x and y so to convert that one just try to BD dot here. 20 00:01:32,070 --> 00:01:32,830 Data from 21 00:01:36,030 --> 00:01:38,160 F capital and three. 22 00:01:38,440 --> 00:01:46,570 And in that one positive parameters that is first X1 and the wide indexed like here we have something 23 00:01:46,570 --> 00:01:55,720 random that is B B2 then between make sure these are indexes. 24 00:01:55,750 --> 00:01:59,410 So they require courts also. 25 00:01:59,590 --> 00:02:06,850 Otherwise it will show you error just copy this for now and paste in this one and just change y one. 26 00:02:07,270 --> 00:02:09,030 So here we are done with Dedmon. 27 00:02:09,030 --> 00:02:15,790 Now if you write X1 you get this and via you get decision not to join these means like I have this one 28 00:02:15,850 --> 00:02:19,810 and this one I also get that one here. 29 00:02:19,990 --> 00:02:27,130 So to join that we have a simple matter that is X or join the one that you need first like here on the 30 00:02:27,130 --> 00:02:36,990 left and then in parentheses we passed the one that we need on right like y you will get this one Hey 31 00:02:37,070 --> 00:02:43,010 I have one two three four five six seven then I have three four five and two three six here if you press 32 00:02:43,010 --> 00:02:48,680 shift tab here you will find different bunch of options like how that is the one we are going to using 33 00:02:49,100 --> 00:02:56,390 these joining and concatenation is so how is something if you write that here you have four types of 34 00:02:56,390 --> 00:03:02,780 options that is left and in Melbourne's index how 35 00:03:06,080 --> 00:03:08,590 sorry I not have a comma there. 36 00:03:08,690 --> 00:03:17,920 Now this one and one thing here we have this same because it this index values that is B1 B twenty three. 37 00:03:18,050 --> 00:03:18,950 So here. 38 00:03:18,950 --> 00:03:23,750 Now the default options like left then we have right. 39 00:03:23,780 --> 00:03:30,140 Notice this one this is the same that we have something known as in this one is by default if you do 40 00:03:30,140 --> 00:03:38,030 not choose how lender in it is by default then we have one out there so then the indexes are same all 41 00:03:38,030 --> 00:03:39,890 this will be seen. 42 00:03:39,890 --> 00:03:49,100 And now if I do something like change this one in two we do hear this one before and this one five and 43 00:03:49,100 --> 00:03:57,020 do something like this joint you will get this one here you have one two three five six seven then we 44 00:03:57,020 --> 00:04:05,240 have C with indexed B1 and the values in X that do that have before and three five and then and similarly 45 00:04:05,370 --> 00:04:14,160 invite we have twenty three men if you know change this one in two if not you will get this one the 46 00:04:14,160 --> 00:04:22,980 only one that have same index is if you do this one like left you will get disciplined only those values 47 00:04:22,980 --> 00:04:25,430 that like this one is the left. 48 00:04:25,530 --> 00:04:33,450 And here this have indexed B1 p2 p3 so you will find only P1 between P3 that's left when this left stands 49 00:04:33,450 --> 00:04:41,830 for the low we can see data frame on the left if you convert this one into right you will find only 50 00:04:41,850 --> 00:04:45,540 overwrite like P1 before and faith indexes or this. 51 00:04:46,620 --> 00:04:50,050 And if you do not have any index in common like. 52 00:04:50,370 --> 00:05:00,390 If I make this one before this one B5 and this one B6 and do something like this one you will get only 53 00:05:00,390 --> 00:05:08,280 this one values in X will be met because knowing next is seen so here it is right he finds that which 54 00:05:08,280 --> 00:05:12,090 index are going to be covered here on the output. 55 00:05:13,260 --> 00:05:14,700 So this is about the joining. 56 00:05:14,700 --> 00:05:20,960 And this one is over really easy and little concept just X do not join in panties. 57 00:05:21,060 --> 00:05:22,140 The one on the right. 58 00:05:22,170 --> 00:05:25,630 And if you want these then you can add these also. 59 00:05:25,800 --> 00:05:33,720 If you do like this one you do not pass and even then dinner one by default and that will not equal 60 00:05:33,720 --> 00:05:36,210 to way. 61 00:05:36,420 --> 00:05:40,620 Now we are done with this one and we will continue in the next video.