Skip to content Skip to sidebar Skip to footer
Showing posts with the label Multi Index

Filtering Rows By A Particular Index Level In A Multiindex Dataframe

Given a multIndex dataframe: mux = pd.MultiIndex.from_arrays([ list('aaaabbbbbccdddddd'… Read more Filtering Rows By A Particular Index Level In A Multiindex Dataframe

Merging Crosstabs In Python

I am trying to merge multiple crosstabs into a single one. Note that the data provided is obviously… Read more Merging Crosstabs In Python

Can Pandas Read Excel's Group Structure Into A Multindex?

I have an Excel file with some (mostly) nicely grouped rows. I built a fake example below. Is ther… Read more Can Pandas Read Excel's Group Structure Into A Multindex?

Pandas Multi-index - Can't Convert Non-uniquely Indexed Dataframe To Panel

Given a time series data, I'm trying to use panel OLS with fixed effects in Python. I found thi… Read more Pandas Multi-index - Can't Convert Non-uniquely Indexed Dataframe To Panel

How To Retrieve Pandas Df Multiindex From Hdfstore?

If DataFrame with simple index is the case, one may retrieve index from HDFStore as follows: df = p… Read more How To Retrieve Pandas Df Multiindex From Hdfstore?

Set Value Multiindex Pandas

I'm a newbie to both Python and Pandas. I am trying to construct a dataframe, and then later po… Read more Set Value Multiindex Pandas

Pandas Apply Function On Multiindex

I would like to apply a function on a multiindex dataframe (basically groupby describe dataframe) w… Read more Pandas Apply Function On Multiindex

Sort Dataframe Multiindex Level And By Column

Updated: pandas version 0.23.0 solves this problem with Sorting by a combination of columns and in… Read more Sort Dataframe Multiindex Level And By Column