How can I descending reorder the dots in the scatter plot in ggplot based on the X values ?

Question

[mohsamir2016]

Dear All, I am stuck at one trick in ggplot in R: I am trying to plot a scatter plot for metabolites (y axis) based on their VIP score (X axis) here is the data , but when I run this in ggplot, it produced non-ordered scattering of the points as you can see here I would like to plot the same figure but with the dots being descending order from high to low similar to this one

I have tried using reorder but could not get my head around it. Here is my script

ggplot(VIP, aes(x= `Mean decrease in model accuracy`, y = Metabolites, color = Class)) + geom_point(size = 3) 

HIghly appreciating for any help

Thanks

Answer 1

[iraun]

You can give a try to forcats. For example, you could try first to sort your dataframe by in descending order based on the score, and then force ggplot to plot in order of appearance in the dataframe with fct_inorder():

ggplot(VIP.... y = fct_inorder(Metabolites))