🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.

Join and Win

Correlating data

ErikaH

Hello guys!
I am working with some data and I need help in this case: I have a lot of informations about some cities, like population, average number of cars etc. I need to generate a graphic correlating year, data (population, for instance) and the cities. How can I do this?

(I couldn't attach my sketch explain the graphic)

Thanks for your attention,

Érika

Find more posts tagged with

AI Studio

Correlation

Accepted answers

varunm1

Yep, it is easy if your data has columns "year", "Population" and "City". Just double click on your data after uploading and see "Visualizations" on the right panel.

Image: https://us.v-cdn.net/6030995/uploads/editor/ic/1supbw3u5uxk.png

All comments

sgenzer

hi @ErikaH I just "boosted" your rank so you can now post images.

Welcome to the RM community!

Scott

ErikaH

Image: https://us.v-cdn.net/6030995/uploads/editor/nc/coha6efm83zc.jpg

Telcontar120

So if your data is already structured appropriately, then this as simple as going to the VIsualization panel, selecting a line graph, and then setting the attributes for X and Y axis and color/grouping.
However, if your data is not yet in the correct format for this, then you will need to do some data ETL first. Fortunately RapidMiner is terrific for that. You can either use TurboPrep to do it via a wizard, or you can use the data ETL operators.

varunm1

Yep, it is easy if your data has columns "year", "Population" and "City". Just double click on your data after uploading and see "Visualizations" on the right panel.

ErikaH

Thank you all for your answer!

My data is already organized.

But when I select the LINE type for the graphic, I don´t see the color option.

I got something similar using the SCATTER type, selecting color by "city name" and choosing "LOESS" type for regression interpolation. Does it give the same results?

Thanks again for your attention,

Erika