We are looking for an excel master to help us consolidate a zip file (will send separately due to size) of the tsv/txt files into eight master geographic region XLS files. The rows contain a list of hotels we need to purge down to only the information we require.
We will bonus the person ($50) if they can get this done accurately and done by End of Day Monday.
-------Changes to Data--------
Inside each text files is more columns and rows of data than we ultimately need.
The attachment is an example (europe_1.xlsx) only and has the FINAL columns of data points we want -- ignore the properties.
Remove all properties with over a 100 room count (column: nr_rooms exceed 100)
EXCEPT for hotel names (column: name) with the word Hostel or Guesthouse in their name.
i.e. Magic Hostel nr+rooms count 250 (should be included)
REMOVE ALL Hotel Names which include the words: Accor, Ibis, Best Western, Carlson Rezidor, Choice, Drury, Extended Stay, G6, Hilton, Hyatt, IMIC, IHG, La QUinta, Louvre, Magnuson, Marriott, sheraton, Vantage, Wyndham