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 …

blue meadia
- 13
- 2
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…

KeeperOfTheSevenKeys
- 69
- 1
- 10
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:…

Dor Tabakuli
- 3
- 1
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...

shriyan walke
- 3
- 1