[R] read.csv "Duplicate row.names not allowed"

[David Winsemius]

On Feb 7, 2012, at 12:22 AM, Hasan Diwan wrote:

> I'm trying to read in a CSV, with lines looking like:
> HEADER,  Latitude DecDeg,  Latitude Hemisphere,  Longitude DecDeg,
> Longitude Hemisphere,  Speed knots,  Bearing Degrees,  fixQualityGga,
> noOfSatGga,  altGga,  heightGga,  selectionGsa,  fixGsa,  pdopGsa,
> hdopGsa,  vdopGsa,  noOfSatGsv,  Time, *checkSum
> $GPS, 3747.0224, N, 12223.4522, W, 0.36, 348.21, 1, 3, 4.01, 175.5,
> -25.2, A, 2, 4.14, 4.01, 1.00, 00, 1328565081, *0E
> $GPS, 3747.0894, N, 12223.4684, W, 0.44, 348.21, 1, 4, 1.65, 14.4,
> -25.2, A, 3, 1.92, 1.65, 0.99, 00, 1328565082, *3D
> $GPS, 3747.0897, N, 12223.4685, W, 0.13, 348.21, 1, 6, 1.23, 14.0,
> -25.2, A, 3, 1.57, 1.23, 0.98, 00, 1328565083, *32
> ... using read.csv and am getting the error message in the subject
> line ("Duplicate row.names not allowed"). Any idea what is causing
> this?

count.fields( textConnection("HEADER,  Latitude DecDeg,  Latitude  
Hemisphere,  Longitude DecDeg, Longitude Hemisphere,  Speed knots,   
Bearing Degrees,  fixQualityGga, noOfSatGga,  altGga,  heightGga,   
selectionGsa,  fixGsa,  pdopGsa, hdopGsa,  vdopGsa,  noOfSatGsv,   
Time, *checkSum
+ $GPS, 3747.0224, N, 12223.4522, W, 0.36, 348.21, 1, 3, 4.01, 175.5,  
-25.2, A, 2, 4.14, 4.01, 1.00, 00, 1328565081, *0E
+ $GPS, 3747.0894, N, 12223.4684, W, 0.44, 348.21, 1, 4, 1.65, 14.4,  
-25.2, A, 3, 1.92, 1.65, 0.99, 00, 1328565082, *3D
+ $GPS, 3747.0897, N, 12223.4685, W, 0.13, 348.21, 1, 6, 1.23, 14.0,  
-25.2, A, 3, 1.57, 1.23, 0.98, 00, 1328565083, *32")
+ )
[1] 25 20 20 20

The spaces shouldn't be in field names.

More column headings than data, eh? You probably need to edit your  
header so it doesn't have "extra stuff". And remove the leading "$GPS"  
which seems to be getting interpreted as row.names.

read.csv(textConnection("  Latitude_DecDeg,  Latitude_Hemisphere,   
Longitude_DecDeg, Longitude_Hemisphere,  Speed_knots,   
Bearing_Degrees,  fixQualityGga, noOfSatGga,  altGga,  heightGga,   
selectionGsa,  fixGsa,  pdopGsa, hdopGsa,  vdopGsa,  noOfSatGsv,   
Time, check
+  3747.0224, N, 12223.4522, W, 0.36, 348.21, 1, 3, 4.01, 175.5,  
-25.2, A, 2, 4.14, 4.01, 1.00, 00, 1328565081, *0E
+  3747.0894, N, 12223.4684, W, 0.44, 348.21, 1, 4, 1.65, 14.4, -25.2,  
A, 3, 1.92, 1.65, 0.99, 00, 1328565082, *3D
+  3747.0897, N, 12223.4685, W, 0.13, 348.21, 1, 6, 1.23, 14.0, -25.2,  
A, 3, 1.57, 1.23, 0.98, 00, 1328565083, *32"))
            Latitude_DecDeg Latitude_Hemisphere Longitude_DecDeg  
Longitude_Hemisphere
  3747.0224               N            12223.45                 
W                 0.36
  3747.0894               N            12223.47                 
W                 0.44
  3747.0897               N            12223.47                 
W                 0.13
            Speed_knots Bearing_Degrees fixQualityGga noOfSatGga  
altGga heightGga
  3747.0224      348.21               1             3       4.01   
175.5     -25.2
  3747.0894      348.21               1             4       1.65    
14.4     -25.2
  3747.0897      348.21               1             6       1.23    
14.0     -25.2
            selectionGsa fixGsa pdopGsa hdopGsa vdopGsa  
noOfSatGsv       Time check
  3747.0224            A      2    4.14    4.01    1.00          0  
1328565081   *0E
  3747.0894            A      3    1.92    1.65    0.99          0  
1328565082   *3D
  3747.0897            A      3    1.57    1.23    0.98          0  
1328565083   *32




> -- 
> Sent from my mobile device
> Envoyait de mon portable
>
> ______________________________________________
> 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
West Hartford, CT