How to get all the values of datatable which is 10% than a defined value when reading by data from csv?

Question

0.00/5 (No votes)

See more:

I am reading a .csv file and getting and calculating avg
now i want print value's which are 10% above the avg value.
I am converting my data into Datatable.

What I have tried:

Static void Main(string[] args)
        {
  string csv_file_path = @"C:\Sample files\LP.csv";
            DataTable csvData = GetDataTabletFromCSVFile(csv_file_path);  
 object  med= p.GetMedianFromDataTable(csvData, "Value");
            Console.ReadLine();
}

Posted 25-Mar-18 1:02am

Akhil Jain

Updated 25-Mar-18 6:42am

v5

Add a Solution

Comments

Patrice T 25-Mar-18 7:15am

What is the problem?

Akhil Jain 25-Mar-18 7:27am

how to print all the values which are 10% less or above than the medians

Patrice T 25-Mar-18 7:41am

What is exactly your problem (in this code) ?
Use Improve question to update your question.

Akhil Jain 25-Mar-18 7:48am

i don't know how to get all the values which are 10% above or 10% less than median

RickZeeland 25-Mar-18 8:31am

You asked this question before and got an answer, please revisit your previous question !

Akhil Jain 25-Mar-18 8:35am

no it's diffrent

RickZeeland 25-Mar-18 8:41am

Did you even look at the link to the CodeProject article which has a Median function ?

Richard MacCutchan 25-Mar-18 8:46am

No, it's exactly the same as How to read multiple CSV file in a folder in C# console application.?[^], apart from this one wants 10% as opposed to 15%.

Akhil Jain 25-Mar-18 7:56am

code is fine till now now i need to find all the values which are 10% greater or 10 % less than the median which i don't know(Datatable column="VALUE") which need to be compare.pls help

Patrice T 25-Mar-18 8:00am

Use Improve question to update your question.
So that everyone can pay attention to this information.

Richard MacCutchan 25-Mar-18 8:38am

Calculate the median value, and from that get 10% of it. Then go through each entry in your list/table/database/whatever, and get the difference between its value and the median. If the difference is equal to the 10% value, then print the item.

Akhil Jain 25-Mar-18 8:40am

i have calculate the 10% how to go through datatable pls help

Richard MacCutchan 25-Mar-18 8:44am

What do you mean how? You iterate through the rows checking the relevant cell in each row.

Akhil Jain 25-Mar-18 8:46am

i don't know how to do that !! new Coder

Richard MacCutchan 25-Mar-18 8:48am

Go to DataTable Class (System.Data)[^] and study the documentation. The chances are you can get a version in your own language.

Akhil Jain 25-Mar-18 9:39am

ok i have done it !!

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2018-03-25T06:43:00

Average is average and median is median. Do not mix that!

There's only one case when average is equal to median and vice versa: for 2-element array when both values are the same, for example: {10,10}.

Check this:

C#

void Main()
{
	int[] ages = {100,22,13,43,25,61,17,80, 29}; 
	double median = Median(ages);
	
	double greaterThanMedian = median+median*.15;
	double lessThanMedian =  median-median*.15;
	
	var result = ages.Where(x=> x>lessThanMedian && x<greaterThanMedian)
		.ToList();
	
	foreach(var x in result)
		Console.WriteLine("{0}", x);	
}


public static double Median(int[] arr)
{
	if (arr==null) throw new Exception("An array cannot be null!");
	
	bool isEvenNumberOfValues = arr.Length % 2 == 0;
	int toSkip = isEvenNumberOfValues ? (arr.Length/2)-1 : arr.Length/2;
	int toTake = isEvenNumberOfValues ? 2 : 1;
	
	return arr.OrderBy(x=>x).Skip(toSkip).Take(toTake).Average();
}

According to your code:

	var result = csvData.AsEnumerable()
		.Where(x=> x.Field<int>("Value")>=lessThanMedian && x.Field<int>("Value")<=greaterThanMedian)
		.ToList();
//or

	var result1 = csvData.Select(string.Format("(Value >= {0} AND Value <= {1})",lessThanMedian, greaterThanMedian))
		.ToList();

Good luck!