Directions are in the attached notebook file, it is a python assignment.
Sheet: Table1 b_id b_name b_neighborhood b_address b_city b_state b_zip b_stars b_review_count tags r_id u_id r_stars r_date r_text r_useful r_funny r_cool id name review_count yelping_since useful funny cool fans average_stars compliment_hot compliment_more compliment_profile compliment_cute compliment_list compliment_note compliment_plain compliment_cool compliment_funny compliment_writer compliment_photos elite_tags 2BbFeotL85cIaBjSq1SWiA Springs Cafe by Wolfgang Puck Westside 333 S Valley View Blvd Las Vegas NV 89107 American (New), Restaurants YYIAglOQmbto4z3LNv1T8w ---1lKK3aKOuomHnwAkAow 1.0 2010-10-17 00:00:00 When you say your a vegetarian don't recomend the potato soup with Bacon. Then don't mess around with me about the refund, with no mea culpa. ---1lKK3aKOuomHnwAkAow Monera 246.0 2007-06-04 00:00:00 2010, 2011, 2012, 2013 5cbsjFtrntUAeUx51FaFTg Agave Summerlin 10820 W Charleston Blvd Las Vegas NV 89135 Mexican, Restaurants 12_4xbZupkMox3adrUCwwA ---1lKK3aKOuomHnwAkAow 1.0 2010-11-05 00:00:00 So I was coming here once a month or so maybe more, however after Happy Hour Disaster I will not be back. I went to Happy Hour and asked if they could do a veggie taco instead of a meat one. They seriously delivered a tortilla with peppers in it. Thats ---1lKK3aKOuomHnwAkAow Monera 246.0 2007-06-04 00:00:00 2010, 2011, 2012, 2013 alaiXlogA286nuM8tj9ghw Bet on the Farm Westside 333 Valley View Blvd, Ste 106 Las Vegas NV 89139 Farmers Market, Food wAKcY80cAazkoWkUe1NSGw ---1lKK3aKOuomHnwAkAow 5.0 2012-02-19 00:00:00 The Freethinkers secular Unschooled group meets here on Thursdays. We would be the hipster/eclectic parents of school age children. They would be the children asking questions, engaging adults, and defying authority. You can find us playing chess in the ---1lKK3aKOuomHnwAkAow Monera 246.0 2007-06-04 00:00:00 2010, 2011, 2012, 2013 bPcqucuuClxYrIM8xWoArg Due Forni South Summerlin 3555 S Town Center Dr, Ste 105 Las Vegas NV 89135 Bars, Italian, Nightlife, Pizza, Restaurants, Wine Bars -pk4s5YUD0grEEBt2QYlDA ---1lKK3aKOuomHnwAkAow 5.0 2011-09-29 00:00:00 Did anyone mention bacon chocolate ice cream. They are worth checking out on Facebook also because they post when they make special items. I think they are the best lunch for the money on the summerlin side of town. I also love the patio and the Edison ---1lKK3aKOuomHnwAkAow Monera 246.0 2007-06-04 00:00:00 2010, 2011, 2012, 2013 CWNMLT-ppaUjLMmrnYDPVg Roy's Restaurant Westside 8701 W Charleston Blvd Las Vegas NV 89117 Asian Fusion, Hawaiian, Restaurants _U_ctMQkF3Smqo9mjpw1Iw ---1lKK3aKOuomHnwAkAow 5.0 2010-11-05 00:00:00 Why the hell does anyone go to Kona Grill? Unless you want to take a spray tan gold digger to be your wife, seriously the food blows. Happy hour can suck it, like the girl who can't find a seat and has to sit on your lap. Want great food, real happy ---1lKK3aKOuomHnwAkAow Monera 246.0 2007-06-04 00:00:00 2010, 2011, 2012, 2013 dM8Yp8StA1NdusK5Ta_j-g Retro Bakery Centennial 7785 N Durango Dr, Ste 130 Las Vegas NV 89131 Bakeries, Desserts, Food CVyZjR2NHBr--vitm2u79Q ---1lKK3aKOuomHnwAkAow 3.0 2012-06-22 00:00:00 I dont know I was spoiled in SF. We had cupcakes with guts, gooey bits in the inside. Cupcakes in Vegas seem to be mostly a base for some tasty frosting options. Depth is needed. The kids liked it. ---1lKK3aKOuomHnwAkAow Monera 246.0 2007-06-04 00:00:00 2010, 2011, 2012, 2013 edV_IqWqz5KVSGLrsru5EQ Wesley J Robertson, MD JD FAAP Summerlin 653 N Town Center Dr, Ste 106, Sunshine Valley Pediatrics Las Vegas NV 89144 Doctors, Family Practice, Health & Medical, Pediatricians Pv2naqFGkzYiw_x83oK9pA ---1lKK3aKOuomHnwAkAow 5.0 2010-11-27 00:00:00 He is an amazing pediatrician, very smart, has an MD and JD. They have a very busy practice but he never makes you feel rushed. He listens to concerns and gets along well with my would be doctor husband. ---1lKK3aKOuomHnwAkAow Monera 246.0 2007-06-04 00:00:00 2010, 2011, 2012, 2013 eJKnymd0BywNPrJw1IuXVw Nacho Daddy Downtown Downtown 113 N 4th St Las Vegas NV 89101 American (New), Breakfast & Brunch, Mexican, Restaurants, Tex-Mex gWwbX6j1aW9l2RBR347ifg ---1lKK3aKOuomHnwAkAow 5.0 2014-06-25 00:00:00 So this place is pretty awesome when Astrid or Alex is working. Otherwise its pretty much a three. Nacho Daddy your regulars demand these girls work all the time. ---1lKK3aKOuomHnwAkAow Monera 246.0 2007-06-04 00:00:00 2010, 2011, 2012, 2013 gHoP4eJimaMltfUlp6EP4Q Sammy's Woodfired Pizza and Grill Westside 6500 W Sahara Ave Las Vegas NV 89146 Gluten-Free, Pizza, Restaurants, Salad 7gO_hTYu6bShMVGrU6ZWbA ---1lKK3aKOuomHnwAkAow 4.0 2011-05-01 00:00:00 This is a fave place for our daughters. They are always well treated by the staff and there is something both of them like to eat on the menu. It is also next to a yogurt shop which sweetens the deal. ---1lKK3aKOuomHnwAkAow Monera 246.0 2007-06-04 00:00:00 2010, 2011, 2012, 2013 gVhX5xcnGjHE3mF2eXqKYg The Writer's Block Downtown 1020 Fremont St Las Vegas NV 89101 Books, Bookstores, Mags, Music & Video, Shopping z2FzA6gsY0EIgzKwIVUmDA ---1lKK3aKOuomHnwAkAow 5.0 2015-06-15 00:00:00 My girls have taken a few workshops at Writers Block and they have adored them. We have also adopted a few birds and we hope to adopt a few owls. I enjoy the robust selection that feeds my brain from color theory in plays to a plethora of science books. ---1lKK3aKOuomHnwAkAow Monera 246.0 2007-06-04 00:00:00 2010, 2011, 2012, 2013 jGv6tpmE7F9CG5qmLHad6A Rainbow Feathers Company Downtown 1036 S Main St Las Vegas NV 89101 Arts & Crafts, Costumes, Shopping qiexh3d6eYbDCEZ018ng6A ---1lKK3aKOuomHnwAkAow 5.0 2010-12-17 00:00:00 15 dollars for an array of beautiful feather boas, and more feathers than you can imagine. They provide feathers for showgirls and cirque, but they entertain feather neophytes like me. Great quality for a great price. ---1lKK3aKOuomHnwAkAow Monera 246.0 2007-06-04 00:00:00 2010, 2011, 2012, 2013 kosTPb88O4Q0XGbVbEOGCA Prommares Thai Food Westside 6362 W Sahara Ave Las Vegas NV 89146 Restaurants, Thai 1ikB-TEgwg2gigixDEDSuA ---1lKK3aKOuomHnwAkAow 4.0 2010-10-16 00:00:00 While its not Lotus it was tasty an the women were nice. The cook was singing so I'm sure food was made with love. ---1lKK3aKOuomHnwAkAow Monera 246.0 2007-06-04 00:00:00 2010, 2011, 2012, 2013 nv2z5SYQR0JlzflUrm00Mw Las Vegas Distillery 7330 Eastgate Rd, Ste 100 Henderson NV 89011 Beer, Distilleries, Food, Hotels & Travel, Tours, Wine & Spirits EqvkiGx03k6ixVGF7XrAwQ ---1lKK3aKOuomHnwAkAow 5.0 2012-06-02 00:00:00 Holy amazing this is the best kept secret in the foodie world! I am reviewing this so that fellow elites join ranks and show Las Vegas Distillery some love! 1) George is awesome. He taught himself everything and is a self made man. 2) It is way cool i ---1lKK3aKOuomHnwAkAow Monera 246.0 2007-06-04 00:00:00 2010, 2011, 2012, 2013 OnnvNs2JJ-B2xbwHEHbWDw Royal Printing Westside 3390 S Valley View Blvd Las Vegas NV 89102 Local Services, Printing Services mGXZgmp696Vx3w16UNFG9Q ---1lKK3aKOuomHnwAkAow 5.0 2011-12-11 00:00:00 If you are looking for great customer service and not another printing company that will treat you like yesterday's news, you want to talk to the folks at Royal Printing! They will also let you know if it does not make sense to print something, that kind ---1lKK3aKOuomHnwAkAow Monera 246.0 2007-06-04 00:00:00 2010, 2011, 2012, 2013 R-McIj4Psxl1VlEacsXeRg YoScream Summerlin 430 S Rampart Blvd, Ste 190 Las Vegas NV 89144 Food, Ice Cream & Frozen Yogurt 0cdjRebZLHYu-xyMSFKgMQ ---1lKK3aKOuomHnwAkAow 4.0 2011-09-29 00:00:00 You guys need to be open when the farmers market is open. Seriously 9 am is not to early for crepes. Anyhow they would be 5 stars but this time thing is a bummer. I really love the location and the fact the kids can burn the sugar off playing. ---1lKK3aKOuomHnwAkAow Monera 246.0 2007-06-04 00:00:00 2010, 2011, 2012, 2013 rpqEs1JT1XGHJzRUYfXDMQ Jamba Juice 1829 W Craig Rd, Unit 3 North Las Vegas NV 89032 Food, Juice Bars & Smoothies dpVpCeQJ2SXMsnyw5ljvOQ ---1lKK3aKOuomHnwAkAow 5.0 2011-05-01 00:00:00 I love you Jamba Juice now will you please open one in Boca Park? ---1lKK3aKOuomHnwAkAow Monera 246.0 2007-06-04 00:00:00 2010, 2011, 2012, 2013 RRw9I8pHt5PzgYGT2QeODw Grimaldi's Pizzeria Westside 750 S Rampart Blvd, Ste 7 Las Vegas NV 89145 Pizza, Restaurants 7EQzYGniK8TJvEOkMaTDyg ---1lKK3aKOuomHnwAkAow 5.0 2010-11-16 00:00:00 I was driving to Henderson to get Grimaldi's and now there is one on this side of town. Henderson is apparently another state to people in Las Vegas, it is unfathomable that one would ever go that far away for anything. Well Grimaldi's is so good it was ---1lKK3aKOuomHnwAkAow Monera 246.0 2007-06-04 00:00:00 2010, 2011, 2012, 2013 rXEQbezXp1GadjEuWj6c1g En Fuego Cigars Anthem 790 Coronado Center Dr, Ste 150 Henderson NV 89052 Home Services, Keys & Locksmiths, Local Flavor, Shopping, Tobacco Shops FEEkkUWYiTFIzzh0kWUOrQ ---1lKK3aKOuomHnwAkAow 5.0 2016-10-10 00:00:00 Sometimes being a solo girl walking into a cigar joint on a football day can be kinda scary. They shook my hand, were incredibly kind, gave me ample time to shop. I wish sports was not so tied into the lounge part of this. However I get that I'm not ---1lKK3aKOuomHnwAkAow Monera 246.0 2007-06-04 00:00:00 2010, 2011, 2012, 2013 slVkMoNTCGI2rOhMaL5u5A Berry Blendz 7175 W Lake Mead Blvd, Ste 140 Las Vegas NV 89128 Food, Juice Bars & Smoothies 2D3lifCSaaKLr73PK27eyg ---1lKK3aKOuomHnwAkAow 2.0 2011-02-16 00:00:00 Okay so it tasted weird. Some aftertaste that I could not get over. I like the all fruit menu at Jamba and wish there was one closer too me. I had hoped this would be it but it was not. Heres to shelping over to Decatur ---1lKK3aKOuomHnwAkAow Monera 246.0 2007-06-04 00:00:00 2010, 2011, 2012, 2013 sZsJooAzpKqOvDysphkqpQ Pop Up Pizza Downtown 1 S Main St Las Vegas NV 89101 Pizza, Restaurants, Vegan 23MKMYyMrw7mRrNlC2hwBA ---1lKK3aKOuomHnwAkAow 5.0 2012-06-22 00:00:00 I know I am going to join a list of amazing people who think this pizza is profound. I like that I can grab a weird slice before visiting Insurgo (http://www.insurgotheater.org/). A bonus to an already surreal existence. I was not sure if I would like pi ---1lKK3aKOuomHnwAkAow Monera 246.0 2007-06-04 00:00:00 2010, 2011, 2012, 2013 vW65SNLam99SyOuVagNuvg Diego Mexican Cuisine The Strip 3799 Las Vegas Boulevard S Las Vegas NV 89109 Mexican, Nightlife, Restaurants kgBmTZIP5svZK4spp_MrSw ---1lKK3aKOuomHnwAkAow 3.0 2010-11-09 00:00:00 So they lost a reservation for 9, really. It took a bit of negotating but they ended up putting us in a private room. Thank god because it is loud in there. The restrant is really cool inside. There are fishtanks with no fish just bubbles. Neat bar ---1lKK3aKOuomHnwAkAow Monera 246.0 2007-06-04 00:00:00 2010, 2011, 2012, 2013 yp2nRId4v-bDtrYl5A3F-g Nittaya's Secret Kitchen Summerlin 2110 N Rampart, Ste 110 Las Vegas NV 89128 Restaurants, Thai 1PJpo48hSChCbriXEHGSjw ---1lKK3aKOuomHnwAkAow 1.0 2010-11-20 00:00:00 This should be kept a secret so that no one has the terrible food I had. There are many great Thai places in Las Vegas and there is no need to eat here. The only plus is that the tiny dining room is cute. Hopefully this bodes for them going out of bu ---1lKK3aKOuomHnwAkAow Monera 246.0 2007-06-04 00:00:00 2010, 2011, 2012, 2013 ZibmYdOPKLlqDM9oR6xzOA Bachi Burger Westside 9410 W Sahara Ave, Ste 150 Las Vegas NV 89117 American (New), Asian Fusion, Bars, Burgers, Nightlife, Restaurants, Wine Bars Ferm9Dh6SXnLfBFYsQqWOg ---1lKK3aKOuomHnwAkAow 4.0 2012-06-27 00:00:00 I was suspicious as the idea of Asian burgers sounded strange, color me converted, these babies rock. The pineapple ketchup made me wonder why we ever used tomatoes. So why not 5 stars? Coffee was not bottomless as they blew the circuit, though the ch ---1lKK3aKOuomHnwAkAow Monera 246.0 2007-06-04 00:00:00 2010, 2011, 2012, 2013 EGzsR_Tyd0QOaZ6g7wPl-w Filibertos Mexican Food 529 E Dunlap Ave Phoenix AZ 85020 Mexican, Restaurants C64IMmOZmJWiNdFe3ELklQ ---cu1hq55BP9DWVXXKHZg 4.0 2014-11-19 00:00:00 Went to this location on 11/19/2014. Its not there. Even Google Maps shows the Building is empty ---cu1hq55BP9DWVXXKHZg Jeb 57.0 2009-04-18 00:00:00 1jiDdqe0H1FkzKBSfzePnQ Anthem RV & Boat 44019 N Black Canyon Hwy Phoenix AZ 85086 Automotive, Boat Dealers, RV Dealers AcWDOM7P4tJM-Xsea3LThQ --1av6NdbEbMiuBr7Aup9A 1.0 2016-06-12 00:00:00 Do not attempt service. Bottom line is was lied to about part order. Similar to other complaint I sent rv in and waited 3 weeks for part that never came in. I ordered part to install myself got it in 2 days no problem. I hate to call someone a lier but t --1av6NdbEbMiuBr7Aup9A Ron 11.0 2010-09-26 00:00:00 Hpi9raHlFm6prTSzFHTurg Corleones Philly Steaks 15040 N Nothsight Blvd Scottsdale AZ 85260 Cheesesteaks, Chicken Wings, Pizza, Restaurants, Sandwiches PX83ZIZisbi6IFN9Guk9ZQ --2HUmLkcNHZp0xw6AMBPg 5.0 2016-07-29 00:00:00 Great team! Love this place. I have come in right before close (I know! Bad!) and they are always smiles and happy to help me. This location has the best staff if you ask me. Love their food always but the staff is why I come back! --2HUmLkcNHZp0xw6AMBPg Kristin 33.0 2016-07-28 00:00:00 4.6 KwufI-XUy8Vs2cnJ8n7F6w El Pollo Loco 7204 E Shea Blvd Scottsdale AZ 85260 Fast Food, Mexican, Restaurants SyvYsze0oKE4jIvOJG2WFQ --2HUmLkcNHZp0xw6AMBPg 5.0 2017-06-18 00:00:00 Excited this is less than 1/2 mile from my home. Fresh, delicious fast food. Great salads. --2HUmLkcNHZp0xw6AMBPg Kristin 33.0 2016-07-28 00:00:00 4.6 yX0pOWG_Be9TjGnm0aihVA Modern Grove 15530 N Tatum Blvd, Ste 160 Phoenix AZ 85032 American (New), Beer, Breakfast & Brunch, Burgers, Comfort Food, Food, Restaurants, Vegetarian, Wine & Spirits tfi5EOpqZw637p3AJtOUMg --2HUmLkcNHZp0xw6AMBPg 5.0 2017-06-17 00:00:00 Obsessed with their chicken salad and sweet fries. Their chef with the beard is awesome!!! --2HUmLkcNHZp0xw6AMBPg Kristin 33.0 2016-07-28 00:00:00 4.6 Zj4092--r1Z8izd3Uq8lKg Opa Life Greek Cafe 9500 Via De Ventura Scottsdale AZ 85256 Bars, Beer Bar, Breakfast & Brunch, Greek, Mediterranean, Nightlife, Restaurants T3QcvFBPGjGrxEf0cT6vVQ --2HUmLkcNHZp0xw6AMBPg 5.0 2017-06-24 00:00:00 Cool venue, AMAZING food. Super friendly staff. Greek fries, pita, and any salad. You