Challenge #206: Hotel Reservations

[SeanAdams]

Solution attached below - both in regular Alteryx and embedded Python.

Spoiler

[TonyAdam]

Some logical sorting of the result would have been useful... 

Spoiler

[reply_mueller]

Very basic exercise: Here's my - very straight-forward - take on this.

Spoiler

[ponraj]

Here is my solution. 

Spoiler

[BradWerner]

Spoiler

[CesarPicco]

This one was fun and timely too...  

[MOHAMMEDAFZAL]

Here's my solution. The Alteryx version was not compatible so used a blank workflow.

Check it out!

Thanks 🙂

[estherb47]

Fun and fast! 

Spoiler

[Steph3388]

In looking at the posted solution I probably could have eliminated a few superfluous steps, but here it is:

Spoiler

[SeanAdams]

Update on previous post here: https://community.alteryx.com/t5/Weekly-Challenge/Challenge-206-Hotel-Reservations/m-p/547969#M38582

 (forgot to put some detail about the solution)

Spoiler

The Python version uses many of the same techniques as any DataFrame project:

DataFrame Fitering
dfInput = dfInput[dfInput['reservation_status'] == 'Check-Out']

new column based on a function based on other columns.
- Helper function
- Do an apply with the axis set to 1 (rows rather than columns)

def rowFunc(row):
    arrivalDate = '{}-{}-{}'.format(row.arrival_date_year, row.arrival_date_month, row.arrival_date_day_of_month)
    row.arrivalDate = datetime.strptime(arrivalDate, '%Y-%B-%d')
    row.departureDate = datetime.strptime(row.reservation_status_date, '%Y-%m-%d')
    row.stayTime = (row.departureDate - row.arrivalDate).days
    return row

dfInput = dfInput.apply(rowFunc, axis = 1)

Then some summarising - thanks to @NicoleJohnson  for showing me how to do this
dfGrouped = dfInput.groupby(['arrival_date_month']).stayTime.agg([np.mean, np.count_nonzero])

#SnakingMyWayThruChallenges