How can i extracted data from this

The image displays customer reviews with an average rating of 4.3 out of 5 from 1,689 global ratings, showing a distribution of 60% 5-star, 21% 4-star, 10% 3-star, 4% 2-star, and 6% 1-star reviews. (Captioned by AI)

How to extract no of rating for each star without going into the each star page.

@John_Raj,

Number of reviews per category are not visible on this screen so it’s not possible to get.

You will have to get it one by one by using the below filter.

Thanks,
Ashok :slight_smile:

1 Like

You can use table extraction it will retrieve the ratings in form of data table and then you can further use that data table, or you can individually extract the ratings using Get Text activity and then can further use it.

Thanks,
Bharat

1 Like

Using table extraction and giving only the first and last column.

2 Likes

And in addition, if you need the number of reviews, not only the %, just extract the total from the top side, right below the stars, and calculate the approximate number of reviews based on the percentage.

40,634 totals - 79% 5 Star = ~32,101 unique 5* reviews

BR,
Ignasi

1 Like

Use For Each UI Element. When indicating elements indicate the main element as the percentage, then add a label and indicate the “5 star” “4 star” etc label. In the loop, add the data to a dictionary with the rating as the key and the percentage as the value. Now you have a simple key/value dictionary with an item for each rating and its percentage. You can access the percentage value for a rating with yourDictVar(“5 star”).ToString which will give 60%.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.