Python Playground

Given the following pivot table: import pandas as pd import numpy as np df = pd.DataFrame( … Read more Pandas Sort Multiindex Pivot Table

I've a dataframe which looks like this some feature another feature label sample 0 … Read more How Can I Summarize Several Pandas Dataframe Columns Into A Parent Column Name?

My .csv file looks like: Area When Year Month Tickets City Day 2015 1 14… Read more Want Multiindex For Rows And Columns With Read_csv

Below is my dataframe. I made some transformations to create the category column and dropped the o… Read more How To Do Group By On A Multiindex In Pandas?

I have a dataframe where I would like to turn the data in the (first level of the) index into a col… Read more Make Column From Pandas Dataframe Index

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

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

I am looking to an efficient method to drop duplicate columns in a multiindex dataframe with Pandas… Read more Drop Duplicate In Multiindex Dataframe In Pandas

I am trying to save a Pandas dataframe to an excel file using the to_excel function with XlsxWriter… Read more Blank Line Below Headers Created When Using Multiindex And To_excel In Python

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

I am trying to select individual rows from a multiindex dataframe using a list of multiindices. For… Read more Select Individual Rows From Multiindex Pandas Dataframe

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?

I have a dataset similar to the following: df_lenght = 240 df = pd.DataFrame(np.random.randn(df_len… Read more Sub-select A Multi-index Pandas Dataframe To Create Multiple Subsets (using A Dictionary)

I have a dataframe where I would like to turn the data in the (first level of the) index into a col… Read more Make Column From Pandas Dataframe Index

I have dataframe like this: Tahun Jan Feb Mar Apr Mei Jun Jul Ags … Read more Selecting The Dataframe

Given the following pivot table: import pandas as pd import numpy as np df = pd.DataFrame( … Read more Pandas Sort MultiIndex Pivot Table

I'm taking a Data Mining course at university right now, but I'm a wee bit stuck on a multi… Read more In Pandas How To Sort One Level Of A Multi-index Based On The Values Of A Column, While Maintaining The Grouping Of The Other Level