Attribute Generation

Lamaa

Hi,

I have a data file to evaluate the performance of the restaurant. And the business question is Which neighborhood has the most attractive restaurants (Cost Vs Rate). Here the neighborhood is the place where the restaurant has placed its service, cost is the average cost of eating there and rate is the rating provided by customer.

So, how can I generate a new attribute by combining cost and rate to find the best neighborhood.

Thank You in Advance

varunm1

Hello @Lamaa

You can set a scale initially before coding for a cost vs rate attribute. For example, if the average cost of eating at a restaurant X is 25 Dollars and the rating of that restaurant is 3 out of 5 stars, you can set this as Medium expensive - Medium rated place, you can code it using IF statement in generate attributes operator. Similarly, if the cost is 40 dollar and 4 stars out of 5, you can code it as costly - well-rated place. 

You first need to come up with a scale based on ratings and average cost, then it is the matter of if statements in generate attribute operator to create an attribute CostVsRate.

Hope this helps. If you are looking for something else, please provide detail information about your idea and the dataset.