Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Name Yelp Google Overall Menu Item Cost Albertacos 3.5 3.9 3.45 California 5.7 Albertacos 3.5 3.9 3.45 Carne asada 5.25 Burrito Factory 4.5 4.8 3.5

image text in transcribedimage text in transcribedimage text in transcribed
Name Yelp Google Overall Menu Item Cost Albertacos 3.5 3.9 3.45 California 5.7 Albertacos 3.5 3.9 3.45 Carne asada 5.25 Burrito Factory 4.5 4.8 3.5 Steak everything 7.35 Burros and Fries 3.5 4.1 3.575 California 7.19 Burros and Fries 3.5 4.1 3.575 Carne asada 6.89Question 4. From the burritos table, some of the restaurant locations have multiple reviews. Winifred thinks California burritos are the best type of burritos, and wants to see the average overall rating for California burritos at each location. Create a table that has two columns: the name of the restaurant and the average overall rating of California burritos at each location. Tip: Revisit the burritos table to see how California burritos are represented. Note: you can break up the solution into multiple lines, as long as you assign the final output table to california_burritos ! For reference however, the staff solution only used one line. california_burritos = burritos.where ( 'Menu_Item' , 'California') . select ( 'Name' , "Overall" ) . group( 'Name' , np. mean) california_burritos Name Overall mean Burros and Fries 3.575 Caliente Mexican Food 3.25 California Burrito Company 3.2 Cancun Mexican & Seafood 4.1 Cotixan 3.6 Don Carlos Taco Shop 3.3 El Dorado Mexican Food 4.025 4Question 6. Using the burritos table, assign menu_average to a table that has three columns that uniquely pairs the name of the restaurant, the menu item featured in the review, and the average Overall score for that menu item at that restaurant. Hint: Use .group, and remember that you can group by multiple columns. Here's an example from the textbook. menu_average = ... menu_average ok.grade( \"q1_6 \" )

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Programming questions