The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Anybody can ask a question
Anybody can answer
The best answers are voted up and moderated by our team

Importing an Excel document onto Python

Importing an Excel document onto Python


Using Jupyter on a Mac, I cannot import my .csv Excel file onto Python.  I get this error:
FileNotFoundError: [Errno 2] File b’real_estate_price_size.csv’ does not exist: b’real_estate_price_size.csv’
I got a response from 365 Data Science saying the files must all be in the same directory, though I am not sure which files 365 Data Science is referring to.  Any ideas?  

2 Answers

Top Answer

365 Team

This is an issue that occurs due to your specific Anaconda installation. The easiest way to solve this is to reinstall Anaconda. However, we recommend that you use the absolute path of a file when loading the data.
Thus, you can write:

data = pd.read_csv(‘ABSOLUTE_PATH/real_esate_price_size.csv’)

To me this looks like:

data = pd.read_csv('C:/Users/365/Desktop/The Data Science Course 2018 – All Resources/Part_4_Advanced_Statistical_Methods_(Machine_Learning)/S27_L142/real_estate_price _size.csv') 

In your case, you can find that by opening the folder containing the files and copy-pasting the path.
Once you copy-paste this path, you should CHANGE ALL SLASHES from backward to forward. This means that if your path is C:\Users\YOUR_COMPUTER_NAME\Desktop\… , you should make it look like: C:/Users/YOUR_COMPUTER_NAME/Desktop/…
Note that, due to the standards for referencing paths, in Python, instead of a backward slash ( \ ), you should use a forward slash ( / ).


It worked thanks!

1 year
Complete Data Science Education
Get 50% OFF