The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here

Using Aggregate -MarketBasket Analysis

SunnyLotusFloweSunnyLotusFlowe Member Posts: 37 Contributor II
edited June 2019 in Help
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
Tagged:

Answers

  • IngoRMIngoRM Employee-RapidMiner, RapidMiner Certified Analyst, RapidMiner Certified Expert, Community Manager, RMResearcher, Member, University Professor Posts: 1,751 RM Founder
    Hi,

    it does basically the same thing as the aggregation known from databases (group by plus aggregation function). Here are some infos:

    http://www.sqlcommands.net/sql+group+by/
    http://www.w3schools.com/sql/sql_groupby.asp

    Cheers,
    Ingo
  • SunnyLotusFloweSunnyLotusFlowe Member Posts: 37 Contributor II
    i think u have missunderstood me ::)  :) . i know what the aggregation does. but i need a motivation to use it.

    i need a specific situation where this operator is applied.



    greetings

    Lotus
  • IngoRMIngoRM Employee-RapidMiner, RapidMiner Certified Analyst, RapidMiner Certified Expert, Community Manager, RMResearcher, Member, University Professor Posts: 1,751 RM Founder
    Oh, I must than have misunderstood

    But what exactly does it do?
    By reading your statement again it of course says "I need a motivation" for using it  ;)

    The answer still is the same: Read the text given in the links, they also give a motivation in which situations the operator can be applied.

    Cheers,
    Ingo
  • SunnyLotusFloweSunnyLotusFlowe Member Posts: 37 Contributor II
    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
  • IngoRMIngoRM Employee-RapidMiner, RapidMiner Certified Analyst, RapidMiner Certified Expert, Community Manager, RMResearcher, Member, University Professor Posts: 1,751 RM Founder
    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
  • SunnyLotusFloweSunnyLotusFlowe Member Posts: 37 Contributor II
    thx alot for the information. now i have enough to work on the problem on my own  :D

    greetings

    Lotus
Sign In or Register to comment.