python - Display Pandas DataFrame in csv format -


i have pandas dataframe q2 looks this:

    studentid     subjects 6         323      history 9         323      physics 8         999    chemistry 7         999      history 4         999      physics 0        1234    chemistry 5        2834      physics 1        3455    chemistry 2        3455      history 10       3455  mathematics 3       56767  mathematics

i want find out student has taken courses , display on screen.

gb = q2.groupby(('studentid')) result = gb['subjects'].unique()  c1=pd.dataframe({'studentid':result.index, 'subjects':result.values})

c1 looks this

   studentid                           subjects 0        323                 [history, physics] 1        999      [chemistry, history, physics] 2       1234                        [chemistry] 3       2834                          [physics] 4       3455  [chemistry, history, mathematics] 5      56767                      [mathematics]

however, desired output following:

323: history, physics 999: chemistry, history, physics 1234: chemistry 2834: physics 3455: chemistry, history, mathematics 56767: mathematics

what can do?

i think can apply function join. creating dataframe can use reset_index:

gb = q2.groupby(('studentid')) result = gb['subjects'].unique()  c1 = result.reset_index()  c1.subjects = c1.subjects.apply(', '.join) print (c1)    studentid                         subjects 0        323                 history, physics 1        999      chemistry, history, physics 2       1234                        chemistry 3       2834                          physics 4       3455  chemistry, history, mathematics 5      56767                      mathematics

last can cast column studentid str (if dtype int) , concanecate together:

c1['new'] = c1.studentid.astype(str) + ':' + c1.subjects print (c1)    studentid                         subjects  \ 0        323                 history, physics    1        999      chemistry, history, physics    2       1234                        chemistry    3       2834                          physics    4       3455  chemistry, history, mathematics    5      56767                      mathematics                                         new   0                  323:history, physics   1       999:chemistry, history, physics   2                        1234:chemistry   3                          2834:physics   4  3455:chemistry, history, mathematics   5                     56767:mathematics

also if original data can overwrite, use:

result = result.index.to_series().astype(str) + ':' + result.apply(', '.join) print (result) studentid 323                      323:history, physics 999           999:chemistry, history, physics 1234                           1234:chemistry 2834                             2834:physics 3455     3455:chemistry, history, mathematics 56767                       56767:mathematics dtype: object

-

Comments

Post a Comment

Popular posts from this blog

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

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

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