<jupyter_start><jupyter_text>Here is an example of how to get access to all data  Connect to the NHANES data resource using the HPDS Adapter<jupyter_code>import PicSureHpdsLib
adapter = PicSureHpdsLib.BypassAdapter("http://pic-sure-hpds-nhanes:8080/PIC-SURE")
resource = adapter.useResource()<jupyter_output><empty_output><jupyter_text>Download all data dictionary items<jupyter_code>all_terms = resource.dictionary().find()
all_terms.keys()
all_terms.DataFrame()<jupyter_output><empty_output><jupyter_text>Get all subject records<jupyter_code>query = resource.query()
query.help()
query.select().add(all_terms.keys())
query.getResultsDataFrame()<jupyter_output>/opt/conda/lib/python3.6/site-packages/IPython/core/interactiveshell.py:2856: DtypeWarning: Columns (86,120,287,438,461,549,552,553,554,555,557,561,564,565,567,569,570,571,573,574,575,576,577,578,580,581,583,584,585,586,587,588,589,590,592,593,594,595,596,597,598,599,600,601,602,603,647,651,652,666,680,685,687,688,718,723,749,767,769,770,771,786,813,814,825,831,833,837,840,846,861,864,869,880,891,896,898,903,906,908,913,933,934,966,971,977,979,981,982,984,986,1006,1009,1010,1023,1034,1035,1036,1037,1038,1048,1049,1066,1068,1160,1161) have mixed types. Specify dtype option on import or set low_memory=False.
  if self.run_code(code, result):
{'fraction_non_alphanumeric': 0.15584415584415584, 'fraction_numerical': 0.2612681436210848, 'mean_word_length': 12.36734693877551, 'pattern_counts': {'":': 0, '<': 12, '<?xml version=': 0, '>': 12, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 1, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'chain_length': '3', 'dir': 'jupyter-structured-clean-dedup', 'id': '327169', 'license': 'Apache-2.0', 'n_tokens_mistral': 749, 'n_tokens_neox': 547, 'n_words': 58, 'path': 'Jupyter Notebook Examples/Python/HPDS/MISC - Download All Data.ipynb', 'repo_name': 'hms-dbmi/PIC-SURE-2-Jupyter-Examples', 'size': '1309'}