Tracking Exercise Data Trends with NHANES

Posted on Feb 11, 2017
The skills the author demoed here can be learned through taking Data Science with Machine Learning bootcamp with NYC Data Science Academy.
Contributed by Thomas Kassel. He is currently enrolled in the NYC Data Science Academy remote bootcamp program taking place from January-May 2017. This post is based on his second class project, Shiny, focusing on the creation of an interactive web application using the Shiny package in R.

Introduction

About NHANES

The National Health and Nutrition Examination Survey (NHANES) is one of the foremost assessments of health data statistics for children and adults in the United States. Sponsored by the Centers for Disease Control, NHANES combines interviews with physical examinations and laboratory tests for approximately 5,000 Americans each year. Results are compiled, anonymized and made publicly available at the program’s website on a rolling basis. These datasets are a major source of information for further studies ranging from simple national averages for physiological measurements (height or weight) to epidemiological trends for public health policy reform.

American Health Stats App

The 2013-2014 NHANES publication is made accessible through a Shiny application, providing an interactive environment for users to explore data trends. Because of the wide range of information gathered by the survey, the app focuses on a subset of the findings, drawing particular attention to the prevalence of exercise and associated health outcomes across demographic groups.

To use the live application, navigate here.

Tracking Exercise Data Trends with NHANES

Data

NHANES divides results into many separate tables for more manageable file download sizes. The app makes use of the following datasets (including but not limited to):

  • Demographics – gender, age, ethnicity, education, annual household income, household size
  • Exercise – minutes of various forms of physical activity per day
  • Examination/Laboratory – physiological measurements

The common field across tables is the sequence ID, a unique identifier for each survey participant which can be used for joining operations across any/all tables. Let’s take a look at the initial raw data import of many NHANES tables and an example dplyr left_join operation to quickly aggregate information by survey participant.

Data Exploration

The app is meant to be used as a starting point to explore high-level trends in the latest NHANES survey publication. It is recommended, however, that the program's survey methods and analytic guidelines be followed in order to draw any robust statistical conclusions from the underlying sample data.

What demographic cohorts are covered by NHANES?

The “Overview & Demographics” tab allows users to explore this question. NHANES appears to be a nationally representative sample of the U.S. population across gender, education level and income. However, certain sub-populations are more heavily represented, such as youths under 18 still undergoing much of their physiological development and at therefore at higher focus for many public health concerns.

Tracking Exercise Data Trends with NHANES

Which populations regularly engage in physical activity?

The “Explore Exercise Trends” tab provides exploratory visualization of who is getting exercise, in what form and amount, and the possible health outcomes associated. Density curves help to illustrate exercise trends and confirm preconceptions about some of the grouping (i.e. demographic) variables involved in those trends.

Below we observe that, with each drop in level of education – from college/advanced graduate down to high school dropout – the density curve’s average moves from left to right. This implies a direct inverse relationship between minutes per day conducting “vigorous or moderate” physical activity at the workplace, i.e. manual labor, and education.

Tracking Exercise Data Trends with NHANES

What health outcomes correlate with physical activity?

Minutes per day of physical activity – whether in the workplace, recreationally; vigorous, moderate or otherwise – are used as the predictor variable in a scatterplot to explore correlations with a variety of health outcomes such as weight, BMI, cholesterol, or blood pressure.

Tracking Exercise Data Trends with NHANES

Above we observe a clear negative correlation between resting pulse (bpm) and average minutes per day of vigorous recreational activity. Through the use of the interactive graphing package Plotly, we gain further information from mouseover tooltips in this visual: among participants getting an average 180 minutes of exercise per day, none had a resting pulse of over 98 bpm.

Other relationships explored, such as cholesterol levels versus exercise habits, highlight the limitations of taking a bivariate approach in predicting health outcomes. For example, we might assume a negative correlation between amount of exercise and LDL cholesterol levels, but in the case below we observe this correlation to actually be positive. This suggests the study could benefit from other known associations to cholesterol, such as diet (perhaps individuals with moderate-exercise jobs tend to have higher-cholesterol diets) and genetic disposition.

Cholesterol

Next Steps

As alluded to in the previous section, inclusion of more variables from the original NHANES dataset and the use of formal statistical methods could help to tell a more comprehensive story about the program data. Chief among these would be an exploration of dietary/nutritional and lifestyle habits (e.g. smoking, drug use), since NHANES has collected that data for each participant. As NHANES is an ongoing and continuously developing program, there is further potential to track the movement of these health trends over time in the general U.S. population.

