Final Assignment
Question 1
1a
1b(i)
# A tibble: 2 × 2
sentiment n
<chr> <int>
1 negative 43890
2 positive 897121b(ii)
The overall feeling towards the hotel is mostly positive, with nice, clean and beautiful being the most common words used to describe it. The main complaints were to do with price and overcrowding, however when we compare those to the positive reviews, we can understand that price or overcrowding did not prohibit the majority of people from enjoying their stay, therefore ruling out the posibility of most customers not being satisfied with the cost of their stay.
1c
# A tibble: 10 × 2
sentiment n
<chr> <int>
1 positive 142865
2 joy 78868
3 trust 62167
4 anticipation 57325
5 negative 39748
6 surprise 25302
7 sadness 20286
8 anger 17196
9 fear 13913
10 disgust 103161d
# A tibble: 30 × 2
bigram n
<chr> <int>
1 rainbow tower 3567
2 hawaiian village 2909
3 hilton hawaiian 2821
4 ocean view 2332
5 diamond head 2180
6 waikiki beach 1710
7 tapa tower 1625
8 ali'i tower 1583
9 front desk 1328
10 resort fee 992
# ℹ 20 more rows1e
# A tibble: 30 × 2
trigram n
<chr> <int>
1 hilton hawaiian village 2614
2 diamond head tower 575
3 partial ocean view 389
4 ala moana shopping 365
5 friday night fireworks 358
6 round table pizza 205
7 moana shopping centre 171
8 ala moana mall 147
9 front desk staff 144
10 10 minute walk 137
# ℹ 20 more rows1f(i)
# A tibble: 10 × 3
review_date id text
<chr> <dbl> <chr>
1 17/06/2003 20 "Stayed at HHV on recent June trip to Hawaii. I am an owne…
2 15/07/2003 24 "Great stay at Hilton Hawaiin Village1. Spent 6 nights the…
3 11/10/2003 44 "We made reservations 3 months in advanced for an ocean vi…
4 20/11/2003 54 "I goto Hawai'i twice a year, and every time I go, I stay …
5 14/12/2003 59 "Since we frequently travel with our young children (2 and…
6 20/02/2004 72 "We stayed at the Hilton Hawaiian Village the week prior t…
7 16/04/2004 93 "Just returned from a nine night stay at the Lagoon Tower …
8 13/06/2004 112 "It was PARADISE! Our family stayed at the Hilton Hawaiian…
9 20/06/2004 116 "We honeymooned in Hawaii for two weeks the first being at…
10 29/06/2004 121 "We booked a partial ocean view room for $205 and were all…The lagoon reviews essentially describe how great the condition of the rooms were and what great views there were, and especially noted how friendly the staff were, making check in and customer service impeccable.
1f(ii)
# A tibble: 10 × 3
review_date id text
<chr> <dbl> <chr>
1 06/02/2003 9 "Loved the hotel and the staff. Had a upper floor room in …
2 23/02/2003 11 "We stayed at the Rainbow Tower and the view was amazing! …
3 24/07/2003 26 "We just returned from a 7 day, 6 night stay at the Hilton…
4 12/08/2003 31 "Our Hawaii Family vacation (July 28th, 2003) to Oahu incl…
5 16/08/2003 32 "Our dream vacation at the Hilton Hawaiin on June 22 was n…
6 10/09/2003 38 "My husband and I just returned from the wonderful island …
7 11/10/2003 44 "We made reservations 3 months in advanced for an ocean vi…
8 30/11/2003 57 "My husband and I enjoyed our first three days of our hone…
9 14/12/2003 59 "Since we frequently travel with our young children (2 and…
10 24/12/2003 60 "In Dec'02, I stayed at the HHV for 2 weeks. I stayed at t…The Rainbow Tower reviews were fairly positive, with customers being happy with the view as well as the comfy beds and clenlieness of the rooms.
1f(iii)
# A tibble: 10 × 3
review_date id text
<chr> <dbl> <chr>
1 10/09/2003 38 "My husband and I just returned from the wonderful island …
2 04/03/2004 82 "I won our holiday in a competition with a local radio sta…
3 11/07/2004 124 "Stayed at the Hilton Hawaiian Village from 7/3/04-7/9/04 …
4 08/05/2005 258 "My Husband and I just came back from HHV after staying fo…
5 14/07/2005 287 "My wife, two boys (12 & 16) and I stayed at in the Ali'i …
6 01/08/2005 300 "My family and I stayed at HHV for our first trip to Hawai…
7 06/10/2005 352 "pros: hotel right on beach! this is not so common on Waik…
8 07/11/2005 367 "We stayed in the Ali'i tower - definately a good move. Fr…
9 26/12/2005 391 "My husband, myself and our 10 year old son just returned …
10 17/01/2006 404 "We just returned...good trip. We have a 14, 11 yr old plu…In general, the Ala Moana shopping centre reviews were more negative, with the main complaint being about it being too expensive.
1g
Question 2
2a
<<DocumentTermMatrix (documents: 1525, terms: 8460)>>
Non-/sparse entries: 42032/12859468
Sparsity : 100%
Maximal term length: 22
Weighting : term frequency (tf)2b
A LDA_Gibbs topic model with 12 topics.2c
topic_num topic_size mean_token_length dist_from_corpus tf_df_dist
1 1 679.7835 5.2 0.6094804 5.264284
2 2 757.3316 5.7 0.6025832 5.255577
3 3 765.1819 4.9 0.6109637 2.515860
4 4 632.0196 5.0 0.6062474 4.956614
5 5 651.5361 5.8 0.5912534 4.815915
6 6 684.0719 4.6 0.6107813 3.179492
7 7 648.9375 7.0 0.6136500 2.831027
8 8 716.8746 5.3 0.6047843 6.476463
9 9 752.0914 5.9 0.6026265 1.766864
10 10 768.5831 4.7 0.5970428 2.057957
11 11 723.7747 5.5 0.6110572 4.217963
12 12 679.8142 5.8 0.6277362 3.718974
doc_prominence topic_coherence topic_exclusivity
1 3 -173.0021 9.890127
2 9 -175.9003 9.909063
3 12 -171.1145 9.976613
4 28 -120.0684 9.951058
5 1 -129.3061 9.837345
6 12 -149.1790 9.956861
7 12 -135.2615 9.939567
8 8 -162.3335 9.844527
9 5 -176.5321 9.935250
10 5 -171.4565 9.894294
11 16 -146.8533 9.922355
12 35 -149.6859 9.991781Recommendations for Mcdonalds Judging by the top 10 terms per topic, we can see that customer service could definitely be as we see when we look into topic 6 and 7, customer sevice trainig is an advised action for this mcdonalds. Topic 5 indicates that drive thru waiting times might be too long, they could offer another drive thru lane to solve this. Topic 9 indicates that there might be cleanlinesss issues, so I would recommend that they do a full clean of the place more frequently.