Register a SA Forums Account here!
JOINING THE SA FORUMS WILL REMOVE THIS BIG AD, THE ANNOYING UNDERLINED ADS, AND STUPID INTERSTITIAL ADS!!!

You can: log in, read the tech support FAQ, or request your lost password. This dumb message (and those ads) will appear on every screen until you register! Get rid of this crap by registering your own SA Forums Account and joining roughly 150,000 Goons, for the one-time price of $9.95! We charge money because it costs us money per month for bills, and since we don't believe in showing ads to our users, we try to make the money back through forum registrations.
 
  • Locked thread
kazoosandthings
Dec 6, 2004

In order to join the pirate crew,
you must prove yourself on the kazoo.
It's happening again! I didn't make the leaderboard on the first challenge but I'm going to try my speedy luck again tonight. This year I am aiming to solve in SQL to the extent possible. Problem 1 this year seems about as challenging as problem 2 last year -- will things prove twice as hard overall?

Adbot
ADBOT LOVES YOU

kazoosandthings
Dec 6, 2004

In order to join the pirate crew,
you must prove yourself on the kazoo.
Your Python/Pandas looks a bit like how it might look in R, with the data frame subsetting and filtering and whatnot.

I did part 4 in postgresql; the translate function made the substitution cipher much less painful than I thought it would be at first: https://github.com/piratejon/toyproblems/blob/master/adventofcode/2016/04/04.sql

kazoosandthings
Dec 6, 2004

In order to join the pirate crew,
you must prove yourself on the kazoo.
I am Erlang-illiterate and hard pressed to understand your approaches by reading the code alone. I wonder if it will become more clear when the problems are more complex and have to be broken into smaller pieces.

  • Locked thread