Hello MongoDB community, I am trying to understand the difference in the results and performance implications between two aggregate queries in MongoDB...

I have a dataframe with a column Status which values are either 'OPEN' or 'CLOSED'. I would like to do a groupby() on multiple columns and use the fol...

I have a dataset like this: Contract KPI Contract Extension Date Start Contract End Date Amount Purchased New ID Contract New Amount Purchased ...

The main purpose is to get the total price of the orders array of objects. So I used mongoDB aggregation operation. I used NoSQL booster to check quer...

I have this dataframe : df = pd.DataFrame({'CLASS': ['A', 'B', 'A'], 'MEMBERS': ['foo & bar', 'bar & luz', 'baz']}) print(df) # CLASS MEMBERS #...

I'm trying to aggregate some rows in my dataframe with a list[str] column. For each index I need the intersection of all the lists in the group. Not s...

I have a table sub_table like this: "id" "created_datetime" "main_table_id" "skill" ... "team" 1 2023-11-01 01:00:00 1 drum ... a 2 2023-11-...

What is the reason why default initialization is possible with RegBaseB but not with RegBaseA: struct RegBaseA { union {unsigned int value;}; ...

I'm trying to extract, for each event_type, in how many days the event occurred and the last occurrence. Currently I wrote the following query: { ...

I am running PySpark 3.3.1. In my Window function, I noticed that the max output is not what I expect. Why is that? What is happening in the window gr...

I have a table. When I am using formula: =FILTER(A1:C7,B1:B7="red",) what I am getting is: What I would like to get however is: Any ideas how to do...

After a pivot_wider(), I get the following data.frame. How can I aggregate the data on the same line? CODE_C CODE_P LIB_COMPOSANT LIB_PRODUIT `2020-...

Im trying to get my head around the most effective way to achieve intended result. After some reading i realize turning only_full_group_by=off is a ba...

Given the following tables: UnitAlertStatus ID AlertedUnitID UnitAlertStatus EpochStamp Unit ID HardwareID Name UnitTyp...

I am using below JMeter commandline to execute JMeter tests and generate csv file jmeter -n -t "E:\New folder\apache-jmeter-5.1.1\JMeterProject\Test.j...

I'm trying to group messages, which have been sent shortly after another. A parameter defines the maximum duration between messages for them to be con...

Updated to specify using MS SQL Server. I have a table that has one row for each action performed by a worker, each action with a date/time stamp. Act...

"error": { "ok": 0, "code": 5107201, "codeName": "Location5107201", "$clusterTime": { "clusterTime": { "$timestamp": "7292060947630260235" }, "signatu...

I am trying to model a domain for the backend of my app. In my domain, I have Cook aggregate root and every cook will have an Ethnicity. If we think i...

I am having an ordinary spring boot integration test, which works fine with @Autowired and @MockBean, having all real, just the rest templates to the ...

I have a mongo aggregate query like below: db.someCollection.aggregate([ { $match: { taskId: "qy7u17-xunwqu" } }, // Group by "tracklet_id" ...

I attempted to determine the minimum and maximum values from the courses associated with employees using the count aggregate function. The relationshi...

I attempted to determine the minimum and maximum values from the courses associated with employees using the count aggregate function. The relationshi...

I have this table: I don't know how I can get these results, based on the occupation and age of employees: I'm inexperienced at this. In excel I use ...

In my data model I have a table that looks a bit like this: Customer Demographic Sales A AA 10 B AA 15 C BB 20 D CC 30 I want to cre...