AllCitiesData.csv
Elena Giasi
30/10/2017
Hotels<-read.csv("AllCitiesData.csv")
View(Hotels)
head(Hotels)
CityName Population CityRank IsTouristDestination IsWeekend IsNewYearEve
1 Varanasi 1201815 15 Yes Yes No
2 Varanasi 1201815 15 Yes No No
3 Varanasi 1201815 15 Yes Yes No
4 Varanasi 1201815 15 Yes No No
5 Varanasi 1201815 15 Yes Yes No
6 Varanasi 1201815 15 Yes Yes No
Date HotelName RoomRent StarRating Airport
1 Dec 18 2016 Nadesar Palace 75000 5 19
2 Dec 21 2016 Nadesar Palace 75000 5 19
3 Dec 25 2016 Nadesar Palace 75000 5 19
4 Jan 04 2017 Nadesar Palace 75000 5 19
5 Jan 08 2017 Nadesar Palace 75000 5 19
6 Dec 18 2016 Taj Nadesar Palace 75000 4 19
HotelAddress HotelPincode
1 Nadesar Palace Grounds, Varanasi, Uttar Pradesh 221002
2 Nadesar Palace Grounds, Varanasi, Uttar Pradesh 221002
3 Nadesar Palace Grounds, Varanasi, Uttar Pradesh 221002
4 Nadesar Palace Grounds, Varanasi, Uttar Pradesh 221002
5 Nadesar Palace Grounds, Varanasi, Uttar Pradesh 221002
6 Nadesar Palace Grounds, Varanasi 221002
HotelDescription FreeWifi FreeBreakfast
1 Luxury resort in Varanasi with golf course, spa Yes Yes
2 Luxury resort in Varanasi with golf course, spa Yes Yes
3 Luxury resort in Varanasi with golf course, spa Yes Yes
4 Luxury resort in Varanasi with golf course, spa Yes Yes
5 Luxury resort in Varanasi with golf course, spa Yes Yes
6 Luxury resort in Varanasi with golf course, spa Yes No
HotelCapacity HasSwimmingPool
1 10 Yes
2 10 Yes
3 10 Yes
4 10 Yes
5 10 Yes
6 10 Yes
attach(Hotels)
summary(Hotels)
CityName Population CityRank IsTouristDestination
Jaipur : 765 Min. : 8096 Min. : 3.00 No :2168
Goa : 624 1st Qu.: 595575 1st Qu.: 9.00 Yes:4299
Kochi : 608 Median :1457723 Median :15.00
Pune : 600 Mean :1515470 Mean :16.03
Udaipur: 456 3rd Qu.:2490891 3rd Qu.:23.00
Agra : 432 Max. :4467797 Max. :37.00
(Other):2982
IsWeekend IsNewYearEve Date
No :2424 No :5658 Dec 25 2016: 810
Yes:4043 Yes: 809 Dec 28 2016: 810
Dec 18 2016: 809
Dec 21 2016: 809
Dec 24 2016: 809
Dec 31 2016: 809
(Other) :1611
HotelName RoomRent StarRating
Apnayt Villa : 16 Min. : 299 Min. :0.000
Fortune Hotel The South Park : 16 1st Qu.: 2482 1st Qu.:3.000
Golden Tulip Chandigarh Panchkula: 16 Median : 4000 Median :3.000
Goldfinch Hotel : 16 Mean : 6025 Mean :3.424
Holiday Inn Chandigarh Panchkula : 16 3rd Qu.: 6499 3rd Qu.:4.000
Hotel City Park : 16 Max. :75000 Max. :5.000
(Other) :6371
Airport
Min. : 0.20
1st Qu.: 6.20
Median :12.00
Mean :15.17
3rd Qu.:22.50
Max. :61.00
HotelAddress
14-4507/9, Balmatta Road, Near Jyothi Circle, Hampankatta : 16
57/1,Tamil Sangam Road, Simmakkal, Madurai, 625001, India : 16
B-4/25, Shivala Ghat, Nepali Kothi, Varanasi, Uttar Pradesh: 16
Chowara Beach, Kovalam, Chowara, Kerala : 16
Circuit House Road,,Jodhpur,Rajasthan,India : 16
Fatehabad Road, Agra, Uttar Pradesh, 282001 India : 16
(Other) :6371
HotelPincode HotelDescription
Min. :134109 3-star Jaipur hotel with restaurant : 64
1st Qu.:282001 Abc : 64
Median :342802 Jaipur hotel next to shopping : 56
Mean :388606 3-star hotel in Pune : 40
3rd Qu.:411057 3-star Jaisalmer hotel with restaurant: 40
Max. :781022 3 lmn : 40
(Other) :6163
FreeWifi FreeBreakfast HotelCapacity HasSwimmingPool
No : 542 No :2504 Min. : 1.00 No :3867
Yes:5925 Yes:3963 1st Qu.: 15.00 Yes:2600
Median : 30.00
Mean : 49.55
3rd Qu.: 64.00
Max. :414.00
TASK 3a
Q1 How many total hotels are there in the sample?
unique(Hotels$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üSTa 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 ... Zone by The Park Bani Park Jaipur
Q2 How many total cities are there in the sample?
unique(Hotels$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
Q3 What is the average room rent in the sample?
mean(Hotels$RoomRent)
[1] 6024.896
Q4 What is the median room rent in the sample?
median(Hotels$RoomRent)
[1] 4000
TASK 3b
Q1 List the Tourist destination cities in the sample; List the non-Tourist destinations
TouristDestination=subset(Hotels$CityName,IsTouristDestination=="Yes")
library(plyr)
count(unique(data.frame(TouristDestination)))[1]
TouristDestination
1 Agra
2 Amritsar
3 Goa
4 Jaipur
5 Jaisalmer
6 Jodhpur
7 Kochi
8 Madurai
9 Manali
10 Rishikesh
11 Srinagar
12 Udaipur
13 Varanasi
NonTouristDestination=subset(Hotels$CityName,IsTouristDestination=="No")
count(unique(data.frame(NonTouristDestination)))[1]
NonTouristDestination
1 Bhubaneswar
2 Chandigarh
3 Guwahati
4 Indore
5 Kanpur
6 Lucknow
7 Mangalore
8 Panchkula
9 Pune
10 Rajkot
11 Surat
12 Thiruvanthipuram
Q2 Create a table showing the count of hotels in Tourist and non-Tourist destinations
Q3 Create a table showing the average room rent in Tourist and non-Tourist destinations (Hint: Use the aggregate() or by() function)
aggregate(RoomRent,by=list(TouristDestination=IsTouristDestination),mean)
TouristDestination x
1 No 4507.500
2 Yes 6790.124
Q4 Plot the average rent in Tourist and non-Tourist destinations. (Hint: use plotmeans() in library(gplots))
library(gplots)
plotmeans(RoomRent~IsTouristDestination,data = Hotels,frame=FALSE)
Q5 Compare the average room rent at Tourist destinations with non-Tourist destinations using a suitable statistical test
Task 3c
Q1 Create a table counting the number of hotels offering and not-offering free breakfast at Tourist and non-Tourist destinations. Also include the total count of hotels in Tourist and non-Tourist destinations in this table. (Hint: xtabs(); ftable(); addmargins() functions may help you)
Error in parse(text = x, srcfile = src) : <text>:2:35: unexpected symbol
1: gg<-xtabs(IsTouristDestination=="Yes" ~ IsTouristDestination=="Yes", data = Hotels)
2: gg<-xtabs(TouristDestination~ x+y data
^