Excel import fehlgeschlagen

[wischi11]

Hi,
folgender Fehler taucht bei meinem Code auf:

Code:

df_suburbs = pd.read_excel("C:\Users\xxxxx\Desktop\waterwatch_clean2.xslx', sheet_name = 'Sheet1")
df_suburbs.head()


Error:

(unicode error) 'unicodeescape' codec can't decode bytes in position 2-3: truncated \UXXXXXXXX escape



Wenn ich ein \ oder r hinzufüge also: "C:\\Users\\xxxxxx\\Desktop\\waterwatch_clean2.xslx', sheet_name = 'Sheet1" erscheint folgender Fehler: #

---------------------------------------------------------------------------
FileNotFoundError Traceback (most recent call last)
<ipython-input-18-21927fb87884> in <module>
----> 1 df_suburbs = pd.read_excel(r"C:\Users\xxxxxx\AppData\Local\Temp\waterwatch_clean2', sheet_name = 'Sheet1")
2 df_suburbs.head()

~\anaconda3\lib\site-packages\pandas\util\_decorators.py in wrapper(*args, **kwargs)
297 )
298 warnings.warn(msg, FutureWarning, stacklevel=stacklevel)
--> 299 return func(*args, **kwargs)
300
301 return wrapper

~\anaconda3\lib\site-packages\pandas\io\excel\_base.py in read_excel(io, sheet_name, header, names, index_col, usecols, squeeze, dtype, engine, converters, true_values, false_values, skiprows, nrows, na_values, keep_default_na, na_filter, verbose, parse_dates, date_parser, thousands, comment, skipfooter, convert_float, mangle_dupe_cols, storage_options)
334 if not isinstance(io, ExcelFile):
335 should_close = True
--> 336 io = ExcelFile(io, storage_options=storage_options, engine=engine)
337 elif engine and engine != io.engine:
338 raise ValueError(

~\anaconda3\lib\site-packages\pandas\io\excel\_base.py in __init__(self, path_or_buffer, engine, storage_options)
1069 ext = "xls"
1070 else:
-> 1071 ext = inspect_excel_format(
1072 content=path_or_buffer, storage_options=storage_options
1073 )

~\anaconda3\lib\site-packages\pandas\io\excel\_base.py in inspect_excel_format(path, content, storage_options)
947 assert content_or_path is not None
948
--> 949 with get_handle(
950 content_or_path, "rb", storage_options=storage_options, is_text=False
951 ) as handle:

~\anaconda3\lib\site-packages\pandas\io\common.py in get_handle(path_or_buf, mode, encoding, compression, memory_map, is_text, errors, storage_options)
649 else:
650 # Binary mode
--> 651 handle = open(handle, ioargs.mode)
652 handles.append(handle)
653

FileNotFoundError: [Errno 2] No such file or directory: "C:\\Users\\xxxxxxx\\AppData\\Local\\Temp\\waterwatch_clean2', sheet_name = 'Sheet1"

[rogerb]

@wischi11,

FileNotFoundError, ist ja ziemlich eindeutig.

ich würde vielleicht noch "pathlib" einsetzen und "/" verwenden um sicher zu gehen, dass der Pfad richtig eingelesen wird und auch existiert.

Code: Alles auswählen

from pathlib import Path

file_path = Path("C:/Users/xxxxxxx/AppData/Local/Temp/waterwatch_clean2")

[Sirius3]

@wischi11: schau Dir mal die Anführungszeichen genau an. Ich benutze einen Editor, der Strings in einer deutlich anderen Farbe einfärbt, dann fallen solche Fehler sofort auf.