python - How do I change order/grouping/level of pandas MultiIndex columns? -


i'm trying reorder/swaplevel/pivot/something columns in pandas dataframe. columns multiindex, can't find sauce want.

the fastest varying column in multiindex month, slowest varying column.

i've got nbviewer notebook if try out yourself: http://nbviewer.ipython.org/gist/flamingbear/4cfac24c80fe34a67474

what have:

+-------------------------------------------------------------------+ |+-----+------+------+-----+------+-----+-----+------+-----+-----+  | ||     |weight             |extent            |rank                || |+-----+------+------+-----+------+-----+-----+------+-----+-----+  | ||month|'1jan'|'feb' |'mar'|'1jan'|'feb'|'mar'|'1jan'|'feb'|'mar'|  | |+-----+------+------+-----+------+-----+-----+------+-----+-----+  | ||year |      |      |     |      |     |     |      |     |     |  | |+-----+------+------+-----+------+-----+-----+------+-----+-----+  | ||2000 |45.1  |46.1  |25.1 |13.442|14.94|15.02|13    |17   |14   |  | |+-----+------+------+-----+------+-----+-----+------+-----+-----+  | ||2001 |85.0  |16.0  |49.0 |13.380|14.81|15.14|12    |15   |17   |  | |+-----+------+------+-----+------+-----+-----+------+-----+-----+  | ||2002 |90.0  |33.0  |82.0 |13.590|15.13|14.88|15    |22   |10   |  | |+-----+------+------+-----+------+-----+-----+------+-----+-----+  | ||2003 |47.0  |34.0  |78.0 |13.640|14.83|15.27|17    |16   |22   |  | |+-----+------+------+-----+------+-----+-----+------+-----+-----+  | +-------------------------------------------------------------------+

what want

+------------------------------------------------------------------+ |+-----+------+------+----+------+------+-----+------+------+----+ | ||month|1jan              |feb                |mar                || |+-----+------+------+----+------+------+-----+------+------+----+ | ||     |weight|extent|rank|weight|extent|rank |weight|extent|rank| | |+-----+------+------+----+------+------+-----+------+------+----+ | ||year |      |      |    |      |      |     |      |      |    | | |+-----+------+------+----+------+------+-----+------+------+----+ | ||2000 |45.1  |13.442|13  |46.1  |14.94 |17   | 25.1 |15.02 |14  | | |+-----+------+------+----+------+------+-----+------+------+----+ | ||2001 |85.0  |13.380|12  |16.0  |14.81 |15   | 49.0 |15.14 |17  | | |+-----+------+------+----+------+------+-----+------+------+----+ | ||2002 |90.0  |13.590|15  |33.0  |15.13 |22   | 82.0 |14.88 |10  | | |+-----+------+------+----+------+------+-----+------+------+----+ | ||2003 |47.0  |13.640|17  |34.0  |14.83 |16   | 78.0 |15.27 |22  | | |+-----+------+------+-----------+------+-----+------+------+----+ | +------------------------------------------------------------------+

any appreciated. can work original dataframe, writing csv desired ordering fantastic.

thanks in advance, matt

your columns multiindex. need reassign dataframe's columns new multiindex created swapping levels of existing one:

df.columns = df.columns.swaplevel(0, 1) df.sortlevel(0, axis=1, inplace=true) >>> df  month   '1jan'                 'feb'                 'mar'                       weight  extent  rank  weight  extent  rank  weight  extent  rank year                                                                     2000      45.1  13.442    13    46.1   14.94    17    25.1   15.02    14 2001      85.0  13.380    12    16.0   14.81    15    49.0   15.14    17 2002      90.0  13.590    15    33.0   15.13    22    82.0   14.88    10 2003      47.0  13.640    17    34.0   14.83    16    78.0   15.27    22

you can export csv:

df.to_csv(filename)

Comments

Post a Comment

Popular posts from this blog

shopping cart - Page redirect not working PHP -

im trying redirect user when click "empty cart". redirect working "add cart" not "empty cart". ideas great. in main .php file set current url seen $current_url = base64_encode("http://$_server[http_host]$_server[request_uri]"); then below cartaction.php file handles actions such "add cart" , "empty cart" <?php session_start(); include_once 'config.php'; //add item in shopping cart if(isset($_post["add"])) { $product_id = $_post["product_id"]; //product id $return_url = base64_decode($_post["return_url"]); //return url $qty = $_post["qty"]; $product = $mysqli->query("select product_name, unit_price, unit_quantity products product_id = '$product_id'"); $obj = $product->fetch_object(); if(!isset($_session['products'])) { $_session['products'] = array(); } if(array_key_exists($product_id...
Read more

php - How to modify a menu to show sub-menus -

i have custom php menu made person, displays categories menu. however, need display subcategories well. tried adding hierarchical parameter didn't work. hoping assistance! here code: <ul> <?php /* categories wp e-commerce products */ $wpec_product_categories = get_terms( 'wpsc_product_category', 'hide_empty=0&parent=0&exclude=298'); $myarray = array(); foreach($wpec_product_categories $wpec_categories){ $myarray[$wpec_categories->term_id]['name'] = $wpec_categories->name; $myarray[$wpec_categories->term_id]['slug'] = $wpec_categories->slug; $myarray[$wpec_categories->term_id]['term_id'] = $wpec_categories->term_id; } foreach($myarray $wpec_categories1){ $wpec_term_name = $wpec_categories1['name']; $wpec_term_slug = $wpec_categories1['slug']; $wpec_term_id = $wpec_categories1['term_id']; echo '<li> <a href="'.get_page_link(19)....
Read more

python - Installing PyDev in eclipse is failed -

unable read repository @ http://pydev.sf.net/updates/content.xml. sun.security.validator.validatorexception: pkix path building failed: sun.security.provider.certpath.suncertpathbuilderexception: unable find valid certification path requested target i installing pydev in eclipse using python, doesn't install successfully. gives above error. happened? how solve error? i had error when trying install on laptop behind corporate firewall. couldn't tell setup of firewall, not sure of root cause. i got passed error installing pydev eclipse when out behind firewall. another way got around have eclipse on non-firewalled machine, install pydev eclipse, , copy whole eclipse directory non-firewalled machine firewalled machine. there better way, , way fix properly, didn't have time work out firewall doing. this on windows 7 machine (yeah know) not work *nix versions installed through package manager yum or apt.
Read more