Overview

Automated Workflow for Processing PDF Files into Structured Database

This workflow is designed to extract key information from raw PDF files, including tables and graphs.

Objective:

Extracting key information, such as tables and graphs, from raw PDF files.

Workflow:

• Use OCR software to convert PDF files to text format.
• Extract key information, such as tables and graphs, from the text files. (Extracting depth and oil show in drilling report)
• Convert the extracted information into structured data formats, such as CSV or Excel.
• Write process log, create specific folders for old mudlog files & processed mudlog files
• Visualize the data using data visualization tools, such as Tableau, PowerBI, Looker, or Spotfire.

This automated workflow can save time and improve accuracy when processing large amounts of PDF files for data extraction and analysis.