learn-co-students/excel-to-python-data-science-intro-000

excel-to-python-data-science-intro-000's Issues

Continued error message: No such file or directory: './cities.xlsx'

Unable to import excel files into jupyter notebook

CODE
import pandas travel_df = pandas.read_excel('./cities.xlsx') cities = travel_df.to_dict('records') cities[0]

ERROR
`---------------------------------------------------------------------------
FileNotFoundError Traceback (most recent call last)
in ()
1 import pandas
----> 2 travel_df = pandas.read_excel('./cities.xlsx')
3 cities = travel_df.to_dict('records')
4 cities[0]

~\Anaconda3\lib\site-packages\pandas\util_decorators.py in wrapper(*args, **kwargs)
176 else:
177 kwargs[new_arg_name] = new_arg_value
--> 178 return func(*args, **kwargs)
179 return wrapper
180 return _deprecate_kwarg

~\Anaconda3\lib\site-packages\pandas\util_decorators.py in wrapper(*args, **kwargs)
176 else:
177 kwargs[new_arg_name] = new_arg_value
--> 178 return func(*args, **kwargs)
179 return wrapper
180 return _deprecate_kwarg

~\Anaconda3\lib\site-packages\pandas\io\excel.py in read_excel(io, sheet_name, header, names, index_col, usecols, squeeze, dtype, engine, converters, true_values, false_values, skiprows, nrows, na_values, parse_dates, date_parser, thousands, comment, skipfooter, convert_float, **kwds)
305
306 if not isinstance(io, ExcelFile):
--> 307 io = ExcelFile(io, engine=engine)
308
309 return io.parse(

~\Anaconda3\lib\site-packages\pandas\io\excel.py in init(self, io, **kwds)
392 self.book = xlrd.open_workbook(file_contents=data)
393 elif isinstance(self._io, compat.string_types):
--> 394 self.book = xlrd.open_workbook(self._io)
395 else:
396 raise ValueError('Must explicitly set engine if not passing in'

~\Anaconda3\lib\site-packages\xlrd_init_.py in open_workbook(filename, logfile, verbosity, use_mmap, file_contents, encoding_override, formatting_info, on_demand, ragged_rows)
114 peek = file_contents[:peeksz]
115 else:
--> 116 with open(filename, "rb") as f:
117 peek = f.read(peeksz)
118 if peek == b"PK\x03\x04": # a ZIP file

FileNotFoundError: [Errno 2] No such file or directory: './cities.xlsx'
`