'How to generate an equivalent of pandas.DataFrame.describe in bigquery SQL?
In Pandas, you can get an overview of the table (mean, quantiles, count and count of unique values) for all columns by using the following method: pandas.DataFrame.describe.
Here is an example:
Is there a way to generate such a table in BigQuery SQL, dynamically? The tables. I work with have tens if not hundred of columns, I cannot write them one by one.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|