Displaying 2 results from an estimated 2 matches for "_persistent_connections".
2008 Jul 14
3
Data Manipulations and SQL
Greetings,
I am new to R and have some background knowledge about SQL. I'd like to
know whether there is a way to manipulate the R datasets (or data
frames) using SQL statements. For example, I have two data frames and
both of them have a column called "id", then I want to join this two
data frames into one. In SQL, we can just simply use the join comment.
What should we do in R?
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,