This reads in your posted data:
> x <- read.table(textConnection("Samplerate = 2 samps/sec
+ Nr Cnt1X Cnt1Y Cnt2X Cnt2Y sec100 hour
+ 1 53 84 43 2 22 12
+ 2 90 155 74 0 72 12
+ 3 90 155 74 0 121 12"), skip=1, header=TRUE)
> closeAllConnections()
>
> x
Nr Cnt1X Cnt1Y Cnt2X Cnt2Y sec100 hour
1 1 53 84 43 2 22 12
2 2 90 155 74 0 72 12
3 3 90 155 74 0 121 12
On Wed, Dec 23, 2009 at 8:31 PM, arthurbeer01 <[email protected]>wrote:
>
> Hi, this is my first post so please be gentle.
> I quite new to R and using it for my biology degree.
>
> My problem is. Im trying to import data from a .csv file using the
> read.table command. The .csv file header starts on row 2 but is contained
> in
> column 1, i have 600 data files and for future ease would rather not edit
> each file seperatly. The data starts on row three and I only need the first
> 381 data points.
>
> The R error message using the code iv got so far is
>
> Error in read.table(file("s1-2c83.csv"), header = FALSE, sep = ",", quote =
> "", :
> more columns than column names
>
> The code I have so far is
>
> framename<-read.table(file ("s1-2c83.csv"),
> header = FALSE, # FLASE indicates headers are not included in input file
> sep = ",", # must have "," otherwise errors in table
> quote = "",
> dec = ".",
> row.names = 1, # must = 1 or extra column of row numbering is entered
> col.names = ("Nr2sec,Cnt1X,Cnt1Y,Cnt2X,Cnt2Y,sec100,hour"),
> as.is = FALSE,
> na.strings = "NA",
> colClasses = NULL,
> nrows = 381, # rows to stop data.table recording (not input file row
> number!)
> skip = 2, # number of rows to skp before reading data from input file
> strip.white = FALSE,
> comment.char = "")
>
> write.csv(framename, file = "s1-2c83-ok.csv")
>
> If I delete the line col.names, Iv manged to get the data read and saved to
> a new .csv file but cannot work out how to get the column headers renamed.
> The read.table (framename) displays the headers as v1,v2,v3 etc, this is
> what i cant change. Also it has the first column without a header (i think
> its the row number) which I dont want in the output file
>
> The read data file example s1-2c83.csv
>
> 1:Samplerate = 2 samps/sec
> 2: Nr Cnt1X Cnt1Y Cnt2X Cnt2Y sec100 hour
> 3: 1 53 84 43 2 22 12
> 4: 2 90 155 74 0 72 12
> 5: 3 90 155 74 0 121 12
>
> Any help will be greatly appreciated after the 5hrs Iv spent already on
> this
> problem.
>
> Many thanks in advance
>
> Adam
>
>
>
> --
> View this message in context:
> http://n4.nabble.com/Column-naming-issues-using-read-table-tp978241p978241.html
> Sent from the R help mailing list archive at Nabble.com.
>
> ______________________________________________
> [email protected] mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide
> http://www.R-project.org/posting-guide.html<http://www.r-project.org/posting-guide.html>
> and provide commented, minimal, self-contained, reproducible code.
>
--
Jim Holtman
Cincinnati, OH
+1 513 646 9390
What is the problem that you are trying to solve?
[[alternative HTML version deleted]]
______________________________________________
[email protected] 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.
