Months Analysis

I’m trying to do some exercises on Market Basket Analysis, but I couldn’t figure out how to analyzing the products per month (seasonal analyzing). Maybe someone can help on this.

Thanks, Anoon

I don’t know what you have in data and if you use Python/pandas/DataFrame but if you have column with date - ie. year-month-day - then with pandas you should easily create column with year-month (and let say with name "year-month") and then you can use name of this column with groupby("year-month") to group products per month and calculate values for every month and compare them.

Hi Furas,
Thanks for your explanation. The data is bulk of customers invoices that collect from the cashier exported to xls data sheet. I’m using Rapidminer.

© Copyright 2013-2020 Analytics Vidhya