+ Reply to Thread
Results 1 to 5 of 5

Thread: read.table error

  1. #1
    Points: 1,283, Level: 19
    Level completed: 83%, Points required for next Level: 17

    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    read.table error




    newbie question here. I can't get read.table to read the first entry in a tab delimited file. Here's the data file (from Crawley's Statistics: An Introduction Using R)

    Code: 
    Field.Name	Area	Slope	Vegetation	Soil.pH	Damp	Worm.density 
    Nashs.Field	3.6	11	Grassland	4.1	F	4
    Silwood.Bottom	5.1	2	Arable	5.2	F	7
    Nursery.Field	2.8	3	Grassland	4.3	F	2
    Rush.Meadow	2.4	5	Meadow	4.9	T	5
    Gunness.Thicket	3.8	0	Scrub	4.2	F	6
    Oak.Mead	3.1	2	Grassland	3.9	F	2
    Church.Field	3.5	3	Grassland	4.2	F	3
    Ashurst	2.1	0	Arable	4.8	F	4
    The.Orchard	1.9	0	Orchard	5.7	F	9
    Rookery.Slope	1.5	4	Grassland	5	T	7
    Garden.Wood	2.9	10	Scrub	5.2	F	8
    North.Gravel	3.3	1	Grassland	4.1	F	1
    South.Gravel	3.7	2	Grassland	4	F	2
    Observatory.Ridge	1.8	6	Grassland	3.8	F	0
    Pond.Field	4.1	0	Meadow	5	T	6
    Water.Meadow	3.9	0	Meadow	4.9	T	8
    Cheapside	2.2	8	Scrub	4.7	T	4
    Pound.Hill	4.4	2	Arable	4.5	F	5
    Gravel.Pit	2.9	1	Grassland	3.5	F	1
    Farm.Wood	0.8	10	Scrub	5.1	T	3
    Here's what I type into R:

    Code: 
    > worms<-read.table("c:\\temp\\worms.txt",header=T,row.names=1)
    > attach(worms)
    > names(worms)
    [1] "Area"         "Slope"        "Vegetation"   "Soil.pH"      "Damp"        
    [6] "Worm.density"
    > worms
                      Area Slope Vegetation Soil.pH  Damp Worm.density
    Nashs.Field        3.6    11  Grassland     4.1 FALSE            4
    Silwood.Bottom     5.1     2     Arable     5.2 FALSE            7
    Nursery.Field      2.8     3  Grassland     4.3 FALSE            2
    Rush.Meadow        2.4     5     Meadow     4.9  TRUE            5
    Gunness.Thicket    3.8     0      Scrub     4.2 FALSE            6
    Oak.Mead           3.1     2  Grassland     3.9 FALSE            2
    Church.Field       3.5     3  Grassland     4.2 FALSE            3
    Ashurst            2.1     0     Arable     4.8 FALSE            4
    The.Orchard        1.9     0    Orchard     5.7 FALSE            9
    Rookery.Slope      1.5     4  Grassland     5.0  TRUE            7
    Garden.Wood        2.9    10      Scrub     5.2 FALSE            8
    North.Gravel       3.3     1  Grassland     4.1 FALSE            1
    South.Gravel       3.7     2  Grassland     4.0 FALSE            2
    Observatory.Ridge  1.8     6  Grassland     3.8 FALSE            0
    Pond.Field         4.1     0     Meadow     5.0  TRUE            6
    Water.Meadow       3.9     0     Meadow     4.9  TRUE            8
    Cheapside          2.2     8      Scrub     4.7  TRUE            4
    Pound.Hill         4.4     2     Arable     4.5 FALSE            5
    Gravel.Pit         2.9     1  Grassland     3.5 FALSE            1
    Farm.Wood          0.8    10      Scrub     5.1  TRUE            3
    >
    Notice I only have 6 variables - Field.Name is missing. I've checked the txt file, there are no spaces after the Field.Name, just a tab. The strange thing is, this was working fine last night. What gives??

  2. #2
    Devorador de queso
    Points: 95,940, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Awards:
    Posting AwardCommunity AwardDiscussion EnderFrequent Poster
    Dason's Avatar
    Location
    Tampa, FL
    Posts
    12,937
    Thanks
    307
    Thanked 2,630 Times in 2,246 Posts

    Re: read.table error

    I think it has to do with you putting the row.names=1 option in there. In doing that you're telling it that the first column is row names and thus it doesn't really think you care about that column heading because that column just represents row names. If you actually care about that try to not set the row names option.

  3. #3
    Dark Knight
    Points: 6,762, Level: 54
    Level completed: 6%, Points required for next Level: 188
    vinux's Avatar
    Posts
    2,011
    Thanks
    52
    Thanked 241 Times in 205 Posts

    Re: read.table error

    worms<-read.table("c:\\temp\\worms.txt",header=T,row.names=NULL)
    This will work
    In the long run, we're all dead.

  4. #4
    Points: 1,283, Level: 19
    Level completed: 83%, Points required for next Level: 17

    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: read.table error

    Quote Originally Posted by Dason View Post
    I think it has to do with you putting the row.names=1 option in there. In doing that you're telling it that the first column is row names and thus it doesn't really think you care about that column heading because that column just represents row names. If you actually care about that try to not set the row names option.
    Very good, that worked. Thanks!

  5. #5
    Points: 1,283, Level: 19
    Level completed: 83%, Points required for next Level: 17

    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: read.table error


    Quote Originally Posted by vinux View Post
    worms<-read.table("c:\\temp\\worms.txt",header=T,row.name s=NULL)

    This will work
    didn't work, due to the space between "row.name" and "s".

    just kidding, I knew what you meant. Thanks!

+ Reply to Thread

           




Similar Threads

  1. Error code when using read.csv
    By wafll in forum R
    Replies: 4
    Last Post: 03-10-2011, 07:08 AM
  2. Replies: 2
    Last Post: 08-05-2009, 06:01 AM
  3. reading table - error
    By WeeG in forum R
    Replies: 2
    Last Post: 05-26-2009, 09:38 AM
  4. How do you read a Z-Score Table?
    By jjs2168 in forum Statistics
    Replies: 1
    Last Post: 04-08-2009, 11:49 PM
  5. Who can read a result table for me?
    By angelaabd in forum Psychology Statistics
    Replies: 0
    Last Post: 07-28-2008, 10:24 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts






Advertise on Talk Stats