I have a multi index dataframe, let's say
index = [['a', 'a', 'b', 'b'],[1, 2, 1, 2]]
df = pd.DataFrame([1,2,3,4], index=index)
     0
a 1  1
  2  2
b 1  3
  2  4
If I want to add a new column with a constant value, I can just do
df['new_col'] = 'IamNew'
     0 new_col
a 1  1  IamNew
  2  2  IamNew
b 1  3  IamNew
  2  4  IamNew
Perfect. However, what if I want to add a new column with a list? This doesn't work
df['new_col']=[1,2]
ValueError: Length of values does not match length of index
I have tried many options and spent quite some time trying to figure this out. Any idea?