cheatsheet

If you’ve got a GPU on your system that you want to run your deep learning model on, you’d probably want to check that the library is able to access the GPU. Installation issues/ incorrect setups etc can mean that it’s actually inaccessible. I have googled far too many times ‘is tensorflow/pytorch accessing the GPU’, so putting this down here so I don’t have to go through the same stackoverflow posts again and again 😅...

In BigQuery, there is the concept of repeated fields and arrays. I was trying to figure out how to count how many entries in a table contain a certain value in that repeated column. And since the syntax [value] IN some_array is not valid, there is one extra that is needed. Suppose we have some data around freemium podcast platform. In this platform users can pay for an upgraded service, or listen for free....