|
|
Hi all,
I did successful to calculate Average of a datatable's column by used:
aNewVal = dt.Compute("Sum(Total)", "EmpID = 5")
Do we have a similar command for calculate geomatric mean please? (In VB.net/C#)
Could you please show me a way to calculate calculate a geomean for a datatable column?
Thank you verymuch.
|
|
|
|
|
Member 9527531 wrote: I did successful to calculate Average of a datatable's column by used:
aNewVal = dt.Compute("Sum(Total)", "EmpID = 5")
You've calculated the sum of the values, not the average. To calculate the average (arithmetic mean), you'd need to use Avg(Total) instead.
Member 9527531 wrote: Do we have a similar command for calculate geomatric mean please? (In VB.net/C#)
There's nothing built-in - see the list of supported expressions on MSDN[^] - so you'll have to roll your own.
Using the arithmetic mean of logarithms[^] and a spot of LINQ, it's quite simple to calculate the geometric mean:
IEnumerable<double> values = dt.AsEnumerable().Where(r => r.Field<int>("EmpID") == 5).Select(r => r.Field<double>("Total"));
double geometricMean = Math.Exp(values.Select(Math.Log).Average());
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Could any one give me a similar LINQ code to calculate GEOMEAN for my code (in VB) please? (My code was for Average)
My code for calculating Average is
Dim MyVal as Double = mySourceTable.Compute("Avg(" & aSumColumn & ")", (aGroupByColumn & " = 'abc' AND " + amYearColumn & " = '2009'"))
Because I don't family with LINQ so I tried to modify the code to
Dim values As IEnumerable(of double) = dtGroup.AsEnumerable().Where(r => r.Field<int>(aGroupByColumn & " = 'abc' AND " + amYearColumn & " = '2009'")).Select(r => r.Field<double>("Total"))
Dim geometricMean = Math.Exp(values.Select(Math.Log).Average())
Absolutely, the modified code above can not be run.
I did not use LINQ before and I also did not use C#. Please give me the LINQ to calculate GEOMEAN in VB.
Help me please.
Many thank
SELECT exp(avg(log(Ind)))
FROM TabInd
Calculating geometric mean (GEOMEAN) with SQL.[^]
modified 5-Sep-16 3:51am.
|
|
|
|
|
I have a vb.net app (.net 4) which writes serial data (no more than 10 bytes, via System.IO.Ports.SerialPort) and there seems to be a delay in the send. An external device tells me to do something. It takes my program about 15ms to process this request and send the result back to the host. The host is timing me to see how long it takes. I can guarantee that I am sending the serial string within the 15ms, but the host doesn’t get it for 80ms and some times as much as 150ms! What external force is causing this delay? I was original using a USB to serial adapter but have since switched to a PCIe card and am getting the same results.
|
|
|
|
|
Please dont post the same question in multiple forums - you posted it in another forum - once is enough
|
|
|
|
|
Thanks for the suggestion, but it seemed pretty logical to post in both places. And, the fact that I got good information from both posts, furthers that logic.
|
|
|
|
|
A very rare occurrence, I assure you.
Most of the time, you get conflicting answers and the people on one post don't know about the other. It turns into a nightmare and pisses people off, especially the original poster.
|
|
|
|
|
Note taken. Thank you Dave.
|
|
|
|
|
Member 8153852 wrote: What external force is causing this delay?
None, it is caused by the design of Windows. See here[^].
You application is not the only one running, and you cannot guarantee your call will be within 80 or 150ms, as Windows is not a realtime-OS. That way other applications (like from some companies that like to preload their reader) cannot use up all resources.
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
I used the asp.net login control to create the user login screen:
<asp:login id="lgn" runat="server">
But, how do I make it functional so that valid logins work? Do I have to add JavaScript code or C# code conditions to make this functional?
|
|
|
|
|
Please use the ASP.NET forum for ASP.NET questions.
|
|
|
|
|
|
many developer criticize the asp.net. I don't know they hated due to brand name of Microsoft or performance asp.net?.
|
|
|
|
|
This is a debate question. It's not really suitable for a forum like this. You might want to try the Lounge instead.
|
|
|
|
|
Ask it under ASP.NET forums, they would say "ASP.NET is the best!". Ask it under PHP forums, they would say "ASP.NET is the worst!"
So it just doesn't make any sense at all as the choice is yours to make. You can surely Google for it and ask about the features and services provided by each of the framework. You will get the idea yourself.
The sh*t I complain about
It's like there ain't a cloud in the sky and it's raining out - Eminem
~! Firewall !~
|
|
|
|
|
How To Show Dll code in asp.net
|
|
|
|
|
That question does not mean anything.
|
|
|
|
|
Your question (such as it is) makes no sense. You haven't described the problem you're trying to solve with any usable detail what-so-ever.
The question, as asked, is unanswerable.
|
|
|
|
|
OP has been consigned to the Spam bin.
|
|
|
|
|
Yeah, I saw that after I posted.
|
|
|
|
|
you can view the code using net reflector or jetbrains resharper decompiler
|
|
|
|
|
Dear friends,
I wanted to create small tool which is used to replace some part of code in c# file from older application long back developed.
My customer is advised to use NReFactory library.
Already I have gone through that about NRefactory in code project. I'm bit confused because it has lot of features like code compilation and analysis etc.
Please guide me which NReFactory library do I need to use for my requirement. Is there any sample code specific to code replacement.
Example:
1. Reed old c# file
2. Replace old namespace, type and property to new one
3. Create a modified file in new system location.
Thanks in Advance 😊
Regards,
Ram
Ram
-- modified 28-Oct-15 23:25pm.
|
|
|
|
|
using ( StreamWriter sw = new StreamWriter( "Outfile.txt" ) ) {
sw.Write( new StreamReader( "Infile.txt" ).ReadToEnd().Replace( "OLD", "NEW" ) );
}
|
|
|
|
|
Instead of creating your small tool, I suggest you use Resharper, and do proper refactoring (Ctrl-R, O) - I've been using it for a while, and it's amazing!
Best,
John
-- LogWizard Meet the Log Viewer that makes monitoring log files a joy!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
