1
00:00:00,720 --> 00:00:04,680
In today's video, we will do a small project on our Web site.

2
00:00:05,040 --> 00:00:14,490
It is the life project so far, but we have a lot on this website and we are first, we try to look

3
00:00:15,690 --> 00:00:16,230
mobile.

4
00:00:19,700 --> 00:00:29,750
So here you can see we are getting different types of information about the product and the seller information,

5
00:00:30,230 --> 00:00:37,120
and then we have a rating and here you can see this rating received on time.

6
00:00:37,130 --> 00:00:38,990
So it's a little bit hidden.

7
00:00:38,990 --> 00:00:43,220
So I can't read the complete rating here.

8
00:00:43,820 --> 00:00:51,280
And some of the attributes are hidden and in the same way if I try to search for the paper.

9
00:00:53,750 --> 00:01:02,570
So here you can see we are getting different types of results here and we need to grab all this data

10
00:01:02,690 --> 00:01:05,860
and then we need to make a report.

11
00:01:06,680 --> 00:01:10,910
So let's do it with the help of poverty, how easy it is.

12
00:01:10,950 --> 00:01:16,160
So if you click dot the homestead and here it is, mobile.

13
00:01:19,250 --> 00:01:30,650
And you can see the wall here, this is a live dot com slash troop surge and then we have at the end

14
00:01:30,650 --> 00:01:33,800
we have and such as a call to mobile.

15
00:01:34,190 --> 00:01:37,370
And if I write here because then paper.

16
00:01:44,560 --> 00:01:49,780
So here you can see we are getting all the results, according to our search query.

17
00:01:51,080 --> 00:02:02,330
So we will take this Yoran and go to the power cutin Ed, and here we have to click getData Web.

18
00:02:05,120 --> 00:02:09,260
And then we need to pierce the wall here, like, OK.

19
00:02:12,750 --> 00:02:18,830
So here you can see we are getting a different tables, like if you click the table one.

20
00:02:20,160 --> 00:02:22,500
So this is the data here.

21
00:02:25,680 --> 00:02:33,570
We are getting in Columbine that this is a product name, then the other is the price, and then we

22
00:02:33,570 --> 00:02:40,770
have the other quantity and the column for and this is the like other type.

23
00:02:41,790 --> 00:02:44,600
And we have here the Fifth Column.

24
00:02:45,240 --> 00:02:49,250
This is the name of the seller and a lot of other information.

25
00:02:49,410 --> 00:02:52,170
Normally we have to go to each and every.

26
00:02:53,360 --> 00:02:59,450
Seller one by one, and then we try to see different stuff there.

27
00:03:00,040 --> 00:03:05,410
And if you click on the table, too, these are getting maybe it's about shipping.

28
00:03:06,020 --> 00:03:07,280
So there were three.

29
00:03:09,140 --> 00:03:17,450
Table four, so you can see we are getting different types of information that is available on the website.

30
00:03:17,480 --> 00:03:18,480
And here we need.

31
00:03:18,500 --> 00:03:29,150
We are interested in the column one you need to click control column to maybe three for this added information.

32
00:03:30,230 --> 00:03:36,890
And then we need we are also interested in the feedback.

33
00:03:36,890 --> 00:03:38,210
The rating is right.

34
00:03:38,210 --> 00:03:40,670
Click and remove other columns.

35
00:03:42,050 --> 00:03:44,860
So these are the stuff in which we are interested.

36
00:03:45,500 --> 00:03:52,700
So now you can make the the name of the column you you can rename it like products.

37
00:03:54,680 --> 00:03:56,060
The second is.

38
00:03:58,840 --> 00:03:59,440
Rice.

39
00:04:03,020 --> 00:04:05,150
And maybe you can relate to this one as well.

40
00:04:05,390 --> 00:04:06,500
So this is the

41
00:04:09,320 --> 00:04:10,850
order quantity.

42
00:04:16,190 --> 00:04:22,940
This one is the seller and this columnist is directing this one.

43
00:04:25,510 --> 00:04:32,720
So we need to order because everything the type of every column is is a text, right?

44
00:04:32,830 --> 00:04:40,900
This is also a text for what we can do is we can fetch the minimum amount and then we can do ascending

45
00:04:40,900 --> 00:04:45,630
or descending or here you can see zero point to one zero parenthesis.

46
00:04:45,740 --> 00:04:48,500
So this is the minimum amount and this is the maximum amount.

47
00:04:48,880 --> 00:04:51,170
So how we can get this amount here.

48
00:04:51,610 --> 00:04:56,530
So first of all, we need to extract information.

49
00:04:56,630 --> 00:05:01,300
So we need to extract all the digits before Desh.

50
00:05:02,320 --> 00:05:09,750
So first, we need to find the position of this number minus the zero point one dash.

51
00:05:10,090 --> 00:05:13,900
So for this, we need to click add column, add custom column.

52
00:05:15,790 --> 00:05:25,380
And here we have to write the the name of the column is Price and we have to use one function here and

53
00:05:27,650 --> 00:05:28,330
start.

54
00:05:31,530 --> 00:05:32,280
Position.

55
00:05:39,320 --> 00:05:47,540
Text of position up and it OK, let me remove this one so that Intellisense can work.

56
00:05:49,400 --> 00:05:54,170
So the first is the first parameter is the text as a text.

57
00:05:54,590 --> 00:06:00,560
This is the price and then the substring will be dash.

58
00:06:06,050 --> 00:06:14,020
So this one click, OK, and here you can see we are getting this is the index of this dash, right?

59
00:06:14,360 --> 00:06:18,970
And here we are getting minus one because there is no data available here.

60
00:06:18,980 --> 00:06:21,100
So we need all the digits before dash.

61
00:06:22,340 --> 00:06:27,320
So for this, we need to click setting.

