1 00:00:00,740 --> 00:00:08,240 In this video, we will do one more question on a Republican, so here you can see for why try to search 2 00:00:08,990 --> 00:00:11,720 Mobile's mobile phones. 3 00:00:17,110 --> 00:00:25,300 And you can see different mobile phones here and different sellers prices, as you have seen in the 4 00:00:25,300 --> 00:00:25,900 last four years. 5 00:00:26,350 --> 00:00:28,390 But in this video, what we will do more. 6 00:00:30,940 --> 00:00:32,830 If you go below. 7 00:00:42,300 --> 00:00:51,150 You can see here, let me submit here, you can see we are getting such touches, used phones, smartphone, 8 00:00:51,990 --> 00:01:01,560 smartwatch, iPhone, and so these are the latest searches for the keyword that you are searching and 9 00:01:01,560 --> 00:01:02,400 this website. 10 00:01:02,460 --> 00:01:05,130 So in this video, we will lose web scrapping. 11 00:01:06,030 --> 00:01:17,070 Like if I search mobile phones, then we will collect all the data from Usborne Smartphone and all the 12 00:01:17,070 --> 00:01:20,310 available search drums here. 13 00:01:20,400 --> 00:01:20,670 Right. 14 00:01:20,700 --> 00:01:26,010 If we have six or seven latest search terms, then the power to read. 15 00:01:26,190 --> 00:01:33,660 First of all, it will go and collect the data for the U.S. phone and we will get all the data that 16 00:01:33,660 --> 00:01:35,550 is available in this page. 17 00:01:35,830 --> 00:01:38,120 Right, the whole page. 18 00:01:38,670 --> 00:01:45,630 And then again, it will go for the U.S. phone and then again, collect all the data and then we will 19 00:01:45,630 --> 00:01:50,940 merge all this data to build the complete data set. 20 00:01:51,090 --> 00:01:51,450 Right. 21 00:01:51,450 --> 00:01:56,230 And then you can utilize that data set for further analysis. 22 00:01:56,310 --> 00:01:57,310 Let's go to the power. 23 00:01:57,570 --> 00:02:02,220 Ed and I need to. 24 00:02:05,820 --> 00:02:08,550 Get this in. 25 00:02:10,050 --> 00:02:10,530 Coffee. 26 00:02:11,840 --> 00:02:14,750 And then I need to go to the power, Keri. 27 00:02:17,210 --> 00:02:18,470 getData went. 28 00:02:20,950 --> 00:02:27,590 And here I need to list like, OK, so here you can see let's click here. 29 00:02:28,150 --> 00:02:28,840 Table seven. 30 00:02:30,300 --> 00:02:31,250 Table six. 31 00:02:34,030 --> 00:02:34,870 For. 32 00:02:39,630 --> 00:02:46,630 So here you have seen that we are not able to get the data that that belonged to the alleged. 33 00:02:48,090 --> 00:02:54,360 So what we have to do now here is you can see one option at table using examples like here. 34 00:02:58,020 --> 00:02:58,920 Scroll down. 35 00:03:01,000 --> 00:03:08,770 So here you can see the satellite, the first one is right here used. 36 00:03:10,970 --> 00:03:12,650 Used font's this one. 37 00:03:14,940 --> 00:03:19,620 And then the second one is smartphone, you can see. 38 00:03:23,980 --> 00:03:25,030 Smartphone's. 39 00:03:27,220 --> 00:03:31,980 So that the power clearly recognize this table. 40 00:03:36,530 --> 00:03:44,780 And if you click here, see, after typing in two places, like in the first row, just fine then in 41 00:03:44,780 --> 00:03:53,360 the second row smartphone, and if you click somewhere after three or four rows, it will automatically 42 00:03:53,360 --> 00:03:59,910 recognize all the features that are available for the such as this table. 43 00:03:59,990 --> 00:04:00,290 Right. 44 00:04:00,560 --> 00:04:08,040 So you have seen here at the summit, so here you have seen the last iPhone 11 projects. 45 00:04:08,060 --> 00:04:11,630 So you can see here is a different level from X-Rite. 46 00:04:13,730 --> 00:04:24,910 So we need to name this column, for example, a. related products click OK. 47 00:04:29,310 --> 00:04:32,910 And we just need to load. 48 00:04:36,050 --> 00:04:38,540 So if you click again to the Tascam data. 49 00:04:42,690 --> 00:04:48,390 And here you can see these are the related products, right? 50 00:04:50,700 --> 00:04:53,020 So now we need to change the name of the table. 51 00:04:53,580 --> 00:04:57,390 This is how we can save some products. 52 00:04:59,140 --> 00:05:01,320 Now we need to add one parameter here. 53 00:05:03,060 --> 00:05:12,000 Just click on the managed barometer new parameter, and the name of the perimeter is like a search 54 00:05:14,670 --> 00:05:17,100 and you can find any description here. 55 00:05:18,920 --> 00:05:20,900 The type is text. 56 00:05:22,630 --> 00:05:24,860 And just that any value, right? 57 00:05:25,000 --> 00:05:28,960 And here we can ride like mobiles like, OK. 58 00:05:33,380 --> 00:05:40,400 So this is part of this is the perimeter, right, and now we need to associate this search products 59 00:05:40,430 --> 00:05:42,190 with this product label. 60 00:05:42,620 --> 00:05:45,950 So click here, go to the IT Ed. 61 00:05:48,310 --> 00:05:50,350 And here we have to use. 62 00:05:51,570 --> 00:05:54,810 This barometer, let me copy. 63 00:05:59,740 --> 00:06:03,700 It was Ed, so here you can see we can right here. 64 00:06:04,720 --> 00:06:07,540 We need to delete. 65 00:06:10,580 --> 00:06:16,470 No quotation and sign and the name of the barometer, such products. 66 00:06:16,560 --> 00:06:17,000 That's it. 67 00:06:17,660 --> 00:06:18,470 And we need to click. 68 00:06:18,470 --> 00:06:19,340 OK, then. 69 00:06:25,150 --> 00:06:32,290 And here you can see that previously we have written here mobile phones and now we have entered just 70 00:06:32,290 --> 00:06:35,680 mobiles and you will see this list. 71 00:06:35,890 --> 00:06:42,320 So this is we didn't get any such and such queries for the products mobile. 72 00:06:43,090 --> 00:06:49,270 So let's try to add mobile phones. 73 00:06:52,450 --> 00:06:53,830 And the products. 74 00:06:56,670 --> 00:07:01,470 So here you can see we are getting used on smartphones and some other stuff. 75 00:07:02,130 --> 00:07:10,160 Let me know what it is like cameras, a camera, and then we need products. 76 00:07:11,070 --> 00:07:18,180 So here you can see mini camera, Wi-Fi, camera, canon, SLR cameras, all different types of agents 77 00:07:18,200 --> 00:07:19,130 you can see here. 78 00:07:19,140 --> 00:07:19,420 Right. 79 00:07:20,010 --> 00:07:26,730 So now we are able to fetch the related search results. 80 00:07:26,730 --> 00:07:27,060 Right. 81 00:07:27,630 --> 00:07:38,790 And now our next task is we need to fetch the data automatically for all these related products and 82 00:07:38,790 --> 00:07:39,660 then we need to combine. 83 00:07:39,660 --> 00:07:39,990 Right. 84 00:07:40,860 --> 00:07:45,620 Like if you do this stuff manually, you just need to go first. 85 00:07:45,630 --> 00:07:52,680 You need to search Gamora and then you will see the latest search terms and then you need to go one 86 00:07:52,680 --> 00:07:53,280 by one. 87 00:07:54,000 --> 00:07:58,200 First, you have to search mini camera Wi-Fi and then collect all the reserves. 88 00:07:58,640 --> 00:08:02,210 Then again, you have to search for the thermal camera and so on. 89 00:08:02,220 --> 00:08:04,640 And at the end, you need to combine six reserves. 90 00:08:04,650 --> 00:08:10,170 If you have like 10 related products, you can estimate that how much time it will take. 91 00:08:10,440 --> 00:08:10,790 All right. 92 00:08:11,460 --> 00:08:15,620 So now we need, again, one query here. 93 00:08:15,870 --> 00:08:16,770 Let me. 94 00:08:17,960 --> 00:08:30,950 Copy and no, let's try to get data from the Web again, based and OK, so here you can see the table 95 00:08:30,950 --> 00:08:31,220 one. 96 00:08:34,880 --> 00:08:44,540 So we are interested in this column, column one, column two and some other informations. 97 00:08:46,860 --> 00:08:52,830 The prices are the areas prices is fine, so we can take the table one Lecoq. 98 00:08:56,670 --> 00:09:05,850 And in which columbarium does the skull of one and just pest control and column two, then column for 99 00:09:05,850 --> 00:09:13,440 then column five and then we are interested in for example. 100 00:09:14,620 --> 00:09:15,370 Feedback. 101 00:09:17,090 --> 00:09:23,270 This is the writing column, right, I guess this is writing as well, so you can choose any column 102 00:09:23,270 --> 00:09:26,510 according to your requirement, right. 103 00:09:26,510 --> 00:09:28,820 Click and remove other columns. 104 00:09:29,630 --> 00:09:37,930 OK, so at the end, we need these columns for all the religious touchstones. 105 00:09:38,210 --> 00:09:41,250 So just rename it like product. 106 00:09:43,160 --> 00:09:46,430 This is the price range. 107 00:09:53,540 --> 00:09:54,770 Are the quantity. 108 00:09:57,350 --> 00:09:58,940 This is the seller. 109 00:10:02,520 --> 00:10:09,230 And this one is the feedback, that's it, right? 110 00:10:09,300 --> 00:10:13,920 We can just rename it final product. 111 00:10:18,460 --> 00:10:23,020 And then we have to click to the advanced ed. 112 00:10:24,960 --> 00:10:32,730 And we need to write one function here, the function name is like a products as text. 113 00:10:35,980 --> 00:10:42,010 This is a function, so we need to use this function parameter here. 114 00:10:48,010 --> 00:10:51,050 Percent at best. 115 00:10:51,340 --> 00:10:53,330 The this is the name of the pyramid, right? 116 00:10:53,980 --> 00:10:59,010 So we just need to click down and now we need to click here. 117 00:11:01,710 --> 00:11:05,420 They the product stable, so we just need to click add column. 118 00:11:07,220 --> 00:11:16,520 And then we have to click invoked function, this one, so because we need to invoke effects and you 119 00:11:16,520 --> 00:11:22,490 can write any name, column name here, the function to read the name is final products, as you can 120 00:11:22,490 --> 00:11:24,200 see, effects, final product. 121 00:11:24,740 --> 00:11:29,630 And the name of the column is related products like Lecoq. 122 00:11:32,320 --> 00:11:41,800 So here you can see it has we are getting this result for every product like camera, so we are getting 123 00:11:41,800 --> 00:11:43,150 different cameras. 124 00:11:43,660 --> 00:11:48,920 So we are getting different results for each search term like DSL. 125 00:11:49,390 --> 00:11:53,670 And here you can see we are getting this information right here. 126 00:11:53,680 --> 00:11:55,240 You can see the smart Minea video. 127 00:11:57,430 --> 00:12:02,560 If I click the digital camera, you will see your 3.0 HD screen. 128 00:12:03,470 --> 00:12:06,960 OK, so we just need to click here. 129 00:12:07,900 --> 00:12:11,710 So in which column we are Indesit click on, OK. 130 00:12:14,260 --> 00:12:21,410 And here you can see we got this result like mini camera and then thermal camera. 131 00:12:21,430 --> 00:12:28,140 Then underlying results here, Gamora Canon camera decelerate a of the stuff, right. 132 00:12:28,450 --> 00:12:31,550 So all are mushed in one table. 133 00:12:32,350 --> 00:12:40,270 So if we again, go to the search product and if you search for Ssempa, so if you search Glock's. 134 00:12:43,140 --> 00:12:43,610 And. 135 00:12:45,240 --> 00:12:47,220 Then collect the product. 136 00:12:48,240 --> 00:12:59,160 So you can see we are getting different types of clocks here, so you can see the hourly clock, wake 137 00:12:59,160 --> 00:13:09,060 up, alarm clock and all the information that we have chosen, the columns that work in which column 138 00:13:09,060 --> 00:13:09,870 we are interested. 139 00:13:10,230 --> 00:13:12,930 So here you can see all the little information as well. 140 00:13:13,290 --> 00:13:17,600 So in this way, it saves a lot of time. 141 00:13:18,060 --> 00:13:24,030 We just search one project and we just click one time and it does the magic for you. 142 00:13:24,780 --> 00:13:30,360 So in this way, you can prepare your dataset for further analysis.