Hi R-Experts,
I'm having a problem with reading a large data file which is
in .csv format and size is 120 MB (app.). I was trying to use RODBC
package but I found RODBCconnectExcel function only. And can I convert
this file to .dbf format? How can I read this file? And also let me
know if this was a file in .sas7bdat format, what should I do? Thanks in
advance.
Sumanta.
[[alternative HTML version deleted]]
Sumanta consider using read.csv which is a special case of read.table ?read.csv as for the RODBC functions, you probably found odbcConnectExcel, but the help file there mentions a .dbf connections ?odbcConnectDbase from there using sqlQuery it should be possible to write a .dbf file. ?sqlQuery cheers, On 11/17/06, Sumanta Basak <sumantab@ambaresearch.com> wrote:> > Hi R-Experts, > > > > I'm having a problem with reading a large data file which is > in .csv format and size is 120 MB (app.). I was trying to use RODBC > package but I found RODBCconnectExcel function only. And can I convert > this file to .dbf format? How can I read this file? And also let me > know if this was a file in .sas7bdat format, what should I do? Thanks in > advance. > > > > > > Sumanta. > > > [[alternative HTML version deleted]] > > ______________________________________________ > R-help@stat.math.ethz.ch mailing list > stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide > R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. >-- Tim Calkins 0406 753 997 [[alternative HTML version deleted]]
For a CSV file I would use 'read.csv()'. I've compiled some notes on reading in large data frames into R at biostat.jhsph.edu/~rpeng/docs/R-large-tables.html. -roger Sumanta Basak wrote:> Hi R-Experts, > > > > I'm having a problem with reading a large data file which is > in .csv format and size is 120 MB (app.). I was trying to use RODBC > package but I found RODBCconnectExcel function only. And can I convert > this file to .dbf format? How can I read this file? And also let me > know if this was a file in .sas7bdat format, what should I do? Thanks in > advance. > > > > > > Sumanta. > > > [[alternative HTML version deleted]] > > ______________________________________________ > R-help at stat.math.ethz.ch mailing list > stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. >-- Roger D. Peng | biostat.jhsph.edu/~rpeng