[R] how to read this data file into R?

David Winsemius dwinsemius at comcast.net
Wed Feb 3 00:40:48 CET 2010


On Feb 2, 2010, at 6:31 PM, Felipe Carrillo wrote:

>
> Convert the file into a csv file( myfile.csv),
> delete some of the unwanted rows before importing into R.
> Save the file on your working directory and then import into R:
>
> x <- read.csv("myfile.csv")
> # Change column names
> names(x) <- LETTERS[1:ncol(x)];x

The problem with that solution is that there are an irregular number  
of numbers per row ranging from 8 to 6. You could read in as text with  
readLines but then need to extract by 25 lines at a time and then  
cbind the segments. Doable mind you, but I suspect faster with a  
spreadsheet intermediate solution.

The real solution is to grab the miscreant sender by the throat , er,   
tactfully discuss with your valued customer ,,, and shake out a  
machine readable form that has all of one row in a row.

-- 
David.

>
> Change your column names to whatever you want
>
> Felipe D. Carrillo
> Supervisory Fishery Biologist
> Department of the Interior
> US Fish & Wildlife Service
> California, USA
>
>
> --- On Tue, 2/2/10, song song <rprojecthelp at gmail.com> wrote:
>
>> From: song song <rprojecthelp at gmail.com>
>> Subject: [R] how to read this data file into R?
>> To: r-help at r-project.org
>> Date: Tuesday, February 2, 2010, 2:55 PM
>>
>>    [,1]      [,2]
>>    [,3]     [,4]
>>    [,5]     [,6]
>>    [,7]
>> [,8]
>>   [1,] 2.010061 -5.223624 2.010061 2.010061 1.463336
>> 1.463336 2.010061
>> 2.010061
>>   [2,] 2.057502 -5.101445 2.057502 2.057502 2.057502
>> 2.057502 2.057502
>> 2.057502
>>   [3,] 2.011081 -5.227745 2.011081 2.011081 2.011081
>> 2.011081 2.011081
>> 2.011081
>>   [4,] 2.031695 -5.147776 2.031695 2.031695 2.031695
>> 2.031695 2.031695
>> 2.031695
>>   [5,] 1.982144 -5.219977 2.578551 1.982144 1.982144
>> 1.982144 1.982144
>> 1.982144
>>   [6,] 1.997830 -5.197152 1.997830 1.997830 1.997830
>> 1.997830 1.229965
>> 1.997830
>>   [7,] 1.987102 -5.202288 1.987102 1.987102 1.987102
>> 1.987102 1.987102
>> 2.045108
>>   [8,] 2.004351 -5.263740 2.004351 2.004351 2.004351
>> 2.004351 2.004351
>> 2.004351
>>   [9,] 1.860640 -5.281771 1.947604 1.947604 1.947604
>> 1.947604 1.947604
>> 1.947604
>> [10,] 2.034417 -5.268606 1.917726 1.917726 1.917726
>> 1.917726 1.917726
>> 1.917726
>> [11,] 1.892761 -5.254092 1.892761 1.892761 1.892761
>> 1.892761 1.892761
>> 1.892761
>> [12,] 1.878266 -4.725234 1.878266 1.878266 2.265870
>> 1.878266 1.878266
>> 1.878266
>> [13,] 1.941847 -5.293714 1.941847 1.941847 1.941847
>> 2.212040 1.941847
>> 1.941847
>> [14,] 3.280856 -5.295412 1.891672 1.891672 1.891672
>> 1.891672 2.295541
>> 1.891672
>> [15,] 1.833538 -5.381407 2.417865 1.833538 1.833538
>> 1.833538 1.833538
>> 1.833538
>> [16,] 1.813212 -5.256472 1.813212 2.337103 1.813212
>> 1.813212 1.813212
>> 1.813212
>> [17,] 1.763356 -5.262836 1.763356 2.538904 3.202743
>> 1.763356 1.763356
>> 1.763356
>> [18,] 2.718888 -5.269976 1.824456 1.824456 1.824456
>> 1.824456 1.824456
>> 1.824456
>> [19,] 1.868374 -5.237574 1.868374 1.868374 1.868374
>> 1.868374 1.868374
>> 1.868374
>> [20,] 1.879976 -5.195960 1.879976 1.879976 2.400419
>> 1.879976 1.879976
>> 1.879976
>> [21,] 1.897184 -5.195960 1.897184 1.897184 1.897184
>> 1.897184 1.897184
>> 1.897184
>> [22,] 1.946035 -5.195960 1.946035 1.946035 1.946035
>> 1.946035 1.946035
>> 1.946035
>> [23,] 1.531107 -5.195960 2.005964 2.005964 2.005964
>> 2.005964 1.012178
>> 2.005964
>> [24,] 1.966488 -5.195960 1.966488 3.300449 1.966488
>> 1.966488 1.966488
>> 1.966488
>> [25,] 1.922473 -5.132915 1.922473 1.922473 1.922473
>> 1.922473 1.327156
>> 1.922473
>>
>>    [,9]     [,10]
>>    [,11]      [,12]
>>    [,13]    [,14]
>> [,15]
>>   [1,]  2.0100609 -5.223624 2.0100609 2.01006088
>> 2.0100609 2.010061
>> 2.0100609
>>   [2,]  2.0575018 -5.217940 2.0575018 2.05750183
>> 2.0575018 2.057502
>> 2.0575018
>>   [3,]  2.0110810 -5.227745 2.0110810 1.25251992
>> 1.1365329 2.011081
>> 2.0110810
>>   [4,]  2.0316951 -5.147776 2.0316951 0.53524458
>> 2.0316951 2.031695
>> 2.0316951
>>   [5,]  1.9821437 -5.219977 1.9821437 1.98214375
>> 1.9821437 1.982144
>> 1.9821437
>>   [6,]  1.9978302 -5.197152 1.9978302 1.99783017
>> 1.9978302 1.997830
>> 1.9978302
>>   [7,]  1.4779031 -5.202288 1.9871021 1.98710207
>> 1.9871021 1.477903
>> 1.9871021
>>   [8,]  2.0043512 -5.263740 2.0043512 2.00435118
>> 2.0043512 2.004351
>> 2.0043512
>>   [9,]  1.9476036 -5.281771 1.9476036 1.86063972
>> 1.9476036 1.947604
>> 1.9476036
>> [10,]  2.0344169 -5.268606 2.0344169 1.91772554
>> 1.9177255 2.034417
>> 1.9177255
>> [11,]  1.8927610 -5.254092 2.2300986 1.89276104
>> 1.8927610 1.892761
>> 1.8927610
>> [12,]  2.2658697 -5.279645 1.8782663 1.87826632
>> 0.9758728 1.878266
>> 1.8782663
>> [13,]  1.9418472 -5.293714 1.9418472 1.94184718
>> 1.9418472 1.941847
>> 1.9418472
>> [14,]  1.8916717 -5.295412 1.8916717 1.89167168
>> 1.8916717 1.891672
>> 1.8916717
>> [15,]  1.8335379 -5.381407 1.8335379 1.83353786
>> 1.8335379 1.833538
>> 1.8335379
>> [16,]  1.8132119 -5.256472 1.8132119 1.81321188
>> 2.3371032 1.813212
>> 1.8132119
>> [17,]  1.7633565 -5.262836 1.7633565 2.53890421
>> 1.7633565 1.763356
>> 1.7633565
>> [18,]  1.8244564 -5.269976 1.8244564 1.82445645
>> 1.8244564 1.824456
>> 1.8244564
>> [19,]  1.8683740 -5.237574 1.8683740 1.86837403
>> 1.8683740 1.868374
>> 1.8683740
>> [20,]  1.0173668 -5.195960 1.8799758 1.87997583
>> 1.8799758 2.685630
>> 1.8799758
>> [21,]  1.8971842 -5.195960 1.8971842 1.89718417
>> 1.8971842 2.438014
>> 1.8971842
>> [22,]  1.9460347 -5.195960 1.9460347 1.94603470
>> 1.7662487 1.946035
>> 1.9460347
>> [23,]  0.7982354 -5.195960 2.0059635 2.00596350
>> 2.0059635 2.005964
>> 2.0059635
>> [24,]  1.9664877 -5.195960 1.9664877 1.96648770
>> 1.9664877 1.966488
>> 1.9664877
>> [25,]  1.9224727 -5.132915 3.2417843 1.92247274
>> 1.9224727 1.922473
>> 1.9224727
>>            [,16]
>>   [,17]     [,18]
>>   [,19]     [,20]
>> [,21]     [,22]
>>   [1,] -5.223624 2.010061 -5.223624  1.4633362
>> -5.223624 2.010061 -5.090333
>>   [2,] -5.217940 2.057502 -5.217940  1.0054481
>> -5.217940 2.057502 -5.217940
>>   [3,] -5.227745 2.011081 -5.040568  2.0110810
>> -5.227745 2.011081 -5.227745
>>   [4,] -5.147776 1.819924 -5.147776  2.0316951
>> -5.147776 2.031695 -5.147776
>>   [5,] -5.219977 1.982144 -4.965402  0.2863589
>> -5.219977 1.982144 -5.219977
>>   [6,] -5.197152 1.997830 -5.197152  1.9978302
>> -5.197152 1.997830 -5.197152
>>   [7,] -5.202288 1.987102 -5.202288  1.9871021
>> -5.202288 1.987102 -5.202288
>>   [8,] -4.665015 2.004351 -5.263740  2.0043512
>> -4.665015 2.004351 -5.263740
>>   [9,] -5.281771 1.947604 -5.281771  1.9476036
>> -5.281771 1.947604 -5.281771
>> [10,] -4.787324 1.917726 -5.268606  1.9177255
>> -5.268606 1.917726 -5.268606
>> [11,] -5.254092 1.892761 -5.254092  1.8927610
>> -4.740590 1.892761 -5.254092
>> [12,] -5.279645 1.878266 -5.279645  1.8782663
>> -5.279645 1.878266 -5.279645
>> [13,] -5.293714 1.941847 -5.293714  2.2120401
>> -4.208322 1.941847 -5.293714
>> [14,] -5.295412 1.891672 -5.295412  1.8916717
>> -4.041867 1.891672 -5.295412
>> [15,] -5.381407 2.281394 -5.381407  1.8335379
>> -3.885552 1.833538 -5.381407
>> [16,] -5.256472 1.813212 -5.256472  1.8132119
>> -5.256472 1.813212 -5.256472
>> [17,] -5.262836 1.763356 -5.262836  1.7633565
>> -5.262836 1.763356 -5.262836
>> [18,] -5.269976 2.890181 -5.269976  1.8244564
>> -5.269976 1.824456 -5.269976
>> [19,] -5.237574 1.868374 -5.237574  1.8683740
>> -5.237574 1.868374 -5.237574
>> [20,] -5.195960 1.879976 -5.195960  1.8799758
>> -5.195960 1.879976 -5.195960
>> [21,] -5.195960 1.897184 -5.195960  1.8971842
>> -5.195960 1.897184 -5.195960
>> [22,] -5.195960 1.946035 -5.195960 -0.2933984 -5.195960
>> 1.946035 -5.195960
>> [23,] -5.195960 2.005964 -5.195960  0.7982354
>> -5.195960 2.005964 -5.195960
>> [24,] -5.195960 1.966488 -5.195960  1.9664877
>> -5.195960 1.966488 -5.195960
>> [25,] -5.132915 1.922473 -5.132915  0.9233183
>> -5.132915 1.922473 -5.132915
>>             [,23]
>>    [,24]      [,25]
>>   [,26]    [,27]
>>    [,28]    [,29]
>>   [1,]  2.0100609 2.0100609 -0.2265311 2.010061
>> 2.010061 -5.223624 2.010061
>>   [2,]  2.0575018 2.0575018  0.4005312
>> 2.057502 2.057502 -5.217940 2.057502
>>   [3,]  2.0110810 2.0110810  2.0110810
>> 2.011081 2.011081 -5.227745 2.011081
>>   [4,]  2.0316951 2.0316951  2.0316951
>> 2.031695 2.031695 -5.147776 2.031695
>>   [5,]  1.9821437 1.9821437  1.4806333
>> 1.982144 1.982144 -5.219977 1.982144
>>   [6,]  1.9978302 1.9978302  1.9978302
>> 1.517729 1.997830 -5.197152 1.997830
>>   [7,]  1.9871021 1.9871021  1.9871021
>> 1.987102 1.477903 -5.202288 1.987102
>>   [8,]  1.4458665 2.0043512  2.0043512
>> 2.004351 2.004351 -5.263740 2.004351
>>   [9,]  1.9476036 1.9476036  1.8606397
>> 1.947604 1.947604 -4.713271 1.947604
>> [10,]  1.9177255 1.9177255  1.9177255 1.917726
>> 2.034417 -5.268606 1.917726
>> [11,]  1.8927610 1.3224297  1.8927610 2.230099
>> 1.892761 -5.254092 1.892761
>> [12,]  1.8782663 1.8782663  1.8782663 1.878266
>> 1.878266 -5.279645 1.878266
>> [13,]  1.9418472 1.9418472  1.9418472 1.941847
>> 1.941847 -4.208322 2.212040
>> [14,]  1.8916717 1.8916717  1.8916717 1.891672
>> 1.891672 -5.295412 1.891672
>> [15,]  1.8335379 1.8335379  2.2813944 1.833538
>> 2.281394 -5.381407 1.833538
>> [16,]  1.8132119 1.8132119  1.8132119 2.337103
>> 1.813212 -5.256472 1.813212
>> [17,]  1.7633565 2.5389042  2.5389042 2.595662
>> 1.763356 -5.262836 1.763356
>> [18,]  2.7188879 1.8244564  1.8244564 1.824456
>> 1.824456 -5.269976 1.824456
>> [19,]  1.8683740 2.6859935  1.8683740 1.868374
>> 1.868374 -5.237574 1.868374
>> [20,]  1.8799758 1.8799758  1.8799758 1.879976
>> 1.879976 -5.195960 3.699892
>> [21,]  1.8971842 1.8971842  1.8971842 1.897184
>> 1.897184 -5.195960 1.897184
>> [22,]  1.9460347 1.9460347  1.9460347 1.946035
>> 1.946035 -5.195960 3.781882
>> [23,]  1.0121785 2.0059635  2.0059635 2.005964
>> 2.005964 -5.195960 2.005964
>> [24,]  1.9664877 1.9664877  1.9664877 2.025442
>> 1.966488 -5.195960 1.966488
>> [25,]  1.3271565 1.9224727  0.9233183 1.922473
>> 1.922473 -5.132915 3.241784
>>
>>    [,30]     [,31]
>>    [,32]    [,33]
>>     [,34]       [,35]
>>   [1,]  1.46333623 2.0100609 -5.090333 2.010061
>> -0.226531126  2.01006088
>>   [2,]  2.05750183 1.3105841 -5.217940
>> 2.057502  0.029241895  0.02761610
>>   [3,]  2.01108103 2.0110810 -5.227745
>> 2.011081  0.339256598  2.01108103
>>   [4,]  2.03169511 2.0316951 -5.147776 2.031695
>> -5.147775829  1.50221329
>>   [5,]  1.55774038 1.9821437 -5.219977
>> 1.982144  0.286358885  0.28635889
>>   [6,]  1.99783017 1.9978302 -5.197152
>> 1.997830  1.997830167  1.99783017
>>   [7,]  1.47790312 0.7237104 -5.202288
>> 1.987102  0.723710361  0.73504349
>>   [8,]  2.00435118 1.4332984 -5.263740 2.004351
>> -0.619465588  2.00435118
>>   [9,]  1.94760360 1.9476036 -5.281771 1.947604
>> -0.976910576  1.86063972
>> [10,]  1.91772554 1.9177255 -5.268606 1.917726
>> -1.791538434  1.91772554
>> [11,]  1.89276104 1.8927610 -5.254092 2.230099
>> -1.791538434  2.23009859
>> [12,]  1.87826632 1.8782663 -5.279645 1.878266
>> 0.975872753  1.87826632
>> [13,]  1.94184718 1.9418472 -5.293714 1.146211
>> -5.293713913  1.94184718
>> [14,]  1.89167168 1.8916717 -5.295412 1.891672
>> -4.041867058  1.44591603
>> [15,]  1.83353786 1.8335379 -5.381407 2.281394
>> -2.411775517  1.83353786
>> [16,]  2.33710323 1.8132119 -5.256472 1.813212
>> -3.032447437  1.81321188
>> [17,]  1.76335647 1.7633565 -5.262836 1.763356
>> -1.791538434  1.76335647
>> [18,]  1.82445645 1.8244564 -5.269976 2.718888
>> -2.802877612  1.82445645
>> [19,]  1.86837403 1.8683740 -5.237574 1.868374
>> -0.583427551  1.86837403
>> [20,]  1.87997583 2.4004191 -5.195960 1.879976
>> -0.221729569  1.87997583
>> [21,]  1.89718417 1.8971842 -5.195960 1.897184
>> -0.335125564  1.89718417
>> [22,]  1.94603470 1.9460347 -5.195960 1.946035
>> -0.293398374  1.94603470
>> [23,]  2.00596350 2.0059635 -5.195960 2.005964
>> -1.791538434  0.02761610
>> [24,]  1.96648770 1.9664877 -5.195960 1.966488
>> 0.642854756  0.11557730
>> [25,]  1.92247274 1.9224727 -5.132915 1.922473
>> -5.132915158  1.92247274
>>
>> -----Inline Attachment Follows-----
>>
>> ______________________________________________
>> R-help at 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.
>>
>
>
>
>
> ______________________________________________
> R-help at 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.

David Winsemius, MD
Heritage Laboratories
West Hartford, CT



More information about the R-help mailing list