Using Aggregate -MarketBasket Analysis

Question

Hello All,

i have read alot about using the Aggregate-Operator in this Forum. But what exactly does it do?
Can someone explain this to me on a example Table?

greetings

SunnyLotusFlower

SunnyLotusFlowe · Answer

thx alot for the information. now i have enough to work on the problem on my own  :D

greetings

Lotus

IngoRM · Answer

Hi,
That was my question.

No, is was not. But anyway...

If this is useful in association analysis or not can not be answered in general. If you want to search for associations in aggregations you will probably need the aggregation operator. Don't forget that you could define several attribute which should be used for grouping and in that case you will end up with several transactions containing different sums of apples / bananas / ... for different groups - what is quite similar to different items for different transactions.

If you are not aiming at something like that, you probably won't need it. It's as simple as that.

Cheers,
Ingo

SunnyLotusFlowe · Answer

as far as i understood the content given in the link this operator can be used to get sum of each product in the data set.

But in which cases do i need to know how much e.g. apple i got in the Data set. That was my question.

Both links say 'u can use the aggregate for sum, average etc. but when is it useful in Association analysis...

greetings

Lotus