Hi
if you still have Excel file and can open it
open Excel
select what you want to read, including header
press ctrl-C
then in R
a<-read.delim("clipboard")
and to write from R
write.table(tab, "clipboard", sep = "\t", row.names = F)
open Excel
press ctrl-V
Looks like Excel left in your txt file something which prevent
correct reading. Does the txt file look like you presented in other
viewer (Notepad,....)
HTH
Petr
On 16 Sep 2005 at 19:46, Krishna wrote:
> Hi all
>
> i am facing a peculiar problem for data input using read.table which i
> never faced previously.
>
> i have a data file by name abnew.txt with two coloumns data as
> depicted below.
>
> A B
> 420 422
> 314 321
>
> the txt file is created using the excel save as option. i issued the
> statement as
>
> > a <- read.table("abnew.txt", header=TRUE)
> > a
> X.ţS
> 1 NA
> 2 2
> 3 2
> 4 NA
> 5 2
> 6 2
> 7 NA
> 8 2
> 9 2
> 10 NA
>
> the o/p looks like as copied above. can some one help me on correct
> data reading. your earliest response will help me a lot.
>
> thanks and regards
>
> snvk
>
> ______________________________________________
> [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
Petr Pikal
[EMAIL PROTECTED]
______________________________________________
[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
