Hi all, I have a big .csv file (21Mb with 1000000 rows) it has this shape: x 1 NaN 2 NaN 3 0.23 and so on..... So the first column has x as a header then row number, the second column contains values between -1,1 and NaN for empty values. What should I need to do is: create a new .csv file from this one excluding NaN values and plot a line graph using the new .csv file. Or can I use the old .csv file to plot a graph excluding NaN values. Thanks in advance for any help or suggestions. Regards, Vahe [[alternative HTML version deleted]]
Just read in and plot the data. The NaN will not be plotted:> input <- read.table(text = "x+ 1 NaN + 2 NaN + 3 0.23 + 4 .34 + 5 .55 + 6 .66 + 7 NaN + 8 .88", header = TRUE)> plot(input$x) >On Fri, May 3, 2013 at 9:49 AM, Vahe nr <vner75@gmail.com> wrote:> Hi all, > > I have a big .csv file (21Mb with 1000000 rows) it has this shape: > x > 1 NaN > 2 NaN > 3 0.23 > > and so on..... > > So the first column has x as a header then row number, the second column > contains values between -1,1 and NaN for empty values. > > What should I need to do is: create a new .csv file from this one excluding > NaN values and plot a line graph using the new .csv file. > > Or can I use the old .csv file to plot a graph excluding NaN values. > > Thanks in advance for any help or suggestions. > > Regards, > Vahe > > [[alternative HTML version deleted]] > > ______________________________________________ > R-help@r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide > http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. >-- Jim Holtman Data Munger Guru What is the problem that you are trying to solve? Tell me what you want to do, not how you want to do it. [[alternative HTML version deleted]]
On 05/03/2013 11:49 PM, Vahe nr wrote:> Hi all, > > I have a big .csv file (21Mb with 1000000 rows) it has this shape: > x > 1 NaN > 2 NaN > 3 0.23 > > and so on..... > > So the first column has x as a header then row number, the second column > contains values between -1,1 and NaN for empty values. > > What should I need to do is: create a new .csv file from this one excluding > NaN values and plot a line graph using the new .csv file. > > Or can I use the old .csv file to plot a graph excluding NaN values. >Hi Vahe, If you want to plot the line ignoring the NaN values, rather than having the line break at each NaN, use this: vndat<-data.frame(1:10, x=c(-1,-0.6,-0.4,NaN,-0.2,0.2,0.4,NaN,0.6,0.8)) plot(vndat$x[complete.cases(vndat$x)],type="l") Jim (the other one)