62
00:06:27,320 --> 00:06:33,380
And here we have to use one function here that is again, text function, kick, start, start.

63
00:06:36,020 --> 00:06:47,300
And takes the perimeter is the the name of the column that is price, and then the second is so that's

64
00:06:47,300 --> 00:06:47,540
it.

65
00:06:48,200 --> 00:06:55,700
OK, so here you can see we are getting like a zero point two one dash, zero point six four, and we

66
00:06:55,700 --> 00:06:58,160
are getting, again, six for the minimum value.

67
00:06:58,160 --> 00:07:04,280
And here we are getting error because we don't have any value available at minus one position.

68
00:07:04,280 --> 00:07:10,880
So we need to fix this error just to click here and then we have to use it in one function.

69
00:07:10,880 --> 00:07:13,880
Error handling this is.

70
00:07:15,270 --> 00:07:15,750
Like.

71
00:07:18,630 --> 00:07:20,730
Try try this.

72
00:07:21,760 --> 00:07:22,570
Otherwise.

73
00:07:29,250 --> 00:07:31,260
The original column price.

74
00:07:34,230 --> 00:07:39,140
Does it click OK, and here you can see we are getting nowhere here.

75
00:07:40,630 --> 00:07:49,540
So now we change the different, for example, in trying to fix decimal number, and then we also need

76
00:07:49,540 --> 00:07:56,530
to sort this call as in ascending order so that it.

77
00:07:59,000 --> 00:08:02,990
No, we can load it closed and apply.

78
00:08:08,460 --> 00:08:10,620
And we have to add one table here.

79
00:08:14,750 --> 00:08:17,000
So the first problem will be products.

80
00:08:19,470 --> 00:08:20,500
Then we need.

81
00:08:21,550 --> 00:08:22,300
Bryce.

82
00:08:23,950 --> 00:08:25,870
And here we have a question.

83
00:08:28,830 --> 00:08:35,820
This is the we have to change here, the name like a minimum

84
00:08:39,930 --> 00:08:46,350
mean price, and we can also put here one.

85
00:08:48,130 --> 00:08:55,800
I like the rating and here we have to increase the excise.

86
00:08:56,160 --> 00:09:06,590
So here you can see we have added Prado's Tyson milk price and rating so we can put it here like in

87
00:09:06,600 --> 00:09:07,320
ascending order.

88
00:09:07,410 --> 00:09:11,150
So here you can see this is the first part.

89
00:09:11,160 --> 00:09:17,590
It is the like the minimum Ardipithecus point zero one point zero three point zero five and so on.

90
00:09:19,650 --> 00:09:22,650
So we we we have to do one more thing.

91
00:09:25,540 --> 00:09:28,120
We need to go to the ED.

92
00:09:31,890 --> 00:09:45,300
And we have to add here some parameters, many parameters, new parameters, and the name is products

93
00:09:47,760 --> 00:09:49,710
and the type is.

94
00:09:51,730 --> 00:09:52,420
This text.

95
00:09:54,500 --> 00:09:58,230
First of all, the list of videos and here you can see here, Candye Mobile.

96
00:10:02,970 --> 00:10:06,630
Paper, laptop,

97
00:10:12,570 --> 00:10:13,020
watch.

98
00:10:14,940 --> 00:10:22,330
OK, so you can choose mobile and the current value is also mobile click.

99
00:10:22,590 --> 00:10:34,640
OK, so this is a static parameter and we can we can rename this like after we need to copy Google here

100
00:10:34,650 --> 00:10:35,430
on the table one.

101
00:10:36,450 --> 00:10:44,190
And here we have to again, we need to go to The View and the advanced editor here.

102
00:10:44,190 --> 00:10:49,360
You can see this is the URL that we have pasted here that belong to people.

103
00:10:50,100 --> 00:10:55,970
So what we need to do here, we need to put quotation here and sign.

104
00:10:57,060 --> 00:11:02,670
And here we have to write and no stamp.

105
00:11:02,710 --> 00:11:03,150
So I.

106
00:11:03,600 --> 00:11:05,790
This is dynamic, right.

107
00:11:06,360 --> 00:11:07,400
Click OK.

108
00:11:11,010 --> 00:11:17,190
OK, so here you can see we are getting mobile and this is a mobile data.

109
00:11:17,200 --> 00:11:23,760
And if I look closer and apply, you don't need to search and type, you just need to select here.

110
00:11:23,760 --> 00:11:25,100
And this is very easy.

111
00:11:25,110 --> 00:11:31,800
Power query will automatically fetch all the stuff, the price and the minimum price, the order and

112
00:11:31,950 --> 00:11:41,460
you can fetch, as you have seen, we have a lot of information available and you can grab that information,

113
00:11:41,460 --> 00:11:48,120
put some more parameters, generate dynamic parameters based on the table, and then use those.

114
00:11:48,570 --> 00:11:53,280
Again, here, we need to again click here to to edit parameter.

115
00:11:53,820 --> 00:12:01,320
And here you can choose, for example, laptop click, OK, and apply changes.

116
00:12:05,620 --> 00:12:14,200
So you can see these are the laptops and the minimum order and all of these things very, very easy.

117
00:12:14,530 --> 00:12:16,920
You don't need to go to the website.

118
00:12:16,930 --> 00:12:20,480
You just need to select your here, watch, click.

119
00:12:20,480 --> 00:12:29,380
OK, apply changes so you can see we are getting different watches, their price rating and everything.

120
00:12:29,530 --> 00:12:36,580
So this is very easy and very powerful to grab a different result.

121
00:12:36,730 --> 00:12:43,510
And you can experiment with different types of websites to grab different types of result.

122
00:12:44,260 --> 00:12:52,540
And it will save your time and you can make the complete data set for your analysis.