About Author

Thomas Kassel

Thomas completed a B.A. at Wesleyan University, focusing on molecular neuroscience while completing additional coursework in math and economics. After transitioning from the life sciences into the field of clean technology he joined his current firm, energy efficiency...
View all posts by Thomas Kassel >

Related Articles

Leave a Comment

Tracking Exercise Trends with NHANES — RSS ленты February 16, 2017
[…] article was first published on R – NYC Data Science Academy Blog, and kindly contributed to […]
anthony damico February 12, 2017
hi thomas, i don't see any mentions of the survey library? if you want to track changes over time, or statistically significant differences by educational attainment, or correlations between exercise and health metrics, then you need to calculate standard errors, confidence intervals, and other measures of variance the way that the CDC specifies. nhanes requires more than just weights to be analyzed correctly. here are examples: https://github.com/ajdamico/asdfree/tree/master/National%20Health%20and%20Nutrition%20Examination%20Survey by the way, easier to import nhanes into R with library(devtools) install_github("ajdamico/lodown") library(lodown) # National Health & Nutrition Examination Survey # download all available microdata lodown( "nhanes" , output_dir = "C:/My Directory/NHANES" ) # download only the 2013-2014 files nhanes_cat <- get_catalog( "nhanes" , output_dir = "C:/My Directory/NHANES" ) lodown( "nhanes" , nhanes_cat[ nhanes_cat$years == "2013-2014" , ] )

View Posts by Categories


Our Recent Popular Posts


View Posts by Tags

#python #trainwithnycdsa 2019 2020 Revenue 3-points agriculture air quality airbnb airline alcohol Alex Baransky algorithm alumni Alumni Interview Alumni Reviews Alumni Spotlight alumni story Alumnus ames dataset ames housing dataset apartment rent API Application artist aws bank loans beautiful soup Best Bootcamp Best Data Science 2019 Best Data Science Bootcamp Best Data Science Bootcamp 2020 Best Ranked Big Data Book Launch Book-Signing bootcamp Bootcamp Alumni Bootcamp Prep boston safety Bundles cake recipe California Cancer Research capstone car price Career Career Day citibike classic cars classpass clustering Coding Course Demo Course Report covid 19 credit credit card crime frequency crops D3.js data data analysis Data Analyst data analytics data for tripadvisor reviews data science Data Science Academy Data Science Bootcamp Data science jobs Data Science Reviews Data Scientist Data Scientist Jobs data visualization database Deep Learning Demo Day Discount disney dplyr drug data e-commerce economy employee employee burnout employer networking environment feature engineering Finance Financial Data Science fitness studio Flask flight delay gbm Get Hired ggplot2 googleVis H20 Hadoop hallmark holiday movie happiness healthcare frauds higgs boson Hiring hiring partner events Hiring Partners hotels housing housing data housing predictions housing price hy-vee Income Industry Experts Injuries Instructor Blog Instructor Interview insurance italki Job Job Placement Jobs Jon Krohn JP Morgan Chase Kaggle Kickstarter las vegas airport lasso regression Lead Data Scienctist Lead Data Scientist leaflet league linear regression Logistic Regression machine learning Maps market matplotlib Medical Research Meet the team meetup methal health miami beach movie music Napoli NBA netflix Networking neural network Neural networks New Courses NHL nlp NYC NYC Data Science nyc data science academy NYC Open Data nyc property NYCDSA NYCDSA Alumni Online Online Bootcamp Online Training Open Data painter pandas Part-time performance phoenix pollutants Portfolio Development precision measurement prediction Prework Programming public safety PwC python Python Data Analysis python machine learning python scrapy python web scraping python webscraping Python Workshop R R Data Analysis R language R Programming R Shiny r studio R Visualization R Workshop R-bloggers random forest Ranking recommendation recommendation system regression Remote remote data science bootcamp Scrapy scrapy visualization seaborn seafood type Selenium sentiment analysis sentiment classification Shiny Shiny Dashboard Spark Special Special Summer Sports statistics streaming Student Interview Student Showcase SVM Switchup Tableau teachers team team performance TensorFlow Testimonial tf-idf Top Data Science Bootcamp Top manufacturing companies Transfers tweets twitter videos visualization wallstreet wallstreetbets web scraping Weekend Course What to expect whiskey whiskeyadvocate wildfire word cloud word2vec XGBoost yelp youtube trending ZORI