Hello, Asking for help from R experts here. I'm totally new in R and I'm just spending lots of time to figure out how to plot scatter plots on R. I have a large data set (>10K rows) which I wish to plot out the data using a scatter plot using this function on the tutorial: http://www.statmethods.net/graphs/scatterplot.html

plot(wt, mpg, main="Scatterplot Example", xlab="Car Weight ", ylab="Miles Per Gallon ", pch=19)

However, my dataset contains many '0' which causes the plot to look strange and wish to have them omitted. How can I do that please? Thanks!

Hi thank you for your reply. However, there are more than 100k 0 values in the data and it's too labour intensive to remove them one by one. Is there another way which I can do this without manipulating data?

You can slice or subset your dataframe, obviously not manually but with an R command.

Hi, Genosa,

is there any function in Microsoft Excel to remove zero values from your matrix before importing it into R ?

~ Best

Doing this in R is one or two lines of code and the solution can easily be found using google or every R tutorial.