从一个位置读取PY文件，并点PDF作者到另一个位置

发布于 2025-02-03 10:40:50 字数 984 浏览 2 评论 0原文

我有一个更长的代码，该代码从一个位置运行，此片段试图在原始文件夹位置寻找信息，而当我想查看其他地方。

这是从Excel读取的，并创建行内容的PDF文件，每个列一个文件。当数据与excel文件位于同一文件夹中时，它在哪里查看列数据的位置。

如果我将行数据“ file1/pdf”等移到文件夹中，我可以修复错误并运行。我的错误：filenotfounderror：[errno 2]没有这样的文件或目录：'file1.pdf'

我的dataframe：

        mod1       mod2       mod3       mod4       mod5
0  File1.pdf  File3.pdf  File1.pdf  File7.pdf  File3.pdf
1  File2.pdf        NaN  File2.pdf        NaN  File3.pdf
2  File3.pdf        NaN        NaN        NaN        NaN

    def merge_pdf(models):
        df = pd.read_excel(r'directory of excel', sheet_name='materials')
        df = df.stack().add('.pdf').unstack()
        num = '123456'
        for header in models:
            merger = PdfFileMerger()
            for index, row in df.iterrows():
                if type(row[header]) == str:
                    merger.append(row[header])
            merger.write(f"#{num} ({header}).pdf")
            merger.close()

原文

I have a longer code which is ran from one location, and this snippet tries to look for information that's in the original folder location, when I'd like to it look somewhere else.

What this does is read from an excel and create PDF files of the row content, one file per column.
Where it looks for the column data it's trying to look in the parent folder, when the data is in the same folder as the excel file.

I can fix the error and have it run if I move the row data "File1/pdf" etc. to the folder the py file is in.
My error: FileNotFoundError: [Errno 2] No such file or directory: 'File1.pdf'

My dataframe:

        mod1       mod2       mod3       mod4       mod5
0  File1.pdf  File3.pdf  File1.pdf  File7.pdf  File3.pdf
1  File2.pdf        NaN  File2.pdf        NaN  File3.pdf
2  File3.pdf        NaN        NaN        NaN        NaN

    def merge_pdf(models):
        df = pd.read_excel(r'directory of excel', sheet_name='materials')
        df = df.stack().add('.pdf').unstack()
        num = '123456'
        for header in models:
            merger = PdfFileMerger()
            for index, row in df.iterrows():
                if type(row[header]) == str:
                    merger.append(row[header])
            merger.write(f"#{num} ({header}).pdf")
            merger.close()

分享到QQ

分享到微博