Food Environment Atlas (USDA)

The current version of the Food Environment Atlas has over 275 variables, including new indicators on access and proximity to a grocery store for sub populations; an indicator on the SNAP Combined Application Project for recipients of Supplemental Security Income (at the State level); and indicators on farmers’ markets that report accepting credit cards or report selling baked and prepared food products. All of the data included in the Atlas are aggregated into an Excel spreadsheet for easy download. These data are from a variety of sources and cover varying years and geographic levels. The documentation for each version of the data provides complete information on definitions and data sources.

import pandas as pd

# After downloading the excel file.
df = pd.read_excel('August2015.xls', sheet_name='PRICES_TAXES')

# See the 10 counties with the highest soda price.
df.sort_values('SODA_PRICE10'
         , ascending=False).head(10)[['State', 'County', 'SODA_PRICE10']]

library(xlsx)

# After downloading the excel file.
df <- read.xlsx("August2015.xls", sheetName = "PRICES_TAXES")

# See the 10 counties with the highest soda price.
head(df[order(df$SODA_PRICE10, decreasing = TRUE)
  , c("State", "County", "SODA_PRICE10")], 10)