Repeating ID Excel Import Newbie Question
I have been searching the forum and watched most of the videos but am still at the very beginning. So please bear with me.
I am still learning and at the moment and am using a simple Excel file with 3 attributes (see screenshot) I imported the data via "add data".
What I have is simply a list of 4 projects and ratings for specific areas for each of the project area. The project ID is repeated 5x per project to match each area. When I import the data I have 20 example sets (5each per project ID). I now want to run simple stats on this data (distribution of high-medium -low per project ID, maybe decision tree etc)
How do I work with this data, at the moment I get stats for 20 different example sets and not for 4 projects with 5 subareas. Not sure it makes sense but should be more obvious with the screenshot. Maybe you could point me in the right direction re knowledge base. Trying to step up to Rapidminer from Excel Pivots..
Many thanks for your help