R - aggregate data for 1 column by another column, based on statistices on a 3rd column -

R - aggregate data for 1 column by another column, based on statistices on a 3rd column -

Let me assume that I have an R data frame with 3 columns A , B

and C , where A values are not all separate.

How do I get all the values of A, the value of C for which B is minimum (for that value of A)? In some pseudo SQL code this happens: SELECT C WHERE B = MIN (B) GROUPBY A ?

I've looked at the total () function, I'm not sure it can complete it.

Total (B ~ A, Data = MyDataFrame, Minute) Only gives me the minimum score of B for each A, but then I do not know how to get related C value for.

In order to achieve the values, this is to minimize the data frame with the result of this aggregation, and / or it can only be done in gross () ?

Input:

ABC 1 0 1 1 2 2 1 1 3 1 1 4 2 1 1 2 2 2 3 3 3 3 4

Output:
1
1a The value of the value is A = 1

3 for C (0) A value of C is equal to 2

data.table package:

Library (data-worthy) DT from the Lt; - as.data.table (mydataframe) dt [, c [which.min (b)], by = "a"] # a v1 # 1: 1 1 # 2: 2 3

or dplyr :

library (dplyr) mydataframe%.% Group_by (a)%.% Summarize (res = c [that.min (b) ]) # A res # 1 2 3 # 2 1 1

or by the original function by :

(mydataframe, Mydataframe $ a, function (x) x $ c [that.min (x) $ b)]) #mydataframe $ a: 1 # [1] 1 # --------------- ------------------ -------------------------------- -------------- # mydataframe $ A: 2 # [1] 3

Comments

Post a Comment

Popular Posts

Xml parsing with python -

I am using xml with Python xmltodict . But I'm getting the following error, xml.parsers.expat.ExpatError: mismatched tag: line 2890, column2 this is my code, import xmltodict import urllib2 url = "url here" data = xmltodict.parse (urllib2.urlopen (url) .read () print data I have tried to use the Entry here, with the at print, the print code 'urlib2 import lxml.etree', Url = "Url here" xmldata = urllib2.urlopen (url) .read () root = ET.frost string (xmldata) print 'full' print route This also helps me Error, lxml.etree.XMLSyntaxError: Opening and closing tag mismatch: Client ID line 54 and type, line 55, column 14 I know that there is a problem in XML My question is, what is the way to read all the nodes except that it is xml ?

c# - WPF UserControl.Loaded event does not trigger -

my program when I (mouseenter event) a TransportOrderLineDetailView to hover over a certain UserControl (Here I use TransportOrderLineUserControl) Should be shown. The TransportOrderLineDetailView should be placed at the bottom right of my screen. For this I want to see the actual Wide & amp; The actual highlight for the actual placement is because those 2 properties require a different value than 0, because I execute this code with the DetailView.Loaded event. I use the exact same type for two other items I do not work for TransportOrderLineDetailView Code where the scene is generated:. TransportOrderLineDetailView tolDetailView = new TransportOrderLineDetailView (New TransportOrderLineDetailViewModel (transportOrderLine)); Window.DetailContent = tolView; TolView.Loaded + = SetDetailViewOnUI; code-behind view: public TransportOrderLineDetailView (TransportOrderLineDetailViewModel detailViewModel) {InitializeComponent (); Datacontex = descriptionviewmodel; } M...

ios - Pixel position of UIImageView in coordinate system -

I am stuck in an interesting situation where I have 1.4, 1.4 x for reset, y is a pixel dot Start by putting imageview .. and why .. any document link? Please any light please. Thank you. View = [[UIView alloc] initWithFrame: CGRectMake (10, 50, 20, 20)]; View.backgroundColor = [UIColor greenColor]; [Self.view addSubview: view]; Scene 2 = [[UIView alloc] initWithFrame: CGRectMake (10.4, 70, 20, 20)]; View2.backgroundColor = [UIColor redColor]; [Self.view addSubview: view2]; Scene 3 = [[UIView alloc] initWithFrame: CGRectMake (11, 90, 20, 20)]; View3.backgroundColor = [UIColor blue color]; [Self.view addSubview: view3]; The first is a visual reference, I know that its original x is at 20px. Be careful here, due to retina @ 2x resolution 10 points x = 20 px, and 11 points x = 22 px. You speak in the code in the code, and give a pixel result on the screen. I tried to change the X coordinate gradually here I found: 9.75 & lt; X & lt; = 10.25: Red square star...

Powered by Blogger