******************* User Defined Functions*******************
BigQuery now supports User Defined Functions (UDFs) in SQL and JavaScript that extend BigQuery for more specialized computations and that can be reused in notebooks and queries. To facilitate the analysis of cancer data, ISB-CGC offers a set of UDFs that implement commonly used statistical tests and methods in cancer research and bioinformatics. The UDFs are located in the isb-cgc-bq.functions data set, and the source code of the functions and examples of how to use them can be found in our Community Notebook GitHub Repository. The following table lists all the functions available in ISB-CGC.
| UDF (click for details) | Description | Notebooks |
|---|---|---|
| kmeans | K-means method for clustering data | Python |
| p_fisherexact | p value of the Fisher exact test | |
| mannwhitneyu | Mann–Whitney U test | |
| kruskal_walis | Kruskal Walis test | Python |
| significance_level_ttest2 | Significance level of the two sided T test | Python |
| complement_chisquare_cdf | One minus the CDF of the Chi Square distribution | |
| jstat_normal_cdf | CDF of the Normal distribution |