Last answered:

30 Aug 2020

Posted on:

20 Aug 2020


Jupyter notebook

I have problem, that i am unable to insert/import  csv/excel file in jupyter. Please tell me how to import that file in detail.
I have already searched on google how to import csv/excel file in jupyter and tried many codes but it couldn't work. i have installed all the necessary packages which are mentioned in the video.

3 answers ( 0 marked as helpful)
Posted on:

23 Aug 2020

Hi omkar! Thanks for reaching out. Can you please support your question with the code you are trying to execute, as well as a screenshot containing the error message? This will help us assist you better. Hope this helps.
Posted on:

28 Aug 2020

Start your code here 
df_used_cars = pd.read_csv("C:/Users/hp/Documents/Data Science/365 Data Science/Data Visualisation/bar_chart_data")

this is code and i am unable to upload screenshot so i am pasting the whole error :

FileNotFoundError                         Traceback (most recent call last)
<ipython-input-4-d3322ed17be0> in <module>
----> 1 df_used_cars = pd.read_csv("C:/Users/hp/Documents/DataScience/365DataScience/DataVisualisation/bar_chart_data")

~\anaconda3\lib\site-packages\pandas\io\ 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         )
--> 676         return _read(filepath_or_buffer, kwds)
    678     parser_f.__name__ = name

~\anaconda3\lib\site-packages\pandas\io\ in _read(filepath_or_buffer, kwds)
    447     # Create the parser.
--> 448     parser = TextFileReader(fp_or_buf, **kwds)
    450     if chunksize or iterator:

~\anaconda3\lib\site-packages\pandas\io\ in __init__(self, f, engine, **kwds)
    878             self.options["has_index_names"] = kwds["has_index_names"]
--> 880         self._make_engine(self.engine)
    882     def close(self):

~\anaconda3\lib\site-packages\pandas\io\ 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":

~\anaconda3\lib\site-packages\pandas\io\ in __init__(self, src, **kwds)
   1889         kwds["usecols"] = self.usecols
-> 1891         self._reader = parsers.TextReader(src, **kwds)
   1892         self.unnamed_cols = self._reader.unnamed_cols

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/hp/Documents/DataScience/365DataScience/DataVisualisation/bar_chart_data does not exist: 'C:/Users/hp/Documents/DataScience/365DataScience/DataVisualisation/bar_chart_data'



file directory  is correct but it's still showing the error

Posted on:

30 Aug 2020

Hi omkar and Dan! Thanks for reaching out! @omkar: Please make sure to add the file extension at the end of the string. Then, please retry.
@Dan: Can you please support your question with a screenshot? This will help us assist you better. Please note that replacing your file into a folder with a shorter path might solve the problem  in some occasions. Hope this helps but please feel free to get back to us should you need further assistance. Thank you.

Submit an answer