来自 python 目录的 Pandas.read_csv 文件

Question

我需要在python中读取_csv文件，哪个文件在 UPLOAD_FOLDERFileNotFoundError: [Errno 2] File b'../bpe.csv' does not exist:这是代码：def get_uploads():    """gets the images and other files from the uploads directory    and returns two lists of tuples in the form (name, path)    """    others = []    uploads = os.listdir(os.path.join(app.root_path, app.config['UPLOAD_FOLDER']))    # sort by time last modified    uploads.sort(key=lambda filename: os.stat(os.path.join(app.root_path, app.config['UPLOAD_FOLDER'], filename)).st_mtime)    for upload in uploads[::-1]:        others.append(( upload))    print(others)    for i in others:        if i=='bpe.csv':            databpe=i        if  i=='ch.csv':            datach=i    if databpe and  datach:        df=pandas.read_csv(databpe)        ch=pandas.read_csv(datach)        flash("check desktop","success")    return render_template("page3.html")

Answer 1

os.listdir返回相对路径。所以一个最小的修复是：

    df=pandas.read_csv(os.path.join(app.root_path, app.config['UPLOAD_FOLDER'], databpe))

    ch=pandas.read_csv(os.path.join(app.root_path, app.config['UPLOAD_FOLDER'], datach))

更好的重构是：

def get_uploads():

    databpe_path = os.path.join(app.root_path, app.config['UPLOAD_FOLDER'], 'bpe.csv')

    datach_path = os.path.join(app.root_path, app.config['UPLOAD_FOLDER'], 'ch.csv')

    if os.path.isfile(databpe_path) and os.path.isfile(datach_path):

        df=pandas.read_csv(databpe_path)

        ch=pandas.read_csv(datach_path)

        flash("check desktop","success")

    return render_template("page3.html")