In today's video, we will do a small project on our Web site.
It is the life project so far, but we have a lot on this website and we are first, we try to look
mobile.
So here you can see we are getting different types of information about the product and the seller information,
and then we have a rating and here you can see this rating received on time.
So it's a little bit hidden.
So I can't read the complete rating here.
And some of the attributes are hidden and in the same way if I try to search for the paper.
So here you can see we are getting different types of results here and we need to grab all this data
and then we need to make a report.
So let's do it with the help of poverty, how easy it is.
So if you click dot the homestead and here it is, mobile.
And you can see the wall here, this is a live dot com slash troop surge and then we have at the end
we have and such as a call to mobile.
And if I write here because then paper.
So here you can see we are getting all the results, according to our search query.
So we will take this Yoran and go to the power cutin Ed, and here we have to click getData Web.
And then we need to pierce the wall here, like, OK.
So here you can see we are getting a different tables, like if you click the table one.
So this is the data here.
We are getting in Columbine that this is a product name, then the other is the price, and then we
have the other quantity and the column for and this is the like other type.
And we have here the Fifth Column.
This is the name of the seller and a lot of other information.
Normally we have to go to each and every.
Seller one by one, and then we try to see different stuff there.
And if you click on the table, too, these are getting maybe it's about shipping.
So there were three.
Table four, so you can see we are getting different types of information that is available on the website.
And here we need.
We are interested in the column one you need to click control column to maybe three for this added information.
And then we need we are also interested in the feedback.
The rating is right.
Click and remove other columns.
So these are the stuff in which we are interested.
So now you can make the the name of the column you you can rename it like products.
The second is.
Rice.
And maybe you can relate to this one as well.
So this is the
order quantity.
This one is the seller and this columnist is directing this one.
So we need to order because everything the type of every column is is a text, right?
This is also a text for what we can do is we can fetch the minimum amount and then we can do ascending
or descending or here you can see zero point to one zero parenthesis.
So this is the minimum amount and this is the maximum amount.
So how we can get this amount here.
So first of all, we need to extract information.
So we need to extract all the digits before Desh.
So first, we need to find the position of this number minus the zero point one dash.
So for this, we need to click add column, add custom column.
And here we have to write the the name of the column is Price and we have to use one function here and
start.
Position.
Text of position up and it OK, let me remove this one so that Intellisense can work.
So the first is the first parameter is the text as a text.
This is the price and then the substring will be dash.
So this one click, OK, and here you can see we are getting this is the index of this dash, right?
And here we are getting minus one because there is no data available here.
So we need all the digits before dash.
So for this, we need to click setting.
And here we have to use one function here that is again, text function, kick, start, start.
And takes the perimeter is the the name of the column that is price, and then the second is so that's
it.
OK, so here you can see we are getting like a zero point two one dash, zero point six four, and we
are getting, again, six for the minimum value.
And here we are getting error because we don't have any value available at minus one position.
So we need to fix this error just to click here and then we have to use it in one function.
Error handling this is.
Like.
Try try this.
Otherwise.
The original column price.
Does it click OK, and here you can see we are getting nowhere here.
So now we change the different, for example, in trying to fix decimal number, and then we also need
to sort this call as in ascending order so that it.
No, we can load it closed and apply.
And we have to add one table here.
So the first problem will be products.
Then we need.
Bryce.
And here we have a question.
This is the we have to change here, the name like a minimum
mean price, and we can also put here one.
I like the rating and here we have to increase the excise.
So here you can see we have added Prado's Tyson milk price and rating so we can put it here like in
ascending order.
So here you can see this is the first part.
It is the like the minimum Ardipithecus point zero one point zero three point zero five and so on.
So we we we have to do one more thing.
We need to go to the ED.
And we have to add here some parameters, many parameters, new parameters, and the name is products
and the type is.
This text.
First of all, the list of videos and here you can see here, Candye Mobile.
Paper, laptop,
watch.
OK, so you can choose mobile and the current value is also mobile click.
OK, so this is a static parameter and we can we can rename this like after we need to copy Google here
on the table one.
And here we have to again, we need to go to The View and the advanced editor here.
You can see this is the URL that we have pasted here that belong to people.
So what we need to do here, we need to put quotation here and sign.
And here we have to write and no stamp.
So I.
This is dynamic, right.
Click OK.
OK, so here you can see we are getting mobile and this is a mobile data.
And if I look closer and apply, you don't need to search and type, you just need to select here.
And this is very easy.
Power query will automatically fetch all the stuff, the price and the minimum price, the order and
you can fetch, as you have seen, we have a lot of information available and you can grab that information,
put some more parameters, generate dynamic parameters based on the table, and then use those.
Again, here, we need to again click here to to edit parameter.
And here you can choose, for example, laptop click, OK, and apply changes.
So you can see these are the laptops and the minimum order and all of these things very, very easy.
You don't need to go to the website.
You just need to select your here, watch, click.
OK, apply changes so you can see we are getting different watches, their price rating and everything.
So this is very easy and very powerful to grab a different result.
And you can experiment with different types of websites to grab different types of result.
And it will save your time and you can make the complete data set for your analysis.