BigQuery is a big overkill for a dataset that fits in memory. Colab + Pandas is the way to go unless you want to sit around twiddling thumbs while BigQuery shuffles the data around.
Also, I find it's SQL dialect and UI very nice for simple stuff too.