Re: [R] Reading Input file

[Maithili Shiva]

Dear R helpers / Johannes Sir,
 
Unfortunately it didn't work.

I am getting following warning messages.
 
1: In neweate[i] = read.csv(rates[i]) :
  number of items to replace is not a multiple of replacement length.
2:  similar message
3:  similar message
4: similar message
 
Let me be specific in my problem.
 
I have three csv files as 
 
rate1.csv
r1        r2        r3        r4        
r5         r6
10.1   10.25   10.25   10.50   10.50    10.75
 
rate2.csv
r1        r2        r3        r4        
r5         r6
15.1   15.45   15.45   15.70   15.70    15.90
 
rate3.csv
r1        r2        r3        r4        
r5         r6
18.3   18.50   18.50   18.65   18.65    18.95
 
Normally I can read these files as 
 
newrate1  =  read.csv('rate1.csv'')
newrate2  =  read.csv('rate2.csv')
newrate3  =  read.csv('rate3.csv')
 
However, due to some other requirement first I have to define following R code
 
n = 3 
 
rate_name = NULL
 
for (i in 1:n)

rate_name[i] = (paste(`rate', i, ‘.csv`, sep = ‘’))

# rate_name gives "rate1.csv" "rate2.csv" "ratë3.csv"
 
 
### MY TASK
 
I need to use the rate_names to read the actual rate1.csv, rate2.csv and 
rate3.csv files.
 
When I use the following code
 
newrate <- list()
for (i in 1:n)
   {
    newrate[i] = read.csv(rate_name[i])
   }

I get following warning messages
 
1: In newrate[i] = read.csv(rate_name[i]) :
  number of items to replace is not a multiple of replacement length
2: similar message
3: similar message
 
 
## APPROACH II
 
PPP = matrix(data = rate_name, nrow = 1, ncol = 3, byrow = FALSE)
X = matrix(data = NA, nrow = 3, ncol = 6, byrow = FALSE)
 
for (j in 1:3)
X = read.csv(PPP[1, j])
 
# X returns  (i.e. only first record is taken)
 
r1        r2        r3        r4        
r5         r6
10.1   10.25   10.25   10.50   10.50    10.75
 
 
Please guide
 
With regards
 
Maithili
 
 
--- On Sat, 26/12/09, Johannes Signer <j.m.sig...@gmail.com> wrote:


From: Johannes Signer <j.m.sig...@gmail.com>
Subject: Re: [R] Reading Input file
To: "Maithili Shiva" <maithili_sh...@yahoo.com>
Cc: r-help@r-project.org
Date: Saturday, 26 December, 2009, 9:42 AM





On Sat, Dec 26, 2009 at 10:21 AM, Maithili Shiva <maithili_sh...@yahoo.com> 
wrote:



Dear R helpers
 
I have some files in my say 'WORK' directory and the file names are say 
rate1.csv, rate2.csv, rate3.csv, rate4.csv
 
Because of some other requirement, I need to run the following commands
 
n = 4 
 
rates = NULL
 
for (i in 1:n)

rates[i] = (paste(`rate', i, ‘.csv`, sep = ‘’))
 
# this gives me "rate1.csv" "rate2.csv" and so on
 
#My problem is now I need to relate these file names with actual files and read 
these files
# There are files rate1.csv, rate2.csv, rate3.csv, rate4.csv in my WORK 
directory.
 
 
# If I individually define
 
PPP = read.csv(‘rate[1]’)
PPP      # When I run PPP in R, it gives contents of the file rate1.csv 
i.e. I am able to read the required rate1 file. But if I run following 
commands, I get errors.
 
newrate = NULL
 

Maybe try:

newrate <- list()

and leave everything else as it is.

just an idea, 

 
for (i in 1:n)
   {
    newrate[i] = read.csv(rates[i])
   }
 
I need to read all these four files for my further analysis. Please guide.
 
 
Regards
 
Maithili
 
 


     The INTERNET now has a personality. YOURS! See your Yahoo! Homepage.
       [[alternative HTML version deleted]]


______________________________________________
R-help@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.





[[elided Yahoo spam]]

        [[alternative HTML version deleted]]


______________________________________________
R-help@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.