python - Multiindex print 2nd level index labels on right side of a table -

-

taking example http://pandas.pydata.org/pandas-docs/stable/advanced.html

in [10]: arrays = [np.array(['bar', 'bar', 'baz', 'baz', 'foo', 'foo', 'qux', 'qux']),    ....:           np.array(['one', 'two', 'one', 'two', 'one', 'two', 'one', 'two'])]    ....:   in [11]: s = pd.series(np.random.randn(8), index=arrays)  in [13]: df = pd.dataframe(np.random.randn(8, 4), index=arrays)  in [14]: df out[14]:                  0         1         2         3 bar 1 -0.424972  0.567020  0.276232 -1.087401     2 -0.673690  0.113648 -1.478427  0.524988 baz 1  0.404705  0.577046 -1.715002 -1.039268     2 -0.370647 -1.157892 -1.344312  0.844885 foo 1  1.075770 -0.109050  1.643563 -1.469388     2  0.357021 -0.674600 -1.776904 -0.968914 qux 1 -1.294524  0.413738  0.276662 -0.472035     2 -0.013960 -0.362543 -0.006154 -0.923061

how move second index print display after last columns? this:

            0         1         2         3 bar -0.424972  0.567020  0.276232 -1.087401 1     -0.673690  0.113648 -1.478427  0.524988 2 baz  0.404705  0.577046 -1.715002 -1.039268 1     -0.370647 -1.157892 -1.344312  0.844885 2 foo  1.075770 -0.109050  1.643563 -1.469388 1      0.357021 -0.674600 -1.776904 -0.968914 2 qux -1.294524  0.413738  0.276662 -0.472035 1     -0.013960 -0.362543 -0.006154 -0.923061 2

not quite same can call reset_index passing second level , reorder columns using fancy indexing using ix , passing list of desired column order:

in [100]: df.reset_index(level=1).ix[:,list(df) + ['level_1']]  out[100]:             0         1         2         3 level_1 bar -0.171917 -0.084470  0.568098  0.749653     1 bar  0.114017  0.474004 -0.032003  0.197596     2 baz -0.310686 -0.236696  0.471586 -0.286288     1 baz  2.014078  0.957119 -0.399487  1.109984     2 foo -0.309654  0.916766  1.207385 -0.673540     1 foo  0.442063 -0.819095  0.314201 -1.125304     2 qux  1.817970 -0.316869  1.773183 -0.097240     1 qux  0.025067  0.135640  1.054219 -0.230144     2

Comments

Post a Comment

Popular posts from this blog

matlab - error with cyclic autocorrelation function -

-
Image
i'm trying code cyclic autocorrelation function in matlab follows: t=0:(n-1); t=t*te; i_alpha=0; tau=-n2*te:te:n2*te; alpha=-1/2:1/n:1/2; ryy_cl=zeros(length(alpha),length(tau)); alpha=alpha/te ind_tau=0; i_alpha=i_alpha+1; k=tau ind_tau=ind_tau+1; if k>0 % ryy_cl(i_alpha,ind_tau)=1/length(sig_bin_syl_mod(1:end- k))*sum((sig_bin_syl_mod(1:end-k)).*sig_bin_syl_mod(k+1:end)).*exp(1i*2*pi*alpha*t(1+k:length(sig_bin_syl_mod(1:end)))); ryy_cl(i_alpha,ind_tau)=(1/n)*sum((sig_bin_syl_mod(1:end-k)).*sig_bin_syl_mod(k+1:end)).*exp(-1i*2*pi*alpha*t(1:end-k)); else ryy_cl(i_alpha,ind_tau)=(1/n)*sum((sig_bin_syl_mod(1-k:end)).*sig_bin_syl_mod(1:end+k)).*exp(-1i*2*pi*alpha*t(1-k:end)); end end end i'm getting errors, , doesn't show expecting. according below formulae, how can fix it? the code provided incomplete, difficult confidently reproduce error. in particular, haven't de...
Read more

django - (fields.E300) Field defines a relation with model 'AbstractEmailUser' which is either not installed, or is abstract -

-
i trying create customuser django project email username , add radio button truck , company. in registration process email-id registered per truck or company. mentioned radio button 'tag' , add manytomany field tag in emailuser model. when makemigrations, raising error : (fields.e300) field defines relation model 'abstractemailuser' either not installed, or abstract. i quite new django , not sure whether have created correct code wants. please me solving this. here code, models.py: import django django.contrib.auth.models import ( abstractbaseuser, baseusermanager, permissionsmixin) django.core.mail import send_mail django.db import models django.utils import timezone django.utils.translation import ugettext_lazy _ class emailusermanager(baseusermanager): """custom manager emailuser.""" def _create_user(self, email, password, is_staff, is_superuser, **extra_fields): """create , save emailus...
Read more

c# - What is a good .Net RefEdit control to use with ExcelDna? -

-
i using exceldna , c# build suite of tools. part of forms i'd want user select cells/ranges workbook. i've got application.inputbox route working...but doesn't cool... i haven't read many things excel's refedit control, , see many have in past written workarounds, in (shudder) vba or vb.net. however, none of these seem recent... best approach/control refedit functionality on form run via exceldna (if applicable)? the refedit sample project of github explores different ways of dealing threading when showing form excel add-in, main issue making refedit control .net add-in. check page links various other implementations: https://github.com/excel-dna/exceldna/wiki/links-about-refedit
Read more