#hanukkahofdata — Public Fediverse posts

📝 "Hanukkah of Data, 5784"

👤 Ella Kaye (@ellakaye)

🔗 https://ellakaye.co.uk/posts/2023-12-07_hanukkah-of-data-5784/

#rladies #rstats #hanukkahofdata #r #tidyverse

📝 "Hanukkah of Data, 5784"

👤 Ella Kaye (@ellakaye)

🔗 https://ellakaye.co.uk/posts/2023-12-07_hanukkah-of-data-5784/

#rladies #rstats #hanukkahofdata #r #tidyverse

Just in time before the new year, I wrapped up my #HanukkahOfData solutions in #rstats https://www.datannery.com/posts/hanukkah-of-data-revisited-2023-speedrun/

I absolutely loved #HanukkahOfData, which I completed in #RStats with the #tidyverse. I wrote up my solutions and reflections on the puzzles and overall experience. https://ellakaye.co.uk/hanukkah-of-data-5784/ I'm already looking forward to this coming round again next year!

I absolutely loved #HanukkahOfData, which I completed in #RStats with the #tidyverse. I wrote up my solutions and reflections on the puzzles and overall experience. https://ellakaye.co.uk/hanukkah-of-data-5784/ I'm already looking forward to this coming round again next year!

After doing #HanukkahOfData this year and letting it bake in my head for a few days, I wrote down a few things I learned about #Jupyter and #Polars along the way.

https://dev.to/ajkerrigan/stuff-i-learned-during-hanukkah-of-data-2023-4da6

After doing #HanukkahOfData this year and letting it bake in my head for a few days, I wrote down a few things I learned about #Jupyter and #Polars along the way.

https://dev.to/ajkerrigan/stuff-i-learned-during-hanukkah-of-data-2023-4da6

#HanukkahOfData 5783 Days 4 - 8:

I have just finished #HoD. I did almost everything in SQL with SQL Server.

The ASCII art of the candles and the rug is really beautiful.

https://hanukkah.bluebird.sh/5783/

Here are all my solutions:
https://github.com/nharrer/hanukkah-of

#SQL #Python

#HanukkahOfData 5783 Days 4 - 8:

I have just finished #HoD. I did almost everything in SQL with SQL Server.

The ASCII art of the candles and the rug is really beautiful.

https://hanukkah.bluebird.sh/5783/

Here are all my solutions:
https://github.com/nharrer/hanukkah-of

#SQL #Python

#HanukkahOfData 5783 Days 1-3:

Yes, as if I don't already waste way too much time on #AdventOfCode, I started doing last year's #HanukkahOfData, which is also a lot of fun.

https://hanukkah.bluebird.sh/5783/

Here are my solutions for days 1 - 3:
https://github.com/nharrer/hanukkah-of-data/

#HoD #SQL #Python

#HanukkahOfData 5783 Days 1-3:

Yes, as if I don't already waste way too much time on #AdventOfCode, I started doing last year's #HanukkahOfData, which is also a lot of fun.

https://hanukkah.bluebird.sh/5783/

Here are my solutions for days 1 - 3:
https://github.com/nharrer/hanukkah-of-data/

#HoD #SQL #Python

Coffee and bagels anyone? Solution of day2 of (revisited) #HanukkahOfData in #rstats :
https://www.datannery.com/posts/hanukkah-of-data-revisited-2023/#day-2

Just did the Day 1 puzzle of #HanukkahOfData (which got rebooted this year 🎉 ) https://hanukkah.bluebird.sh/5784/

After a week of learning #Rust while taking on #AdventOfCode, I thought I'd give myself a break and just do the HoD in pure #python

It's like taking off a heavy backpack. I feel so *competent* again!

Just did the Day 1 puzzle of #HanukkahOfData (which got rebooted this year 🎉 ) https://hanukkah.bluebird.sh/5784/

After a week of learning #Rust while taking on #AdventOfCode, I thought I'd give myself a break and just do the HoD in pure #python

It's like taking off a heavy backpack. I feel so *competent* again!

(Revisited) solution of day one of #HanukkahOfData in #rstats :
https://www.datannery.com/posts/hanukkah-of-data-revisited-2023/#day-1

(Revisited) solution of day one of #HanukkahOfData in #rstats :
https://www.datannery.com/posts/hanukkah-of-data-revisited-2023/#day-1

https://hanukkah.bluebird.sh/

Hanukkah of Data begins!

