Jupyter notebook
Hello,
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.
Thanks.
3 answers ( 0 marked as helpful)
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.
Best,
Martin
Best,
Martin
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\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 ~\anaconda3\lib\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: ~\anaconda3\lib\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): ~\anaconda3\lib\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": ~\anaconda3\lib\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/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
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.
Best,
Martin
'.../bar_chart_data.csv")@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.
Best,
Martin