IT, operating systems, maths, and more.
This is the third part of the ML series. For your convenience you can find other parts in the table of contents in Part 1 – Linear regression in MXNet Last time we saw how to calculate linear regression for the Iris dataset. However, we had to hardcode all the featuers. Today we are going … Continue reading Machine Learning Part 3 — Linear regression in SQL revisited
This is the second part of the ML series. For your convenience you can find other parts in the table of contents in Part 1 – Linear regression in MXNet Image that you have only a data warehouse with SQL capabilities to train and evaluate your models. Last time we ran Python code to calculate … Continue reading Machine Learning Part 2 — Linear regression in SQL
Did you know that you can execute almost any SQL query directly in your Excel spreadsheet? This can be very useful for executing queries with GROUP BY and aggregates since they cannot be generated that easily. Let’s begin. I will use Excel 2013 but this method should work in other editions as well. First, create … Continue reading Executing SQL query inside Excel spreadsheet
This is the twenty third part of the SQLxD series. For your convenience you can find other parts in the table of contents in Part 1 – XML Transformation Here go the tests for query parser: If you followed this series then this whole code should be very easy. Summary We now have engine for … Continue reading SQLxD Part 23 — Query parser tests
This is the twenty second part of the SQLxD series. For your convenience you can find other parts in the table of contents in Part 1 – XML Transformation For parsing queries we use IronPython. Let’s begin with C# code for executing PLY engine: And now goes the parser: This is simply an implementation of … Continue reading SQLxD Part 22 — Query parser