Hi All,
I want to change the column names to the name i have in the csv file. Below is the code i used but i am getting an error i.e.
Keyerror: 'Column_Names'
Thanks.
I want to change the column names to the name i have in the csv file. Below is the code i used but i am getting an error i.e.
Keyerror: 'Column_Names'
data_columns = pd.read_csv('E:/Personal/Learning/Predictive ModelingBook/Book Datasets/Customer Churn Columns.csv') data_column_list = data_columns['Column_Names'].tolist() data=pd.read_csv('E:/Personal/Learning/Predictive Modeling Book/BookDatasets/Customer Churn Model.txt',header=None,names=data_column_list) data.columns.values
--------------------------------------------------------------------------- KeyError Traceback (most recent call last) ~\AppData\Local\Continuum\anaconda3\lib\site-packages\pandas\core\indexes\base.py in get_loc(self, key, method, tolerance) 3077 try: -> 3078 return self._engine.get_loc(key) 3079 except KeyError: pandas\_libs\index.pyx in pandas._libs.index.IndexEngine.get_loc() pandas\_libs\index.pyx in pandas._libs.index.IndexEngine.get_loc() pandas\_libs\hashtable_class_helper.pxi in pandas._libs.hashtable.PyObjectHashTable.get_item() pandas\_libs\hashtable_class_helper.pxi in pandas._libs.hashtable.PyObjectHashTable.get_item() KeyError: 'Column_Names' During handling of the above exception, another exception occurred: KeyError Traceback (most recent call last) <ipython-input-31-93082a685b38> in <module> 2 3 data_columns = pd.read_csv('C:/Users/Nidhesh.Tiwari/Desktop/Udemy/Prediction with Python/Predictive Modelling/Customer Churn Model.csv') ----> 4 data_column_list = data_columns["Column_Names"].tolist() 5 data=pd.read_csv('C:/Users/Nidhesh.Tiwari/Desktop/Udemy/Prediction with Python/Predictive Modelling/Customer Churn Model.txt',header=None,names=data_column_list) 6 data.columns.values ~\AppData\Local\Continuum\anaconda3\lib\site-packages\pandas\core\frame.py in __getitem__(self, key) 2686 return self._getitem_multilevel(key) 2687 else: -> 2688 return self._getitem_column(key) 2689 2690 def _getitem_column(self, key): ~\AppData\Local\Continuum\anaconda3\lib\site-packages\pandas\core\frame.py in _getitem_column(self, key) 2693 # get column 2694 if self.columns.is_unique: -> 2695 return self._get_item_cache(key) 2696 2697 # duplicate columns & possible reduce dimensionality ~\AppData\Local\Continuum\anaconda3\lib\site-packages\pandas\core\generic.py in _get_item_cache(self, item) 2487 res = cache.get(item) 2488 if res is None: -> 2489 values = self._data.get(item) 2490 res = self._box_item_values(item, values) 2491 cache[item] = res ~\AppData\Local\Continuum\anaconda3\lib\site-packages\pandas\core\internals.py in get(self, item, fastpath) 4113 4114 if not isna(item): -> 4115 loc = self.items.get_loc(item) 4116 else: 4117 indexer = np.arange(len(self.items))[isna(self.items)] ~\AppData\Local\Continuum\anaconda3\lib\site-packages\pandas\core\indexes\base.py in get_loc(self, key, method, tolerance) 3078 return self._engine.get_loc(key) 3079 except KeyError: -> 3080 return self._engine.get_loc(self._maybe_cast_indexer(key)) 3081 3082 indexer = self.get_indexer([key], method=method, tolerance=tolerance) pandas\_libs\index.pyx in pandas._libs.index.IndexEngine.get_loc() pandas\_libs\index.pyx in pandas._libs.index.IndexEngine.get_loc() pandas\_libs\hashtable_class_helper.pxi in pandas._libs.hashtable.PyObjectHashTable.get_item() pandas\_libs\hashtable_class_helper.pxi in pandas._libs.hashtable.PyObjectHashTable.get_item() KeyError: 'Column_Names'Please help me in the same.
Thanks.