My solutions to the 2022 Hanukkah of Data puzzles:
-
Introduction: password is 5777 (Hebrew year for 2017) (solved on 2023-01-08)
-
Puzzle 1. Solved on 2023-01-08
-
Puzzle 2. Solved on 2023-01-09. Techniques: adding custom columns to
dataframe
, using more than one dataframe, merging with selection. -
Puzzle 3. Solved on 2023-01-09. Input from Puzzle 2 needed, plus additional external infomation on years and astrology. Tecniques: pandas
to_datetime
,Timestamp
dataframe masksar. -
Puzzle 4. Solved on 2023-01-09. Similar to Puzzle 2.
-
Puzzle 5. Solved on 2023-01-10. Techniques: dataframe
count()
anddrop_duplicates()
-
Puzzle 6. Solved on 2023-01-10.
-
Puzzle 7. Solved on 2023-01-11. Used external loop to search since I'm very bad at pandas' complex queries. Techniques: pandas
Timedelta
. -
Puzzle 8. Solved on 2023-01-11.