How do I map a dictionary with list values to a dataframe?
<p>I need to map a dict to a column in a dataframe but don't know how to do it when the values in the dict are in a list. Ideally I was a new column for the values in pos <code>[0]</code>, and another column for the values in pos <code>[1]</code>.</p>

<pre><code>dict = {'foo':['A','B'],
        'bar':['C','D']}

df = pd.DataFrame([[0,'foo'],
                   [1,'bar']], columns=['Col1','Col2'])
</code></pre>

<p>Below is the usual way I'd go about this task if there was only one dict value.</p>

<pre><code>df['Col3'] = df.Col2.map(dict)
</code></pre>