Pivoting in MS SQL Server
SELECT * FROM ( SELECT p.product_name, g.tx_id, g.transmonth FROM [DataAnalytics].[dbo].[tbla_hst_gross_add_policy] g INNER JOIN [DataAnalytics].[dbo].[tbld_product] p ON g.product_code = p.product_code and transmonth>='202101' ) t PIVOT (...
Why Uppercase for X and Lowercase for y is Used in Python Model
In terms of Linear Algebra, it is extremely common to use capital Latin letters for matrices (e.g. design matrix XX) and lowercase Latin letters for vectors (response vector yy)....
Supervised-vs-Unsupervised-vs-Reinforcement Machine Learning
Machine Learning is a part of Data Science where the efficiency of a system improves itself by repeatedly performing the tasks by using data instead...
Keyboard Shortcuts for Jupyter Notebook
If you know the keyboard shortcuts for Jupyter Notebook it will be easy for you to code withing shortest possible of time. Top 5 Important...
Google Colab Notebook for Python
Sometimes we may require to work with Python without installing Python into your laptop or computer. It’s not a big deal in the present world...
What is Data Mining?
It is the age of data. Every seconds millions of data are producing into different ends and day by day data is increasing considering volume, velocity, or...