Search DaniWeb - groupby

How to add a new column to a hierarchical dataframe grouped by groupby 10 Years Ago by glez_b … grouped index=data.set_index(['Fecha','Hora'],inplace=True) grouped = index.groupby(level=0) for example data['u'] Fecha Hora 2011/07… LINQ GroupBy - VB.NET 6 Years Ago by KushMishra …-Each" loop here. What I want is a "GroupBy" clause which would get me a Dictionary (Of String… Re: LINQ GroupBy - VB.NET 6 Years Ago by ddanbe Don't know what `DAL.searchForComments` stands for, but what about this(have not tested it) var results = A().GroupBy( n => n.ID, n => n.Name, (key, g) => new { ID = key, Name = g.ToList() }); SQL Query with SUM and Groupby 5 Years Ago by PM312 …) from TblPurLedTranData whre TblPurLedtranData.ActCode='" & 1162828 & "' Groupby DocNo " ** PosDate DocDate DocNo DocAmount DueDate Status Period DocType… Re: LINQ GroupBy - VB.NET 6 Years Ago by xrjf Do you mean somewhat like this?: Imports System.Linq Public Class Properties Private Sub Properties_Load(sender As Object, e As EventArgs) Handles MyBase.Load Try Dim A1() As A = {New A(1, "name1", "address1"), New A(2, "name2",… Re: LINQ GroupBy - VB.NET 6 Years Ago by xrjf @ddanbe why don't express lambda expressions in VB.NET instead of c#? Re: LINQ GroupBy - VB.NET 6 Years Ago by xrjf Six thousand rows doesn't seem so much, unless having constant calls to the function. Imports System.Linq Public Class Properties Private Sub Properties_Load(sender As Object, e As EventArgs) Handles MyBase.Load Try Dim A1() As A = {New A(1, "name1", "address1", "… Re: LINQ GroupBy - VB.NET 6 Years Ago by ddanbe Oops xrj indeed I was wrong, neg rep me if you like, but I don't think (IMHO) that 'lambda' syntax in vb even looks like lambda syntax. But I guess KM499 will have his way with my suggestion. If not, so be it. :) Re: LINQ GroupBy - VB.NET 6 Years Ago by xrjf I'm not gonna give a neg. rep. point, not even discuss what does lambda syntax look like in any specific language. Just that if this is a vb.net thread it's not a c# or not even asp.net. Isn't it? Re: LINQ GroupBy - VB.NET 6 Years Ago by tinstaafl According to your description it looks to me that your collection will contain objects that may have more than one name associated with each specific id. If this is the case then something along these lines might be closer to what you're looking for: Dim dict = (From a In collectionA Group a.Name By key = a.ID… Re: LINQ GroupBy - VB.NET 6 Years Ago by KushMishra Hi **tinstaafl**, **ddanbe** and **xrj**, Thank you very much all for your suggestions. **xrj**, this didn't work for me because as **tinstaafl** said, I mentioned earlier that my collection contains more than one record for each ID, so the following would throw exception of having a pre-existing key. Dim q = (From p In A1 Select ID = … Re: SQL Query with SUM and Groupby 5 Years Ago by pty Excluding your aggregate columns you need to `group by` all you `select` by. That's just the way it works. Re: SQL Query with SUM and Groupby 5 Years Ago by Kim Rowden PM312, I noticed your question and it looks like you are asking for 2 things: 1. the sum of the 'DocAmount' - that's as explained by 'pty' in the other reply. 2. you want to display other info about the 'DocNo's that you are using in the GROUP BY. This is a very different request from the SUM(). If all the other columns will have the same … Re: SQL Query with SUM and Groupby 5 Years Ago by scamquist check your spelling. You used whre, not where Re: SQL Query with SUM and Groupby 5 Years Ago by SeanDevoy As mentioned, you are very close. The part it seems you don't understand is that for "aggregate functions" (like SUM, MAX, MIN and others) the rules for "SELECT" columns and "GROUP BY" columns are necesarilly quite strict. Every column in the "SELECT" fields must either be an aggregated column or be … Re: expand on pyTony code in thread Collect data from different lines in file in Python 12 Years Ago by TrustyTony Groupby needs sorted input, yours is not. Redirect pages with data 11 Years Ago by Maideen …($row = $stmt->fetch()): if($groupby!=$row['MVCode']): if($displaySubTotal): ?> …($row = $stmt->fetch()): if($groupby!=$row['MVCode']): if($displaySubTotal): ?>… Setting the Column of a td with the selectec item in the combobox 9 Years Ago by jean_5 …]>").html("City"); if (object.GroupBy == "Banks") $("body").children…]>").html("Banks"); if (object.GroupBy == "User") $("body").children…lt;select class="combobox" name="GroupBy"> <option value="Cities"… Re: Setting the Column of a td with the selectec item in the combobox 9 Years Ago by jean_5 …;Banks") $('.change:first').html('Banks'); if (object.GroupBy == "Users") $('.change:first').html('Users'); <select class=&…quot;combobox" name="GroupBy"> <option value="City">City… sending data to printer directly 11 Years Ago by Maideen …php include '../templete/print_head.php'; ?> <?php $groupby = ''; $displaySubTotal = FALSE; $subTotal = 0; $…row = $stmt->fetch()): if($groupby!=$row['MVName']): if($displaySubTotal): ?> … sql joins question 14 Years Ago by dumbncool … LEFT OUTER JOIN Employee E ON D.DeptId = E.DeptId GROUPBY D.DeptId; [/code] 2. To find all the department ids… LEFT OUTER JOIN Employee E ON D.DeptId = E.DeptId GROUPBY D.DeptId HAVING COUNT(*) = 0; [/code] Thanks for your time… Can someone please convert this C# code into python? Or tell me how to? 3 Years Ago by Yumensh … using (var txtStream = await customReactions.GroupBy(cr => cr.Trigger) .OrderBy(…} else { var ordered = customReactions .GroupBy(cr => cr.Trigger) .OrderBy… Kotlin - Lists of Lists 2 Years Ago by EmiLynn …<String, Mammal> { return this // .flatMap { it.friends.groupBy { it.name } } //.groupBy { it.name } // .associateBy{it.name + it.friends + sumOf { it… Re: expand on pyTony code in thread Collect data from different lines in file in Python 12 Years Ago by Cireyoretihw thanks still working on what OOP code others used [url]http://code.activestate.com/recipes/259173-groupby/[/url] helps but i will need to look harder to see what code i can replace groupby to produce the result that i think the original thread was trying to produce ... ... a new way of thinking is always a slow proccess Re : charts 16 Years Ago by msantosh18 can any one help me how to create charts by connecting to database. my need is that i have to group by a column in database and represent it in a chart in visual basic. the values after groupby may have 10 values. how can i do it in pie charts and bar charts. warning: mysql_num_rows - supplied argument is not a valid MySQL result resource 14 Years Ago by chienee …;</form>"; //paging end // echo $tablename.$whereclause.$choose; // $groupby = " group by ".$choose; $report = new display($dbf,"… trigger map hilite plugin from remote text link 13 Years Ago by filch …', strokeOpacity: 1, strokeWidth: 1, fade: true, alwaysOn: false, neverOn: false, groupBy: false } </script> <script> [/CODE] Anyone have… Vertical Histogram with Built-In Modules Only 13 Years Ago by joeywheels …) word_list.append(word_count) word_list.sort() for key, iter in itertools.groupby(word_list): word_seq.append((key, len(list(iter)))) histogram(word_seq)[/CODE… Re: Vertical Histogram with Built-In Modules Only 13 Years Ago by joeywheels …) word_list.append(word_count) word_list.sort() for key, iter in itertools.groupby(word_list): word_seq.append((key, len(list(iter)))) print("%s… Re: Vertical Histogram with Built-In Modules Only 13 Years Ago by joeywheels …) word_list.append(word_count) word_list.sort() for key, iter in itertools.groupby(word_list): word_seq.append((key, len(list(iter)))) print("%s…