Group columns in dataframe, Multiindex pandas

Question

I am calculating some correlations for a set of measures.

For each measure, I have a data frame of the look attached, which I will join in one data frame.

I want to add multilevel indexing, with the name of the measure, above the columns I have. What is the best way of doing so?

pyaj · Accepted Answer · 2022-03-29 04:02:37Z

1

You can use corr to find the correlations within your columns

df.corr()

Use this to split CI95% column into two columns

df[['CI95%_1','CI95%_2']] = pd.DataFrame(df['CI95%'].tolist(), index= df.index)

Then use corr()

answered Mar 28, 2022 at 23:10

pyaj

6407 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1