While running code : model.load_and_clean_data('Absenteeism_new_data.csv') I am getting error of: KeyError: "['Pets', 'Month_value'] not in index"

Hi Sumeera! Thanks for reaching out. Please accept my apologies for the delayed response. Also, thank you very much for pointing this out! It seems the error indeed stems from using 'Pets' in plural in the module. This is something we need to correct. Thank you. Best, Martin

I tried to add arguement delim_whitespace = True in pd.read_csv code in module file so error changed from indexer to ID not found. I am stcuk here please solve my this query as soon as possible. pd.read_csv("wspace.csv", header=None, delim_whitespace=True)

I am writing the full error which is occurring for the code: model.load_and_clean_data('Absenteeism_new_data.csv') KeyError Traceback (most recent call last) <ipython-input-4-31f66a937b22> in <module> ----> 1 model.load_and_clean_data('Absenteeism_new_data.csv') ~\ML projects\absenteeism_module.py in load_and_clean_data(self, data_file) 128 129 # we need this line so we can use it in the next functions --> 130 self.data = self.scaler.transform(df) 131 132 # a function which outputs the probability of a data point to be 1 ~\ML projects\absenteeism_module.py in transform(self, X, y, copy) 29 def transform(self, X, y=None, copy=None): 30 init_col_order = X.columns ---> 31 X_scaled = pd.DataFrame(self.scaler.transform(X[self.columns]), columns=self.columns) 32 X_not_scaled = X.loc[:,~X.columns.isin(self.columns)] 33 return pd.concat([X_not_scaled, X_scaled], axis=1)[init_col_order] ~\anaconda3\lib\site-packages\pandas\core\frame.py in __getitem__(self, key) 2910 if is_iterator(key): 2911 key = list(key) -> 2912 indexer = self.loc._get_listlike_indexer(key, axis=1, raise_missing=True)[1] 2913 2914 # take() does not accept boolean indexers ~\anaconda3\lib\site-packages\pandas\core\indexing.py in _get_listlike_indexer(self, key, axis, raise_missing) 1252 keyarr, indexer, new_indexer = ax._reindex_non_unique(keyarr) 1253 -> 1254 self._validate_read_indexer(keyarr, indexer, axis, raise_missing=raise_missing) 1255 return keyarr, indexer 1256 ~\anaconda3\lib\site-packages\pandas\core\indexing.py in _validate_read_indexer(self, key, indexer, axis, raise_missing) 1302 if raise_missing: 1303 not_found = list(set(key) - set(ax)) -> 1304 raise KeyError(f"{not_found} not in index") 1305 1306 # we skip the warning on Categorical KeyError: "['Pets', 'Month_value'] not in index"

Resolved: After using clumsy approach I found the errors in the mismatch spelling of two variables: 'Pets' & 'Month_values' in model file and module file. Now issue resolved by correcting the spelling in both files.