Testing file to read data from gas ebcdic file to pandas dataframes

mlbelobraydi / TXRRC_data_harvest

Script for accessing and organizing oil and gas well data from the Texas Railroad Commission

The Unlicense

32 stars 18 forks source link

Testing file to read data from gas ebcdic file to pandas dataframes #24

Open mlbelobraydi opened 4 years ago

mlbelobraydi commented 4 years ago

An initial notebook and working file have been created for the oil and gas layouts. These need to be vetted and tested to ensure the data grabbed from their respective files are getting good data.

bgilbert5 commented 3 years ago

Hi, looks like a great project, its a shame they converted from FTP. Did you ever have any luck on this EBCDIC conversion? Thanks!

mlbelobraydi commented 3 years ago

The files are still available here: https://www.rrc.texas.gov/resource-center/research/data-sets-available-for-download/, but it does look like it has been reorganized.

The EBCDIC conversions are in the notebooks and are working for the well bore and production files. The layouts make it possible to move from the file to something that can be entered into tables for use.