Hi, I'd like to import a 154x1 vector of a stock monthly returns from a text (or excel spreadsheet) into R. I need to work on this vector by calculating mean, variance and use it for more complex operations. What is the best function to do so? There are no headers, just 154 decimale numbers (so there also negative numbers). Thanks, Claudio -- View this message in context: http://r.789695.n4.nabble.com/How-to-import-data-from-a-text-file-in-R-tp4650718.html Sent from the R help mailing list archive at Nabble.com.
How to import data from a text file in R
3 messages · dilo88, jim holtman, John Kane
read the 'intro to R' again and then ?scan ?read.table Sent from my iPad
On Nov 25, 2012, at 6:29, dilo88 <claudio.diloreto at carloalberto.org> wrote:
Hi, I'd like to import a 154x1 vector of a stock monthly returns from a text (or excel spreadsheet) into R. I need to work on this vector by calculating mean, variance and use it for more complex operations. What is the best function to do so? There are no headers, just 154 decimale numbers (so there also negative numbers). Thanks, Claudio -- View this message in context: http://r.789695.n4.nabble.com/How-to-import-data-from-a-text-file-in-R-tp4650718.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.
Save the file as a csv file and try something like this:
mydata <- read.csv("xxxx.csv", header = FALSE)
John Kane
Kingston ON Canada
-----Original Message----- From: claudio.diloreto at carloalberto.org Sent: Sun, 25 Nov 2012 03:29:42 -0800 (PST) To: r-help at r-project.org Subject: [R] How to import data from a text file in R Hi, I'd like to import a 154x1 vector of a stock monthly returns from a text (or excel spreadsheet) into R. I need to work on this vector by calculating mean, variance and use it for more complex operations. What is the best function to do so? There are no headers, just 154 decimale numbers (so there also negative numbers). Thanks, Claudio -- View this message in context: http://r.789695.n4.nabble.com/How-to-import-data-from-a-text-file-in-R-tp4650718.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.
____________________________________________________________ FREE 3D MARINE AQUARIUM SCREENSAVER - Watch dolphins, sharks & orcas on your desktop!