Data Science SQL

Root mean squared error

SELECT SQRT(AVG(POWER(y - y_pred, 2))) AS rmse FROM ...

Mean absolute error

SELECT AVG(ABS(y - y_pred)) AS mae FROM ...

Mean error

SELECT AVG(y_pred - y) AS me FROM ...

Median - get it here

SELECT MEDIAN(y) FROM ...

Published September 10, 2015 · Tweet


You might also enjoy

Securing Sensitive Data in Rails

Introducing Dexter, the Automatic Indexer for Postgres

Rails, Meet Data Science


All code examples are public domain.
Use them however you’d like (licensed under CC0).