"Filtered processing of CSV data"

pk34212pk34212 MemberPosts:1Contributor I
edited June 2019 inHelp

Hi

I'd like to process data from a CSV file with the below data structure and sample data. Text1 is a colour code which falls into various categories.

category | text1 | numeric1 | numeric2

1 green 2 1

1 blue 4 1

2 green 6 2

2 blue 23 32

I'd like to process the data by category in the following way:

1) weight=numeric1*numeric2

2) sum of all weight for each category

3) display weight sum for each category in a barchart

Is there any possibility to process CSV data in RapidMiner in this way?

Many thanks for your help in advance.

Tagged:

Answers

  • sgenzersgenzer Administrator, Moderator, Employee, RapidMiner Certified Analyst, Community Manager, Member, University Professor, PM ModeratorPosts:2,959Community Manager

    hello@pk34212- welcome to the community. Yes you can certain do all of these things quite easily:

    1) use the "Generate Attributes" operator and just enter your formula

    2) use the "Aggregate" operator and group by category

    3) click "Charts" in the Results pane.

    Good luck!

    Scott

    Telcontar120
Sign InorRegisterto comment.