search for: sqlitebrowser

Displaying 2 results from an estimated 2 matches for "sqlitebrowser".

2006 Jan 05
2
Suggestion for big files [was: Re: A comment about R:]
[ronggui] >R's week when handling large data file. I has a data file : 807 vars, >118519 obs.and its CVS format. Stata can read it in in 2 minus,but In >my PC,R almost can not handle. my pc's cpu 1.7G ;RAM 512M. Just (another) thought. I used to use SPSS, many, many years ago, on CDC machines, where the CPU had limited memory and no kind of paging architecture. Files did
2010 Nov 15
5
How to Read a Large CSV into a Database with R
Hi, I'm working in R 2.11.1 x64 on Windows x86_64-pc-mingw32. I'm trying to insert a very large CSV file into a SQLite database. I'm pretty new to working with databases in R, so I apologize if I'm overlooking something obvious here. I'm trying to work with the American Community Survey data, which is two 1.3GB csv files. I have enough RAM to read one of them into memory,