Added Aggregate Function Entropy Which Computes Shannon Entropy

Why it matters

The entropy function provides a way to quantify the uncertainty or randomness in data by calculating Shannon entropy. This is useful for data analysis tasks involving information theory, such as assessing the distribution uniformity or variability in categorical data.

How to use it

Use the new aggregate function entropy in your SQL queries to compute the Shannon entropy over a column or expression. Example usage:

sql<br>SELECT entropy(column_name) FROM table_name<br>