i just want to read data from Excel and i copied it and pasted into a txt file. then i want to use "read.table" to read it. but however i tried, it doesn't work. can someone help me? data is attached. thanks http://www.nabble.com/file/p16851853/weekly.txt weekly.txt -- View this message in context: http://www.nabble.com/a-simple-question-of-importing-data-tp16851853p16851853.html Sent from the R help mailing list archive at Nabble.com.
try:
var <- read.table("weekly.txt", sep="\t", header=TRUE)
Charles
On Thu, Apr 24, 2008 at 3:29 PM, tzsmile <rz2171 at yahoo.com>
wrote:>
> i just want to read data from Excel and i copied it and pasted into a txt
> file.
> then i want to use "read.table" to read it. but however i tried,
it doesn't
> work.
> can someone help me?
> data is attached.
> thanks http://www.nabble.com/file/p16851853/weekly.txt weekly.txt
> --
> View this message in context:
http://www.nabble.com/a-simple-question-of-importing-data-tp16851853p16851853.html
> Sent from the R help mailing list archive at Nabble.com.
>
> ______________________________________________
> 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.
>
> -----Original Message----- > From: r-help-bounces at r-project.org > [mailto:r-help-bounces at r-project.org] On Behalf Of tzsmile > Sent: Thursday, April 24, 2008 12:30 PM > To: r-help at r-project.org > Subject: [R] a simple question of importing data > > > i just want to read data from Excel and i copied it and > pasted into a txt > file. > then i want to use "read.table" to read it. but however i > tried, it doesn't > work. > can someone help me? > data is attached. > thanks http://www.nabble.com/file/p16851853/weekly.txt weekly.txt > -- > View this message in context: > http://www.nabble.com/a-simple-question-of-importing-data-tp16851853p16851853.html> Sent from the R help mailing list archive at Nabble.com. > > ______________________________________________ > 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. >Have you looked at the foreign package? It should help do what you want. Or you could use Excel to output a .csv and read that with read.table(). Hope this is helpful, Dan