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