#hanukkahOfData

Coding challenges this December:

#AdventOfCode by @ericwastl: https://adventofcode.com

#24PullRequests by @24pullrequests https://24pullrequests.com

It's from last year (5783), but the #HanukkahOfData by @saulpw is fun:
https://hanukkah.bluebird.sh/5783/

And #AdventOfPython313 by Karolina Surma:
https://lists.fedoraproject.org/archives/list/[email protected]/thread/XLB6DXTB4JHFHMBB2LG3JQF3KASSN7IQ/ #Python #Python313

Coding challenges this December:

#AdventOfCode by @ericwastl: https://adventofcode.com

#24PullRequests by @24pullrequests https://24pullrequests.com

It's from last year (5783), but the #HanukkahOfData by @saulpw is fun:
https://hanukkah.bluebird.sh/5783/

And #AdventOfPython313 by Karolina Surma:
https://lists.fedoraproject.org/archives/list/[email protected]/thread/XLB6DXTB4JHFHMBB2LG3JQF3KASSN7IQ/ #Python #Python313

@saulpw Any plans to run #HanukkahOfData again this year?

https://hanukkah.bluebird.sh/about/

@visidata #AdventOfCode

@saulpw Any plans to run #HanukkahOfData again this year?

https://hanukkah.bluebird.sh/about/

@visidata #AdventOfCode

Compared with #HanukkahOfData puzzles 1 and 2 which had a lot of setup and feeling around, the remaining puzzles were more about smaller tweaks to answer specific questions. And in the case of day 7, doing some extremely gross things with SQL.

But the full series is up here now for anyone interested: https://dev.to/ajkerrigan/series/21177

I suspect I'll add commentary after reviewing other people's code and posts!

Compared with #HanukkahOfData puzzles 1 and 2 which had a lot of setup and feeling around, the remaining puzzles were more about smaller tweaks to answer specific questions. And in the case of day 7, doing some extremely gross things with SQL.

But the full series is up here now for anyone interested: https://dev.to/ajkerrigan/series/21177

I suspect I'll add commentary after reviewing other people's code and posts!

For the second day of #HanukkahOfData I pivoted to #Datasette , which worked great!

I then clumsily adapted the solution to #pandas, which was educational with a few missteps 😅. I _think_ my takeaway is that grouping on category columns can cause things to explode. But the lesson is still in progress...

https://dev.to/ajkerrigan/hanukkah-of-data-2022-puzzle-2-1fng

For the second day of #HanukkahOfData I pivoted to #Datasette , which worked great!

I then clumsily adapted the solution to #pandas, which was educational with a few missteps 😅. I _think_ my takeaway is that grouping on category columns can cause things to explode. But the lesson is still in progress...

https://dev.to/ajkerrigan/hanukkah-of-data-2022-puzzle-2-1fng

Reflecting on #HanukkahOfData with a post about the first puzzle (https://dev.to/ajkerrigan/hanukkah-of-data-2022-puzzle-1-5eb2).

On the first day I was still getting a feel for the data set, and stuck with #VisiData . I didn't yet realize that I'd lean so hard on #Datasette and #pandas in the following days...

Reflecting on #HanukkahOfData with a post about the first puzzle (https://dev.to/ajkerrigan/hanukkah-of-data-2022-puzzle-1-5eb2).

On the first day I was still getting a feel for the data set, and stuck with #VisiData . I didn't yet realize that I'd lean so hard on #Datasette and #pandas in the following days...

I wrote a long-form #blog post with my thoughts about #HanukkahOfData - it was a delight to solve these puzzles and learn more about #VisiData! 🕎

https://www.georgeho.org/hanukkah-of-data-2022/

I wrote a long-form #blog post with my thoughts about #HanukkahOfData - it was a delight to solve these puzzles and learn more about #VisiData! 🕎

https://www.georgeho.org/hanukkah-of-data-2022/

Finished both the #AdventOfCode and the #HanukkahOfData today. AoC was a nice way to exercise an unfamiliar language, and HoD introduced me to some new pastries.
https://adventofcode.com/
https://hanukkah.bluebird.sh/5783/

Finished both the #AdventOfCode and the #HanukkahOfData today. AoC was a nice way to exercise an unfamiliar language, and HoD introduced me to some new pastries.
https://adventofcode.com/
https://hanukkah.bluebird.sh/5783/

#HanukkahOfData

Nice puzzles!

