(Jul-08-2019, 01:47 AM)scidam Wrote:data_columns
is Pandas dataframe. It doesn't contain a column namedColumn_Names
. Everything depends
on content of the fileCustomer Churn Columns.csv
. Try to print all column names
after the data is loaded, e.g.print(data_columns.columns)
.
Thanks for your reply. but i am not getting how to store all the names of columns and use that column names to rename columns of another file.
Moreover, i tried the print command and use the 'Area Code' i.e.
import pandas as pd import os import numpy as np data_columns = pd.read_csv('C:/Prediction with Python/Predictive Modelling/Customer Churn Model.csv') print(data_columns.columns) data_column_list = data_columns['Area Code'].tolist() #data.columns.values #data=pd.read_csv('C:/Prediction with Python/Predictive Modelling/Customer Churn Model.txt',header=None,names=data_column_list) #data
Index(['State,Account Length,Area Code,Phone,Int'l Plan,VMail Plan,VMail Message,Day Mins,Day Calls,Day Charge,Eve Mins,Eve Calls,Eve Charge,Night Mins,Night Calls,Night Charge,Intl Mins,Intl Calls,Intl Charge,CustServ Calls,Churn?'], dtype='object')
-------------------------------------------------------------------------- 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: 'Area Code' During handling of the above exception, another exception occurred: KeyError Traceback (most recent call last) <ipython-input-46-2b1c87f32751> in <module> 5 data_columns = pd.read_csv('C:/Prediction with Python/Predictive Modelling/Customer Churn Model.csv') 6 print(data_columns.columns) ----> 7 data_column_list = data_columns['Area Code'].tolist() 8 #data.columns.values 9 #data=pd.read_csv('C:/Prediction with Python/Predictive Modelling/Customer Churn Model.txt',header=None,names=data_column_list) ~\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: 'Area Code'