python 3.x - Pandas Label Duplicates -


given following data frame:

import pandas pd d=pd.dataframe({'label':[1,2,2,2,3,4,4],                'values':[3,5,7,2,5,8,3]}) d     label   values 0     1       3 1     2       5 2     2       7 3     2       2 4     3       5 5     4       8 6     4       3

i know how count unique values this:

d['dup']=d.groupby('label')['label'].transform('count')

which results in:

    label   values  dup 0     1     3       1 1     2     5       3 2     2     7       3 3     2     2       3 4     3     5       1 5     4     8       2 6     4     3       2

but column have following values: 1 if there 1 unique row per label column, 2 if there duplicates , row in question first of such, , 0 if row duplicate of original. this:

    label   values  dup  status 0     1     3       1     1 1     2     5       3     2 2     2     7       3     0 3     2     2       3     0 4     3     5       1     1 5     4     8       2     2 6     4     3       2     0

thanks in advance!

i think can use loc condition created function duplicated:

d['status'] = 2 d.loc[d.dup == 1, 'status'] = 1 d.loc[d.label.duplicated(), 'status'] = 0  print (d)     label  values  dup  status 0      1       3    1       1 1      2       5    3       2 2      2       7    3       0 3      2       2    3       0 4      3       5    1       1 5      4       8    2       2 6      4       3    2       0

or double numpy.where:

d['status1'] = np.where(d.dup == 1, 1,                np.where(d.label.duplicated(), 0, 2))  print (d)      label  values  dup  status  status1 0      1       3    1       1        1 1      2       5    3       2        2 2      2       7    3       0        0 3      2       2    3       0        0 4      3       5    1       1        1 5      4       8    2       2        2 6      4       3    2       0        0

-

Comments

Post a Comment

Popular posts from this blog

angular - Is it possible to get native element for formControl? -

i've got angular2 reactive form . created formcontrol s , assigned input fields by [formcontrol]=... . understand creates nativeelement <-> formcontrol link. my question: possible nativeelement formcontrol ? wanna myformcontrol.nativeelement.focus() i can share 1 terrible solution works me. in reactive forms can use either 1) formcontroldirective ts mycontrol = new formcontrol('') template <input type="text" [formcontrol]="mycontrol"> or 2) formcontrolname ts myform: formgroup; constructor(private fb: formbuilder) {} ngoninit() { this.myform = this.fb.group({ foo: '' }); } template <form [formgroup]="myform"> <input type="text" formcontrolname="foo"> </form> so these directives write patch like 1) formcontroldirective const originformcontrolngonchanges = formcontroldirective.prototype.ngonchanges; formcontroldirective.proto
Read more

unity3d - Rotate an object to face an opposite direction -

i have object , b. when click on object b, rotates object b (a faces b). b doesn't face a. need following : when faces b, need face opposite direction. have code rotating @ b. how rotate face opposite direction after that? vector3 targetdirection = target - transform.position; float step = speed * time.deltatime; vector3 newdirection = vector3.rotatetowards (turretdome.transform.forward, targetdirection, step, 0.0f); turretdome.transform.rotation = quaternion.lookrotation (newdirection); you object facing object b, want inverse direction of object after that? objecta.transform.rotation = quaternion.inverse(objecta.transform.rotation) but lets assume example turretdome object a, (negate direction): turretdome.transform.rotation = quaternion.lookrotation (-newdirection); naturally, both of these snippets not show how smoothen rotation, seem know how use time.deltatime. just incase unsure, quaternion.lerp this
Read more

javascript - Why jQuery Select box change event is now working? -

i working on product filters user select select box according his/her preference not getting selected value user in jquery. html code:- <select name="product_filter" id="product_filter"> <option value="price_low_first">price : low high</option> <option value="price_high_first">price : high low</option> <option value="latest">latest</option> <option value="popular">most popular</option> </select> jquery code: $(function () { $("#product_filter").change(function () { alert("hi") var selectedtext = $(this).find("option:selected").text(); var selectedvalue = $(this).val(); alert("selected text: " + selectedtext + " value: " + selectedvalue); }); }); hi believe code perfect. once please check jquery.min.js
Read more