The data I am working with is from eBird, and I am looking to sort out species occurrence by both name and year. There are over 30k individual observations, eac
I'm looking for a solution where I could aggregate data coming from TCP or even from an azure queue based on a device id. I have been looking at the documentati
I found this similar question to mine, but without explanation Mongoose find query vs $match, I'm trying to do something similar. I manage to filter by today's
Hi everyone, I'm a little bit lost with a problem thinking in ddd way. Imagine you have an application to sell concert ticket. So you have an entity which is ca
We have a microservice which enables consumers (indirectly) to query a database, where we have our own logic to limit what consumers can do with the queries. Wh
I work with timestamps (having mixed DST values). Tried in Pandas 1.0.0: s = pd.Series( [pd.Timestamp('2020-02-01 11:35:44+01'), np.nan, # same result
I have a records collection with the following indexes: {"_id":1} {"car.make":1,"city":1,"car.mileage":1} And performing the following query: db.records.agg
I need to run a query as cronjob and it is too slow to perform. It sums a value from a view table (data_time_series) for each pair of aks and ii and inserts a r
I have a list that looks like [(1,2,5),(2,10,13),(5,24,56),(1,8,10),(2,3,11)] How can I produce a dictionary by grouping by first element of tuples and find
I have a dataset where each individual (id) has an e_date, and since each individual could have more than one e_date, I'm trying to get the earliest date for ea
I'm having a problem with the aggregate function. My data.frame looks like this: **Region Sex SNI value** orebro Man 0 497 orebro
I am getting the following error while joining two collection and project the fields using MognoDB. Error:: Error: command failed: { "ok" : 0, "er
I have two collections with same structure and want to merge them in aggregation result and query & sort over them after merging. E.g.; First collection: