FOR ALL WORK FROM WEEK 6 ONWARDS, YOU WILL NEED ADD-ON PYTHON MODULES SUCH AS pandas, numpy, re, and...

Question

FOR ALL WORK FROM WEEK 6 ONWARDS, YOU WILL NEED ADD-ON PYTHON MODULES SUCH AS pandas, numpy, re, and csv, among others. BEFORE ATTEMPTING ANY OF THIS WEEK'S WORK, FIRST REVIEW THE DETAILED NOTE ON ALL THIS IN THIS WEEK'S ANNOUNCEMENT. THEN REVIEW THE 'DICTIONARIES TUTORIAL.' FINALLY, IF NECESSARY,ALSO REVISIT (a) THE 'LISTS TUTORIAL,' (b) THE 'FOR AND WHILE LOOPS TUTORIAL,' AND (c) THE 'SETS' TUTORIAL.'

In Week 6 projects, we continue with the same TripAdvisor context as in the past couple of weeks. You may therefore want to use your submissions for Week 5 as foundations upon which to build your work here.

Using dictionaries, and add-on Python modules such as re, pandas, and csv,augment the functionality of EXAMPLE SCRIPT 2 provided towards the end of the Dictionaries Tutorial to create the .csv file shown below. Note that --

The data file for this project (attached) contains thousands of reviews rather than 20 reviews.

Your dictionary as well as your subsequent data frame and .csv file need to incorporate all the fields shown below, in the sequence shown below.

The first column titled 'Negative-Keywords' needs to display the total number of negative keywords for each reviewer, per your Week 5 computations.

