this is a port of the dataframe api code from my original pystarburst posting – this time i implemented the same scenarios with ibis, the portable python dataframe library, and had a blast doing it
Monthly Archives: October 2023
viewing astronauts thru windows (more pystarburst examples)
i’ve got a fever and the only prescription is more pystarburst examples — this third installment is all about window functions via the dataframe api and like before, I present sql first for comparison
sql window functions explained (transparently as possible)
sql window functions aren’t really that complicated, but like everything else they deserve a decent introduction – i hope mine helps for anyone trying to wrap their head around what they are
pystarburst analytics examples (querying aviation data part deux)
i had so much fun publishing my first pystarburst post and running it in starburst galaxy that i wanted to share some more examples – i ported my aviation dataset analytical queries to python and the dataframe api