Data cleaning methodology for monthly water-to-oil and water-to-gas production ratios in continuous resource assessments

Open-File Report 2016-1204
By: , and 

Links

Abstract

Petroleum production data are usually stored in a format that makes it easy to determine the year and month production started, if there are any breaks, and when production ends. However, in some cases, you may want to compare production runs where the start of production for all wells starts at month one regardless of the year the wells started producing. This report describes the JAVA program the U.S. Geological Survey developed to examine water-to-oil and water-to-gas ratios in the form of month 1, month 2, and so on with the objective of estimating quantities of water and proppant used in low-permeability petroleum production. The text covers the data used by the program, the challenges with production data, the program logic for checking the quality of the production data, and the program logic for checking the completeness of the data.

Suggested Citation

Varela, B.A., Haines, S.S., and Gianoutsos, N.J., 2017, Data cleaning methodology for monthly water-to-oil and water-to-gas production ratios in continuous resource assessments: U.S. Geological Survey Open-File Report 2016–1204, 11 p., https://doi.org/10.3133/ofr20161204.

ISSN: 2331-1258 (online)

Table of Contents

  • Abstract
  • Introduction
  • Variations in Data Sources
  • Difficulties and Challenges of Disordered Data
  • Data Cleaning Strategy
  • Cleaning Algorithm
  • Checking Completeness of Water-to-Oil/Gas Calculation
  • Summary
  • References

Additional publication details

Publication type Report
Publication Subtype USGS Numbered Series
Title Data cleaning methodology for monthly water-to-oil and water-to-gas production ratios in continuous resource assessments
Series title Open-File Report
Series number 2016-1204
DOI 10.3133/ofr20161204
Year Published 2017
Language English
Publisher U.S. Geological Survey
Publisher location Reston, VA
Contributing office(s) Central Energy Resources Science Center
Description Report: ii, 11 p.; Data Release
Online Only (Y/N) Y