I keep getting module 'pandas' has no attribute 'DataFrame' and I can not remove and re-install pandas package

user_12071493 0
Viewed 392

I am using conda env, and I am trying to run a python script that converts xml file to pandas dataframe. But I keep getting this error:

xml_df = pd.DataFrame(xml_list, columns=column_name)
AttributeError: module 'pandas' has no attribute 'DataFrame'

So I thought I would uninstall and re-install back again the pandas library in my conda env. But I can't even delete the pandas package using conda remove or pip uninstall. I am getting this error:

 with open(path, 'rb') as stream:
FileNotFoundError: [Errno 2] No such file or directory: 'c:\\users\\bla\\anaconda3\\envs\\tensorflow\\lib\\site-packages\\pandas-1.2.4.dist-info\\RECORD'

Then I thought it might be issue with the new pandas==1.2.4 version and I tried to pip install --upgrade pandas==1.2.3 and now I am getting different error:

ERROR: Could not install packages due to an OSError: [Errno 2] No such file or directory: 'c:\\users\\bla\\anaconda3\\envs\\tensorflow\\lib\\site-packages\\pandas-1.2.4.dist-info\\METADATA'

I went to check in my file directory and clearly I do not see those files. When I installed the pandas, I installed using pip. Now I am not sure what to do because I am stuck. I can not remove or even upgrade the pandas to solve that error. I really do not want to delete and re-start my env since I have a lot of packages installed. I would appreciate your help. Thank you!

pandas pip python
2 Answers

First, quit all running Python sessions. Then, go into the c:\users\bla\anaconda3\envs\tensorflow\lib\site-packages folder and delete any files or folders that start with pandas or ~andas, regardless of capitalization. Exit your virtualenv (don't delete it, just deactivate it), then enter/activate it again and run pip install pandas. This should fix the issues you're seeing.

user_14260650

You might have another file called pandas.py in your directory or a variable called pd in your program. Check if you do, and rename the file/variable.

user_138054860
Related