python - pandas dataframe.drop(col,axis=1) does not drop column from column.levels in multiindex dataframe -


i have multiindex dataframe dropping columns using df.drop(col,axis=1). then, looking through column.levels[0] , doing operations on columns. however, when try this, pandas looks removed column since not removed column.levels. bug? there war?

here df working with:

                ^gspc         pf             adj close  adj close date                             2013-04-22    1562.50    4023.45 2013-04-23    1578.78    4099.20 2013-04-24    1578.79    4094.70 2013-04-25    1585.16    4124.25 2013-04-26    1582.24    4211.65 2013-04-29    1593.61    4340.75 2013-04-30    1597.57    4467.55 2013-05-01    1582.70    4432.25 2013-05-02    1597.59    4494.95 2013-05-03    1614.42    4539.55 2013-05-06    1617.50    4645.95 2013-05-07    1625.96    4624.65 2013-05-08    1632.69    4677.40 2013-05-09    1626.67    4637.25 2013-05-10    1633.70    4602.40 2013-05-13    1633.77    4618.60 2013-05-14    1650.34    4510.85 2013-05-15    1658.78    4362.00 2013-05-16    1650.47    4418.95 2013-05-17    1667.47    4406.95 2013-05-20    1666.29    4503.50 2013-05-21    1669.16    4471.20

here how dropping columns:

data = data.drop(stock.ticker,axis=1,level=0)

here issue is:

>>> print data.columns multiindex [(^gspc, adj close), (pf, adj close)] >>> print data.columns.labels [array([2, 3]), array([0, 0])] >>> print data.columns.levels [index([nvda, aapl, ^gspc, pf], dtype=object), index([adj close], dtype=object)]

adding method used generate df requested in comment: tickers list of stock ticker strings. stock object has ticker property among others. portfolio object collection of stocks.

data = getdata.get_history(tickers,dt.today()-relativedelta(months=months)) data = data.drop(['open','high','low','close','volume'],axis=1) data = data.unstack(0).swaplevel(0,1,axis=1).sortlevel(0,axis=1) data['pf','adj close'] = np.zeros(len(data)) stock in portfolio.getstocksinportfolio():   data['pf','adj close'] += data[stock.ticker,'adj close'] * stock.getsharesowned()   data = data.drop(stock.ticker,axis=1,level=0)


Comments

Post a Comment

Popular posts from this blog

python - How to create a legend for 3D bar in matplotlib? -

Image
given ax = plt.subplot() : ax.bar()[0] can passed plt.legend() . however, ax.bar3d() returns none . how create legend displayed bars? update: passing legend="stuff" ax.bar3d() , calling ax.legend() raises /usr/lib/python2.6/site-packages/matplotlib/axes.py:4368: userwarning: no labeled objects found. use label='...' kwarg on individual plots. warnings.warn("no labeled objects found. " you need use proxy artist legends not supported. this code: from mpl_toolkits.mplot3d import axes3d import matplotlib.pyplot plt import numpy np fig = plt.figure() ax = fig.add_subplot(111, projection='3d') x, y = np.random.rand(2, 100) * 4 hist, xedges, yedges = np.histogram2d(x, y, bins=4) elements = (len(xedges) - 1) * (len(yedges) - 1) xpos, ypos = np.meshgrid(xedges[:-1]+0.25, yedges[:-1]+0.25) xpos = xpos.flatten() ypos = ypos.flatten() zpos = np.zeros(elements) dx = 0.5 * np.ones_like(zpos) dy = dx.copy() dz = hist.flatten() ax...
Read more

java - Multi-Label Document Classification -

i have database in store data based upon following 3 fields: id, text, {labels}. note each text has been assigned more 1 label \ tag \ class. want build model (weka \ rapidminer \ mahout) able recommend \ classify bunch of labels \ tags \ classes given text. i have heard svm , naive bayes classifier, not sure whether support multi-label classification or not. guides me right direction more welcome! the basic multilabel classification method one-vs.-the-rest (ovr), called binary relevance (br). basic idea take off-the-shelf binary classifier, such naive bayes or svm, create k instances of solve k independent classification problems. in python-like pseudocode: for each class k: learner = svm(settings) # example labels = [class_of(x) == k x in samples] learner.learn(samples, labels) then @ prediction time, run each of binary classifiers on sample , collect labels predict positive. (both training , prediction can done in parallel, since problems assumed ...
Read more

php - Dynamic url re-writing using htaccess -

how can rewrite http://mydomain.com/test/master.php?catid=2&subcatid=8 http://mydomain.com/test/master.php/catname/subcat using .htaccess file. once rewritten, how can access these parameters in master.php? note: untested, let me know if doesn't work. rewriterule ^master.php/([a-za-z0-9_-]+)/([a-za-z0-9_-]+)$ /master.php?catid$1&subcatid=$2 [l]
Read more