Introduction
In this example, we will show patterns between items stored in SQL Server using Python. We will use the FP-Growth algorithm to find common elements in the data that appear together in the transactions. For example, if we go to the supermarket, what items do we usually buy together?
Requirements First, we will need the SQL Server installed. In SQL Server, we will have the data to analyze. Secondly, we will use AdventureworksDW2009. This database contains sample data that we will use for this article. Thirdly, we will have Python installed. Finally, we will use Visual Studio