Hanukkah of Data 5784 - Day 3 The Neighbor

:: programming, python, puzzle

The Task

We’re given the clues that the person to identify is:

  • A Cancer
  • Born in the year of the Rabbit
  • A neighbor of the contractor

Solution

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
 
import pandas as pd

rabbit_years = (1939, 1951, 1963, 1975, 1987, 1999, 2011, 2023)

customers          = pd.read_csv('noahs-customers.csv', parse_dates=['birthdate'])
contractor_address = customers[customers['phone'] == '332-274-4185'].iloc[0]['citystatezip']

bd          = customers['birthdate']
birth_month = bd.dt.month
birth_day   = bd.dt.day
birth_year  = bd.dt.year

is_cancer       = ((birth_month == 6) & (birth_day >= 21)) | ((birth_month == 7) & (birth_day <= 22))
is_rabbit_year  = birth_year.isin(rabbit_years)
is_neighborhood = customers['citystatezip'] == contractor_address

def solve():
    return customers[is_cancer & is_rabbit_year & is_neighborhood].iloc[0]['phone']

# -------------------------------------------------------------------------------------

assert solve() == '917-288-9635'

Is a Cancer

1
2
3
4
5
6
 
bd          = customers['birthdate']
birth_month = bd.dt.month
birth_day   = bd.dt.day
birth_year  = bd.dt.year

is_cancer       = ((birth_month == 6) & (birth_day >= 21)) | ((birth_month == 7) & (birth_day <= 22))

Is Year of Rabbit

1
2
3
 
rabbit_years = (1939, 1951, 1963, 1975, 1987, 1999, 2011, 2023)

is_rabbit_year  = birth_year.isin(rabbit_years)

Is in the Neighborhood

1
 
is_neighborhood = customers['citystatezip'] == contractor_address

Final Result

1
 
return customers[is_cancer & is_rabbit_year & is_neighborhood].iloc[0]['phone']