[R] Odd result

[peter dalgaard]

Yes. Also notice that something fishy seems to be going on in columns 2 and 3 (assuming that the date/time is 1 column). 
They appear to be read as character data, even though the content is numeric?

-pd

> On 24 Sep 2023, at 11:58 , Michael Dewey <lists using dewey.myzen.co.uk> wrote:
> 
> Dear David
> 
> To get the first 46 rows just do KurtzData[1:43,]
> 
> However really you want to find out why it happened. It looks as though the .csv file you read has lots of blank lines at the end. I would open it in an editor to check that.
> 
> Michael
> 
> On 23/09/2023 23:55, Parkhurst, David wrote:
>> With help from several people, I used file.choose() to get my file name, and read.csv() to read in the file as KurtzData.  Then when I print KurtzData, the last several lines look like this:
>> 39   5/31/22              16.0      341    1.75525 0.0201 0.0214   7.00
>> 40   6/28/22  2:00 PM      0.0      215    0.67950 0.0156 0.0294     NA
>> 41   7/25/22 11:00 AM      11.9   1943.5        NA     NA 0.0500   7.80
>> 42   8/31/22                  0    220.5        NA     NA 0.0700  30.50
>> 43   9/28/22              0.067     10.9        NA     NA 0.0700  10.20
>> 44  10/26/22              0.086      237        NA     NA 0.1550  45.00
>> 45   1/12/23  1:00 PM     36.26    24196        NA     NA 0.7500 283.50
>> 46   2/14/23  1:00 PM     20.71       55        NA     NA 0.0500   2.40
>> 47                                              NA     NA     NA     NA
>> 48                                              NA     NA     NA     NA
>> 49                                              NA     NA     NA     NA
>> Then the NA�s go down to one numbered 973.  Where did those extras likely come from, and how do I get rid of them?  I assume I need to get rid of all the lines after #46,  to do calculations and graphics, no?
>> David
>> 	[[alternative HTML version deleted]]
>> ______________________________________________
>> R-help using r-project.org mailing list -- To UNSUBSCRIBE and more, see
>> 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.
> 
> -- 
> Michael
> 
> ______________________________________________
> R-help using r-project.org mailing list -- To UNSUBSCRIBE and more, see
> 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.

-- 
Peter Dalgaard, Professor,
Center for Statistics, Copenhagen Business School
Solbjerg Plads 3, 2000 Frederiksberg, Denmark
Phone: (+45)38153501
Office: A 4.23
Email: pd.mes using cbs.dk  Priv: PDalgd using gmail.com