Filtering Based On The "rows" Data After Creating A Pivot Table In Python Pandas

I have a set of data that I'm getting from a SQL database and reading into a pandas dataframe. The resulting df is about 250M rows and growing everyday. Therefore, I'd like to pivo

Solution 1:

You should be able to slice it like so:

In[11]: pivot.ix[('2013-06-01', 3):('2013-06-01', 6)]Out[11]:
                     viewsreport_dateitem_id2013-06-01516

See advance indexing in the docs.