[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
9. Re: : new to octave, confused about load(), dlmread et cetera
From: |
Roman.Griego |
Subject: |
9. Re: : new to octave, confused about load(), dlmread et cetera |
Date: |
Fri, 3 Sep 2010 10:56:33 +0000 |
> >
> > The original data was an csv export of a sql query done in excel. I
> > grabbed the first two lines because row one was my header, the second
> was
> > a related piece of data that didn't really belong with the rest of
> the
> > data. I stripped the zeros because I was making histograms from the
> data.
> > The zeros were added from dlmread to make all the rows the same
> length, in
> > my case all my data are integers greater than one.
> >
>
> Can't you just read it directly from the Excel file then?
> There is direct .xls R/W support in octave nowadays (using the octave-
> forge
> io pkg).
> Empty cells in an Excel range are read as NaNs which -reading postings
> earlier in the thread- might come in handy, too.
>
> Philip
******************************************
[rdgriego]
If I do that I still have to convert the file to Tab Delimited...
I'd rather not use excel at all, however right now it is my best access to the
SQL server I need.
- 9. Re: : new to octave, confused about load(), dlmread et cetera,
Roman.Griego <=