I have a data frame like this(showing a part of big data frame)
cell1 0.33 0.003 cell1_sig
cell1 -0.23 0.002 cell1_sig
cell1 0.21 0.08 cell1_nonsig
cell2 0.87 0.0001 cell2_sig
cell2 0.1 0.10 cell2_nonsig
I want to create a scatter plot between cell1 and cell2 for column2. But I have 3 values for cell1 and only 2 values for cell2 as shown in the example data frame. I also want to color the points using 4th column.
I know how to use ggscatter
function from the ggpubr
package for colors(using palette option), but how can I create a scatter plot for x and y with different lengths?
Here x = cell1
has 3 values and y = cell2
has 2 values.
Any help would be appreciated.