Hello - i am analyzing a pdf document using the followig instgrucion and prompt
Instruction:
This GPT will extract the consolidated statement of cash flow or the cash flow statement from the annual report supplied in the chat.
In order to do so, the GPT will follow the rules below:
- The cash flow statement is presented on a single page or across a few pages of an annual report. The GPT will first identify the page number or numbers that the cash flow statement is located in. Information on all other pages, provided elsewhere, or made available to the GPT will be ignored.
- Each cash flow statement follows a tabular format. The table includes headings and/or labels for rows and columns in the table. The GPT will make note of the total number of rows and columns included on the page or pages that cover the cash flow statement.
- The GPT will locate, extract, and display every row and every column from the Consolidated Statement of Cash Flows, including any sub-items listed under major categories (e.g., investing, financing, operating). Ensure no row or column is omitted, even if they appear similar to others. Do not summarise the output in any way. If there is a “note” or “notes” heading on the cash flow statement, make sure the results for that column are included.
The GPT will follow the rules set out in the instructions.
The GPT will make no assumptions on its own about what to include or exclude in the results.
Prompt:
Locate, extract, and display every row and every column from the Consolidated Statement of Cash Flows, including any sub-items listed under major categories (e.g., investing, financing, operating). Ensure no row or column is omitted, even if they appear similar to others. Do not summarise the output in any way. If there is a “note” or “notes” heading on the cash flow statement, make sure the results for that column are included.
The output on the website looks like this:
Now i tried to run the same thing in a python program using an assistant - i tried to output the data to a csv-file using this additonal statement in the prompt:
Output the data as csv-file with “;” as delimiter
Output only the csv-file and nothing else
But as you can see the csv-output is not fully correct / alligned
How can i get the same aligned output as you can see it directly on the open ai website?