Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!
Introduction to SQL in BigQuery
Data Types
Questions
-
Can you set Vim keybindings for editors?
-
how to connect to a BigQuery …
GCP Compute Engine VM Instances
Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!
GCP¶
GCP c2 and c3 VMs are good choices according to performance per price. It's even cheaper than customized VM types with reduced memories! GCP c2 VMs are compute optimized and are ideal for CPU intensive workloads. Note that GCP c2 spot VMs are even cheaper than AWS t2.nano VMs if you can stand your VM being preempted.
Tips on GCP
Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!
Notice that lots of services can be used for free (with monthly limits). For more details, please refer to GCP Free Tier Usage Limits .
https://cloud.google …
`ifelse` on Pandas Series
Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!
Series.apply + Lambda Function¶
DataFrame.apply + Lambda Function¶
axis=1: apply the lambda function on each row
List Comprehension¶
numpy.where¶
numpy.where is vectorized ifelse.
Tips on the jupyterlab-myst Extension
Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!
Tips and Traps
- The very first run of MyST markdown in a JupyterLab cell might fail to work. Just rerun it and it should work.