This is the code that i'm using to read a csv file to Jupyter notebook.
import pandas as pd
data = pd.read_csv("C:\\Users\\Mike\\Desktop\\File.csv")
for row in data:
print(row)
if len(data) > 5:
break
I have also tried
data = pd.read_csv(r"C:\Users\Mike\Desktop\File.csv")
which results to the following error
FileNotFoundError Traceback (most recent call last)
<ipython-input-7-332200c5442e> in <module>
1 import pandas as pd
2
----> 3 data = pd.read_csv("C:\\Users\\Mike\\Desktop\\File.csv")
4 for row in data:
5 print(row)
/srv/conda/envs/notebook/lib/python3.6/site-packages/pandas/io/parsers.py in parser_f(filepath_or_buffer, sep, delimiter, header, names, index_col, usecols, squeeze, prefix, mangle_dupe_cols, dtype, engine, converters, true_values, false_values, skipinitialspace, skiprows, skipfooter, nrows, na_values, keep_default_na, na_filter, verbose, skip_blank_lines, parse_dates, infer_datetime_format, keep_date_col, date_parser, dayfirst, cache_dates, iterator, chunksize, compression, thousands, decimal, lineterminator, quotechar, quoting, doublequote, escapechar, comment, encoding, dialect, error_bad_lines, warn_bad_lines, delim_whitespace, low_memory, memory_map, float_precision)
674 )
675
--> 676 return _read(filepath_or_buffer, kwds)
677
678 parser_f.__name__ = name
/srv/conda/envs/notebook/lib/python3.6/site-packages/pandas/io/parsers.py in _read(filepath_or_buffer, kwds)
446
447 # Create the parser.
--> 448 parser = TextFileReader(fp_or_buf, **kwds)
449
450 if chunksize or iterator:
/srv/conda/envs/notebook/lib/python3.6/site-packages/pandas/io/parsers.py in __init__(self, f, engine, **kwds)
878 self.options["has_index_names"] = kwds["has_index_names"]
879
--> 880 self._make_engine(self.engine)
881
882 def close(self):
/srv/conda/envs/notebook/lib/python3.6/site-packages/pandas/io/parsers.py in _make_engine(self, engine)
1112 def _make_engine(self, engine="c"):
1113 if engine == "c":
-> 1114 self._engine = CParserWrapper(self.f, **self.options)
1115 else:
1116 if engine == "python":
/srv/conda/envs/notebook/lib/python3.6/site-packages/pandas/io/parsers.py in __init__(self, src, **kwds)
1889 kwds["usecols"] = self.usecols
1890
-> 1891 self._reader = parsers.TextReader(src, **kwds)
1892 self.unnamed_cols = self._reader.unnamed_cols
1893
pandas/_libs/parsers.pyx in pandas._libs.parsers.TextReader.__cinit__()
pandas/_libs/parsers.pyx in pandas._libs.parsers.TextReader._setup_parser_source()
FileNotFoundError: [Errno 2] File C:\Users\Mike\Desktop\File.csv does not exist: 'C:\\Users\\Mike\\Desktop\\File.csv'
After trying
import os
if os.path.isfile('C:\Users\Mike\Desktop\File.csv'): print('File Exists') else: print('File does not exists')
as suggested by @LittinRajan, i get that the file does not exist. Well, obviously the file does exist, and i'm using the correct path, so it could be something with Jupyter. Any help will be appreciated sine i am new to Python and Jupyter