Walkthrough Index Error while calling predictedScores_new

[fkreuch]

Hi,

I am having a problem assessing the columns in transformedParams_new

predictedScores_new = pd.Series(reg.predict(scaler.transform(transformedParams_new.loc[:, transformedParams_train.columns].fillna(0).values)), index=transformedParams_new.index)

Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "/usr/local/lib/python2.7/dist-packages/pandas/core/indexing.py", line 1294, in __getitem__
    return self._getitem_tuple(key)
  File "/usr/local/lib/python2.7/dist-packages/pandas/core/indexing.py", line 784, in _getitem_tuple
    return self._getitem_lowerdim(tup)
  File "/usr/local/lib/python2.7/dist-packages/pandas/core/indexing.py", line 891, in _getitem_lowerdim
    return self._getitem_nested_tuple(tup)
  File "/usr/local/lib/python2.7/dist-packages/pandas/core/indexing.py", line 964, in _getitem_nested_tuple
    obj = getattr(obj, self.name)._getitem_axis(key, axis=axis)
  File "/usr/local/lib/python2.7/dist-packages/pandas/core/indexing.py", line 1467, in _getitem_axis
    return self._get_label(key, axis=axis)
  File "/usr/local/lib/python2.7/dist-packages/pandas/core/indexing.py", line 90, in _get_label
    elif isinstance(label, tuple) and isinstance(label[axis], slice):
IndexError: tuple index out of range

The columns in transformedParams_train look like this:

Index([u'Unnamed: 0', u'length', u'length.1', u'length.2', u'length.3',
       u'length.4', u'length.5', u'length.6', u'length.7', u'distance',
       ...
       u'RNA folding-pairing, no scaffold.8',
       u'RNA folding-pairing, no scaffold.9',
       u'RNA folding-pairing, no scaffold.10',
       u'RNA folding-pairing, no scaffold.11',
       u'RNA folding-pairing, no scaffold.12',
       u'RNA folding-pairing, no scaffold.13',
       u'RNA folding-pairing, no scaffold.14',
       u'RNA folding-pairing, no scaffold.15',
       u'RNA folding-pairing, no scaffold.16',
       u'RNA folding-pairing, no scaffold.17'],
      dtype='object', length=906)

but the columns in my transformedParams_new look like this...

MultiIndex(levels=[[u'RNA folding-no scaffold', u'RNA folding-pairing, no scaffold', u'RNA folding-with scaffold', u'accessibility', u'base dimers', u'base fractions', u'base table-A', u'base table-C', u'base table-G', u'base table-T', u'distance', u'homopolymers', u'length', u'strand'], [u'(('A', 'A'), -1)', u'(('A', 'A'), -10)', u'(('A', 'A'), -11)', u'(('A', 'A'), -12)', u'(('A', 'A'), -13)', u'(('A', 'A'), -14)', u'(('A', 'A'), -15)', u'(('A', 'A'), -16)', u'(('A', 'A'), -17)', u'(('A', 'A'), -18)', u'(('A', 'A'), -19)', u'(('A', 'A'), -2)', u'(('A', 'A'), -20)', u'(('A', 'A'), -21)', u'(('A', 'A'), -22)', u'(('A', 'A'), -23)', u'(('A', 'A'), -24)', u'(('A', 'A'), -25)', u'(('A', 'A'), -26)', u'(('A', 'A'), -27)', u'(('A', 'A'), -28)', u'(('A', 'A'), -29)', u'(('A', 'A'), -3)', u'(('A', 'A'), -30)', u'(('A', 'A'), -4)', u'(('A', 'A'), -5)', u'(('A', 'A'), -6)', u'(('A', 'A'), -7)', u'(('A', 'A'), -8)', u'(('A', 'A'), -9)', u'(('A', 'A'), 0)', u'(('A', 'A'), 1)', u'(('A', 'A'), 2)', u'(('A', 'A'), 3)', u'(('A', 'A'), 4)', u'(('A', 'A'), 5)', u'(('A', 'A'), 6)', u'(('A', 'A'), 7)', u'(('A', 'C'), -1)', u'(('A', 'C'), -10)', u'(('A', 'C'), -11)', u'(('A', 'C'), -12)', u'(('A', 'C'), -13)', u'(('A', 'C'), -14)', u'(('A', 'C'), -15)', u'(('A', 'C'), -16)', u'(('A', 'C'), -17)', u'(('A', 'C'), -18)', u'(('A', 'C'), -19)', u'(('A', 'C'), -2)', u'(('A', 'C'), -20)', u'(('A', 'C'), -21)', u'(('A', 'C'), -22)', u'(('A', 'C'), -23)', u'(('A', 'C'), -24)', u'(('A', 'C'), -25)', u'(('A', 'C'), -26)', u'(('A', 'C'), -27)', u'(('A', 'C'), -28)', u'(('A', 'C'), -29)', u'(('A', 'C'), -3)', u'(('A', 'C'), -30)', u'(('A', 'C'), -4)', u'(('A', 'C'), -5)', u'(('A', 'C'), -6)', u'(('A', 'C'), -7)', u'(('A', 'C'), -8)', u'(('A', 'C'), -9)', u'(('A', 'C'), 0)', u'(('A', 'C'), 1)', u'(('A', 'C'), 2)', u'(('A', 'C'), 3)', u'(('A', 'C'), 4)', u'(('A', 'C'), 5)', u'(('A', 'C'), 6)', u'(('A', 'C'), 7)', u'(('A', 'G'), -1)', u'(('A', 'G'), -10)', u'(('A', 'G'), -11)', u'(('A', 'G'), -12)', u'(('A', 'G'), -13)', u'(('A', 'G'), -14)', u'(('A', 'G'), -15)', u'(('A', 'G'), -16)', u'(('A', 'G'), -17)', u'(('A', 'G'), -18)', u'(('A', 'G'), -19)', u'(('A', 'G'), -2)', u'(('A', 'G'), -20)', u'(('A', 'G'), -21)', u'(('A', 'G'), -22)', u'(('A', 'G'), -23)
...

So obviously I am having wrong columns... What am I doing wrong?

I hope you can help me!

Thanks in advance!!!
Franziska