multiple problems with code - Printable Version +- Python Forum (https://python-forum.io) +-- Forum: Python Coding (https://python-forum.io/forum-7.html) +--- Forum: General Coding Help (https://python-forum.io/forum-8.html) +--- Thread: multiple problems with code (/thread-22257.html) |
multiple problems with code - SrijaRamarthy - Nov-05-2019 values = melb_data[melb_data.Suburb == "Brighton East"].CouncilArea.mode()[0] print("V",values) melb_data[melb_data.Suburb == "Brighton East"].CouncilArea.fillna(value = values,inplace = True)not the fillna function is not working can anybody help me pls RE: multiple problems with code - Larz60+ - Nov-05-2019 please read: https://python-forum.io/misc.php?action=help&hid=19 [split] HELP ME!! - SrijaRamarthy - Nov-06-2019 for i in Suburb: values = melb_data[melb_data.Suburb == i].CouncilArea.mode()[0] mask = melb_data[melb_data.Suburb == i]['CouncilArea'].isnull() melb_data[melb_data.Suburb == i].CouncilArea.fillna(value = values,inplace = True) and the error is --------------------------------------------------------------------------- KeyError Traceback (most recent call last) ~\Anaconda3\lib\site-packages\pandas\core\indexes\base.py in get_value(self, series, key) 4374 return self._engine.get_value(s, k, -> 4375 tz=getattr(series.dtype, 'tz', None)) 4376 except KeyError as e1: pandas/_libs/index.pyx in pandas._libs.index.IndexEngine.get_value() pandas/_libs/index.pyx in pandas._libs.index.IndexEngine.get_value() pandas/_libs/index.pyx in pandas._libs.index.IndexEngine.get_loc() pandas/_libs/hashtable_class_helper.pxi in pandas._libs.hashtable.Int64HashTable.get_item() pandas/_libs/hashtable_class_helper.pxi in pandas._libs.hashtable.Int64HashTable.get_item() KeyError: 0 During handling of the above exception, another exception occurred: IndexError Traceback (most recent call last) <ipython-input-25-ad558584b420> in <module> 1 for i in Suburb: ----> 2 values = melb_data[melb_data.Suburb == i].CouncilArea.mode()[0] 3 mask = melb_data[melb_data.Suburb == i]['CouncilArea'].isnull() 4 melb_data[melb_data.Suburb == i].CouncilArea.fillna(value = values,inplace = True) ~\Anaconda3\lib\site-packages\pandas\core\series.py in __getitem__(self, key) 866 key = com.apply_if_callable(key, self) 867 try: --> 868 result = self.index.get_value(self, key) 869 870 if not is_scalar(result): ~\Anaconda3\lib\site-packages\pandas\core\indexes\base.py in get_value(self, series, key) 4379 4380 try: -> 4381 return libindex.get_value_box(s, key) 4382 except IndexError: 4383 raise pandas/_libs/index.pyx in pandas._libs.index.get_value_box() pandas/_libs/index.pyx in pandas._libs.index.get_value_at() pandas/_libs/util.pxd in pandas._libs.util.get_value_at() pandas/_libs/util.pxd in pandas._libs.util.validate_indexer() IndexError: index out of bounds |