Questions tagged [rmongodb]

rmongodb is a full featured driver for the R language to interface with the MongoDB database. R is an open source programming language and software environment for statistical computing and graphics.

rmongodb is a full featured driver for the R language to interface with MongoDB. rmongodbis built on top of the MongoDB.com supported C driver.

Documentation and source code

Related links:

99 questions
21
votes
2 answers

Multiple use of the positional `$` operator to update nested arrays

This question is closely related to this one and I will consider the advice given with respect to schema design in a NoSQL context, yet I'm curious to understand this: Actual questions Suppose you have the following document: _id : 2 abcd …
Rappster
  • 11,680
  • 7
  • 58
  • 113
12
votes
3 answers

How to query MongoDB from R?

I want to get a MongoDB query from R. With the mongo shell, I would query with: db.user.find({age:{$gt:21}}) However, In R-Mongo, I haven't found how to describe this query. Thanks
user189594
  • 191
  • 2
  • 6
7
votes
2 answers

Queries in MongoDB

I'm trying to use rmongodb to fetch information from a MongoDB database for further processing in R. However, I have some difficulties to really get started. This one works: cursor <- mongo.find(mongo, "people", query=list(last.name="Smith",…
AnjaM
  • 2,685
  • 5
  • 33
  • 54
6
votes
1 answer

Which package to use to connect R with MongoDB?

I wonder what are the main differences between rmongodb and RMongo packages for connecting R with MongoDB. What are the advantages and disadvantages of these two packages?
AnjaM
  • 2,685
  • 5
  • 33
  • 54
6
votes
2 answers

speed up large result set processing using rmongodb

I'm using rmongodb to get every document in a a particular collection. It works but I'm working with millions of small documents, potentially 100M or more. I'm using the method suggested by the author on the website: cnub.org/rmongodb.ashx count <-…
rjb101
  • 504
  • 5
  • 14
5
votes
3 answers

Running advanced MongoDB queries in R with rmongodb

As MySQL is driving me nuts I'm trying to make myself acquainted with my first "NoSQL" DBMS and it happened to be MongoDB. I'm connecting to it via rmongodb. The more I play around with rmongodb, the more questions/problems come up with respect to…
Rappster
  • 11,680
  • 7
  • 58
  • 113
4
votes
1 answer

long time to import data using mongo.find.all (rmongodb)

I tried to import data from mongodb to r using: mongo.find.all(mongo, namespace, query=query, fields= list('_id'= 0, 'entityEventName'= 1, context= 1, 'startTime'=1 ), data.frame= T) The command works find for small data sets, but I want to import…
4
votes
1 answer

rmongodb $cond in aggregation framework

I am trying to perform a sum in a group by operation in rmongodb. The "column" that I am summing contains NaN values with cause my sum to return NaN. I want to use $project to replace the NaNs with zeros before running the group by command but I am…
user2574279
4
votes
1 answer

insert data.frame from R to Mongodb

I have a Twitter data CSV file which I have read in R using read.table, then I have performed some algorithms on that data and got the output as tabular data. I want to insert this tabular data into mongodb. Can any one help? The tabular data looks…
user2239175
  • 51
  • 1
  • 4
3
votes
1 answer

Convert mongo objectid to string using rmongodb

I'm trying to convert a mongo collection to an R data frame. I'm using rmongodb package to do the same. I'm facing a problem with fields with the datatype "ObjectId" (in the code below, the column "_id"), rmongodb does not seem to recognize them as…
3
votes
2 answers

rmongodb support for MongoDB 3

I am building a R script in which I need to connect to MongoDB through authentication and process the data fetched from database using rmongodb package.For that I have created a new MongoDB user in version 3.0.4 and while connecting to mongoDB from…
Rubin Porwal
  • 3,218
  • 1
  • 17
  • 25
3
votes
0 answers

rmongodb is very slow in creating data.frame

I am using MongoDB do to tick data analysis in R. Initially I used MySQL, which worked fine, but I wanted to test MongoDB for this purpose. The data set contains about 200 million entries at the moment. Using RODBC I could get the query result into…
rosor
  • 31
  • 2
3
votes
1 answer

using mapreduce in R

I am trying to do a mapreduce using R. There is an R package called mapReduce but its functionality was not for complex mapreduce applications. I am using mongodb for my datatbase and use R's rmongodb package to access it.Now if U need to do some…
user1848018
  • 1,016
  • 12
  • 30
3
votes
1 answer

Processing result sets of queries with package 'rmongodb'

How would you go about processing a result set (length > 1) of a MongoDB query when using the rmongodb package and when your final object should be a list? I try to avoid R-typical "pass-by-value" copying inefficiencies which occur when simply…
Rappster
  • 11,680
  • 7
  • 58
  • 113
2
votes
1 answer

How to list mongodb collections in R

I have been trying to list collections within a mongo database in R. I have realized that this feature is still in the to do list in the mongolite package (https://github.com/jeroen/mongolite/issues/86). There seemed to be a package, rmongodb,…
deann
  • 636
  • 9
  • 19
1
2 3 4 5 6 7