Problem loading .csv file with full path with Pandas

Question

folks.

I am trying to create an input where the user enters the path of a file and this input is loaded to the pd.read_csv. Example:

import os
import pandas as pd
import numpy as np
import matplotlib.pyplot as plt

file_name = input("insert file name (and path): ")

dados = pd.read_csv(nome_arquivo, encoding = "UTF-8", header = 0, decimal=",", sep='\t')

And I get the following error message:

raceback (most recent call last):
  File "/Users/lsales/PycharmProjects/Propmec/Ensaio_tracao.py", line 42, in <module>
    dados = pd.read_csv(nome_arquivo, encoding = "UTF-8", header = 0, decimal=",", sep='\t')
  File "/Users/lsales/PycharmProjects/Propmec/venv/lib/python3.7/site-packages/pandas/io/parsers.py", line 676, in parser_f
    return _read(filepath_or_buffer, kwds)
  File "/Users/lsales/PycharmProjects/Propmec/venv/lib/python3.7/site-packages/pandas/io/parsers.py", line 448, in _read
    parser = TextFileReader(fp_or_buf, **kwds)
  File "/Users/lsales/PycharmProjects/Propmec/venv/lib/python3.7/site-packages/pandas/io/parsers.py", line 880, in __init__
    self._make_engine(self.engine)
  File "/Users/lsales/PycharmProjects/Propmec/venv/lib/python3.7/site-packages/pandas/io/parsers.py", line 1114, in _make_engine
    self._engine = CParserWrapper(self.f, **self.options)
  File "/Users/lsales/PycharmProjects/Propmec/venv/lib/python3.7/site-packages/pandas/io/parsers.py", line 1874, in __init__
    src = open(src, "rb")
FileNotFoundError: [Errno 2] No such file or directory: '/:Users/:lsales/:Downloads/:DS01.txt'

I have tried all variations like \\, :, etc.

Can anybody give me a help in this matter?

Thanks!

Looks like you are on Mac. Try /Users/lsales/Downloads/DS01.txt — Quang Hoang
– Quang Hoang, Commented May 26, 2020 at 17:23

Umar.H · Accepted Answer · 2020-05-26 18:01:08Z

1

As Quang noted you're not parsing your Mac OS path correctly, but what if the file does not truly exists or you make an error in future? it's not good to let your whole program crash because of this hiccup.

It's good practice to handle your errors or write code that can anticpiate them, lets try a While loop and test if a file exists using pathlib.

from Pathlib import Path 

while True:
    path = input("insert file name (and path): ")

    if Path(path).is_file():
        break
    print(f'{path} is not a valid file_path, please try again.')
    print(f"A valid example of your systems file path is: {Path.cwd()}")

Test.

insert file name (and path): test.csv
test.csv is not a valid file_path, please try again.
A valid example of your systems file path is: C:\Users\datanovice

edited May 26, 2020 at 18:01

answered May 26, 2020 at 17:32

Umar.H

23.1k7 gold badges50 silver badges94 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Problem loading .csv file with full path with Pandas

1 Answer 1

Test.

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Test.

Comments

Your Answer

Sign up or log in

Post as a guest

Related