FAQ Database Discussion Community


Grouping an array of objects by key

javascript,arrays,object,grouping
I have this array of objects, and I want them to group by their specific key, in this case tags var items = [ {id: 0, tags: ["a"], name: "foo"}, {id: 1, tags: [], name: "bar"}, {id: 2, tags: ["a"], name: "bazz"}, {id: 3, tags: ["b"], name: "wah"}, {id: 4,...

Need help using lodash to reform an array with new structure

javascript,arrays,grouping,lodash
I have this sample data that is returned from an API that I am trying to reform into an array with a sub-array of grouped objects. The raw data from the API looks like this: [ { "InsightId": 314, "Classification": "Advantage", "AttributeId": 14958, "InsightAttribute": "Implementation speed", "AttributeType": "Product Criterion" },...

Can SSRS create new columns instead of adding another row?

dynamic,ssrs-2008,grouping,ssrs-tablix
My report shows event level information but when the event has multiple records assigned, it creates additional rows in the report when I'd like for it to add additional columns instead. From my screenshot, you can see Drive ID 675276 (Autoo Owners Insurance) and Drive ID 681980 (Liberty Co. HS)...

java 8 stream groupingBy sum of composite variable

java,sorting,java-8,grouping,java-stream
I have a class Something which contains a instance variable Anything. class Anything { private final int id; private final int noThings; public Anything(int id, int noThings) { this.id = id; this.noThings = noThings; } } class Something { private final int parentId; private final List<Anything> anythings; private int getParentId()...

Grouping 0s and 1s in python

python,list,grouping
I have an array of zeros and ones like [0,0,0,1,1,1,0,0,0,1,1]. How to write a program to save neighboring 0's and 1's in different arrays. E.g. [0,0,0,1,1,1,0,0,0,1,1] giving [0,0,0],[1,1,1],[0,0,0],[1,1]....

Grouping the dataframe based on one variable

r,variables,grouping
I have a dataframe with 10 variables all of them numeric, and one of the variable name is age, I want to group the observation based on age.example. age 17 to 18 one group, 19-22 another group and then each row should be attached to each group. And resulting should...

SilverStripe 3: How to group a sorted array by grandparent pages

php,sorting,grouping,silverstripe
I'm trying to loop through all my ProductPages while grouping them by their grandparent's title (as this is the product category). I would also like to sort the product pages under each group by their ProductReleaseDate descending. Finally if possible, any that do not have a ProductReleaseDate to be listed...

LINQ nested groups performance

c#,performance,linq,entity-framework,grouping
i have a full outer join query pulling data from an sql compact database (i use EF6 for mapping): var query = from entry in left.Union(right).AsEnumerable() select new { ... } into e group e by e.Date.Year into year select new { Year = year.Key, Quartals = from x in...

If there are slots consisting of n numbers, which will x fit into?

python,numbers,grouping
This is a little bit hard to phrase... Basically, my question is as follows. If all the numbers up to z are divided into groups of n, which will x fit into. For example: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |_______|...

Groups of nodes with the same attributes in GraphViz file

grouping,graphviz,dot
In the dot language of GraphViz I want to describe a 2-mode network. So I have nodes of two different types. One group for example could contains people how read and the other group could contain the books being read by the people. I want to give the nodes in...

Grouping equal values from an array into subarrays

arrays,python-2.7,grouping
I have created an array that contains all of the values from one column of an excel spreadsheet. There are many values from that column that are equivalent. I need to group all the values that are equal into individual arrays within the first array. file_location = "C:\Users\Practice.xlsx" workbook =...

Linq GroupBy behaves differently for classes and values

c#,linq,grouping
Please consider the following code segment: var list = new string[] { "ab", "ab", "cd", "cd", "cd" }; var groups = list.GroupBy(l => l); var count = groups.Count(); The results: count: 2, groups: [{ Key: "ab", elements: ["ab", "ab"] }, { Key: "cd", elements: ["cd", "cd", "cd"] }] When I...

How to wrap all elements that are next to each other and have the same class?

jquery,grouping,wrap
I would like to know how to wrap all elements that are next to each other and have the same class. wrapAll() didn't work since it pushes the paragraph to the bottom. source <div class="container"> <div class="group"></div> <div class="group"></div> <div class="group"></div> <p>Lorem ipsum dolor sit amet</p> <div class="group"></div> <div class="group"></div>...

grouping, comparing, and counting rows in r

r,grouping,counting
I have a data frame that looks as the following: system Id initial final 665 9 16001 6070 6071 683 10 16001 6100 6101 696 11 16001 6101 6113 712 10 16971 6150 6151 715 11 16971 6151 6163 4966 7 4118 10238 10242 5031 9 4118 10260 10278 5088...

Collectors groupingBy java 8

java,java-8,grouping,collectors
Consider these two classes Subject class: class Subject{ long id; String category; String description; public Subject(long id,String category,String description){ this.id=id; this.category=category; this.description=description; } // getters, setters, toString,... } Observer class: class Observer{ long id; Subject subject; public Observer(long id,Subject subject){ this.id=id; this.subject=subject; } // getters, setters, toString,... } And consider...

Sorting and Grouping of Korean Character (Not familiar with Korean language)

java,sorting,localization,grouping
I'm trying to sort and group Korean character in Java. Currently i'm about to sort by using final Collator collator = Collator.getInstance(Locale.KOREA); Collections.sort(words, collator); However, i have difficulty grouping them into their vowel group (ㄱㄴㄷㄹㅁㅂㅅㅇㅈㅊㅋㅌㅍㅎ)...

SQL Conditional sum and grouping

sql,grouping,sybase,conditional-statements
I have a query that's trying to sum up a patient's length of stay at a hospital. Here is an example of the data | Patient | Admission_ID | Admission_Event_ID | Admission_Event_Type | Start Date | End Date | Duration | Linked_Admission | | P0001 | ADM0001 | AE1 |...

XSL: Group parent attributes using matching child attribute

xml,excel,xslt,grouping
Hey guys I'm trying to use transform an XML document to output a table directly into excel. The problem I'm having is I need to group elements by a child node. My current XSLT is this: <?xml version="1.0" encoding="UTF-8"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:template match="ScanData"> <html> <body> <xsl:for-each select="Report/ReportHost"> <xsl:if test="ReportItem/@severity...

Grouping list of tuples in python

python,list,grouping,itertools
I have a list that consist of tuples and I already sorted this list based on 2nd item. Then I want to make my list grouped based on the 2nd item, and put 1st item into list. This is my input: [('aaa', 1), ('bbb', 1), ('ccc', 2), ('ddd', 2), ('eee',...

Create a view with sum total across two tables grouped by date (SQL Server 2008)

sql-server,views,grouping
I currently have a view like this: CREATE VIEW dbo.audit WITH schemabinding AS SELECT CONVERT(date, DateAdded) AS dt, COUNT_BIG(*) AS cnt FROM dbo.Table1 GROUP BY CONVERT(date, DateAdded) Which returns: dt cnt ----------------- 3/13/2015 5000 3/12/2015 1324 I'm trying to get a sum total count from both tables grouped by date...

R Creating list of divided vector by index

r,vector,grouping
With a code like this example: set.seed(11) x <- sample(letters) x [1] "h" "a" "m" "y" "b" "u" "v" "f" "p" "c" "q" "g" "x" "l" "i" "o" "e" "r" "t" "d" "z" "k" "s" "j" "w" "n" And provided with this vector of values y <- c(4, 13, 20)...

Microsoft Reporting Services Grouping equal rows

sql-server,reporting-services,grouping
So I have 8 columns at all. 5 of them (Company WorkShift Workshop Employee City) are information about company, workshift, workshop, employee and city, other 3 are results of 2 tests and item for which these test was made (named as: Item Test2 Test3). Report's structure for now is something...

Java 8 is not maintaining the order while grouping

java-8,grouping,java-stream,collect
I m using Java 8 for grouping by data. But results obtained are not in order formed. Map<GroupingKey, List<Object>> groupedResult = null; if (!CollectionUtils.isEmpty(groupByColumns)) { Map<String, Object> mapArr[] = new LinkedHashMap[mapList.size()]; if (!CollectionUtils.isEmpty(mapList)) { int count = 0; for (LinkedHashMap<String, Object> map : mapList) { mapArr[count++] = map; } }...

Spark Cassandra Connector keyBy and shuffling

cassandra,apache-spark,grouping,shuffle,connector
I am trying to optimize my spark job by avoiding shuffling as much as possible. I am using cassandraTable to create the RDD. The column family's column names are dynamic, thus it is defined as follows: CREATE TABLE "Profile" ( key text, column1 text, value blob, PRIMARY KEY (key, column1)...

SSRS Row Gropings Inverted (Export to Excel)

sql,excel,reporting-services,grouping,ssrs-grouping
When i run my report my report in SSRS all groupings work correctly however when i export this report to excel the proper rows are grouped but the grouping is inverted (i.e. the last item in the grouping has the '+' sign instead of the parent, top row) thanks for...

Is there an equivalent of SQL GROUP BY ROLLUP in Python pandas? [duplicate]

python,sql,pandas,group-by,grouping
This question already has an answer here: Pandas Pivot tables row subtotals 2 answers Here is how it works in Oracle. I'm looking for a neat equivalent in pandas, preferably integrated with the rendering of the DataFrame to python notebook. The gist of GROUP BY ROLLUP is that if...

Looping through array and grouping data based on a criteria in perl [closed]

arrays,perl,loops,conditional,grouping
I have an array as mentioned below with four columns. Each column represents start, end position, DNA strand, and genes respectively. I want to categorize each rows into number of groups as mentioned below. Criteria: When the difference between end position of one row and start position of next rows...

Adding values in MySQL rows

mysql,logging,grouping,algebra
I have a table where I store parsed server logs: mysql> SELECT id,date,message_type FROM log_entry LIMIT 10 ; +----+---------------------+--------------+ | id | date | message_type | +----+---------------------+--------------+ | 1 | 2015-01-08 18:13:15 | 2 | | 2 | 2015-01-08 18:13:14 | 1 | | 3 | 2015-01-08 18:13:12 | 1...

Running Total by Grouped Records

sql-server-2008,tsql,sum,grouping,running-total
I have a tickets database table as +------------+-------------+------------+ | CategoryID | RequestDate | FixedDate | +------------+-------------+------------+ | 1 | 2014-01-01 | NULL | | 1 | 2014-01-02 | 2014-01-05 | | 1 | 2014-01-28 | 2014-01-30 | | 2 | 2014-02-20 | NULL | | 2 | 2014-03-15 | NULL...

Grouping with wildcard search in XSLT 1.0

xslt,grouping,muenchian-grouping
I want to do a sipmle 'Muenchian grouping' in xslt 1.0 but also with an added wildcard search from a different node. I'm familar with the grouping method and it's awlays worked well but am having trouble with the wildcard issue in that it always shows the group headings that...

Grouping over multiple fields in MongoDb

mongodb,mapreduce,grouping,aggregation
How would I go about grouping over multiple fields? I need to get a unique count for case insensitive true over multiple independent documents. I've looked at both map/reduce and aggregation and I don't quite know what would be the best approach. Lets say I have the following data in...

Group data into small chunk (big data issue)

r,grouping,bigdata
I was looking for an answer to group data into small chunks in R. Let's say I have df = data.frame(a = c(1, 2, 3, 1, 5), b = c(2, 3, 2, 4, 4)) I want to have a new column to specify the group id. Rows having same value...

Custom grouping in xsl

algorithm,xslt,grouping
Hi I have a problem requiring a rather specialized sort of grouping and would like some feedback on the best approach. Here is some xml: <root> <locations> <location> <address>123 4 st Smallville</address> <number>1</number> </location> <location> <address>432 1 st Metropolis</address> <number>2</number> </location> </locations> <insuranceCoverages> <coverage> <name>General Coverage</name> <locationSplits> <coverage>...

group standard buttons together in C#

c#,button,grouping
I was wondering if there is a way to group standard windows form buttons together, such as the way radio buttons can be, where only one can be selected at a time. I have four option buttons on my form, but only want one button to be able to be...

SQL Server 2008 Flatten Rows

sql-server,grouping
I need to flatten a record set that originally has 4 rows per user to be 1 row. I started using the PIVOT functionality but there are 2 fields that need to be flatten (and the pivot wasn't working as expected ). The current data structure: ContactEmail Scenario TRE Updated_On...

SSRS 2008 add columns dynamically per id in a table.

sql-server-2008,dynamic,reporting-services,ssrs-2008,grouping
Here is an example of my dataset: ID Name Date DCMTest1 Planning 02-06-12 DCMTest1 Planning 01-09-13 DCMTest1 Planning 06-09-13 DCMTest2 Planning 03-08-11 DCMTest2 Planning 05-07-12 The result table has to add columns dynamically (the amount of columns is unknown). Here is an example of how I want the data in...

pandas groupby access last group

python,pandas,grouping,dataframes
I have a pandas DataFrame looking like this: date info A x A y B z B x C y I only want to know the last date. In this case it is C. I thought that I can get this by grouping and sorting by the Date column: df.groupby('date',...

Combining Rows in MS Access SQL Query

sql,ms-access,grouping
Below I have a screenshot of a query in MS Access. I am trying to combine the two "Kim Wong" rows into one row that has one time range in the Monday column and the other time range in the Tuesday column. There will when done have time ranges in...

scala list LineSegment

list,scala,grouping
I have a polygon consisting of a group of points, I want to find the list of line segments for that polygon by combining the list of corresponding points and then combining the last point with the first one eg : List of Points - (p1,p2,p3,p4,p5,p6) List of lineSegments -...

Partition data into two separate groups s.t. residual sum of squares with one continuous predictor is minimized

r,algorithm,statistics,grouping,partitioning
What's the basic algorithm to partition a set of data into two groups s.t. the sum of the two separate residual sum of squares is minimized? For example, consider the code below. Basically, how do you compute the value stored in best.cutpoint$RSS without iteratively testing each possible value? set.seed(1) ind.var...

Convert XSL 2.0 count by current-group logic into XSL 1.0 logic

xml,xslt,grouping
I'm a novice with XSL and am trying to summarize some XML data based on grouping of substrings of data. I've been trying to get my head around Muenchian grouping and counting but have not been able to get it to work. I took a look at the XSL 2.0...

Mysql return only items that have n number of property matches

php,mysql,select,grouping
I have a database of items and each item has various number of properties. Is it possible for MySql only to return items that have a certain number of matches (not properties) when a search is run? Example: I am searching for any item with a wheel that is red...

Find social network components in Stata

grouping,social-networking,stata
[I copied part of the below example from a separate post and changed it to suit my specific needs] pos_1 pos_2 2 4 2 5 1 2 3 9 4 2 9 3 The above is read as person_2 is connected to person_4,...,person_4 is connected to person_2, and person_9 is...

Doxygen group warning: end of file inside a group

c,module,grouping,doxygen
I am attempting to use a doxygen(v1.8.9.1) @defgroup comment in a C header file that finishes with an @{ as follows: /** @file foo.h * @brief This is a foo file */ #ifndef FOO_H_ #define FOO_H_ #include somebar.h /** @defgroup foo Foo * @details This foo file does foo stuff...

mysql Quiz leaderboard filter by points, time taken

mysql,sql,select,sql-order-by,grouping
I have a quiz report table which shows a report for every quiz a user takes. I need to create a leaderboard from this, which shows the top users best score, filtering by points and then time taken. here is a link to a sql fiddle http://sqlfiddle.com/#!2/65fbf0/1 I am really...

Financial Data - R data.table - group by condiction

r,data.table,grouping,self-join
Given the following data.table with financial data: userId systemBankId accountId valueDate quantity description 871 0065 6422 2013-02-28 -52400 AMORTIZACION PRESTAMO 871 0065 6422 2013-03-28 -52400 AMORTIZACION PRESTAMO 871 0065 6422 2013-04-01 -3000000 AMORTIZACION PRESTAMO 871 0065 6422 2013-04-30 -52349 AMORTIZACION PRESTAMO 871 0065 6422 2013-05-31 -52349 AMORTIZACION PRESTAMO 871 0065...

Using Table to Group: invalid 'type' (character) of argument

r,grouping
I recently asked a question about how to take the contents of a column and use them as column headers in a new data-frame with a Boolean expression of 1 or 0. if it contained the value in R An example would be Id. Event A. Wc B. Df C....

Grouping with descending order and then sorting with descending order

angularjs,sorting,underscore.js,grouping
How to group data by year and descending order (newer to older) and then inside each group sort items again by descending order? I'm using angular and underscore. fiddle link: http://jsfiddle.net/xgxfqrgv/1/ output now is: 2014 Cranberry 2015 Banana Apple but it should be: 2015 Apple Banana 2014 Cranberry html source:...

java8 stream grouping aggregate

sum,java-8,grouping,java-stream
Given a java class Something class Something { String parent; String parentName; String child; Date at; int noThings; Something(String parent, String parentName, String child, Date at, int noThings) { this.parent = parent; this.parentName = parentName; this.child = child; this.at = at; this.noThings = noThings; } String getParent() { return parent;...

Group by JSON array using jQuery

javascript,jquery,arrays,grouping
I have a set of JSON array and I want the result to be grouped by the "Id" column. I will not use underscore.js for this, as this can't be used in our project. The only option is to do it with jQuery. My source array and expected results are...

BaseX XQuery error: root(): no context value bound

xpath,xquery,grouping,basex
I am trying to run the following XQuery expression in BaseX to extract elements between two succeeding headings. (as an article section). xquery for $x in doc("test.xq")//h2, $y in $x/following-sibling::h2[1] return //*[$x/following::* and $y/preceding::*] But it gives the error Error: Stopped at D:/Program Files/BaseX/data/test.xq, 1/74: [XPDY0002] root(): no context value...

Group list by month

c#,linq,dictionary,group-by,grouping
I have list with datetime objects. I would like to group by month and add it to the dictionary. So after grouping process I want to have list per month and year. For example: Before grouping [mix below elements] After grouping: 1) January 2015 - 5 elements 2) February 2015...

java8 stream grouping and sorting on aggregate sum

java-8,grouping,aggregate,java-stream
Given a java class Something class Something { private int parentKey; private String parentName; private int childKey; private int noThings; public Something(int parentKey, String parentName, int childKey, int noThings) { this.parentKey = parentKey; this.parentName = parentName; this.childKey = childKey; this.noThings = noThings; } public int getParentKey() { return this.parentKey; }...

Using LINQ To Interleave Two Lists

c#,linq,grouping
So here is what I'm attempting to do: symbolList: 1,1,1,2,2,2 valueList: a1,b1,c1,a2,b2,c2 result: 1|a1|b1|c1,2|a2|b2|c2 The a,b,c for each symbol are all different values For each symbol there will be the same amount of corresponding values. So for symbol 1, there are three values that I would like joined with it....

How to get mongoDB aggregated month wise data using java [closed]

java,mongodb,grouping,aggregation
Here is my data in db. "Accounts" : [ { "Total_Credits" : 4000, "Total_Debits" : 0, "Date" : "25-05-2015" }, { "Total_Credits" : 1000, "Total_Debits" : 0, "Date" : "26-05-2015" }, { "Total_Credits" : 1000, "Total_Debits" : 0, "Date" : "10-07-2015" }] I want to extract sum of total credits...

Jquery datatable group by two columns with expand and collapse

jquery,datatable,grouping
references: Two level grouping One level grouping with expand and collapse I want the datatable as in #1, but with the feature of #2 for both the levels, that is both levels can be expanded and collapsed. fiddle reference: jsfiddle.net/RgKPZ/488/ If there is any other similar plugin other than jquery...

Cell of grouped elements

matlab,cell,grouping
I have a linked list S with S(i)=s_i and S(i) is a non-negative integer number. I want a cell C=C{0+1},...C{max(S)+1} such that C{i+1}={i_1,...,i_k}, S(i_1)=...=S(i_k)=i and k is maximal. Example: S(1)=0,S(2)=0,S(3)=1,S(4)=2,S(5)=1,S(6)=2,S(7)=6, Then I should get C{0+1}={1,2}, C{1+1}={3,5}, C{2+1}={4,6}, C{3+1}={},...C{6+1}={7}, C{7+1}={} How can I do that as fast as possible in matlab...

Grouping by object value, counting and then setting group key by maximum object attribute

java,java-8,grouping,java-stream
I have managed to write a solution using Java 8 Streams API that first groups a list of object Route by its value and then counts the number of objects in each group. It returns a mapping Route -> Long. Here is the code: Map<Route, Long> routesCounted = routes.stream() .collect(Collectors.groupingBy(gr...

How to aggregate data with the dyplr package in R

r,data.frame,grouping,dplyr
I would like to understand how to write the following code using the dplyr package: averageStepsDayType <- aggregate( NAreplacement$steps, by=list(interval=NAreplacement$interval, dayType=NAreplacement$dayType), mean ) This is the original data frame: > head(NAreplacement) steps date interval dayType 1 1.7169811 2012-10-01 0 weekday 2 0.3396226 2012-10-01 5 weekday 3 0.1320755 2012-10-01 10 weekday...

SQL Server Create Grouping For Related Records

sql,sql-server-2012,grouping
I'm running into an interesting scenario trying to assign an arbitrary FamilyId to fields that are related to each other. Here is the structure that we're currently working with: DataId OriginalDataId 3 1 4 1 5 1 6 1 3 2 4 2 5 2 6 2 7 10 8...

Group every n-th element of array

ruby,arrays,group-by,group,grouping
I have an array: array = [1, 2, 3, 4, 5, 6, 7, 8, 9] How do I group every n-elements of array? For example, for 3: [[1, 4, 7], [2, 5, 8], [3, 6, 9]] I wrote this code, but it's ugly: array.each_with_index.group_by { |e, i| i % 3}.map...

grouping data in mongo using json data stored

mongodb,grouping,aggregate-functions,aggregation-framework
This is the data I have in my mongo db: { "_id": ObjectId("556d1c7716efd4a035d8e473"), "products": [ { "gtin": 77770000222313, "gpc": 10000068 }, { "gtin": 77770000222312, "gpc": 10000068 } ] } How do I aggregate this so that I get gpc value and then an array under that of the gtins? Something...

R grouping function to select last value in the row

r,grouping
Give a data set like this date X 2012-10-02 2210 2012-10-02 2215 2012-10-03 410 2012-10-03 430 2012-10-03 535 2012-10-03 550 2012-10-04 555 2012-10-04 600 2012-10-04 605 2012-10-04 610 How do I aggregate/Group on date and select only the last value on X in R language. date X 2012-10-02 2215 2012-10-03...

joining to tables in a query for ASP.NET C# ~ multi-part-identifier-could-not-be-bound

c#,sql,asp.net,grouping
Among other answers I have looked at the following: The multi-part identifier could not be bound However tying to use that answer I was still not able to make my grouping work. The following query works: string query = @"SELECT ud.FirstName, ud.LastName, p.Name AS Product, p.ItemNumber, sc.AmountPurchased * sc.Price AS...

How do i count unique dates in crystal report?

c#,crystal-reports,report,grouping
i have a crystal report of sales and its grouped by sale date. this add a grouped by header on report. Is it possible to count how many of this headers are on the report? the reason is i need to count unique number of sale dates! thanks...

MySql - Sort persons by name and partner

php,mysql,sorting,order,grouping
I'm dealing with the following problem in a MySQL/PHP web application: A table of persons looking having the columns: ID, firstname, surname, idOfPartner, street, zipCode should be ordered by the surname of the person which should be then followed by the partner of the person so the result would look...

Grouping Data first by frequency, then by category in python

python,csv,pandas,data,grouping
I have a large csv file, which is a log of caller data. An example of my file: CompanyName High Priority QualityIssue Customer1 Yes User Customer1 Yes User Customer2 No User Customer3 No Equipment Customer1 No Neither Customer3 No User Customer3 Yes User Customer3 Yes Equipment Customer4 No User My...

SQL Server Multiple Groupings

sql,sql-server,grouping,window-functions
I am stumped by what seems like a simple problem. We have the following Table. ID--- ---Income--- ---Years Offset--- ---Income By Offset--- 1 1000 1 NULL 2 500 1 NULL 3 400 1 NULL 4 0 1 NULL 5 2000 2 NULL 6 0 2 NULL 7 400 2 NULL...

java 8 stream group by and summing double

dictionary,java-8,grouping,java-stream,collectors
I am very new to streams in java 8 so my approach could be wrong. I have 2 objects as follows object1{ BigDecimal amount; Code1 code1; Code2 code2; Code3 code3; String desc; } object2{ BigDecimal amount; Code1 code1; Code2 code2; Code3 code3; } So I want to collect all object1...

Add totals to the groups

crystal-reports,sum,grouping
I am recently new working with Crystal Report and I am a bit confused how I can implement my sum on the groups. I group my tasks with taskID: 20422 416.46 Project01 20422 788.73 Project03 20422 361.85 Project04 20422 4,414.37 Project01 20423 806.26 Project08 20423 6787.67 Project09 How can I...

Joining groups in a List using LINQ

c#,linq,grouping
I have a List<Person> where Person contains several data including a GroupID and a PersonID. This list can contain several thousand records of semi-sensitive data (Not very sensitive, but I still need to make the recipient of the list not be able to identify single individuals). I need to take...