0

I have a dataset where I have on each row data associated with an item that has a name (alpha, beta, gamma in the example), as follows:

Dataset example

I now want to create a scatter plot where the X axis corresponds to the names (alpha, beta, gamma) and the Y axis corresponds to the values in v1. But I want to only have one entry of alpha, beta, gamma on the X axis, respectively.

This happens automatically if the X axis values are numbers, but I can't figure out how to do it if they are strings.

I don't want to have to assign each name a number and then modify the x-axis to show these names at the given numbers because the dataset is quite large.

How can I achieve this?

0

You will need to Aggregate them under Median, Average, Sum, Max or Min like:

0

  • There is no way to have multiple dots for v1 on top of each other? – Nicolas Jul 29 at 10:18
  • @Nicolas nope, the aggregation is the only way – user0 Jul 29 at 10:21

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.