-
Notifications
You must be signed in to change notification settings - Fork 0
/
NRc7xB3wQZ-XO8Qd8CGfng_8e2ffd04e9b64f1787517b179f5b3710_YelpDataCourseraPR2.txt
416 lines (300 loc) · 111 KB
/
NRc7xB3wQZ-XO8Qd8CGfng_8e2ffd04e9b64f1787517b179f5b3710_YelpDataCourseraPR2.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
Data Scientist Role Play: Profiling and Analyzing the Yelp Dataset Coursera Worksheet
This is a 2-part assignment. In the first part, you are asked a series of questions that will help you profile and understand the data just like a data scientist would. For this first part of the assignment, you will be assessed both on the correctness of your findings, as well as the code you used to arrive at your answer. You will be graded on how easy your code is to read, so remember to use proper formatting and comments where necessary.
In the second part of the assignment, you are asked to come up with your own inferences and analysis of the data for a particular research question you want to answer. You will be required to prepare the dataset for the analysis you choose to do. As with the first part, you will be graded, in part, on how easy your code is to read, so use proper formatting and comments to illustrate and communicate your intent as required.
For both parts of this assignment, use this "worksheet." It provides all the questions you are being asked, and your job will be to transfer your answers and SQL coding where indicated into this worksheet so that your peers can review your work. You should be able to use any Text Editor (Windows Notepad, Apple TextEdit, Notepad ++, Sublime Text, etc.) to copy and paste your answers. If you are going to use Word or some other page layout application, just be careful to make sure your answers and code are lined appropriately.
In this case, you may want to save as a PDF to ensure your formatting remains intact for you reviewer.
Part 1: Yelp Dataset Profiling and Understanding
1. Profile the data by finding the total number of records for each of the tables below:
i. Attribute table = 10000
ii. Business table = 10000
iii. Category table = 10000
iv. Checkin table = 10000
v. elite_years table = 10000
vi. friend table = 10000
vii. hours table = 10000
viii. photo table = 10000
ix. review table = 10000
x. tip table = 10000
xi. user table = 10000
// Example : SELECT COUNT(*) AS total_records FROM table_name;
2. Find the total distinct records by either the foreign key or primary key for each table. If two foreign keys are listed in the table, please specify which foreign key.
i. Business = 10000 (key : id, key_type : primary)
ii. Hours = 1562 (key : business_id, key_type : foreign)
iii. Category = 2643 (key : business_id, key_type : foreign)
iv. Attribute = 1115 (key : business_id, key_type : foreign)
v. Review = 10000 (key : id, key_type : primary)
vi. Checkin = 493 (key : business_id, key_type : foreign)
vii. Photo = 10000 (key : id, key_type : primary)
viii. Tip = 537 (key : user_id, key_type : foreign)
ix. User = 10000 (key : id, key_type : primary)
x. Friend = 11 (key : user_id, key_type : foreign)
xi. Elite_years = 2780 (key : user_id, key_type : foreign)
Note: Primary Keys are denoted in the ER-Diagram with a yellow key icon.
// Example : SELECT COUNT(DISTINCT(key)) AS total_distinct_records FROM table_name;
3. Are there any columns with null values in the Users table? Indicate "yes," or "no."
Answer: no.
SQL code used to arrive at answer:
SELECT COUNT(*) FROM user
WHERE
id IS NULL OR
name IS NULL OR
review_count IS NULL OR
yelping_since IS NULL OR
useful IS NULL OR
funny IS NULL OR
cool IS NULL OR
fans IS NULL OR
average_stars IS NULL OR
compliment_hot IS NULL OR
compliment_more IS NULL OR
compliment_profile IS NULL OR
compliment_cute IS NULL OR
compliment_list IS NULL OR
compliment_note IS NULL OR
compliment_plain IS NULL OR
compliment_cool IS NULL OR
compliment_funny IS NULL OR
compliment_writer IS NULL OR
compliment_photos IS NULL;
4. For each table and column listed below, display the smallest (minimum), largest (maximum), and average (mean) value for the following fields:
i. Table: Review, Column: Stars
min:1 max:5 avg: 3.7082
ii. Table: Business, Column: Stars
min:1.0 max:5.0 avg:3.6549
iii. Table: Tip, Column: Likes
min:0 max:2 avg:0.0144
iv. Table: Checkin, Column: Count
min:1 max:53 avg:1.9414
v. Table: User, Column: Review_count
min:0 max:2000 avg:24.2995
5. List the cities with the most reviews in descending order:
SQL code used to arrive at answer: SELECT city, SUM(review_count) FROM business GROUP BY city ORDER BY SUM(review_count) DESC;
Copy and Paste the Result Below:
+-----------------+-------------------+
| city | SUM(review_count) |
+-----------------+-------------------+
| Las Vegas | 82854 |
| Phoenix | 34503 |
| Toronto | 24113 |
| Scottsdale | 20614 |
| Charlotte | 12523 |
| Henderson | 10871 |
| Tempe | 10504 |
| Pittsburgh | 9798 |
| Montréal | 9448 |
| Chandler | 8112 |
| Mesa | 6875 |
| Gilbert | 6380 |
| Cleveland | 5593 |
| Madison | 5265 |
| Glendale | 4406 |
| Mississauga | 3814 |
| Edinburgh | 2792 |
| Peoria | 2624 |
| North Las Vegas | 2438 |
| Markham | 2352 |
| Champaign | 2029 |
| Stuttgart | 1849 |
| Surprise | 1520 |
| Lakewood | 1465 |
| Goodyear | 1155 |
+-----------------+-------------------+
(Output limit exceeded, 25 of 362 total rows shown)
6. Find the distribution of star ratings to the business in the following cities:
i. Avon
SQL code used to arrive at answer: SELECT stars as star_rating,count(*) as count from business where city="Avon" GROUP BY stars;
Copy and Paste the Resulting Table Below (2 columns – star rating and count):
+-------------+-------+
| star_rating | count |
+-------------+-------+
| 1.5 | 1 |
| 2.5 | 2 |
| 3.5 | 3 |
| 4.0 | 2 |
| 4.5 | 1 |
| 5.0 | 1 |
+-------------+-------+
ii. Beachwood
SQL code used to arrive at answer: SELECT stars as star_rating,count(*) as count from business where city="Beachwood" GROUP BY stars;
Copy and Paste the Resulting Table Below (2 columns – star rating and count):
+-------------+-------+
| star_rating | count |
+-------------+-------+
| 2.0 | 1 |
| 2.5 | 1 |
| 3.0 | 2 |
| 3.5 | 2 |
| 4.0 | 1 |
| 4.5 | 2 |
| 5.0 | 5 |
+-------------+-------+
7. Find the top 3 users based on their total number of reviews:
SQL code used to arrive at answer: SELECT name, review_count FROM user ORDER BY review_count DESC LIMIT 3;
Copy and Paste the Result Below:
+--------+--------------+
| name | review_count |
+--------+--------------+
| Gerald | 2000 |
| Sara | 1629 |
| Yuri | 1339 |
+--------+--------------+
8. Does posing more reviews correlate with more fans?
Please explain your findings and interpretation of the results:
No, They are not perfectly correlated coz Amy with Highest number of fans(503) have made just 609 reviews, and Gerald with 2000 reviews have just 253 fans
We can also observe that only small part of people with high fan count have posted too many reviews
Many users with high fan count are conservative with number of reviews they have posted
Number of Fans might be key performance metric for Quality over Quantity.
9. Are there more reviews with the word "love" or with the word "hate" in them?
Answer: Yes, more reviews with the word "love" (1780)
SQL code used to arrive at answer:
SELECT count(*) As love_count from review where text like '%love%';
SELECT count(*) As hate_count from review where text like '%hate%';
10. Find the top 10 users with the most fans:
SQL code used to arrive at answer: SELECT name, fans from user ORDER BY fans DESC LIMIT 10;
Copy and Paste the Result Below:
+-----------+------+
| name | fans |
+-----------+------+
| Amy | 503 |
| Mimi | 497 |
| Harald | 311 |
| Gerald | 253 |
| Christine | 173 |
| Lisa | 159 |
| Cat | 133 |
| William | 126 |
| Fran | 124 |
| Lissa | 120 |
+-----------+------+
Part 2: Inferences and Analysis
1. Pick one city and category of your choice and group the businesses in that city or category by their overall star rating. Compare the businesses with 2-3 stars to the businesses with 4-5 stars and answer the following questions. Include your code.
City - Mesu
i. Do the two groups you chose to analyze have a different distribution of hours?
ii. Do the two groups you chose to analyze have a different number of reviews?
Yes, Places with Higher Ratings have Higher Number of Reviews
iii. Are you able to infer anything from the location data provided between these two groups? Explain.
No, For the Selected Location The neighborhood details are missing
SQL code used for analysis:
SELECT k.cat,k.name,k.id, k.neighborhood,k.city,k.stars,k.review_count,k.is_open, Count(*) AS Days_of_open
FROM
(select 'Rating 2-3' as cat,b.name,b.id, b.neighborhood,b.city,b.stars,b.review_count,b.is_open from
business b JOIN category h ON h.business_id = b.id WHERE b.city='Mesa' AND b.stars BETWEEN 2 AND 3 UNION
select 'Rating 4-5' as cat,b.name,b.id, b.neighborhood,b.city,b.stars,b.review_count,b.is_open from business b
JOIN category h ON h.business_id = b.id WHERE b.city='Mesa' AND b.stars BETWEEN 4 AND 5 ) k
JOIN hours h ON k.id=h.business_id GROUP BY k.id ORDER BY k.cat ;
+------------+-----------------------------+------------------------+--------------+------+-------+--------------+---------+--------------+
| cat | name | id | neighborhood | city | stars | review_count | is_open | Days_of_open |
+------------+-----------------------------+------------------------+--------------+------+-------+--------------+---------+--------------+
| Rating 2-3 | Cash Time Loan Center | 0NIXu8EWhXcKqrY2rg2Dqw | | Mesa | 3.0 | 4 | 1 | 7 |
| Rating 2-3 | Ghost Armor SS Springs | 25lVJgvthMyvoRz-W6splw | | Mesa | 2.0 | 3 | 0 | 7 |
| Rating 4-5 | Eklectic Pie - Mesa | -3oxnPPPU3YoxO9M1I2idg | | Mesa | 4.0 | 129 | 0 | 7 |
| Rating 4-5 | Green Corner Restaurant | 16d3BlncEyCTzb0GxXrBXQ | | Mesa | 5.0 | 267 | 1 | 7 |
| Rating 4-5 | Health For Life: North Mesa | 2jg7v96HM3mNSUrbk3sMxg | | Mesa | 4.5 | 16 | 1 | 7 |
+------------+-----------------------------+------------------------+--------------+------+-------+--------------+---------+--------------+
2. Group business based on the ones that are open and the ones that are closed. What differences can you find between the ones that are still open and the ones that are closed? List at least two differences and the SQL code you used to arrive at your answer.
i. Difference 1:
Low rating Business are highly likely to be closed
ii. Difference 2:
Open Business have More ratings
SQL code used for analysis:
3. For this last part of your analysis, you are going to choose the type of analysis you want to conduct on the Yelp dataset and are going to prepare the data for analysis.
Ideas for analysis include: Parsing out keywords and business attributes for sentiment analysis, clustering businesses to find commonalities or anomalies between them, predicting the overall star rating for a business, predicting the number of fans a user will have, and so on. These are just a few examples to get you started, so feel free to be creative and come up with your own problem you want to solve. Provide answers, in-line, to all of the following:
i. Indicate the type of analysis you chose to do:
Predicting if the business is open based on ratings and reviews
ii. Write 1-2 brief paragraphs on the type of data you will need for your analysis and why you chose that data:
We can analyse the Text Data of reviews provided using Word2Vec to know how positive and negative thee reviews, we can analyse them as well as corelate them with
rating to predict if business is open or not.
iii. Output of your finished dataset:
+------------------------+-------+--------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------+
| id | stars | review_count | text | is_open |
+------------------------+-------+--------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------+
| --9e1ONYQuAa-CB_Rrw7Tw | 4.0 | 1389 | My favorite steakhouse in Las Vegas, somewhere I know I can go and get a great steak and have a great atmosphere to share with friends or family. I have been going to Delmonico since about four year ago and I have never been disappointed once. | 1 |
| | | | | |
| | | | One of my favorite things about this place is every time I have made a reservation I have always got seated almost exactly on time. This place is not cheap nor is it too overpriced compared to other steakhouses in Las Vegas that don't even come close to this one. | |
| | | | | |
| | | | One of my favorite things is they have an great selection of scotches and bourbon, the have a separate menu for it and if you like either please make sure and check it out. | |
| | | | | |
| | | | Give this place a try and know that I recommend it to everyone. | |
| --9e1ONYQuAa-CB_Rrw7Tw | 4.0 | 1389 | Was excited to go here since it was Emerille's Steakhouse. We had reservations for 8PM and waited at the bar while they got our table ready. The waiter was really nice and friendly. They brought us bread which they placed individually on our plates. I started with the spinach and arugula salad, which was super good. I was glad to have had that in my stomach, since it took a while to get our steaks. | 1 |
| | | | | |
| | | | I ordered the filet, medium and a side of asparagus. The steak was seared a little too much and tasted a little burnt. They also topped it off with a pad of butter. By no means was it a bad steak, but for the price, I guess I expected more. The asparagus was good but also very buttery. Good food, but I have definitely had better. | |
| --9e1ONYQuAa-CB_Rrw7Tw | 4.0 | 1389 | 2012 Fall Restaurant Week Lunch #2. | 1 |
| | | | | |
| | | | Whether you're visiting Delmonico on a regular night, special occasion, or during Restaurant Week as I did, from the amazing lunch I had with extraordinary service and exceptional food, I'd recommend it to anyone. 4.5 stars at least. | |
| | | | | |
| | | | We seem to be the first party seated for lunch. Our two servers worked well together, being knowledgeable, catering, and attentive from beginning to end. Even as more customers started to come in and they had more to attend to, they still did an amazing job making sure we were taken care of. | |
| | | | | |
| | | | What we put in our tummies: | |
| | | | (pictures posted) | |
| | | | | |
| | | | 1st Course | |
| | | | Traditional New Orleans | |
| | | | Chicken & Andouille Sausage Gumbo | |
| | | | | |
| | | | 2nd Course | |
| | | | Butternut Squash Ravioli | |
| | | | Prime Cheeseburger w/ Bacon | |
| | | | | |
| | | | 3rd Course | |
| | | | Emeril's Banana Cream Pie | |
| | | | Pecan Pie | |
| | | | | |
| | | | I'm no expert on gumbo, but I found it very tasty. Still steaming in individual serving pots, it was poured over rice table-side. Very nice touch. The burger was an enormous 11oz, well-seasoned, cooked medium as requested, hearty and meaty as burgers should be. Fries were just...fries. It was my first experience with butternut squash ravioli, and I loved it. Sage brown butter, toasted hazelnuts, and parmesan cheese made these raviolis sweet and flavorful. | |
| | | | | |
| | | | The highlight of the food was unquestionably the desserts. I never order banana cream pie, but I'm a big believer in trying whatever is the signature item, especially when it's written "Emeril's Banana Cream Pie." I'm sure it's not made very traditionally, but OH MY GOSH. Made with sweet bananas, the pie filling felt more like a cheesecake. Topped with chocolate shavings, amazing crust, this dessert will be what I think of from this day forward when anyone says banana cream pie. You think the way I described it, how could the pecan pie even compete?! Well, it did! Served warm and moist, it was decadent and comforting. | |
| | | | | |
| | | | I was beginning to wonder if the Restaurant Week event and menus were affecting my experiences at these places I've been eagerly wanting to try. I was very excited to participate, awaiting delicious gourmet food at a great price at a fine-dining establishment, helping a worthy cause. | |
| | | | | |
| | | | Personally, I'm very happy to say Delmonico made me want to become a repeat customer, again and again. It's so hard not to give 5 stars, but I would want to experience dining here on a non-Restaurant Week to confidently say it was as amazing as I remembered this lunch. | |
| | | | | |
| | | | I'm very much looking forward to coming back. And soon! | |
| --9e1ONYQuAa-CB_Rrw7Tw | 4.0 | 1389 | My client took me here after the MAGIC Show and it was phenomenal! The steak danced in my mouth. Well not really but you get the picture. The salads and sides (asparagus, potatoes) were excellent. They also have a fine wine selection. This place takes steak on another level! Highly recommended! | 1 |
| --cZ6Hhc9F7VkKXxHMVZSQ | 4.0 | 299 | I have heard about this place for nearly as long as I have lived in the area and finally got to try it out. | 1 |
| | | | I got the 1/4 Chicken with rice, beans and plantains. All of it was good but I wasn't blown away like people suggested I would be. | |
| | | | | |
| | | | Honestly I found the chicken a little greasy, the sauces overly spicy where it was more of an accomplishment to eat rather than an enjoyable accomplice to the meal (and I regularly eat spicy food) and the beans to be not worth my time. | |
| | | | | |
| | | | The plantains were delicious and the ther servers were very attentive. One nice thing that they did was they did not have enough plantains for both of our plates. So, they gave me my portion and put two on my friend's plate so they could get the meals out. They then brought a side plate with the rest of the plantains when they were finished. It was a well thought out move on the part of the staff. | |
| | | | | |
| | | | My friend had the chicken soup and said it was very very good especially when she spooned some broth into the rice and mashed in some avacado. | |
| | | | | |
| | | | This place is certainly worth checking out, and a place I'll likely return to, but did not like enough to be a regular. | |
| --cZ6Hhc9F7VkKXxHMVZSQ | 4.0 | 299 | The chicken is awesome! Specially, for the price. Service is quick. | 1 |
| | | | | |
| | | | Update: Didn't have the same great experience on follow-up visits. Still, it's a good place for good chicken. | |
| -050d_XIor1NpCuWkbIVaQ | 4.0 | 700 | This place is awesome!!! I am a die-hard fan of Robert's in Tucson but this is the first place that gives them a run for their money. Homemade thick slabs of bread served with fresh strawberry jam and an egg scramble with spinach and havarti = breakfast heaven. This place is tiny and I'm sure gets packed as we went on a Tuesday morning and there was a small wait but it's so worth it! | 0 |
| -0NrB58jqKqJfuUCDupcsw | 3.5 | 76 | Couldn't get a table. They wouldn't give us a table for 6. They wouldn't even try. We would have waited. Stupid. Only 1 person working the entire place. Stupid again. I don't like giving my business to people who could care less about mine. If you feel the same then avoid this place. | 1 |
| | | | | |
| | | | We went next door to Ha Ba Tang and had a good time. | |
| | | | | |
| | | | If I could have got a table in would have been happy to leave a real review. | |
| -0tgMGl7D9B10YjSN2ujLA | 3.5 | 112 | Bobby is a very rude server. She has no personality considering she works at the bar. Food is very dry and takes a while. | 1 |
| -0tgMGl7D9B10YjSN2ujLA | 3.5 | 112 | This place can get really awesome or really dull dependent on one solitary man resembling a leprechaun with a filthy mouth and penchant for calling out mouthy toolbags, all while playing the guitar and happily caroling away in Irish drinking hymnals. It can get really crowded, which makes standing really tedious and plants a target on your big forehead for the leprechaun to abuse. On St. Paddy's Day, this place is chaos, and like most other forced holidays is not worth getting into the carnival atmosphere just to say you did it. Cash-only holidays get old in a hurry. | 1 |
| -1UMR00eXtwaeh59pEiDjA | 3.5 | 279 | Every other restaraunt in an airport will get you your food before 30 minutes, it's not even busy, wtf. | 1 |
| -1xuC540Nycht_iWFeJ-dw | 4.5 | 398 | There is usually a line but they process very quickly. We tried the spicy chicken and it was kind of dry. They give a lot of french fries so we didn't need to order two entrees with fries but instead ordered one entree with fries and added additional chicken pieces and it was enough to feed three of us. It's a cheap meal located in a residential neighborhood. Definitely off the beaten path for us tourist. The nata was ok. It would have tasted better if they served it warm or at least at room temp. | 1 |
| -2TKoFglMQvSmHSNWf6S8Q | 4.0 | 8 | Years ago, I banked here. They were horrible. These days the only reason I come here is to make my mortgage payment. Saturday morning, I was the only one in line. For 10 minutes while a teller conversed with a customer about their grandkids. I get it you want to connect with your customers. Another person working the drive thru came to the front where I thought he would help me. No such luck. Finally, a woman from the back came out and asked if I had a check deposit or a payment. She finally took my payment. One more reason to hate the big banks. | 1 |
| -2uhc4spgMqJMy0YSxConA | 4.0 | 18 | Rented a van in the Mesa, AZ area. We had an issue with a cracked window. It wasn't apparent when we picked the car up but by the time we returned the vehicle days later the crack was over 12 inches long. I explained the situation and Alamo did not charge us anything which we really appreciate!!! It wasn't our fault to begin with but I don't think all companies would have believed us! So Thanks Alamo! | 1 |
| -38Kck4mGlkBwd6OXayZRg | 5.0 | 32 | Seriously the best massage I've ever had! Ariana and David are so caring and skilled! The pressure was perfect, the scents were great, the ambiance was fantastic! All in the comfort of our hotel room. If you need (WANT) a massage this is definitely the place to get it from! | 1 |
| -3QHAylnVB-vNmCg2Rf5aw | 5.0 | 19 | Great friendly local game store! Huge selection of board games along with good sections for role-playing and miniatures games. The staff are very knowledgeable and the gaming area in the back is comfortable and clean. The whole place is very welcoming. Madison has a number of game stores, but I'm Board is exceptional. | 1 |
| -3zffZUHoY8bQjGfPSoBKQ | 4.0 | 574 | I love love love love Michael Mina 's restaurants . He owns a couple at bellagio . It was a very nice experience we were greeted and seated. The waiter was extremely nice and helped us pick out what we wanted . We actually ended up doing the tasting menu. The food did take a while to cook and be ready but overall it was really nice | 1 |
| -3zffZUHoY8bQjGfPSoBKQ | 4.0 | 574 | Classy establishment all around. The hotel it is in is the Bellagio. The service from the moment you walk in is what you expect from a nice restaurant. | 1 |
| | | | | |
| | | | There were seven of us for dinner on a Tuesday and the place was jam packed. The service wasn't impacted at all. Everyone who touched the table had a touch of class mixed with a sense of humor. | |
| | | | | |
| | | | Our part ordered almost every entree on the menu with everyone raving. A few of us split the lobster pot pie. If you order it, definitely split it. Half an order was plenty. It is creamy which they warn/tell you about ahead of time. | |
| | | | | |
| | | | The wine list is exhaustive and if you are the one picking the wine will make you anti-social for about 10-15 minutes while you choose. | |
| | | | | |
| | | | Would definitely go again. | |
| -5L8zOxibac-vBrsYtxXbQ | 3.5 | 95 | WOW! This place was exceptional, not only because every meal we enjoyed had a variety of options and was flavorful but also because the prices were so reasonable! I would definitely recommend Shae as your waitress. She is AWESOME! You can definitely expect a good time and great service. Sometimes, to my delight, the experience exceeds my expectations! I highly recommend anyone paying Eds a visit! | 1 |
| -5NXoZeGBdx3Bdk70tuyCw | 4.0 | 54 | Great crispy crust on my individual pizza. We went for lunch and our waitress kept in mind that we were on a tight schedule. Husband thought his sandwich was ok, priced right but nothing special. The hit of this place, as many have said, is the homemade pies! Save room for a slice, very tasty! Can't think of another place in town with homemade pies like these. | 1 |
| -5TBEK1ddM41v_gqGm5oyw | 5.0 | 7 | Richard helped my mom sell our North Toronto home several years back, and she was very, very happy with the job he did. Richard's a lovely man, totally professional, and really knows what he's doing. | 1 |
| -6tvduBzjLI1ISfs3F_qTg | 4.0 | 902 | Great food, nice atmosphere, great location. The tacos are good, I had one of each, very unique! The Beast burrito is my favorite! The ceviche was tasty, but almost too chunky so it was hard to scoop on a chip. No televisions, so that can be good or bad depending on if you want to watch a game while eating. | 1 |
| -7H-oXvCxJzuT42ky6Db0g | 3.5 | 436 | The food here is always delicious. However, the bar staff seemed unhappy and was extremely unfriendly and unwelcoming. My co-worker and I went here on a Sunday night. We both work at a bar in the North Shore that experienced an extremely busy July 4th weekend and we were exhausted and in the search of a good meal. It was impossible to get a smile from a single employee in the building. I ordered the Rhuby drink. The first one was delicious, but the second round was much sweeter and I couldnt finish it. The Shroom flat bread was amazing. My chicken sandwich and buffalo mac & cheese was great. My friend's turkey sandwich and truffle fries were also good. But the lack of friendly or attentive service or even a simple smile was disappointing. The bar was not very busy and the half the restaurant was closed. As workers in the same industry, my friend and I are very aware and understanding of the stress of working in a bar. But I couldn't even bring myself to tip as well as I normally would because the experience was so bad. | 1 |
| -7H-oXvCxJzuT42ky6Db0g | 3.5 | 436 | Came here on a Sunday for lunch. We ordered the candied bacon, pot roast fries, a president salad (which was just a chicken Caesar salad) and the model turkey sandwich. Candied bacon was good, I liked the flavor a lot, not too sweet. The fries were very good as well - they gave a generous portion of the pot roast. The two main meals were ok. | 1 |
| | | | | |
| | | | Overall not bad. I would like to come here for a drink at night thou | |
| -7PX_FOoCwktlunImRyZdg | 4.0 | 93 | I've been there twice so far probably the best gourmet style pizza place in Pittsburgh. There was not a lot of seating in the restaurant however it seems like there was enough room to add at least 5 more tables. I feel like they are not utilizing the space to its fullist potential. | 1 |
+------------------------+-------+--------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------+
iv. Provide the SQL code you used to create your final dataset:
SELECT b.id,b.stars,b.review_count,r.text,b.is_open FROM business b JOIN review r ON r.business_id=b.id;