We have a new package available to help with all your scientific needs! PyleoTUPS will help you query data from NOAA NCEI and PANGAEA and process them in a format useful for downstream applications through Pandas.
More information here: PyleoTUPS: Automated Paleoclimate Data Extraction and Processing — PyleoTUPS 1.1.0 documentation
And check this blog post to learn more about the package: https://medium.com/cyberpaleo/accessing-noaa-and-pangaea-paleoclimate-data-has-never-been-easier-a0d06f2ab659