Mar-13-2019, 10:00 AM
Hello,
I am new to python and i am not sure why i am getting this error
---------------------------------------------------------------------------
KeyError Traceback (most recent call last)
<ipython-input-42-c528cbab0606> in <module>()
----> 1 df['No1',3]
/home/inderjeeet/anaconda2/lib/python2.7/site-packages/pandas/core/frame.pyc in __getitem__(self, key)
2684 return self._getitem_frame(key)
2685 elif is_mi_columns:
-> 2686 return self._getitem_multilevel(key)
2687 else:
2688 return self._getitem_column(key)
/home/inderjeeet/anaconda2/lib/python2.7/site-packages/pandas/core/frame.pyc in _getitem_multilevel(self, key)
2728
2729 def _getitem_multilevel(self, key):
-> 2730 loc = self.columns.get_loc(key)
2731 if isinstance(loc, (slice, Series, np.ndarray, Index)):
2732 new_columns = self.columns[loc]
/home/inderjeeet/anaconda2/lib/python2.7/site-packages/pandas/core/indexes/multi.pyc in get_loc(self, key, method)
2246 if self.nlevels < keylen:
2247 raise KeyError('Key length ({0}) exceeds index depth ({1})'
-> 2248 ''.format(keylen, self.nlevels))
2249
2250 if keylen == self.nlevels and self.is_unique:
KeyError: 'Key length (2) exceeds index depth (1)'
I am not sure where the error is at kindly please advise. Any help would be appreaciated!!!
I am new to python and i am not sure why i am getting this error
a = np.random.standard_normal((9, 4)) a.round(6) df = pd.DataFrame(a) df.columns = [['No1', 'No2', 'No3', 'No4']]Easy enough till here however when i am trying to
df['No2'][3] # value in column No2 at index position 3i get the following error:
---------------------------------------------------------------------------
KeyError Traceback (most recent call last)
<ipython-input-42-c528cbab0606> in <module>()
----> 1 df['No1',3]
/home/inderjeeet/anaconda2/lib/python2.7/site-packages/pandas/core/frame.pyc in __getitem__(self, key)
2684 return self._getitem_frame(key)
2685 elif is_mi_columns:
-> 2686 return self._getitem_multilevel(key)
2687 else:
2688 return self._getitem_column(key)
/home/inderjeeet/anaconda2/lib/python2.7/site-packages/pandas/core/frame.pyc in _getitem_multilevel(self, key)
2728
2729 def _getitem_multilevel(self, key):
-> 2730 loc = self.columns.get_loc(key)
2731 if isinstance(loc, (slice, Series, np.ndarray, Index)):
2732 new_columns = self.columns[loc]
/home/inderjeeet/anaconda2/lib/python2.7/site-packages/pandas/core/indexes/multi.pyc in get_loc(self, key, method)
2246 if self.nlevels < keylen:
2247 raise KeyError('Key length ({0}) exceeds index depth ({1})'
-> 2248 ''.format(keylen, self.nlevels))
2249
2250 if keylen == self.nlevels and self.is_unique:
KeyError: 'Key length (2) exceeds index depth (1)'
I am not sure where the error is at kindly please advise. Any help would be appreaciated!!!