Displaying 2 results from an estimated 2 matches for "us0001w".
Did you mean:
us0001m
2010 Feb 23
1
Excel Data Import using RODBC
Hello I am importing data from Excel to R using RODBC and I am ending up
with the following data frame:
names(AbioRep)
[1] "Date" "US0001W Index" "US0002W Index" "US0001M Index"
"US0002M Index" "US0003M Index" "US0004M Index" "US0005M Index" "US0006M
Index"
[10] "US0007M Index" "US0008M Index" "US0009M Index" "US0010M Index&qu...
2010 Feb 23
1
Importing Headers from excel files
...ut, the NA are supposed to be the second item in the Header. Is there
any way to Import more than one row as headers?. Thank you
Felipe Parra
> Data<-odbcConnectExcel('Curva LIBOR.xlsx',readOnly=T,)
> AbioRep<-sqlFetch(Data,'LIBOR-SWAP')
> head(AbioRep)
Date US0001W Index US0002W Index US0001M Index US0002M Index US0003M
Index US0004M Index US0005M Index US0006M Index US0007M Index US0008M Index
1 2005-01-04 2.32938 2.33563 2.4000
2.49000 2.57 2.6400 2.7100 2.7900
2.85000 2.91000
2 2005-01-05 2.32875...