Had some fun with #HanukkahOfData today.
Thanks #devottys!

Was a bit late to the party but now I've almost caught up.

Uploaded my solutions to @Codeberg https://codeberg.org/christian.heinze/hanukkah_of_data_2022

So, as I've done #HanukkahOfData in #Ibis, I've been providing less and less code screenshots because, well...

Those are hard to share, and I think I don't describe the images properly. Regardless, I do want to say that using Ibis has been really very fun, and I hope my repo I'll make at the end of the event will be able to show off a very nice learning curve! I think I've gotten better with it since day 1, and it's fun to use!
(Hey go to my profile to see at least my logic and some lil' code)

So, as I've done #HanukkahOfData in #Ibis, I've been providing less and less code screenshots because, well...

Those are hard to share, and I think I don't describe the images properly. Regardless, I do want to say that using Ibis has been really very fun, and I hope my repo I'll make at the end of the event will be able to show off a very nice learning curve! I think I've gotten better with it since day 1, and it's fun to use!
(Hey go to my profile to see at least my logic and some lil' code)

Oh, yes, social media.

Uh, tag flood: #Python, #Ibis, #HanukkahOfData. I'm doing Hanukkah of Data with Ibis! The thread that starts above this post shows my experience with day 6, and my profile has my journey through every day so far!

I'll aggregate it into a blog or post that links to posts at the end so it's less obnoxious.

Oh, yes, social media.

Uh, tag flood: #Python, #Ibis, #HanukkahOfData. I'm doing Hanukkah of Data with Ibis! The thread that starts above this post shows my experience with day 6, and my profile has my journey through every day so far!

I'll aggregate it into a blog or post that links to posts at the end so it's less obnoxious.

Day 6 of #HanukkahOfData!

Also, I learned you can arbitrarily capitalize in tags. i'm practically an expert, I hope.

So far, I've been behind, but after a 3-in-a-row yesterday, I'm on track for the first time!

Hopefully this goes just as well, this is a 🧵, watch out for Day 6 spoilers!

Day 6 of #HanukkahOfData!

Also, I learned you can arbitrarily capitalize in tags. i'm practically an expert, I hope.

So far, I've been behind, but after a 3-in-a-row yesterday, I'm on track for the first time!

Hopefully this goes just as well, this is a 🧵, watch out for Day 6 spoilers!

@amontalenti if you’re interested in something that (at least for me) is less of a commitment, I’ve been very much enjoying the #HanukkahOfData https://hanukkah.bluebird.sh/5783/

@amontalenti if you’re interested in something that (at least for me) is less of a commitment, I’ve been very much enjoying the #HanukkahOfData https://hanukkah.bluebird.sh/5783/

Finished Day 3 above here in this 🧵 ! Starting Day 4 of #hanukkahofdata below!

Finished Day 3 above here in this 🧵 ! Starting Day 4 of #hanukkahofdata below!

Okay, Hanukkah of Data day 3! More #Python, more #Ibis, more #hanukkahofdata! Yes, I know I have to do more than one in a day at least once to catch up at this point.

Last two days, I found ways to fixate on the wrong things. Let's try to be more careful today!

Okay, Hanukkah of Data day 3! More #Python, more #Ibis, more #hanukkahofdata! Yes, I know I have to do more than one in a day at least once to catch up at this point.

Last two days, I found ways to fixate on the wrong things. Let's try to be more careful today!

After I get a #HanukkahOfData puzzle solved in a way that feels smooth and comfortable (generally #VisiData or #Datasette), I've been trying to pivot my solutions to #pandas

The results have been mixed so far, but useful 😅

Big win so far: following a sqlite read, converting datatypes (categorical where possible, with a couple datetime or int columns left) reduced deep memory usage to ~10% of the original dataframe

The Hanukkah of Data is going well!
https://hanukkah.bluebird.sh/5783/
#HanukkahOfData #AdventOfCode

The evolving story of the #HanukkahOfData puzzles is centered in New York, and in that frame of mind it was a fun coincidence that today's #TalkTullToMe episode featured the Christmas Song "First Snow on Brooklyn".

During the rundown of New York's boroughs, Omen casually mentions "We don't talk about Staten Island... it's only famous for What We Do in the Shadows and Wu-Tang Clan" 😂

https://hanukkah.bluebird.sh/
https://www.fecklessmomes.com/talk-tull/2022/12/6/first-snow-on-brooklyn