import pandas as pd
!dir
Datenträger in Laufwerk C: ist Windows Volumeseriennummer: 6E90-EACA Verzeichnis von C:\Users\Andreas\data_quest\Datasets\Country Information 29.04.2020 10:30 <DIR> . 29.04.2020 10:30 <DIR> .. 29.04.2020 10:12 <DIR> .ipynb_checkpoints 29.04.2020 08:23 6.820 Countries_Landmasses.csv 29.04.2020 09:34 27.703 Countries_Population.xlsx 29.04.2020 08:09 0 untitled 29.04.2020 10:30 10.285 Untitled.ipynb 29.04.2020 10:16 9.943 Untitled1.ipynb 5 Datei(en), 54.751 Bytes 3 Verzeichnis(se), 16.461.283.328 Bytes frei
!echo %cd%
C:\Users\Andreas\data_quest\Datasets\Country Information
!where /R C:\ /T Countries_landmasses.csv
7184 29.04.2020 07:42:53 C:\Users\Andreas\Data&Quest\Datasets\Country Information\Countries_Landmasses.csv 6820 29.04.2020 08:23:57 C:\Users\Andreas\data_quest\Datasets\Country Information\Countries_Landmasses.csv
df = pd.read_csv(r'C:\Users\Andreas\data_quest\Datasets\Country Information\Countries_Landmasse')
--------------------------------------------------------------------------- FileNotFoundError Traceback (most recent call last) <ipython-input-7-d2ed21748c3a> in <module> ----> 1 df = pd.read_csv(r'C:\Users\Andreas\data_quest\Datasets\Country Information\Countries_Landmasse') ~\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) 683 ) 684 --> 685 return _read(filepath_or_buffer, kwds) 686 687 parser_f.__name__ = name ~\Anaconda3\lib\site-packages\pandas\io\parsers.py in _read(filepath_or_buffer, kwds) 455 456 # Create the parser. --> 457 parser = TextFileReader(fp_or_buf, **kwds) 458 459 if chunksize or iterator: ~\Anaconda3\lib\site-packages\pandas\io\parsers.py in __init__(self, f, engine, **kwds) 893 self.options["has_index_names"] = kwds["has_index_names"] 894 --> 895 self._make_engine(self.engine) 896 897 def close(self): ~\Anaconda3\lib\site-packages\pandas\io\parsers.py in _make_engine(self, engine) 1133 def _make_engine(self, engine="c"): 1134 if engine == "c": -> 1135 self._engine = CParserWrapper(self.f, **self.options) 1136 else: 1137 if engine == "python": ~\Anaconda3\lib\site-packages\pandas\io\parsers.py in __init__(self, src, **kwds) 1915 kwds["usecols"] = self.usecols 1916 -> 1917 self._reader = parsers.TextReader(src, **kwds) 1918 self.unnamed_cols = self._reader.unnamed_cols 1919 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 b'C:\\Users\\Andreas\\data_quest\\Datasets\\Country Information\\Countries_Landmasse' does not exist: b'C:\\Users\\Andreas\\data_quest\\Datasets\\Country Information\\Countries_Landmasse'
df = pd.read_csv(r'C:\Users\Andreas\data_quest\Datasets\Country Information\Countries_Landmasse.csv')
--------------------------------------------------------------------------- FileNotFoundError Traceback (most recent call last) <ipython-input-8-716938bb5760> in <module> ----> 1 df = pd.read_csv(r'C:\Users\Andreas\data_quest\Datasets\Country Information\Countries_Landmasse.csv') ~\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) 683 ) 684 --> 685 return _read(filepath_or_buffer, kwds) 686 687 parser_f.__name__ = name ~\Anaconda3\lib\site-packages\pandas\io\parsers.py in _read(filepath_or_buffer, kwds) 455 456 # Create the parser. --> 457 parser = TextFileReader(fp_or_buf, **kwds) 458 459 if chunksize or iterator: ~\Anaconda3\lib\site-packages\pandas\io\parsers.py in __init__(self, f, engine, **kwds) 893 self.options["has_index_names"] = kwds["has_index_names"] 894 --> 895 self._make_engine(self.engine) 896 897 def close(self): ~\Anaconda3\lib\site-packages\pandas\io\parsers.py in _make_engine(self, engine) 1133 def _make_engine(self, engine="c"): 1134 if engine == "c": -> 1135 self._engine = CParserWrapper(self.f, **self.options) 1136 else: 1137 if engine == "python": ~\Anaconda3\lib\site-packages\pandas\io\parsers.py in __init__(self, src, **kwds) 1915 kwds["usecols"] = self.usecols 1916 -> 1917 self._reader = parsers.TextReader(src, **kwds) 1918 self.unnamed_cols = self._reader.unnamed_cols 1919 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 b'C:\\Users\\Andreas\\data_quest\\Datasets\\Country Information\\Countries_Landmasse.csv' does not exist: b'C:\\Users\\Andreas\\data_quest\\Datasets\\Country Information\\Countries_Landmasse.csv'