jessicaredmond Perfect Honeymoon!!!! We had the most wonderful time at the Excellence. We opted for the Excellence Club and it was well worht it for the perks. Roberto Puello who was the Club Manager did an extra special job of making us feel welcomed! We took some great pictures that looked like postcards. The food was excellent the Pizza was close to being our favorite. The shows were great especially the Michael Jackson and the 70's 80's night. The French resturant was probably our favorite. We will definately be back for an anniversary trip. We made some friends but had plenty of privcacy as well. The rooms were great and everytime we left and came back it was cleaned, towels restocked and the bar was as well!Jan 8, 2009 4 4 5 5 5 5 5 5 5 -1 Good-Time-Boy A truly fantastic place Xmas We have just returned from a 2 week Xmas New Year break at the Excellence Punta Cana. The hotel is magnificent and we have never experienced such incredible service before. The restaurants are great, with plenty of choice. The whole complex is so good that we only did one trip and that was for my wife to swim with the dolphins! Great beaches and pools. The staff fall over each other to look after you! We stayed in a junior suite on ground level and it was spotlessly clean, great maid service and room service on tap 24/7. Overall I would say this is probably the best hotel we have ever stayed in on holidayand I am extremely fussy! The journey to the resort is a little uncomfortable, with the roads in a bad state. But once you are checked in the pace of life slows down and you forget about the outside world!Worthy of special mention and our sincere thanks are:Pedro from the Cielo bar/pool an absolute gentleman. Miguel the Bell Boy and also Carlos from the Skay bar.We will definately be booking again, probably for next Christmas!Jim Eileen (Telford UK) Jan 8, 2009 4 4 5 4 5 5 5 5 5 5 cleanwatergirl too sick to enjoy The ride to and form the airport is not good. Very bumpy road and you can really see the poor living conditions. When you get to the resort it is like another world. we were told not to drink the tap or shower water- keep your mouth shut in the shower etc. but we have since heard that not all properties in punta cana have a water problem. In some resorts they have a huge purification system and the tap water is safe. Both my husband and I were sick with diarrhea while we were there and put it down to the unclean water used to prepare food. We will not go on any more holidays where we have to worry about our health. Each night at about 10PM when we were settling down to sleep the music started up and we like fresh air but we had to close our patio doors to mute the sound. We really wanted a quieter resort. It was disappointing. It was partially our fault for not doing our research properly. Some people did not hear the bands play at night but we couldnt change our swim up room for a quieter one. We will not be returning to Dominican Republic.Jan 6, 2009 15 1 2 1 2 2 3 5 2 -1 AMLBK Relaxing and fun, BUT... I rang in the New Year at Excellence Punta Cana! since New York was FREEZING at the time, I was just happy to be in the sun. My husband and I had a great time overall. However, I was a little surprised to see this hotel rating itself as a 5-star facility (more like a 4). All of the basics were covered, but some of the details that I would expect from a 5-star place were missing. The bed, although comfortable creaked loudly and I couldn tell whether or not the headboard was attached properly. The staff were friendly and helpful overall, but in keeping up with the island mentality, their sense of urgency was lacking (We had to ask two different people for hand towels and our one small room service order took close to an hour to arrive). Actually, as mentioned by another reviewer, the food was the worst part. The presentation was excellent (clean buffet areas, nicely decorated theme restaurants), but the dinner food quality wasn the best. One night I didn even finish my meal (at the exican?restaurant on-site). Lunch (indoor buffet or beach BBQ) was usually the best bet. Actually, everything on the beach ncluding the wait staffas great!Considering all of this, the Excellence was a great setting for relaxation. The grounds were beautiful, the weather was pleasant and there were many options for activities (and spa treatments) if you wanted them. I would definitely go back.One note- coordinate travel to and from the hotel beforehand if you can. The hotel is over an hour away from the airport, so you'll want to skip the can I help you, sir? bidding wars between different transportation companies.One more note- the resort is on the Atlantic side of the ocean. That means rough seas and cold(er) water. If you intend to spend your entire vacation in the ocean, you may want to skip this place. I went in a few times, but I quickly became content just relaxing by the water when I couldn go in it.Jan 6, 2009 3 0 4 3 4 3 5 3 4 -1 Plumtree Somewhat Excellence We just returned from a one week stay at Excellence Punta Cana from Dec27th to Jan4th.We are seasoned travelers and have stayed at a dozen all inclusives. We stayed at Excellence Punta Cana in 2007 for two weeks, then Excellence Mayan Riviera and then Playa Mujeres and now just returned from our second time to Punta Cana. We love Excellence... .So here goes The staff at excellence I rate 5 star all the way they are an amazing group of people friendly hard working and makes your stay wonderful.Pool beach and grounds a solid five star can't say more then wow .Now for the rooms we traveled as three couples all oceanview excellence Club seen all three rooms and they are all in need of work the rooms are showing there age all over the place a 4 rating is generous.Food a 3 rating very incosistent cold most of the time under cooked over cooked, the new ala carte menus has less selection and was not impressed at all. Desserts terriable . Deffinately a great decline since our last trip two years ago.Excellence Club we did it in 2007 and that is why we all choose to do it again I rate it a three the only thing good was the view and the ability for late check out as we had a late flight home. But for its service I rate it a 3...Excellence club was closed upon our late arrival so they gave us our keys and sent us on our way in pitch darkness we knew where we where going so we led the other two couples we traveled with too their rooms. Not impressed.Their service was VERY inconsistent beach towels in all of our three club rooms only once. Went to excellence Club three times for a channel changer in the end tipped staff and they got one from an unoccupied room. Turn down hit and miss had to ask for bathroom amenities, Would not exchange any liquor bottles in room which they did the first time we where there. The club lounge it self which used to have plenty of food to choose from literally had nothing during the day and evening cheese some fruit and bread not at all like it was excellence club has deteriated there service BIG TIME!!! The staff tended better to you then excellence club staff. We requested top floor for all three rooms and after all our returns we thought that was not an unreasonable request and we did not get one top floor room. Save your money and shame on you excellence Club for your lack of service. All three rooms had very inconsistne fridge stalking and was only resolved with a tip and even then once when givin a tip was not done.I will not be returning to Excellence Punta Cana and it is sliding down the charts for a reason. In saying all this we traveled with two other couples and we all had a fabulous time we just feel we did not get what we pated for. Anyone with questions please do not hesitate to contact meJan 6, 2009 9 6 4 3 2 3 3 1 5 4 CR_ONT Beautiful resort but be careful of a few things..... My husband and I just got back from a one-week trip to this resort.Our vacation did not start well. This hotel OVERBOOKS the nicest rooms. When we arrived they immediately downgraded us b/c they did not have the room we booked available. There was also an issue of miscommunication b/w our travel agent and the hotel and the hotel staff was TOTALLY unhelpful in resolving the issue. We had to do all of the legwork ourselves. At one point the concierge told us they could not phone our travel agency b/c that phone call would cost $. Really? That's customer service??Once all was resolved and we were in our proper room, the trip was wonderful. The property is gorgeous and well maintained. There are lots of restaurants to choose from and the food was as good or better than anything we've had in the Carribean. Apart from the front desk staff, all of the other employees are very friendly and helpful. Booking the Excellence Club is worth it - just make sure the documents you get back from your travel agency clearly state that your booking includes the Club.Jan 5, 2009 5 3 3 4 5 5 5 1 4 3 Traveling_Moose A varied but good experience We choose Excellence due to their very good reviews. Some broad observations on what have said.Distance- yes it's a good hour from the airport. We enjoyed the ride through the countryside and small towns. You're going to be in a bubble at an all-inclusive anyway; why not see some of the real island on the way?Rooms- we lucked out. Requested and got a ground floor corner non-smoking room. We also got a partial ocean view and strong sounds of the surf. Semi private patio with a single hammock. After walking around we saw how lucky we were. The majority of the rooms overlook a small interior

mp6-zpg2zwhv.txt screen-shot-2021-10-05-at-105810-pm-kpgy5vq0.png

FOR ALL WORK FROM WEEK 6 ONWARDS, YOU WILL NEED ADD-ON PYTHON MODULES SUCH AS pandas, numpy, re, and csv, among others. BEFORE ATTEMPTING ANY OF THIS WEEK'S WORK, FIRST REVIEW THE DETAILED NOTE ON ALL...

Get Answer To This Question

Related Questions & Answers

Submit New Assignment