Session 11
Ramya
11 November 2017
1.How many total hotels are there in the sample?
cities<-read.csv("AllCitiesData.csv")
unique(cities$HotelName)
[1] Nadesar Palace
[2] Taj Nadesar Palace
[3] Umaid Bhawan Palace
[4] Rambagh Palace
[5] The Oberoi Rajvilas
[6] The Oberoi Amarvilas
[7] The Oberoi Udaivilas, Udaipur
[8] The Leela Kovalam Beach
[9] Xandari Harbour
[10] Xandari Hotel
[11] The Leela Palace Udaipur
[12] Taj Lake Palace
[13] Fateh Prakash Palace
[14] Shiv Niwas Palace
[15] Vivanta by Taj
[16] The Zuri White Sands
[17] Vivanta by Taj - Green Cove, Kovalam
[18] The Raj Palace
[19] The O Resort and Spa
[20] Taj Exotica
[21] Mihir Garh
[22] Vivanta by Taj - Fort Aguada, Goa
[23] Radisson Blu Udaipur Palace Resort & Spa
[24] The Lalit Laxmi Vilas Palace
[25] lebua Resort, Jaipur
[26] Ramada Udaipur Resort and Spa
[27] The Ummed Jodhpur
[28] Niraamaya Surya Samudra
[29] Niraamya Surya Samudra
[30] Seashell Beach Suites
[31] The LaLiT Chandigarh
[32] Hotel Lakend
[33] Mayfair Hideaway Spa Resort
[34] Jai Mahal Palace
[35] Ranbanka Palace
[36] Aquatic Floating Resort
[37] The Ananta Udaipur
[38] Jaisalmer Marriott Resort & Spa
[39] BrijRama Palace
[40] Purity
[41] Aguada Anchorage
[42] The Gateway Hotel Varkala
[43] OYO Premium Jubilee Garden Jawahar Road
[44] RAAS Jodhpur
[45] The Malabar House
[46] Deltin Suites
[47] Vivanta by Taj - Dal View, Srinagar
[48] Indana Palace Jodhpur
[49] The Ajit Bhawan - A Palace Resort
[50] The Khyber Himalayan Resort & Spa
[51] Hotel Rang Mahal
[52] The Gateway Hotel Ramgarh
[53] Shiv Vilas Resorts
[54] Novotel Goa Shrem
[55] OYO Premium Limda Chowk
[56] Brunton Boatyard
[57] Samode Haveli
[58] Trident, Jaipur
[59] Hotel Rawal Kot
[60] Jaisalkot
[61] Souvenir Premier
[62] Chokhi Dhani Resort
[63] Jaypee Palace Hotel
[64] Park Regis Goa
[65] The LaLiT Golf & Spa Resort Goa
[66] RAAS Devigarh
[67] Suryagarh
[68] Gorbandh Palace
[69] Trident, Udaipur
[70] Mango Hotels Jasminn
[71] Lemon Tree Amarante Beach Resort, Goa
[72] Bogmallo Beach Resort
[73] Ramada Palaza JHV
[74] The Fern Residency Udaipur
[75] The Gateway Hotel Pasumalai
[76] Shalai - The Cliff Resort
[77] Bijolai Palace, A Treehouse Palace Hotel
[78] WelcomHeritage Mandir Palace
[79] Holiday Inn Jaipur
[80] Tea Bungalow
[81] Renaissance Lucknow
[82] Turtle on the Beach
[83] Fortune Acron Regina
[84] Suryauday Haveli
[85] Eigth Bastion
[86] Chunda Palace
[87] OYO Rooms Bhuwana Bypass
[88] Silver Sands Hide Away
[89] Beleza By The Beach
[90] The Acacia Hotel & Spa Goa
[91] Fort Chanwa by Citrus
[92] Anantya Resorts
[93] Crowne Plaza Kochi
[94] The Gateway Hotel Ganges
[95] Kochi Marriott Hotel
[96] Lazy Lagoon Sarovar Portico Suites
[97] Nirvana Hermitage
[98] Howard Plaza The Fern
[99] OYO Premium Vazhuthacaud
[100] Uday Samudra Leisure Beach Hotel
[101] OYO Premium Bani Park
[102] The Belmonte by ACE
[103] Aloha On The Ganges
[104] Crowne Plaza Jaipur
[105] Trident, Bhubaneswar
[106] Narayans Leela Inn
[107] Lemon Tree Hotel Candolim Goa
[108] OYO premium airport extension
[109] SMS Hotel
[110] Vivanta by Taj - Gomti Nagar, Lucknow
[111] Double Tree by Hilton Hotel Goa
[112] The Treehouse Blue
[113] Chokhi Dhani The Palace Hotel
[114] Damodra Desert Camp
[115] OYO Premium Jagatsukh Valley
[116] OYO Premium Paltan Bazar
[117] OYO Premium Madurai Railway Junction
[118] WelcomHeritage Ranjits Svaasa
[119] Ramada Plaza Agra
[120] De Alturas Resort
[121] Tatsaraasa Resort and Spa Udaipur
[122] Hyatt Regency, Chandigarh
[123] Devasthali - The Valley of Gods
[124] Solang Valley Resort
[125] Koder House
[126] Hotel Royal Pratap Niwas
[127] Shree Ram International
[128] Golden Tulip Goa Candolim
[129] Trident Cochin
[130] OYO Premium Hadimba Temple
[131] Sol De Goa
[132] Hilton Jaipur
[133] Jaipur Marriott Hotel
[134] Fairfield By Marriott Lucknow
[135] JW Marriott Hotel, Chandigarh
[136] The LaLiT Jaipur
[137] VITS Bhubaneswar
[138] Sterling Villagio Inn
[139] Joecons Beach Resort
[140] Harmonium Resorts Agonda
[141] The Vintage Gulmarg
[142] Radisson Blue Hotel Agra Taj East Gate Road
[143] Olive Downtown Kochi
[144] Hotel Aurora Towe
[145] White Pear Suites
[146] OYO Premium Airforce Board Cantonment
[147] OYO Rooms Near Meera Garden Indore
[148] OYO Rooms Sanganva Chowk Trikon Baugh
[149] Rajputana Udaipur - A j\303\274STa Resort
[150] The Travancore Heritage
[151] Ramada Resort
[152] Ramada Resort Cochin
[153] Hotel Citi Heights
[154] Rivatas
[155] OYO Premium Vytilla Bypass
[156] OYO Premium Ganges Marine Drive
[157] Manuallaya The Resort Spa in the Himalayas
[158] OYO Rooms Meenakshi Amman Temple
[159] Sukhmantra Resort
[160] The Fern Gardenia Resort
[161] Sayaji Pune
[162] Taj Chandigarh
[163] OYO Premium Nayapalli IRC Village
[164] OYO Premium Vani Vihar
[165] Vivanta by Taj - Hari Mahal, Jodhpur
[166] Spice Fort by Dune Eco Group
[167] Zense Resort
[168] Orritel Hotel Hinjewadi
[169] Tissa's Inn
[170] Silver Sands Beach Resort
[171] Mayfair Lagoon
[172] Country Inn & Suites by Carlson
[173] OYO Premium Baner Road
[174] Highland Beach Resort
[175] Courtyard by Marriott Agra
[176] Jagrati Lords Inn
[177] The Gateway Hotel Fatehabad RoadTop Hotel
[178] Trident, Agra
[179] Park Plaza Jodhpur
[180] Courtyard Kochi Airport
[181] ShivAdya Resort & Spa
[182] Hotel Turquoise, Chandigarh
[183] Estuary Island
[184] lebua Lucknow
[185] OYO Rooms Celebration Mall
[186] Fortune Select Metropolitan
[187] Radisson Goa Candolim
[188] The Continental Lucknow
[189] OYO Premium Mukti Dham Rishikesh
[190] Hotel Gandharva By Peppermint
[191] The Anantmaya Resort
[192] Neptune Point Hill Cottages
[193] OYO Premium RNT Marg
[194] Double Tree by Hilton agra
[195] Resort Rio
[196] Beaumonde The Fern
[197] 1st Gate Home- Fusion
[198] La Ri Sa Resort
[199] Vivanta by Taj - Blue Diamond
[200] Hotel City Plaza 17
[201] Cambay Resort Udaipur
[202] Colonel's Camp Oasis India
[203] OYO Premium Log Huts
[204] Ganga Kinare - A Rive ide Boutique Hotel
[205] Lemon Tree Premier, Jaipur
[206] SinQ Party Hotel
[207] Q Hotel, Udaipur, India
[208] OYO Premium Balewadi
[209] OYO Premium Charbagh Lucknow
[210] OYO Premium Nath Mandir South Tukoganj
[211] OYO Premium IVY Hospital
[212] Vivanta by Taj - Guwahati
[213] Whispering Palms Beach Resort
[214] The O Hotel
[215] Regenta Resort Varca Beach
[216] Stone Water Eco Resort
[217] Radisson Blu Kochi
[218] Horizon Hotel
[219] The Amargarh Udaipur
[220] Over The Hill
[221] Hotel Gateway Grandeur
[222] Raasleela
[223] OYO Rooms 100ft Road Udaipur
[224] Hotel Arches
[225] Marriott Suits Pune
[226] Sayaji Hotel
[227] The Gulaal
[228] Casino Hotel
[229] OYO Premium Himalayan View
[230] Garden Hotel
[231] Oyo premiuim Delhi Jaipur Highway
[232] OYO Premium Kakkanad Civil Station
[233] OYO Rooms Akurdi Pune
[234] Beach Bay Cottages
[235] JW Marriott Hotel
[236] Treebo Jaisingh Garh
[237] Radisson Blu Jaipur
[238] OYO Premium World Trade Park
[239] OYO Rooms Near Laxminarayan Theatre Swargate
[240] KK Royal Hotel & Convection Center
[241] Hyatt Amritsar
[242] Crowne Plaza Pune City Centre
[243] Oakwood Residence Naylor Road
[244] Velvet Clarks Exotica, Chandigarh
[245] Apple Country Resorts - Manali
[246] Sodders Gloria Anne
[247] OYO Premium Railway Station
[248] OYO Rooms Lake Palace II
[249] OYO Rooms Aleo Manali
[250] Citrus Manali Resorts
[251] Vivanta By Taj
[252] Vivanta by Taj - Trivandrum, Kerala
[253] Mewargarh Udaipur by Red Lion Hotels
[254] Treebo Rain Forest Enclave
[255] OYO Rooms Sunset Point Jaisalmer
[256] OYO Premium Hampta View
[257] OYO Rooms Near Gokul Das Hospital
[258] Holiday Inn Cochin
[259] OYO Rooms Railway Station Jain Dharamshala
[260] OYO Premium Anand Nagar Guwahati
[261] Zone by The Park Bani Park Jaipur
[262] Goldfinch Hotel
[263] Vista Exotic at Sam Sand Jaisalmer
[264] The Gateway Hotel Athwalines
[265] Hyatt Regency Pune
[266] Clarks Avadh
[267] Clarks Awadh
[268] Country Inn & Suites By Carlson Amritsar
[269] Casino Hotel- CGH Earth, Cochin
[270] OYO Rooms Jaipur Bypass Jhalamand
[271] OYO Rooms Textile Market
[272] OYO Apartments Kalyani Nagar Gold Adlabs
[273] OYO Premium Pimpri Finolex Chowk
[274] OYO Premium Husadiya Chauraha
[275] Heritage Khirasara Palace
[276] The Udaibagh Udaipur
[277] Justa Nathdwara
[278] Hotel Mirage
[279] OYO Premium Station Road Jodhpur
[280] The Wallstreet A Busines Hotel
[281] Sarovar Portico Jaipur
[282] Crystal Sarovar Premiere Agra
[283] Hotel Clarks Shiraz
[284] Soul Vacation Resort and Spa
[285] Niralidhani Ethnic Resort
[286] Jagat Niwas Palace
[287] The Gateway Hotel Hinjawadi
[288] Regency Lagoon Resort
[289] Hilton Gardon Inn
[290] Hotel Ashish Palace
[291] The Grand Leoney Resort
[292] Conrad Pune
[293] OYO Premium Star Prini
[294] OYO Rooms Pattom Marappalam Road
[295] OYO Rooms Bendoorwell Junction
[296] Clarks Amer
[297] St Laurn Business Hotel
[298] OYO Premium Old Station Rd Bhubaneswar 4
[299] Leoney Resort
[300] Alegria - The Goan Village
[301] EllBee Ganga View
[302] OYO Premium Sector 22B Chandigarh
[303] OYO Rooms Jodhpur Railway Station
[304] OYO Rooms Sector 35 C Chandigarh
[305] Manaltheeram Ayurveda Beach Village
[306] Hotel Golden Manor
[307] Poppys Hotel
[308] Sunita Guest House
[309] Club Mahindra Udaipur
[310] Novotel Pune Nagar Road
[311] Cygnett Inn Repose
[312] OYO Rooms Godowlia Shivala Road
[313] OYO Rooms Old Station Lane
[314] Devendra Garh
[315] Levana
[316] OYO Rooms Simsa Manali
[317] OYO Rooms Katraj
[318] The Kothi Heritage
[319] White Meadows Manali by Mahindra Holidays
[320] ITC Rajputana- Jaipur
[321] Agra Regal Vista A sterling Resort
[322] James Plaza Limited (Formerly Park Plaza, Chandigarh)
[323] OYO Premium Near Sankat Mochan Mandir
[324] OYO Rooms Old Public Park
[325] Presidency Blu
[326] Park Regis
[327] Park Regis Jaipur
[328] OYO Premium Malviya Nagar JLN Marg
[329] OYO Rooms Kisan Bhawan Chowk
[330] OYO Premium Tapovan 1
[331] OYO Rooms Heritage Charbagh
[332] OYO Premium Gondal Road NH27
[333] A Palace On River
[334] United-21 Lake City Resort
[335] La Place Sarovar Portico, Lucknow
[336] Sodder's Beach Classic
[337] Umaid Mahal
[338] Mansingh Palace
[339] Courtyard by Mariott, Pune
[340] Country Inn By Carlson-Indore
[341] Hotel Sarovar
[342] Hycinth by Sparsa
[343] The Gateway Hotel Old Port Rd
[344] Hotel Sky Plaza
[345] OYO Rooms Tonk Phatak
[346] OYO Premium Simsa Resort
[347] OYO Rooms Trivandrum Railway Station
[348] OYO Rooms Mangalore Railway Station
[349] Royal Orchid Golden Suites Pune
[350] Fortune Landmark Indor
[351] God's Own Country Ayurveda Resorts
[352] Micasa By The Sea
[353] OYO Apartments Kharadi Bypass
[354] OYO Rooms Balgandharva JM Road
[355] OYO Rooms Sambhaji Nagar Thermax Pimpri
[356] OYO Rooms Thermax Pimpri
[357] OYO Rooms 80 Feet Road
[358] OYO Rooms Rajmahal Square 2
[359] Flora Airport Hotel
[360] Jodhana Elite
[361] Hotel Moti Mahal
[362] OYO Rooms Madurai Periyar Bus Stand
[363] OYO Rooms Lake Palace Road
[364] OYO Rooms South Main Road Koregaon park
[365] OYO Rooms Lucknow Junction
[366] Manali White Mist A Sterling Holidays RESORT
[367] Park Inn Jaipur
[368] The Imperial Palace Hotel
[369] Vista Rooms at Geeta Ashram
[370] OYO Rooms Airport Tonk Road
[371] OYO Rooms IP Mall Sigra
[372] Orient Taj Hotels And Resorts
[373] Hotel Studio Estique
[374] Holiday Inn Amritsar Ranjit Avenue
[375] Spice Heritage
[376] OYO Rooms Beas Valley
[377] Vista Rooms at Bada Bagh Road
[378] Hotel City Park
[379] OYO Rooms Sambhaji Garden
[380] OYO Rooms Bada Chauraha Civil Lines
[381] OYO Rooms Rasoma Circle
[382] The Verda Saffron
[383] Dera Rawatsar
[384] Suryaa Villa
[385] Flute Boutique Hotel
[386] Umaid Haveli Hotel & Resorts
[387] Umaid Haveli Hotels & Resorts
[388] Hotel Marigold Jaipur
[389] Nirwana Hometel Jaipur - A Sarovar Hotel
[390] Hotel Mansingh
[391] Regency Madurai by GRT Hotel
[392] The Tubki Resort
[393] V Resorts Rajaji National Park
[394] The Golden House
[395] Keys Prima Hotel Parc Estique
[396] The Lalit Traveller Jaipur
[397] The lalit traveller jaipur
[398] Park Plaza Zirakpur
[399] OYO Rooms Khole Ke Hanuman Ji
[400] OYO Rooms Patiala Road Zirakpur
[401] No. 18 Hotel
[402] The Fern - An Ecotel Hotel
[403] Hotel Padmini Palace
[404] OYO Premium Near Aravind Eye Hospital
[405] OYO Room MG Road Rakabganj Agra
[406] OYO Rooms Kanchan Bagh 2
[407] OYO Rooms Manglore Jyothi Circle
[408] The Gateway Hotel
[409] The Gateway Hotel Marine Drive
[410] The Marwar Hotel & Gardens
[411] OYO Rooms Shanti Path Jawahar Nagar
[412] OYO Rooms Navlakha Bus Stand
[413] Fortune Pandiyan Hotel
[414] Hotel Surya
[415] Summit Chandertal Regency & Spa
[416] Citrus Pimpri - Pune
[417] Hyatt Pune
[418] OYO room Mahmoorganj
[419] OYO Rooms VIP Road Zirakpur
[420] Fortune Park JPS Grand
[421] The Little Prince Heritage Home
[422] Lemon Tree Hotel, Chandigarh
[423] Snow Valley Resorts
[424] Sun N Sand Pune
[425] The Banyan Soul
[426] Hyatt Place Pune/Hinjawadi
[427] Phils Residency
[428] OYO Premium Apple Garden
[429] OYO Rooms Delhi Gate 3
[430] The Retreat
[431] Palolem Green Inn
[432] Haveli Inn Pal
[433] Hotel Dream Palace
[434] Golden Haveli
[435] Honeymoon Inn
[436] Holiday Inn Pune Hinjewadi
[437] Hotel New Leaf
[438] Orritel Convention Spa & Wedding Resort
[439] Radisson Blu Hotel Pune Kharadi
[440] Fortune Bella Casa
[441] Hotel Amar Kothi
[442] Spree Shivai Hotel
[443] Royal Star
[444] Holiday Inn Chandigarh Panchkula
[445] Avaas Lifestyle Hotel
[446] Cuba Agonda
[447] Hotel Abad Plaza
[448] Napier House
[449] Lake Palace Hotel Trivandrum
[450] OYO Rooms Gopalpura Flyover Tonk Road
[451] OYO Rooms Bani Park Shri Ram Marg
[452] OYO Rooms Near Station Gulambaba Road 2
[453] OYO Rooms Dhakkan Wala Kuan
[454] OYO Rooms Near CHL Hospital Indore
[455] Bull's Retreat
[456] Doubletree by Hilton
[457] OYO Rooms Opposite K Area Zirakpur 6
[458] Urvashi's Retreat
[459] The Pride Hotel
[460] Effotel Hotel Indore
[461] Gemini Continental Lucknow
[462] The Golden Plaza Hotel & Spa
[463] Ganga Beach Resort
[464] Ginger Jaipur
[465] OYO Rooms Mahmoorganj
[466] OYO Apartments Pune Nagar Road
[467] Treebo Vatika Inn
[468] Amer City Heritage
[469] Hotel Royal Haveli
[470] Manali Heights
[471] Ibis Jaipur Hotel
[472] Club Mahindra Manali
[473] Lords Plaza, Surat
[474] Rossitta Wood Castle
[475] Mandiram Palace
[476] AR Suites Fontana Bay
[477] The Central Park Hotel
[478] OYO Rooms Sector 11 Panchkula
[479] KTDC Mascot Hotel Thiruvananthapuram
[480] Abad Atrium
[481] Beach and Lake Ayurvedic Resort
[482] Gitanjali Jaipur
[483] Anjuna Beach Resort
[484] Camp Paradise
[485] Fortune Inn Exotica Hinjawadi
[486] Hotel Shree Panchratna
[487] The Fern Residency, Chandigarh
[488] Fortune Hotel The South Park
[489] Golden Tulip Jaipur
[490] ibis Pune - An AccorHotels Brand
[491] Mango Hotels Prangan
[492] HOTEL ORANGE INTERNATIONAL
[493] Hotel Poonam Haveli
[494] Windsor Rajdhani
[495] The Grand Imperial Heritage Hotel
[496] The Toy Hotel, Chandigarh
[497] United-21 The Grand
[498] OYO Rooms Jyothi Circle
[499] Hotel Vishnupriya
[500] Uddhav Vilas Hotel
[501] The Orchid
[502] Rawla Rawatsar
[503] Le ROI Udaipur
[504] Ginger Mangalore
[505] Hotel Seven Hills Tower
[506] Vivaan The Sunrise Resort
[507] Bhairavgarh By Zennia Hotels
[508] OYO Rooms Link Road
[509] The Residency Tower
[510] United-21 Emerald Forest Hotel
[511] Hotel La Paz Gardens
[512] Savi Camps
[513] Om Niwas Suite Hotel
[514] Hotel KLG Starlite, Chandigarh
[515] OYO Rooms Model Town
[516] OYO Rooms Sadashiv Peth
[517] OYO Rooms AP Sen Road Charbagh
[518] OYO Rooms Opposite K Area Zirakpur 1
[519] OYO Rooms Infocity Road
[520] OYO Rooms Opposite K Area Zirakpur 7
[521] OYO Rooms Opposite K Area Zirakpur 8
[522] Keys Hotel
[523] Keys Hotel Kochin
[524] Imperial Regency
[525] Hotel Buddha
[526] OYO Apartments Baner Road
[527] Beach Florra Inn
[528] Crimson Park - The Heritage
[529] Hotel Karan Vilas
[530] Apnayt Villa
[531] THE PGS VEDANTA COCHIN
[532] The Fern Residency
[533] Hotel Aquamarine, Chandigarh
[534] Vishwaratna Hotel
[535] Citrus Hotels
[536] Treebo Raya Inn
[537] Heritage Village Resorts
[538] Hotel Sagar Plaza
[539] Lily of Nageen
[540] Regenta Almeida Zirakpur Chandigarh
[541] OYO Rooms Race Course Ring Road
[542] Palolem Beach Resort
[543] OYO Rooms Rajendra Nagar Indore
[544] Hotel Atulyaa Taj
[545] Hotel Royal Park
[546] OYO Rooms Chandigarh Sector 34
[547] The Byke Old Anchor beach Resort
[548] Bharat Hotel
[549] BTH Sarovaram
[550] Classic Sarovar Portico
[551] Hotel Crystal Inn
[552] OYO Premium Lucknow Railway Station
[553] OYO Rooms C Road Paota
[554] OYO Rooms Bicholi Hapsi Indore
[555] OYO Rooms Limda Chowk II
[556] Hotel Imperial
[557] Hibiscus Guest House
[558] Treebo Sunshine
[559] Comfort Inn
[560] Quarto De Casa Tipri
[561] The Mercy Luxury Business Hotel
[562] OYO Rooms Taj Mahal East Gate
[563] Vista Rooms At Bapu Gandhi Nagar
[564] Hotel Airlink Castle
[565] Hotel City Heart Premium
[566] OYO Rooms Rangri Valley Manali
[567] OYO Rooms Limda Chowk
[568] OYO Rooms Phulchhab Chowk II
[569] Red Fox Hotel
[570] Pebbles Guesthouse
[571] Treebo Signature Inn
[572] The Varkala Beach Resort and Ayurvedic Spa
[573] OYO Rooms Valley View Manali
[574] Hotel Madhushrie
[575] Hill and Sea View Beach Resort
[576] Elphinstone Residency
[577] Hotel Fort Castle
[578] Pepper Route
[579] Hotel Alleviate
[580] Hotel Namaskar Residency
[581] The Fern Residency Amritsar
[582] Diamond Hotel
[583] Ganga Maonestary
[584] Gokulam Park Hotel & Convention Centre
[585] The Lavitra Udaipur
[586] Vista Roms at Bera Road
[587] OYO Rooms Technopark Extension
[588] Vesta Maurya Palace
[589] Hotel Taj Resorts
[590] Budget Inn Bellevue
[591] Hotel Executive Residency
[592] Hotel Rajshree, Chandigarh
[593] Hotel Vaibhav Harsh
[594] Treebo Woodsvilla Suites
[595] San Joao Holiday Homes
[596] Hotel H.R. Palace
[597] Mint Hotel, Chandigarh
[598] Taj Villa
[599] Vista Rooms
[600] Premier Inn Pune Kharadi
[601] Country Spa Wellness Beach Resort
[602] MS Residence
[603] FabHotel Lotus Koregaon Park
[604] Comfort Inn Legacy
[605] OYO StayOut 1BHK Betalbatim Beach
[606] OYO Premium Opposite Panchkula Bus Stand
[607] Vagator House
[608] Hotel Sifat International
[609] Golden Tulip Chandigarh Panchkula
[610] P L Palace Lords Inn Agra
[611] Shantai Hotel
[612] OYO Rooms Sayaji Square
[613] Hotel Helsinki House
[614] Red Fox Hotel Chandigarh
[615] Treebo Aroma Residency
[616] Clarks Inn, Amritsar
[617] Kedareswar Bed and Breakfast
[618] Park Central
[619] Treebo Western Court Panchkula
[620] Diana Heights
[621] Keys Hotel Pimpri
[622] Hotel Alka
[623] OYO Rooms Nayapalli
[624] Hotel Gorbandh
[625] Vista Rooms at Hanuman Mandir
[626] Hotel Love Kush
[627] Hotel City Heart
[628] OYO Rooms Queens Road
[629] 14 Square Amanora
[630] Keys Hotel, Thiruvananthapuram
[631] Neptune point beach resort
[632] Hotel Sarang Palace
[633] Astoria Hotels
[634] Ganges Inn
[635] Palace on Step
[636] Palace on step
[637] Chandra Inn
[638] Hotel Dewland
[639] Hotel Baba Palace
[640] Unwind Hotels and Resort
[641] OYO Rooms Yagnik Road
[642] Treebo Sapphire Star
[643] Treebo Rana Villa
[644] Fort Beach Service Apartments
[645] Fort Beach Service Department
[646] Eden Garden Heritage Homestay
[647] Hotel Sapphire
[648] Hotel Yog Vashishth
[649] Mango Hotels, Agra-Sikandra
[650] OYO Rooms Panchkula Sector 9
[651] OYO Rooms Panchkula Sector 10
[652] OYO Rooms Panchkula Sector 11
[653] Hotel Emerald, Chandigarh
[654] Shahi Heritage - Shahi Guest House
[655] ADB Rooms The Light House Agra
[656] Phoenix Hotel
[657] Hotel Royale Residency
[658] Palolem Guest House
[659] Hotel Vimal Heritage
[660] Hotel Millennium Continental
[661] Hotel Narula's Aurrum
[662] Hotel Dasaprakash
[663] Best Western Yuvraj
[664] Treebo Woodstock Inn
[665] Ginger Bhubaneswar
[666] The International Hotel
[667] Ocean Park Beach Resort
[668] The Ocean Park Beach Resort
[669] Comfort Inn Sapphire
[670] FabHotel Blossoms Pune Airport
[671] Treebo Celebriti
[672] Hotel Bhoomi Residency
[673] Divine Destinataion
[674] Hotel Central Residency
[675] Biverah Hotel & Suites
[676] Noorya Hometel
[677] Arya Niwas
[678] Hotel V Inn Bani Park
[679] Treebo Adrak
[680] Hotel Jaipur Ashok
[681] Hotel Aura Mumtaz Mahal
[682] The Prem Beacon Jodhpur
[683] Hotel Angels Inn
[684] G Hotel
[685] Hotel Varuna
[686] Siris 18
[687] Hotel Savi Residency
[688] Hotel Presidency
[689] Hotel Snowcrest Manor
[690] Roundcube Guest House
[691] OYO Rooms Phase 3B2 Mohali
[692] Aroma Homestay
[693] Niyati-Boutique Stay
[694] Ray Of Maya Retreat and Resorts
[695] Gupta Inn
[696] Dylan Cafe & Guest House
[697] Hotel Akashdeep
[698] Hotel Marine Palace
[699] Marine Palace
[700] Hotel Kings Corner
[701] Graciano Cottages
[702] Hotel Bhooshan
[703] Siesta Springs
[704] Treebo Deccan8
[705] Hotel Diamond Plaza
[706] Hotel Orchard Pune
[707] 66 Residency
[708] Hotel City Plaza 16
[709] Hotel City Plaza 18
[710] Hotel City Plaza 19
[711] Hotel City Plaza 20
[712] Hotel Taj Heights
[713] Hotel Dayal
[714] Treebo Rigel Inn
[715] Amigo Serviced Apartments - Baner
[716] Treebo Cherry Tree
[717] Kalyan Beacon Hotel Jaisalmer
[718] New Ideal Panchakarma Centre
[719] Hotel Pushpak
[720] Valencia Hospitality Service Apartments
[721] Hotel Swan Inn
[722] RnB 1598, Jaipur
[723] Rudra Vilas Agra
[724] The Senate Hotel
[725] Abad Metro
[726] Margao Residency
[727] OYO Rooms Panchkula Sector 6
[728] Hotel Taj Prince
[729] Treebo OG's Kanthari
[730] OYO Rooms Panchkula Sector 4
[731] Treebo Dreamland
[732] Anjani Hotel
[733] Anuraag Villa
[734] Ecolodge
[735] Treebo Shivani
[736] OYO Rooms Old Station Road 2
[737] The Golden Palms Hotel And Spa
[738] Tara Niwas
[739] OYO Rooms ST Bus Station Rajkot
[740] Vedanta Wake up - Kovalam, Hawa Beach
[741] Hotel FORMULE1 Pune Hinjewadi
[742] Madhu Resorts
[743] 14 Square Serviced Apartments Magarpatta
[744] Hotel City Castle
[745] Atlas Airport Hotel Apartment
[746] OYO Rooms Panchkula Sector 7
[747] OYO Rooms Panchkula Sector 8
[748] FabHotel Orbion Mall Road
[749] Treebo Ocean
[750] Star residency madurai
[751] XL Homestay
[752] Hotel Tokyo Palace
[753] Ideal Ayurvedic Resort
[754] Prathiba Heritage
[755] Hotel Taj Plaza
[756] GenX Jodhpur
[757] Hotel Akaal Residency
[758] Backpacker Panda Oasis Jaisalmer
[759] Optimum Tara Palace
[760] Rishikesh Sadan
[761] OYO Rooms Bapuji Nagar
[762] OYO Rooms Panchkula Sector 5
[763] Treebo Berrys Boutique
[764] Hotel Aiswarya
[765] Hotel Royal Executive
[766] Treebo Mart View
[767] North Center
[768] Trivandrum Hotel
[769] Madeleine Inn
[770] Hotel Amer View
[771] Hotel Deviram palace
[772] OYO Rooms Opposite K Area Zirakpur 4
[773] OYO Rooms Opposite K Area Zirakpur 5
[774] Honolulu Home
[775] OYO Rooms Sum Hospital
[776] OYO Rooms Opposite K Area Zirakpur 2
[777] OYO Rooms Opposite K Area Zirakpur 3
[778] Hotel Crystal Retreat
[779] Equator
[780] FabHotel Padmavati Palace
[781] Kapithan's Inn
[782] Hotel Golden Deluxe
[783] Jaipur Inn
[784] Hotel Idea Inn
[785] Treebo White Inn
[786] Hotel Dreams
[787] Hotel Rooms
[788] Hotel Basera
[789] Hotel City Plaza 3
[790] Hotel City Plaza 5
[791] Hotel City Plaza 6
[792] Hotel City Plaza 7
[793] Hotel City Plaza 8
[794] Hill Place Hotels
[795] Hotel Aicon Palace
[796] OYO Rooms Aatish Market
[797] Hotel Ganesha
[798] Hotel City Plaza 4
[799] Hotel City Plaza 9
[800] Hotel City Plaza 10
[801] Vedanta Wake Up
[802] Hotel Hayat Rabbani
[803] OYO Rooms Raja Park
[804] Hotel Grace Agra
[805] Maya Hotel & Restaurant
[806] Hotel Satkar
[807] Pyrenees Homestay
[808] Royal Aashiyana
[809] Royal Aashiyana Palace Hotel
[810] Baba Guest House
[811] St. Anthonys Lodge
[812] Hotel Aditya Palace
[813] Backpacker Panda Friends - Agra
813 Levels: 14 Square Amanora ... lebua Resort, Jaipur
2.How many total cities are there in the sample?
unique(cities$CityName)
[1] Varanasi Jodhpur Jaipur Agra
[5] Udaipur Thiruvanthipuram Kochi Goa
[9] Chandigarh Jaisalmer Rajkot Srinagar
[13] Madurai Lucknow Rishikesh Bhubaneswar
[17] Manali Guwahati Amritsar Pune
[21] Indore Panchkula Surat Mangalore
[25] Kanpur
25 Levels: Agra Amritsar Bhubaneswar Chandigarh Goa Guwahati ... Varanasi
3.What is the average room rent in the sample?
mean(cities$RoomRent)
[1] 6024.896
4.What is the median room rent in the sample?
median(cities$RoomRent)
[1] 4000
5.Create a table showing the average room rent in Tourist and non-Tourist destinations
aggregate(cities$RoomRent,by=list(Tourist=cities$IsTouristDestination),FUN=mean)
Tourist x
1 No 4507.500
2 Yes 6790.124
6.Plot the average rent in Tourist and non-Tourist destinations.
library(gplots)
plotmeans(cities$RoomRent~cities$IsTouristDestination,mean.labels=TRUE)
7.Create a table summarizing the average room rent at hotels offering and not-offering swimming pool at Tourist and non-Tourist destinations
aggregate(cities$RoomRent,by=list(Pool=cities$HasSwimmingPool,Tourist=cities$IsTouristDestination),FUN=mean)
Pool Tourist x
1 No No 3328.812
2 Yes No 6691.175
3 No Yes 3966.258
4 Yes Yes 10563.975
8.Visualize the differences using a suitable type of plot
cities$HasSwimmingPool<-factor(cities$HasSwimmingPool,level=c("Yes","No"),labels=c("P(Y)","P(N)"))
cities$IsTouristDestination<-factor(cities$IsTouristDestination,level=c("Yes","No"),labels=c("T(Y)","T(N)"))
boxplot(cities$RoomRent~cities$HasSwimmingPool*cities$IsTouristDestination,horizontal=TRUE,xlab="Room Rent",ylab="Room Features",col=c("gold","green"))
9.There is no influence of hotel capacity on hotel rent
setwd("~/Desktop/ACADS/Term 5/DAM")
cities<-read.csv("AllCitiesData.csv")
task_4a<-lm(cities$HotelCapacity~cities$RoomRent)
summary(task_4a)
Call:
lm(formula = cities$HotelCapacity ~ cities$RoomRent)
Residuals:
Min 1Q Median 3Q Max
-123.22 -31.17 -18.32 12.48 364.12
Coefficients:
Estimate Std. Error t value Pr(>|t|)
(Intercept) 4.224e+01 8.304e-01 50.87 <2e-16 ***
cities$RoomRent 1.213e-03 8.671e-05 13.99 <2e-16 ***
---
Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
Residual standard error: 51.9 on 6465 degrees of freedom
Multiple R-squared: 0.02938, Adjusted R-squared: 0.02923
F-statistic: 195.7 on 1 and 6465 DF, p-value: < 2.2e-16
There is significant influence of hotel capacity on the hotel rent since p value<0.05
10.There is no influence of hotel capacity on room rent at non-Tourist destinations
NTcities<-subset(cities,cities$IsTouristDestination=="No")
task_4b1<-lm(NTcities$RoomRent~NTcities$HotelCapacity)
summary(task_4b1)
Call:
lm(formula = NTcities$RoomRent ~ NTcities$HotelCapacity)
Residuals:
Min 1Q Median 3Q Max
-4967 -1809 -1063 336 45101
Coefficients:
Estimate Std. Error t value Pr(>|t|)
(Intercept) 3439.57 124.00 27.74 <2e-16 ***
NTcities$HotelCapacity 18.90 1.52 12.44 <2e-16 ***
---
Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
Residual standard error: 4165 on 2166 degrees of freedom
Multiple R-squared: 0.06663, Adjusted R-squared: 0.0662
F-statistic: 154.6 on 1 and 2166 DF, p-value: < 2.2e-16
There is significant influence of hotel capacity on the hotel rent at non-Tourist destinations since p value<0.05
11.There is no influence of hotel capacity on room rent at Tourist destinations
Tcities<-subset(cities,cities$IsTouristDestination=="Yes")
task_4b2<-lm(Tcities$RoomRent~Tcities$HotelCapacity)
summary(task_4b2)
Call:
lm(formula = Tcities$RoomRent ~ Tcities$HotelCapacity)
Residuals:
Min 1Q Median 3Q Max
-9176 -3843 -2464 466 69357
Coefficients:
Estimate Std. Error t value Pr(>|t|)
(Intercept) 5324.926 175.079 30.41 <2e-16 ***
Tcities$HotelCapacity 31.818 2.606 12.21 <2e-16 ***
---
Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
Residual standard error: 8357 on 4297 degrees of freedom
Multiple R-squared: 0.03352, Adjusted R-squared: 0.03329
F-statistic: 149 on 1 and 4297 DF, p-value: < 2.2e-16
There is significant influence of hotel capacity on the hotel rent at non-Tourist destinations since p value<0.05
12.Differential impact of hotel capacity on room rent at Tourist versus non-Tourist destinations
task_5<-lm(cities$RoomRent~cities$IsTouristDestination+cities$HotelCapacity+cities$IsTouristDestination:cities$HotelCapacity)
summary(task_5)
Call:
lm(formula = cities$RoomRent ~ cities$IsTouristDestination +
cities$HotelCapacity + cities$IsTouristDestination:cities$HotelCapacity)
Residuals:
Min 1Q Median 3Q Max
-9176 -3249 -1623 428 69357
Coefficients:
Estimate Std. Error
(Intercept) 3439.566 215.215
cities$IsTouristDestinationYes 1885.360 263.152
cities$HotelCapacity 18.903 2.638
cities$IsTouristDestinationYes:cities$HotelCapacity 12.914 3.470
t value Pr(>|t|)
(Intercept) 15.982 < 2e-16 ***
cities$IsTouristDestinationYes 7.165 8.67e-13 ***
cities$HotelCapacity 7.165 8.67e-13 ***
cities$IsTouristDestinationYes:cities$HotelCapacity 3.721 2e-04 ***
---
Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
Residual standard error: 7228 on 6463 degrees of freedom
Multiple R-squared: 0.05749, Adjusted R-squared: 0.05706
F-statistic: 131.4 on 3 and 6463 DF, p-value: < 2.2e-16
There is significant influence of hotel capacity on the hotel rent since p value of the interaction term co-efficient is<0.05