pandas - Creating dataframe boxplot from dataframe with row and column multiindex -

-

i have following pandas data frame , i'm trying create boxplot of "dur" value both client , server organized qdepth (qdepth on x-axis, duration on y-axis, 2 variables client , server). seems need client , serveras columns. haven't been able figure out trying combinations ofunstackandreset_index`.

example

here's dummy data recreated since didn't post yours aside image:

qdepth,mode,runid,dur 1,client,0x1b7bd6ef955979b6e4c109b47690c862,7.0 1,client,0x45654ba030787e511a7f0f0be2db21d1,30.0 1,server,0xb760550f302d824630f930e3487b4444,19.0 1,server,0x7a044242aec034c44e01f1f339610916,95.0 2,client,0x51c88822b28dfa006bf38603d74f9911,15.0 2,client,0xd5a9028fddf9a400fd8513edbdc58de0,49.0 2,server,0x3943710e587e3932adda1cad8eaf2aeb,30.0 2,server,0xd67650fd984a48f2070de426e0a942b0,93.0

load data: df = pd.read_clipboard(sep=',', index_col=[0,1,2])

option 1:

df.unstack(level=1).boxplot()

enter image description here

option 2:

df.unstack(level=[0,1]).boxplot()

option 2

option 3:

using seaborn:

import seaborn sns sns.boxplot(x="qdepth", hue="mode", y="dur", data=df.reset_index(),)

enter image description here

update:

to answer comment, here's approximate way (could used starting point) recreate seaborn option using pandas , matplotlib:

fig, ax = plt.subplots(nrows=1,ncols=1, figsize=(12,6)) #bp = df.unstack(level=[0,1])['dur'].boxplot(ax=ax, return_type='dict')  bp = df.reset_index().boxplot(column='dur',by=['qdepth','mode'], ax=ax, return_type='dict')['dur']  # fill boxes desired colors boxcolors = ['darkkhaki', 'royalblue'] numboxes = len(bp['boxes']) in range(numboxes):     box = bp['boxes'][i]     boxx = []     boxy = []     j in range(5):         boxx.append(box.get_xdata()[j])         boxy.append(box.get_ydata()[j])     boxcoords = list(zip(boxx, boxy))     # alternate between dark khaki , royal blue     k = % 2     boxpolygon = mpl.patches.polygon(boxcoords, facecolor=boxcolors[k])     ax.add_patch(boxpolygon)  plt.show()

enter image description here


Comments

Post a Comment

Popular posts from this blog

php - How to display all orders for a single product showing the most recent first? Woocommerce -

-
i have password protected page on frontend. on page, want display full list of purchases associated single woocommerce product id. option 1: i've looked through woocommerce docs , , found: wc_cli_order , list_( $args, $assoc_args ) function lists orders. presumably, orders can filtered product id [--=] filter orders based on order property. line item fields (numeric array, started index zero): line_items.0.product_id option 2: i found article , based on customer id. i've modified code based on guesses meta_key , meta_value. $customer_orders = get_posts( array( 'numberposts' => -1, 'meta_key' => '_product', 'meta_value' => get_product_id(), 'post_type' => wc_get_order_types(), 'post_status' => array_keys( wc_get_order_statuses() ), ) ); how display orders single product showing recent order first? here solution put based on these articles: http://www.w...
Read more

asp.net - How to correctly use QUERY_STRING in ISAPI rewrite? -

-
i'm having difficult time , hope guys can help. using helicon isapi rewrite version 3.1.0.104 on our iis server. edit http.conf file , have tried , still fail. this trying do: redirect url: https://www.domain.com/switch-by-version?version=2.8.5.2594 to: https://test.domain.com/load/load.aspx?tver=2.8.5.2594 the version number @ end source url change, , need target url have same version number @ end of url example above shows. i tried following not work: rewritecond %{query_string} ^version=(\d\d?)\.(\d\d?)\.(\d\d?)\.(.*)$ [nc] rewriterule ^/switch-by-version(.*)$ https://test.domain.com/load/load.aspx?tver=%1 [r=307,nc,l] any appreciated! thanks. if it's running in equivalent context of .htaccess , rule shouldn't start / . here's simpler version: rewritecond %{query_string} ^version=(\d+\.\d+\.\d+(?:\..+)?)$ [nc] rewriterule ^switch-by-version/?$ https://test.domain.com/load/load.aspx?tver=%1 [r=307,nc,l]
Read more

angularjs - How restrict admin panel using in backend laravel and admin panel on angular? -

-
https://scotch.io/tutorials/token-based-authentication-for-angularjs-and-laravel-apps following tutorials, try write authentication restrict admin panel, didn't understood how can that. this admin panel, admin panel don't want show , request database unauthenticated users. my laravel-routes route::get('/admin',function(){ return view('index'); }); route::get('/api/v1/employees/{id?}', 'employees@index'); route::get('/api/v1/users/{id?}', 'employees@users'); route::post('/api/v1/employees', 'employees@store'); route::post('/api/v1/employees/{id}', 'employees@update'); route::delete('/api/v1/employees/{id}', 'employees@destroy'); route::group(['prefix' => 'api'], function() { route::resource('authenticate', 'authenticatecontroller', ['only' => ['index']]); route::post('authenticate', 'authentic...
Read more