Pandas: Use multiple columns of a dataframe as index of another

Question

I've got a large dataframe with my data in it, and another dataframe of the same first dimension that contains metadata about each point in time (e.g., what trial number it was, what trial type it was). What I want to do is slice the large dataframe using the values of the "metadataframe". I want to keep these separate (rather than storing the metadataframe as a multi-index of the larger one). Right now, I am trying to do something like this: ``` def my_func(container): container.big_df.set_index(container.meta_df[['col1', 'col2']]) container.big_df.loc['col1val', 'col2val'].plot() ``` However, this returns the following error: ``` ValueError: Must pass DataFrame with boolean values only ``` Note that this works fine if I only pass a single column to set_index. Can anyone figure out what's going wrong here? Alternatively, can someone tell me that I'm doing this in a totally stupid and hacky way, and that there's a much better way to go about it? :) MY SOLUTION Thanks for the ideas. I…

Accepted Answer

Use `MultiIndex.from_arrays()` to create the index object:

```
import pandas as pd
df1 = pd.DataFrame({"A":[1,2,3], "B":["a","b","c"]})
df2 = pd.DataFrame({"C":[100,200,300]})
df2.index = pd.MultiIndex.from_arrays(df1.values.T)

print df2
```

the result:

```
       C
1 a  100
2 b  200
3 c  300
```

Pandas: Use multiple columns of a dataframe as index of another

Solution

Problem