I have a dataframe with two-level column names as: ID Value A B —————- 1 6 2 5 3 4 4 3 5 2 6 1 I want to change the column head with: column_mapping = { (‘ID’, ‘A’) : ‘ID:A’, (‘Value’, ‘B’): ‘Value:B’ } I tried rename: df.rename(columns=column_mapping, inplace=True) which does not work. Any… Read More Pandas: change multiple level column name to one level
I have two multi-level column dataframes: data = { ‘A’: { ‘X’: {‘Value1’: 2, ‘Value2’: 1}, ‘Y’: {‘Value1’: 2, ‘Value2’: 3} }, ‘B’: { ‘X’: {‘Value1’: 10, ‘Value2’: 11}, ‘Y’: {‘Value1’: 10, ‘Value2’: 11} } } df = pd.DataFrame(data) Which looks like this… Group A B Subgroup X Y X Y Metric Value1 Value2 Value1… Read More How to add dfs with different number of column axis levels, but sharing same axis names?
I have the following multiindex dataframe: MSISDN_COUNT NAME DIM1 SEGMENT JAN22 N Detractor 307 Passive 198 Promoter 1256 Y Detractor 237 Passive 161 Promoter 1096 FEB22 N Detractor 313 Passive 222 Promoter 1260 Y Detractor 261 Passive 169 Promoter 1155 I want to create a new column, which will be calculated for each NAME and… Read More Perform a calculation as a new column on multiindex dataframe
I have several small datasets from a databse displaying genes in different biological pathways. My end goal is to find what are the genes showing up in different datasets. For this reason, i tried to make multilevel dataframes from each dataset and merge them on a single column. However, it looks like it is getting… Read More How to Merge Multilevel Column Dataframes on a Low Level Column
I have a multilevel index dataframe like this: indx = [(‘location’, ‘a’), (‘location’, ‘b’), (‘location’, ‘c’), (‘location2’, ‘a’), (‘location2’, ‘b’), (‘location2’, ‘c’)] indx = pd.MultiIndex.from_tuples(indx) col = [‘S1′,’S2′,’S3’] df = pd.DataFrame(np.random.randn(6, 3), index=indx, columns=col) df S1 S2 S3 location a -0.453549 -0.079797 0.581657 b -0.458573 -0.732625 -2.277674 c 0.874403 0.459590 -1.220271 location2 a -1.418821 0.847556… Read More Pivoting first level of a multilevel index to be the first level of a multilevel column