Questions tagged [group]

585 questions
0
votes
2 answers

Define group between empty column values (untidy data with no data "title rows")

I have a lot of old untidy data in excel files (50 sheets with 400-500 rows each). A part of my data looks like this: Elements= c("Project name ONE","John","Smith","Sara","Project name TWO","stardust","soil","sunflower","juice","doe","tobacco",…
Krag
  • 1
  • 1
0
votes
1 answer

ElasticSearch - merge/combine the results by group

Following is the data stored in ElasticSearch: [ { "id": 1, "class": "class 1", "name": "Scott", "scores": [ { "year": 2022, "score": 100 }, { "year": 2011, "score": 80 }, { "year": 2003, "score": 70 } ] }, …
Elhz
  • 3
  • 1
0
votes
2 answers

Displaying result of joining two MySQL tables without duplicates, using DISTINCT or GROUP BY

I have two tables: BLOG table withe scheme (id_blog, name, content, date, building) and IMG table with scheme (id_img, filename, id_blog). With query below, I've got result of LEFT JOIN tables BLOG and IMG and it's OK. SELECT b.name, …
Sandowl
  • 73
  • 1
  • 4
0
votes
2 answers

Extjs6: gridpanel - multilevel grouping

On a project written with ExtJs 6, I'm looking for the ability to have multi-level grouping on a grid. I don't want to group the records on multiple columns but on one level, but each column to be grouped on its own level. I found some examples for…
VyTre
  • 103
  • 3
  • 14
0
votes
0 answers

SQL Get New Record from Match Records

I have a Table for Mutilate and Duplicate Records So I want Get New Duplicate Like Group By I give the Example My Table example ID, Item Rate -------------- 1 APPLE 10 2 ORANGE 15 3 BANANA 10 4 APPLE 12 5 APPLE 13 6 ORANGE 14 7 APPLE …
0
votes
2 answers

Get Group sum not using group.Sum() in linq

The following query works, but I want to get the same result without using grp.Sum(). Can we do it? from item in (await VehicleReplaceCostDataAsync()) group item by (item.type, item.size, item.ADA, item.eseq) into grp …
0
votes
1 answer

finding file_id of a group media message in telegram by telebot library

In my bot, I received a forwarded media group message which contains 3 different photos. Now I want to catch all these 3 photos and send them again to another chat_id. However, all values in message.photo.file_id are representing the same photo in…
Ali Saghi
  • 11
  • 2
0
votes
1 answer

How to delete a group variable while keeping the group structure of a netcdf in python or bash?

I have a .nc file with a group structure, one of the groups containing a variable I need to delete. Using xarray, if I want to delete the variable I can only extract its group as a new .nc file. ds = xr.load_dataset(path_test,group='/data_01/ku') ds…
benben
  • 1
0
votes
2 answers

MongoDB filter by retrieved value in group

I have this collection in MongoDB: [ { _id: "...", "project": 244, "scanner": "sonarqube", "version": 1 }, { _id: "...", "project": 244, "scanner": "sonarqube", "version": 2 }, { _id: "...", "project": 244, "scanner": "sonarqube", "version": 2…
0
votes
2 answers

MongoDB double $group aggregation by date and status

I have several documents that looks like this (minus many other irrelevant fields): [{ status: 'open', createdDate: 2021-06-17T09:02:58.325Z }, { status: 'declined', createdDate: 2021-07-25T09:09:15.851Z }, { status:…
0
votes
1 answer

Cumulative value with data grouping

I need some expertise help with a following query. So, I need to make a cumulative calculation per day based on the GMV amount. My biggest problem here is I can't remove the gmv from the GROUP BY or I get some error. Any ideas on how I can solve…
giujong
  • 11
  • 1
0
votes
1 answer

Why the primary group of Local Administrators appears as Domain Users {S-1-5-21--513}

I have a text file that the Local Administrator is the owner of the file. When I am running the following code: public static void CheckPermissions(string filePath) { FileSecurity acl = new FileInfo(filePath).GetAccessControl(); …
E235
  • 11,560
  • 24
  • 91
  • 141
0
votes
1 answer

Receiving wrong file's group when using GetAccessControl().GetGroup()

I created a text file and removed all the groups except SYSTEM group. When I am running the following code: public static void CheckPermissions(string filePath) { FileSecurity acl = new FileInfo(filePath).GetAccessControl(); …
E235
  • 11,560
  • 24
  • 91
  • 141
0
votes
1 answer

Facebook API group posting single image error (#120) Invalid album id when caption includes a question mark (?)

Facebook API group posting single image error (#120) Invalid album id when caption includes a question mark (?) (with user token) when uses page token error is "An unknown error has occurred."
Bilal Tariq
  • 639
  • 4
  • 7
0
votes
1 answer

How to calculate time taken by individual thread to execute the request in Jmeter?

if I am having 10 threads running to execute 5 http requests, and at the end of execution I want to know time take by each thread to execute those 5 http request , how can I do that ? can someone please help...