That's strange because I was able to read the file into R just fine
--- On Tue, 2/2/10, David Winsemius <dwinsem...@comcast.net> wrote: > From: David Winsemius <dwinsem...@comcast.net> > Subject: Re: [R] how to read this data file into R? > To: "Felipe Carrillo" <mazatlanmex...@yahoo.com> > Cc: r-help@r-project.org, "song song" <rprojecth...@gmail.com> > Date: Tuesday, February 2, 2010, 3:40 PM > > 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 <rprojecth...@gmail.com> > wrote: > > > >> From: song song <rprojecth...@gmail.com> > >> Subject: [R] how to read this data file into R? > >> To: r-help@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@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@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 > > ______________________________________________ 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.