damonlee92 / build_your_own_ai_investor Goto Github PK

`KeyError                                  Traceback (most recent call last)
<ipython-input-39-96ae9c885c31> in <module>
      1 x_=pd.read_csv("Annual_Stock_Price_Fundamentals_Filtered_2020.csv", index_col=0)
----> 2 x_['Net Income'] = x_['Net Income_X'] # Net Income fix, checked annual reports.
      3 fixNansInX()
      4 addColsToX()
      5 x=getXRatios()

~\miniconda3\envs\machineLearning-env-py377\lib\site-packages\pandas\core\frame.py in __getitem__(self, key)
   3022             if self.columns.nlevels > 1:
   3023                 return self._getitem_multilevel(key)
-> 3024             indexer = self.columns.get_loc(key)
   3025             if is_integer(indexer):
   3026                 indexer = [indexer]

~\miniconda3\envs\machineLearning-env-py377\lib\site-packages\pandas\core\indexes\base.py in get_loc(self, key, method, tolerance)
   3080                 return self._engine.get_loc(casted_key)
   3081             except KeyError as err:
-> 3082                 raise KeyError(key) from err
   3083 
   3084         if tolerance is not None:

KeyError: 'Net Income_X'`