Data Visualization

Author

Robert W. Walker

Published

January 27, 2026

Today, we introduce data visualization.

Our reading for today includes a section of Open Intro Stats and a primer on data types.

In the text book, we will pay extra attention to sections 1, 3, and 5.2.

Five bits of data

Bond Funds

  • Fund Number: An ID.
  • Type: Intermediate Government or Short-term Corporate.
  • Assets: Assets held by the fund in reported dollars.
  • Fees: Are management fees assessed? [Yes/No].
  • Expense Ratio: Ratio of operating expenses to fund assets.
  • Returns [for the year 2009, trailing 3 year and 5 year (from 2009)].
  • The Morningstar risk classification [Below average, average, and above average].
How’s that done? 
library(jsonlite)
BondFunds <- read.csv("./data/BondFunds.csv")

The JSON

Rows

How’s that done? 
toJSON(BondFunds, dataframe = "rows")
[{"Fund.Number":"FN-1","Type":"Intermediate Government","Assets":7268.1,"Fees":"No","Expense.Ratio":0.45,"Return.2009":6.9,"X3.Year.Return":6.9,"X5.Year.Return":5.5,"Risk":"Below average"},{"Fund.Number":"FN-2","Type":"Intermediate Government","Assets":475.1,"Fees":"No","Expense.Ratio":0.5,"Return.2009":9.8,"X3.Year.Return":7.5,"X5.Year.Return":6.1,"Risk":"Below average"},{"Fund.Number":"FN-3","Type":"Intermediate Government","Assets":193,"Fees":"No","Expense.Ratio":0.71,"Return.2009":6.3,"X3.Year.Return":7,"X5.Year.Return":5.6,"Risk":"Average"},{"Fund.Number":"FN-4","Type":"Intermediate Government","Assets":18603.5,"Fees":"No","Expense.Ratio":0.13,"Return.2009":5.4,"X3.Year.Return":6.6,"X5.Year.Return":5.5,"Risk":"Average"},{"Fund.Number":"FN-5","Type":"Intermediate Government","Assets":142.6,"Fees":"No","Expense.Ratio":0.6,"Return.2009":5.9,"X3.Year.Return":6.7,"X5.Year.Return":5.4,"Risk":"Average"},{"Fund.Number":"FN-6","Type":"Intermediate Government","Assets":1401.6,"Fees":"No","Expense.Ratio":0.54,"Return.2009":5.7,"X3.Year.Return":6.4,"X5.Year.Return":6.2,"Risk":"Average"},{"Fund.Number":"FN-7","Type":"Intermediate Government","Assets":985.6,"Fees":"No","Expense.Ratio":0.49,"Return.2009":3,"X3.Year.Return":6.8,"X5.Year.Return":5.3,"Risk":"Average"},{"Fund.Number":"FN-8","Type":"Intermediate Government","Assets":2188.8,"Fees":"No","Expense.Ratio":0.55,"Return.2009":7.4,"X3.Year.Return":6.4,"X5.Year.Return":5.2,"Risk":"Below average"},{"Fund.Number":"FN-9","Type":"Intermediate Government","Assets":390.6,"Fees":"No","Expense.Ratio":0.67,"Return.2009":5.3,"X3.Year.Return":6.1,"X5.Year.Return":5,"Risk":"Below average"},{"Fund.Number":"FN-10","Type":"Intermediate Government","Assets":544.1,"Fees":"No","Expense.Ratio":0.63,"Return.2009":5.7,"X3.Year.Return":6.2,"X5.Year.Return":5.1,"Risk":"Below average"},{"Fund.Number":"FN-11","Type":"Intermediate Government","Assets":1407.4,"Fees":"No","Expense.Ratio":0.45,"Return.2009":0.9,"X3.Year.Return":6.2,"X5.Year.Return":4.7,"Risk":"Average"},{"Fund.Number":"FN-12","Type":"Intermediate Government","Assets":155.5,"Fees":"No","Expense.Ratio":0.91,"Return.2009":12.4,"X3.Year.Return":6.4,"X5.Year.Return":5.1,"Risk":"Below average"},{"Fund.Number":"FN-13","Type":"Intermediate Government","Assets":397.5,"Fees":"No","Expense.Ratio":0.6,"Return.2009":6,"X3.Year.Return":6.3,"X5.Year.Return":5.1,"Risk":"Below average"},{"Fund.Number":"FN-14","Type":"Intermediate Government","Assets":906.1,"Fees":"No","Expense.Ratio":0.51,"Return.2009":8.1,"X3.Year.Return":6.1,"X5.Year.Return":5.1,"Risk":"Below average"},{"Fund.Number":"FN-15","Type":"Intermediate Government","Assets":379.1,"Fees":"No","Expense.Ratio":0.57,"Return.2009":5.7,"X3.Year.Return":6.6,"X5.Year.Return":5.2,"Risk":"Below average"},{"Fund.Number":"FN-16","Type":"Intermediate Government","Assets":62.7,"Fees":"No","Expense.Ratio":0.74,"Return.2009":4.5,"X3.Year.Return":7.8,"X5.Year.Return":5.6,"Risk":"Above average"},{"Fund.Number":"FN-17","Type":"Intermediate Government","Assets":1539.1,"Fees":"No","Expense.Ratio":0.66,"Return.2009":6.4,"X3.Year.Return":6.2,"X5.Year.Return":5,"Risk":"Below average"},{"Fund.Number":"FN-18","Type":"Intermediate Government","Assets":167.3,"Fees":"No","Expense.Ratio":0.6,"Return.2009":5.8,"X3.Year.Return":6.2,"X5.Year.Return":5.1,"Risk":"Below average"},{"Fund.Number":"FN-19","Type":"Intermediate Government","Assets":448,"Fees":"No","Expense.Ratio":0.77,"Return.2009":10.1,"X3.Year.Return":6.5,"X5.Year.Return":5.3,"Risk":"Below average"},{"Fund.Number":"FN-20","Type":"Intermediate Government","Assets":238.1,"Fees":"No","Expense.Ratio":1.13,"Return.2009":4.4,"X3.Year.Return":5.5,"X5.Year.Return":4.3,"Risk":"Below average"},{"Fund.Number":"FN-21","Type":"Intermediate Government","Assets":557.8,"Fees":"No","Expense.Ratio":0.74,"Return.2009":9,"X3.Year.Return":6,"X5.Year.Return":4.9,"Risk":"Below average"},{"Fund.Number":"FN-22","Type":"Intermediate Government","Assets":192.7,"Fees":"No","Expense.Ratio":0.7,"Return.2009":3.2,"X3.Year.Return":6,"X5.Year.Return":4.9,"Risk":"Average"},{"Fund.Number":"FN-23","Type":"Intermediate Government","Assets":261.8,"Fees":"Yes","Expense.Ratio":1.08,"Return.2009":3.5,"X3.Year.Return":5.1,"X5.Year.Return":4,"Risk":"Below average"},{"Fund.Number":"FN-24","Type":"Intermediate Government","Assets":135.8,"Fees":"No","Expense.Ratio":0.65,"Return.2009":-1.1,"X3.Year.Return":6,"X5.Year.Return":4.6,"Risk":"Average"},{"Fund.Number":"FN-25","Type":"Intermediate Government","Assets":1807.3,"Fees":"Yes","Expense.Ratio":0.8,"Return.2009":7.8,"X3.Year.Return":6.1,"X5.Year.Return":4.9,"Risk":"Average"},{"Fund.Number":"FN-26","Type":"Intermediate Government","Assets":4615.4,"Fees":"No","Expense.Ratio":0.45,"Return.2009":1.3,"X3.Year.Return":6.7,"X5.Year.Return":5.2,"Risk":"Above average"},{"Fund.Number":"FN-27","Type":"Intermediate Government","Assets":86.2,"Fees":"No","Expense.Ratio":0.61,"Return.2009":-0.2,"X3.Year.Return":5.6,"X5.Year.Return":4.4,"Risk":"Average"},{"Fund.Number":"FN-28","Type":"Intermediate Government","Assets":291.1,"Fees":"Yes","Expense.Ratio":1.1,"Return.2009":5.1,"X3.Year.Return":5.8,"X5.Year.Return":4.6,"Risk":"Below average"},{"Fund.Number":"FN-29","Type":"Intermediate Government","Assets":6332.5,"Fees":"Yes","Expense.Ratio":0.73,"Return.2009":4.8,"X3.Year.Return":6,"X5.Year.Return":4.9,"Risk":"Below average"},{"Fund.Number":"FN-30","Type":"Intermediate Government","Assets":110.7,"Fees":"No","Expense.Ratio":1.08,"Return.2009":1.9,"X3.Year.Return":5.4,"X5.Year.Return":4.2,"Risk":"Average"},{"Fund.Number":"FN-31","Type":"Intermediate Government","Assets":619.7,"Fees":"Yes","Expense.Ratio":0.96,"Return.2009":5,"X3.Year.Return":5.9,"X5.Year.Return":4.9,"Risk":"Average"},{"Fund.Number":"FN-32","Type":"Intermediate Government","Assets":628.7,"Fees":"No","Expense.Ratio":0.55,"Return.2009":2.1,"X3.Year.Return":6.3,"X5.Year.Return":5.1,"Risk":"Above average"},{"Fund.Number":"FN-33","Type":"Intermediate Government","Assets":274.3,"Fees":"No","Expense.Ratio":0.8,"Return.2009":12.7,"X3.Year.Return":6.1,"X5.Year.Return":5,"Risk":"Average"},{"Fund.Number":"FN-34","Type":"Intermediate Government","Assets":891.8,"Fees":"Yes","Expense.Ratio":0.88,"Return.2009":4.2,"X3.Year.Return":6.6,"X5.Year.Return":5.1,"Risk":"Average"},{"Fund.Number":"FN-35","Type":"Intermediate Government","Assets":94.7,"Fees":"Yes","Expense.Ratio":0.83,"Return.2009":3.5,"X3.Year.Return":6.4,"X5.Year.Return":5.1,"Risk":"Average"},{"Fund.Number":"FN-36","Type":"Intermediate Government","Assets":676.3,"Fees":"Yes","Expense.Ratio":0.93,"Return.2009":22.3,"X3.Year.Return":9.4,"X5.Year.Return":6.4,"Risk":"Above average"},{"Fund.Number":"FN-37","Type":"Intermediate Government","Assets":1182.1,"Fees":"Yes","Expense.Ratio":0.92,"Return.2009":28.6,"X3.Year.Return":9.4,"X5.Year.Return":6.8,"Risk":"Above average"},{"Fund.Number":"FN-38","Type":"Intermediate Government","Assets":135.9,"Fees":"No","Expense.Ratio":0.47,"Return.2009":13,"X3.Year.Return":5.1,"X5.Year.Return":4.5,"Risk":"Below average"},{"Fund.Number":"FN-39","Type":"Intermediate Government","Assets":588.8,"Fees":"Yes","Expense.Ratio":0.96,"Return.2009":5.2,"X3.Year.Return":6.7,"X5.Year.Return":5.3,"Risk":"Average"},{"Fund.Number":"FN-40","Type":"Intermediate Government","Assets":40,"Fees":"No","Expense.Ratio":1.94,"Return.2009":17.1,"X3.Year.Return":6.6,"X5.Year.Return":5.1,"Risk":"Above average"},{"Fund.Number":"FN-41","Type":"Intermediate Government","Assets":1080.4,"Fees":"No","Expense.Ratio":0.95,"Return.2009":3.5,"X3.Year.Return":6,"X5.Year.Return":4.7,"Risk":"Average"},{"Fund.Number":"FN-42","Type":"Intermediate Government","Assets":309.1,"Fees":"Yes","Expense.Ratio":0.98,"Return.2009":0,"X3.Year.Return":5.8,"X5.Year.Return":4.4,"Risk":"Above average"},{"Fund.Number":"FN-43","Type":"Intermediate Government","Assets":4472.2,"Fees":"Yes","Expense.Ratio":0.64,"Return.2009":2.2,"X3.Year.Return":5.5,"X5.Year.Return":4.4,"Risk":"Average"},{"Fund.Number":"FN-44","Type":"Intermediate Government","Assets":498.7,"Fees":"Yes","Expense.Ratio":0.95,"Return.2009":0.9,"X3.Year.Return":4.9,"X5.Year.Return":4.1,"Risk":"Above average"},{"Fund.Number":"FN-45","Type":"Intermediate Government","Assets":278.2,"Fees":"No","Expense.Ratio":0.2,"Return.2009":-3.8,"X3.Year.Return":6,"X5.Year.Return":4.7,"Risk":"Above average"},{"Fund.Number":"FN-46","Type":"Intermediate Government","Assets":1525.5,"Fees":"No","Expense.Ratio":0.13,"Return.2009":-0.7,"X3.Year.Return":7.1,"X5.Year.Return":5.3,"Risk":"Above average"},{"Fund.Number":"FN-47","Type":"Intermediate Government","Assets":556.6,"Fees":"Yes","Expense.Ratio":0.94,"Return.2009":7.9,"X3.Year.Return":5.5,"X5.Year.Return":4.3,"Risk":"Above average"},{"Fund.Number":"FN-48","Type":"Intermediate Government","Assets":588.6,"Fees":"Yes","Expense.Ratio":0.96,"Return.2009":6.2,"X3.Year.Return":5.1,"X5.Year.Return":4.4,"Risk":"Below average"},{"Fund.Number":"FN-49","Type":"Intermediate Government","Assets":332.5,"Fees":"Yes","Expense.Ratio":1,"Return.2009":3.7,"X3.Year.Return":4.7,"X5.Year.Return":4,"Risk":"Average"},{"Fund.Number":"FN-50","Type":"Intermediate Government","Assets":84.9,"Fees":"No","Expense.Ratio":0.71,"Return.2009":11.2,"X3.Year.Return":3.9,"X5.Year.Return":3.7,"Risk":"Below average"},{"Fund.Number":"FN-51","Type":"Intermediate Government","Assets":17.3,"Fees":"No","Expense.Ratio":1.58,"Return.2009":2.1,"X3.Year.Return":4.9,"X5.Year.Return":3.7,"Risk":"Average"},{"Fund.Number":"FN-52","Type":"Intermediate Government","Assets":104.1,"Fees":"Yes","Expense.Ratio":0.95,"Return.2009":-3.6,"X3.Year.Return":4.7,"X5.Year.Return":3.7,"Risk":"Above average"},{"Fund.Number":"FN-53","Type":"Intermediate Government","Assets":530.7,"Fees":"Yes","Expense.Ratio":0.92,"Return.2009":4.6,"X3.Year.Return":5.5,"X5.Year.Return":4.5,"Risk":"Average"},{"Fund.Number":"FN-54","Type":"Intermediate Government","Assets":333.6,"Fees":"No","Expense.Ratio":0.37,"Return.2009":12,"X3.Year.Return":4.9,"X5.Year.Return":4.5,"Risk":"Above average"},{"Fund.Number":"FN-55","Type":"Intermediate Government","Assets":1133.3,"Fees":"No","Expense.Ratio":0.46,"Return.2009":3.4,"X3.Year.Return":2.3,"X5.Year.Return":2.5,"Risk":"Below average"},{"Fund.Number":"FN-56","Type":"Intermediate Government","Assets":322.5,"Fees":"Yes","Expense.Ratio":1.13,"Return.2009":4.7,"X3.Year.Return":5.6,"X5.Year.Return":4.4,"Risk":"Above average"},{"Fund.Number":"FN-57","Type":"Intermediate Government","Assets":123.8,"Fees":"No","Expense.Ratio":0.75,"Return.2009":6.4,"X3.Year.Return":3.3,"X5.Year.Return":3.2,"Risk":"Average"},{"Fund.Number":"FN-58","Type":"Intermediate Government","Assets":425.6,"Fees":"Yes","Expense.Ratio":0.97,"Return.2009":9.1,"X3.Year.Return":4.7,"X5.Year.Return":4.1,"Risk":"Below average"},{"Fund.Number":"FN-59","Type":"Intermediate Government","Assets":184.7,"Fees":"Yes","Expense.Ratio":1.03,"Return.2009":1.7,"X3.Year.Return":5.6,"X5.Year.Return":4.4,"Risk":"Above average"},{"Fund.Number":"FN-60","Type":"Intermediate Government","Assets":122.7,"Fees":"No","Expense.Ratio":0.26,"Return.2009":-3.6,"X3.Year.Return":6.1,"X5.Year.Return":4.7,"Risk":"Above average"},{"Fund.Number":"FN-61","Type":"Intermediate Government","Assets":107.2,"Fees":"No","Expense.Ratio":0.9,"Return.2009":0.1,"X3.Year.Return":5.3,"X5.Year.Return":4,"Risk":"Average"},{"Fund.Number":"FN-62","Type":"Intermediate Government","Assets":135.6,"Fees":"Yes","Expense.Ratio":1.15,"Return.2009":3.7,"X3.Year.Return":5.9,"X5.Year.Return":4.4,"Risk":"Average"},{"Fund.Number":"FN-63","Type":"Intermediate Government","Assets":82.2,"Fees":"No","Expense.Ratio":0.57,"Return.2009":-3.3,"X3.Year.Return":5.1,"X5.Year.Return":4.2,"Risk":"Above average"},{"Fund.Number":"FN-64","Type":"Intermediate Government","Assets":305.7,"Fees":"Yes","Expense.Ratio":0.99,"Return.2009":3,"X3.Year.Return":6.2,"X5.Year.Return":4.9,"Risk":"Above average"},{"Fund.Number":"FN-65","Type":"Intermediate Government","Assets":551.3,"Fees":"No","Expense.Ratio":0.52,"Return.2009":-1.4,"X3.Year.Return":7.3,"X5.Year.Return":5.2,"Risk":"Above average"},{"Fund.Number":"FN-66","Type":"Intermediate Government","Assets":24.2,"Fees":"No","Expense.Ratio":0.52,"Return.2009":0.7,"X3.Year.Return":-0.1,"X5.Year.Return":1.2,"Risk":"Above average"},{"Fund.Number":"FN-67","Type":"Intermediate Government","Assets":661.2,"Fees":"Yes","Expense.Ratio":0.97,"Return.2009":0,"X3.Year.Return":3.2,"X5.Year.Return":3,"Risk":"Above average"},{"Fund.Number":"FN-68","Type":"Intermediate Government","Assets":154.6,"Fees":"Yes","Expense.Ratio":0.9,"Return.2009":2.9,"X3.Year.Return":2.4,"X5.Year.Return":2.6,"Risk":"Average"},{"Fund.Number":"FN-69","Type":"Intermediate Government","Assets":106.9,"Fees":"Yes","Expense.Ratio":0.79,"Return.2009":-4.8,"X3.Year.Return":5.6,"X5.Year.Return":4.6,"Risk":"Above average"},{"Fund.Number":"FN-70","Type":"Intermediate Government","Assets":1011.1,"Fees":"Yes","Expense.Ratio":0.87,"Return.2009":1.4,"X3.Year.Return":1.6,"X5.Year.Return":2.3,"Risk":"Average"},{"Fund.Number":"FN-71","Type":"Intermediate Government","Assets":634.8,"Fees":"Yes","Expense.Ratio":0.9,"Return.2009":7.3,"X3.Year.Return":3.7,"X5.Year.Return":3.4,"Risk":"Above average"},{"Fund.Number":"FN-72","Type":"Intermediate Government","Assets":168.7,"Fees":"Yes","Expense.Ratio":0.99,"Return.2009":-2.9,"X3.Year.Return":6,"X5.Year.Return":4.1,"Risk":"Above average"},{"Fund.Number":"FN-73","Type":"Intermediate Government","Assets":792.1,"Fees":"Yes","Expense.Ratio":1,"Return.2009":1.2,"X3.Year.Return":2.3,"X5.Year.Return":2.6,"Risk":"Above average"},{"Fund.Number":"FN-74","Type":"Intermediate Government","Assets":583.5,"Fees":"No","Expense.Ratio":0.5,"Return.2009":6,"X3.Year.Return":7.3,"X5.Year.Return":5.7,"Risk":"Average"},{"Fund.Number":"FN-75","Type":"Intermediate Government","Assets":56.1,"Fees":"No","Expense.Ratio":0.65,"Return.2009":0.7,"X3.Year.Return":5.2,"X5.Year.Return":4.4,"Risk":"Average"},{"Fund.Number":"FN-76","Type":"Intermediate Government","Assets":285.5,"Fees":"No","Expense.Ratio":0.36,"Return.2009":7.1,"X3.Year.Return":5.5,"X5.Year.Return":4.8,"Risk":"Below average"},{"Fund.Number":"FN-77","Type":"Intermediate Government","Assets":640.3,"Fees":"No","Expense.Ratio":0.27,"Return.2009":0.2,"X3.Year.Return":6.5,"X5.Year.Return":5.2,"Risk":"Above average"},{"Fund.Number":"FN-78","Type":"Intermediate Government","Assets":84.7,"Fees":"Yes","Expense.Ratio":1,"Return.2009":-0.6,"X3.Year.Return":2.5,"X5.Year.Return":2.5,"Risk":"Average"},{"Fund.Number":"FN-79","Type":"Intermediate Government","Assets":81.3,"Fees":"Yes","Expense.Ratio":1.16,"Return.2009":7,"X3.Year.Return":1,"X5.Year.Return":1.7,"Risk":"Above average"},{"Fund.Number":"FN-80","Type":"Intermediate Government","Assets":611.7,"Fees":"No","Expense.Ratio":0.51,"Return.2009":6.5,"X3.Year.Return":6.8,"X5.Year.Return":5.5,"Risk":"Average"},{"Fund.Number":"FN-81","Type":"Intermediate Government","Assets":595.1,"Fees":"No","Expense.Ratio":0.55,"Return.2009":5.5,"X3.Year.Return":6.3,"X5.Year.Return":5.2,"Risk":"Below average"},{"Fund.Number":"FN-82","Type":"Intermediate Government","Assets":131.3,"Fees":"No","Expense.Ratio":0.65,"Return.2009":-3.8,"X3.Year.Return":4.4,"X5.Year.Return":3.8,"Risk":"Above average"},{"Fund.Number":"FN-83","Type":"Intermediate Government","Assets":88,"Fees":"No","Expense.Ratio":0.82,"Return.2009":2,"X3.Year.Return":5.8,"X5.Year.Return":4.5,"Risk":"Average"},{"Fund.Number":"FN-84","Type":"Intermediate Government","Assets":686.6,"Fees":"Yes","Expense.Ratio":0.94,"Return.2009":7.2,"X3.Year.Return":3.7,"X5.Year.Return":3.5,"Risk":"Below average"},{"Fund.Number":"FN-85","Type":"Intermediate Government","Assets":3531.8,"Fees":"No","Expense.Ratio":0.12,"Return.2009":-1.6,"X3.Year.Return":7.2,"X5.Year.Return":5.4,"Risk":"Above average"},{"Fund.Number":"FN-86","Type":"Intermediate Government","Assets":358,"Fees":"Yes","Expense.Ratio":1.06,"Return.2009":0.5,"X3.Year.Return":4.9,"X5.Year.Return":4,"Risk":"Average"},{"Fund.Number":"FN-87","Type":"Intermediate Government","Assets":33,"Fees":"No","Expense.Ratio":1,"Return.2009":0.2,"X3.Year.Return":6.1,"X5.Year.Return":4.8,"Risk":"Below average"},{"Fund.Number":"FN-88","Type":"Short Term Corporate","Assets":139.1,"Fees":"No","Expense.Ratio":0.51,"Return.2009":5.5,"X3.Year.Return":5.1,"X5.Year.Return":4.3,"Risk":"Below average"},{"Fund.Number":"FN-89","Type":"Short Term Corporate","Assets":123.9,"Fees":"No","Expense.Ratio":0.32,"Return.2009":5,"X3.Year.Return":4.4,"X5.Year.Return":4.1,"Risk":"Below average"},{"Fund.Number":"FN-90","Type":"Short Term Corporate","Assets":1922,"Fees":"Yes","Expense.Ratio":1.08,"Return.2009":12.1,"X3.Year.Return":5.5,"X5.Year.Return":5,"Risk":"Average"},{"Fund.Number":"FN-91","Type":"Short Term Corporate","Assets":203.4,"Fees":"Yes","Expense.Ratio":1,"Return.2009":8.3,"X3.Year.Return":5.2,"X5.Year.Return":4.4,"Risk":"Below average"},{"Fund.Number":"FN-92","Type":"Short Term Corporate","Assets":66.1,"Fees":"No","Expense.Ratio":0.71,"Return.2009":6.8,"X3.Year.Return":4.9,"X5.Year.Return":4,"Risk":"Below average"},{"Fund.Number":"FN-93","Type":"Short Term Corporate","Assets":1346,"Fees":"No","Expense.Ratio":0.65,"Return.2009":8.6,"X3.Year.Return":6.1,"X5.Year.Return":4.8,"Risk":"Below average"},{"Fund.Number":"FN-94","Type":"Short Term Corporate","Assets":4772.9,"Fees":"No","Expense.Ratio":0.56,"Return.2009":5,"X3.Year.Return":4.9,"X5.Year.Return":4.2,"Risk":"Below average"},{"Fund.Number":"FN-95","Type":"Short Term Corporate","Assets":77.5,"Fees":"No","Expense.Ratio":0.51,"Return.2009":2.2,"X3.Year.Return":3.7,"X5.Year.Return":3.5,"Risk":"Below average"},{"Fund.Number":"FN-96","Type":"Short Term Corporate","Assets":76.2,"Fees":"No","Expense.Ratio":0.68,"Return.2009":2.5,"X3.Year.Return":5.2,"X5.Year.Return":4.2,"Risk":"Below average"},{"Fund.Number":"FN-97","Type":"Short Term Corporate","Assets":146.3,"Fees":"No","Expense.Ratio":0.55,"Return.2009":12.2,"X3.Year.Return":5.8,"X5.Year.Return":4.8,"Risk":"Average"},{"Fund.Number":"FN-98","Type":"Short Term Corporate","Assets":49.2,"Fees":"No","Expense.Ratio":0.6,"Return.2009":10,"X3.Year.Return":5,"X5.Year.Return":4.6,"Risk":"Average"},{"Fund.Number":"FN-99","Type":"Short Term Corporate","Assets":96.1,"Fees":"No","Expense.Ratio":0.73,"Return.2009":7.3,"X3.Year.Return":4.8,"X5.Year.Return":4.1,"Risk":"Below average"},{"Fund.Number":"FN-100","Type":"Short Term Corporate","Assets":226.8,"Fees":"No","Expense.Ratio":0.45,"Return.2009":2.9,"X3.Year.Return":3.6,"X5.Year.Return":3.6,"Risk":"Below average"},{"Fund.Number":"FN-101","Type":"Short Term Corporate","Assets":122.3,"Fees":"No","Expense.Ratio":0.53,"Return.2009":7.3,"X3.Year.Return":5.9,"X5.Year.Return":4.6,"Risk":"Average"},{"Fund.Number":"FN-102","Type":"Short Term Corporate","Assets":725.9,"Fees":"No","Expense.Ratio":0.68,"Return.2009":15.5,"X3.Year.Return":5.9,"X5.Year.Return":4.7,"Risk":"Average"},{"Fund.Number":"FN-103","Type":"Short Term Corporate","Assets":1248.4,"Fees":"No","Expense.Ratio":0.72,"Return.2009":14,"X3.Year.Return":5.5,"X5.Year.Return":4.7,"Risk":"Average"},{"Fund.Number":"FN-104","Type":"Short Term Corporate","Assets":36.5,"Fees":"No","Expense.Ratio":0.76,"Return.2009":5.5,"X3.Year.Return":5,"X5.Year.Return":4,"Risk":"Below average"},{"Fund.Number":"FN-105","Type":"Short Term Corporate","Assets":127.4,"Fees":"No","Expense.Ratio":0.45,"Return.2009":3.6,"X3.Year.Return":3.3,"X5.Year.Return":3.3,"Risk":"Below average"},{"Fund.Number":"FN-106","Type":"Short Term Corporate","Assets":605.2,"Fees":"No","Expense.Ratio":0.3,"Return.2009":8.1,"X3.Year.Return":4.1,"X5.Year.Return":3.7,"Risk":"Average"},{"Fund.Number":"FN-107","Type":"Short Term Corporate","Assets":1879.2,"Fees":"No","Expense.Ratio":0.48,"Return.2009":9.6,"X3.Year.Return":4.9,"X5.Year.Return":4.2,"Risk":"Average"},{"Fund.Number":"FN-108","Type":"Short Term Corporate","Assets":964.7,"Fees":"Yes","Expense.Ratio":0.85,"Return.2009":12.9,"X3.Year.Return":7.1,"X5.Year.Return":5.3,"Risk":"Average"},{"Fund.Number":"FN-109","Type":"Short Term Corporate","Assets":325.3,"Fees":"No","Expense.Ratio":0.53,"Return.2009":10.7,"X3.Year.Return":4.5,"X5.Year.Return":4.1,"Risk":"Average"},{"Fund.Number":"FN-110","Type":"Short Term Corporate","Assets":69.8,"Fees":"No","Expense.Ratio":0.9,"Return.2009":6,"X3.Year.Return":4.6,"X5.Year.Return":3.8,"Risk":"Average"},{"Fund.Number":"FN-111","Type":"Short Term Corporate","Assets":177.8,"Fees":"Yes","Expense.Ratio":0.94,"Return.2009":8.2,"X3.Year.Return":5.4,"X5.Year.Return":4.4,"Risk":"Below average"},{"Fund.Number":"FN-112","Type":"Short Term Corporate","Assets":156.6,"Fees":"No","Expense.Ratio":0.63,"Return.2009":12,"X3.Year.Return":6.3,"X5.Year.Return":4.9,"Risk":"Average"},{"Fund.Number":"FN-113","Type":"Short Term Corporate","Assets":244.9,"Fees":"No","Expense.Ratio":0.81,"Return.2009":16.4,"X3.Year.Return":5.5,"X5.Year.Return":4.6,"Risk":"Average"},{"Fund.Number":"FN-114","Type":"Short Term Corporate","Assets":475.5,"Fees":"Yes","Expense.Ratio":0.91,"Return.2009":6,"X3.Year.Return":6.4,"X5.Year.Return":4.7,"Risk":"Average"},{"Fund.Number":"FN-115","Type":"Short Term Corporate","Assets":46.1,"Fees":"No","Expense.Ratio":0.92,"Return.2009":5.4,"X3.Year.Return":4.2,"X5.Year.Return":3.6,"Risk":"Average"},{"Fund.Number":"FN-116","Type":"Short Term Corporate","Assets":181.3,"Fees":"No","Expense.Ratio":0.36,"Return.2009":4.9,"X3.Year.Return":4.5,"X5.Year.Return":3.8,"Risk":"Average"},{"Fund.Number":"FN-117","Type":"Short Term Corporate","Assets":63.8,"Fees":"Yes","Expense.Ratio":0.62,"Return.2009":8.6,"X3.Year.Return":5.5,"X5.Year.Return":4.3,"Risk":"Average"},{"Fund.Number":"FN-118","Type":"Short Term Corporate","Assets":135.4,"Fees":"No","Expense.Ratio":0.7,"Return.2009":6.8,"X3.Year.Return":4.2,"X5.Year.Return":3.7,"Risk":"Below average"},{"Fund.Number":"FN-119","Type":"Short Term Corporate","Assets":388,"Fees":"No","Expense.Ratio":0.56,"Return.2009":6.7,"X3.Year.Return":4.6,"X5.Year.Return":3.8,"Risk":"Below average"},{"Fund.Number":"FN-120","Type":"Short Term Corporate","Assets":18.6,"Fees":"No","Expense.Ratio":0.89,"Return.2009":4.1,"X3.Year.Return":3.4,"X5.Year.Return":3.1,"Risk":"Below average"},{"Fund.Number":"FN-121","Type":"Short Term Corporate","Assets":298.1,"Fees":"No","Expense.Ratio":0.51,"Return.2009":11.2,"X3.Year.Return":5,"X5.Year.Return":4.3,"Risk":"Average"},{"Fund.Number":"FN-122","Type":"Short Term Corporate","Assets":461.3,"Fees":"No","Expense.Ratio":0.46,"Return.2009":8.4,"X3.Year.Return":4.5,"X5.Year.Return":4,"Risk":"Average"},{"Fund.Number":"FN-123","Type":"Short Term Corporate","Assets":159.9,"Fees":"Yes","Expense.Ratio":0.8,"Return.2009":5.9,"X3.Year.Return":4.8,"X5.Year.Return":4,"Risk":"Below average"},{"Fund.Number":"FN-124","Type":"Short Term Corporate","Assets":3662.7,"Fees":"No","Expense.Ratio":0.52,"Return.2009":9,"X3.Year.Return":5.2,"X5.Year.Return":4.3,"Risk":"Average"},{"Fund.Number":"FN-125","Type":"Short Term Corporate","Assets":42.6,"Fees":"No","Expense.Ratio":0.74,"Return.2009":5.4,"X3.Year.Return":4.6,"X5.Year.Return":4,"Risk":"Below average"},{"Fund.Number":"FN-126","Type":"Short Term Corporate","Assets":111.4,"Fees":"No","Expense.Ratio":0.97,"Return.2009":9.1,"X3.Year.Return":4.5,"X5.Year.Return":3.7,"Risk":"Below average"},{"Fund.Number":"FN-127","Type":"Short Term Corporate","Assets":114.5,"Fees":"No","Expense.Ratio":0.65,"Return.2009":9.5,"X3.Year.Return":4.9,"X5.Year.Return":4.1,"Risk":"Below average"},{"Fund.Number":"FN-128","Type":"Short Term Corporate","Assets":5282.9,"Fees":"No","Expense.Ratio":0.22,"Return.2009":4.3,"X3.Year.Return":5.6,"X5.Year.Return":4.4,"Risk":"Average"},{"Fund.Number":"FN-129","Type":"Short Term Corporate","Assets":17.4,"Fees":"No","Expense.Ratio":0.75,"Return.2009":2.8,"X3.Year.Return":3.9,"X5.Year.Return":3.4,"Risk":"Below average"},{"Fund.Number":"FN-130","Type":"Short Term Corporate","Assets":518,"Fees":"No","Expense.Ratio":0.72,"Return.2009":10.8,"X3.Year.Return":6.4,"X5.Year.Return":4.9,"Risk":"Average"},{"Fund.Number":"FN-131","Type":"Short Term Corporate","Assets":262.5,"Fees":"No","Expense.Ratio":0.85,"Return.2009":9.5,"X3.Year.Return":4.4,"X5.Year.Return":3.9,"Risk":"Below average"},{"Fund.Number":"FN-132","Type":"Short Term Corporate","Assets":93.9,"Fees":"No","Expense.Ratio":0.74,"Return.2009":9.4,"X3.Year.Return":5.5,"X5.Year.Return":4.3,"Risk":"Above average"},{"Fund.Number":"FN-133","Type":"Short Term Corporate","Assets":1130,"Fees":"Yes","Expense.Ratio":0.86,"Return.2009":13.2,"X3.Year.Return":6.5,"X5.Year.Return":4.9,"Risk":"Above average"},{"Fund.Number":"FN-134","Type":"Short Term Corporate","Assets":1101.9,"Fees":"No","Expense.Ratio":0.64,"Return.2009":13,"X3.Year.Return":3.5,"X5.Year.Return":3.8,"Risk":"Above average"},{"Fund.Number":"FN-135","Type":"Short Term Corporate","Assets":49.9,"Fees":"No","Expense.Ratio":0.6,"Return.2009":1.6,"X3.Year.Return":1.3,"X5.Year.Return":2.3,"Risk":"Below average"},{"Fund.Number":"FN-136","Type":"Short Term Corporate","Assets":640.3,"Fees":"No","Expense.Ratio":0.54,"Return.2009":7,"X3.Year.Return":2.3,"X5.Year.Return":2.7,"Risk":"Below average"},{"Fund.Number":"FN-137","Type":"Short Term Corporate","Assets":477.4,"Fees":"No","Expense.Ratio":0.6,"Return.2009":12.9,"X3.Year.Return":4.6,"X5.Year.Return":3.9,"Risk":"Average"},{"Fund.Number":"FN-138","Type":"Short Term Corporate","Assets":569.4,"Fees":"No","Expense.Ratio":0.52,"Return.2009":12,"X3.Year.Return":4.9,"X5.Year.Return":4,"Risk":"Average"},{"Fund.Number":"FN-139","Type":"Short Term Corporate","Assets":36.8,"Fees":"No","Expense.Ratio":0.38,"Return.2009":3.6,"X3.Year.Return":1.7,"X5.Year.Return":2.5,"Risk":"Below average"},{"Fund.Number":"FN-140","Type":"Short Term Corporate","Assets":145.4,"Fees":"Yes","Expense.Ratio":0.9,"Return.2009":10.1,"X3.Year.Return":3.1,"X5.Year.Return":3,"Risk":"Below average"},{"Fund.Number":"FN-141","Type":"Short Term Corporate","Assets":148.9,"Fees":"No","Expense.Ratio":1.1,"Return.2009":7.7,"X3.Year.Return":4.3,"X5.Year.Return":3.4,"Risk":"Average"},{"Fund.Number":"FN-142","Type":"Short Term Corporate","Assets":195.8,"Fees":"No","Expense.Ratio":0.52,"Return.2009":7.2,"X3.Year.Return":4.2,"X5.Year.Return":3.6,"Risk":"Average"},{"Fund.Number":"FN-143","Type":"Short Term Corporate","Assets":2361.1,"Fees":"Yes","Expense.Ratio":0.8,"Return.2009":17.4,"X3.Year.Return":7.1,"X5.Year.Return":5.1,"Risk":"Above average"},{"Fund.Number":"FN-144","Type":"Short Term Corporate","Assets":12.4,"Fees":"No","Expense.Ratio":0.7,"Return.2009":3.4,"X3.Year.Return":5.5,"X5.Year.Return":4.2,"Risk":"Above average"},{"Fund.Number":"FN-145","Type":"Short Term Corporate","Assets":26.3,"Fees":"No","Expense.Ratio":0.49,"Return.2009":4,"X3.Year.Return":6,"X5.Year.Return":4.6,"Risk":"Above average"},{"Fund.Number":"FN-146","Type":"Short Term Corporate","Assets":681,"Fees":"Yes","Expense.Ratio":0.75,"Return.2009":11.3,"X3.Year.Return":3.5,"X5.Year.Return":3.3,"Risk":"Average"},{"Fund.Number":"FN-147","Type":"Short Term Corporate","Assets":486.1,"Fees":"No","Expense.Ratio":0.5,"Return.2009":10.3,"X3.Year.Return":5.7,"X5.Year.Return":4.4,"Risk":"Above average"},{"Fund.Number":"FN-148","Type":"Short Term Corporate","Assets":10744.6,"Fees":"No","Expense.Ratio":0.46,"Return.2009":13.4,"X3.Year.Return":6.5,"X5.Year.Return":4.9,"Risk":"Above average"},{"Fund.Number":"FN-149","Type":"Short Term Corporate","Assets":108.9,"Fees":"No","Expense.Ratio":0.63,"Return.2009":11.4,"X3.Year.Return":4.1,"X5.Year.Return":3.6,"Risk":"Average"},{"Fund.Number":"FN-150","Type":"Short Term Corporate","Assets":69,"Fees":"Yes","Expense.Ratio":0.98,"Return.2009":5.2,"X3.Year.Return":4.7,"X5.Year.Return":3.4,"Risk":"Below average"},{"Fund.Number":"FN-151","Type":"Short Term Corporate","Assets":128.3,"Fees":"No","Expense.Ratio":0.55,"Return.2009":8.8,"X3.Year.Return":5.9,"X5.Year.Return":4.5,"Risk":"Above average"},{"Fund.Number":"FN-152","Type":"Short Term Corporate","Assets":374.4,"Fees":"No","Expense.Ratio":0.73,"Return.2009":13.2,"X3.Year.Return":4.6,"X5.Year.Return":3.8,"Risk":"Above average"},{"Fund.Number":"FN-153","Type":"Short Term Corporate","Assets":280.6,"Fees":"Yes","Expense.Ratio":0.99,"Return.2009":16.6,"X3.Year.Return":8,"X5.Year.Return":4.6,"Risk":"Above average"},{"Fund.Number":"FN-154","Type":"Short Term Corporate","Assets":456.2,"Fees":"No","Expense.Ratio":0.37,"Return.2009":13.6,"X3.Year.Return":3.7,"X5.Year.Return":3.5,"Risk":"Average"},{"Fund.Number":"FN-155","Type":"Short Term Corporate","Assets":16297.1,"Fees":"No","Expense.Ratio":0.14,"Return.2009":14.2,"X3.Year.Return":4.9,"X5.Year.Return":4.4,"Risk":"Above average"},{"Fund.Number":"FN-156","Type":"Short Term Corporate","Assets":517,"Fees":"No","Expense.Ratio":0.65,"Return.2009":10.6,"X3.Year.Return":4.7,"X5.Year.Return":3.8,"Risk":"Average"},{"Fund.Number":"FN-157","Type":"Short Term Corporate","Assets":80.5,"Fees":"No","Expense.Ratio":0.7,"Return.2009":13.4,"X3.Year.Return":5.1,"X5.Year.Return":4.2,"Risk":"Above average"},{"Fund.Number":"FN-158","Type":"Short Term Corporate","Assets":119.3,"Fees":"No","Expense.Ratio":0.82,"Return.2009":6,"X3.Year.Return":5,"X5.Year.Return":4,"Risk":"Average"},{"Fund.Number":"FN-159","Type":"Short Term Corporate","Assets":88.3,"Fees":"No","Expense.Ratio":0.92,"Return.2009":4.5,"X3.Year.Return":1,"X5.Year.Return":1.7,"Risk":"Average"},{"Fund.Number":"FN-160","Type":"Short Term Corporate","Assets":5701.6,"Fees":"Yes","Expense.Ratio":0.69,"Return.2009":6.7,"X3.Year.Return":3.4,"X5.Year.Return":3.1,"Risk":"Average"},{"Fund.Number":"FN-161","Type":"Short Term Corporate","Assets":478.4,"Fees":"No","Expense.Ratio":0.64,"Return.2009":6.8,"X3.Year.Return":2.2,"X5.Year.Return":2.4,"Risk":"Below average"},{"Fund.Number":"FN-162","Type":"Short Term Corporate","Assets":369.3,"Fees":"No","Expense.Ratio":0.86,"Return.2009":13.5,"X3.Year.Return":2.7,"X5.Year.Return":2.6,"Risk":"Above average"},{"Fund.Number":"FN-163","Type":"Short Term Corporate","Assets":297.4,"Fees":"Yes","Expense.Ratio":1.05,"Return.2009":12.8,"X3.Year.Return":2.6,"X5.Year.Return":2.7,"Risk":"Above average"},{"Fund.Number":"FN-164","Type":"Short Term Corporate","Assets":230.6,"Fees":"No","Expense.Ratio":0.95,"Return.2009":13.9,"X3.Year.Return":3.5,"X5.Year.Return":3.2,"Risk":"Average"},{"Fund.Number":"FN-165","Type":"Short Term Corporate","Assets":115.7,"Fees":"Yes","Expense.Ratio":0.7,"Return.2009":11.5,"X3.Year.Return":1.8,"X5.Year.Return":2.4,"Risk":"Average"},{"Fund.Number":"FN-166","Type":"Short Term Corporate","Assets":6981.5,"Fees":"No","Expense.Ratio":0.45,"Return.2009":7.3,"X3.Year.Return":1.7,"X5.Year.Return":2.4,"Risk":"Below average"},{"Fund.Number":"FN-167","Type":"Short Term Corporate","Assets":190.1,"Fees":"No","Expense.Ratio":0.5,"Return.2009":11.6,"X3.Year.Return":5.5,"X5.Year.Return":4.4,"Risk":"Above average"},{"Fund.Number":"FN-168","Type":"Short Term Corporate","Assets":278.4,"Fees":"Yes","Expense.Ratio":0.85,"Return.2009":15.5,"X3.Year.Return":4.4,"X5.Year.Return":3.8,"Risk":"Above average"},{"Fund.Number":"FN-169","Type":"Short Term Corporate","Assets":246.1,"Fees":"No","Expense.Ratio":0.75,"Return.2009":11.9,"X3.Year.Return":0.8,"X5.Year.Return":2,"Risk":"Average"},{"Fund.Number":"FN-170","Type":"Short Term Corporate","Assets":143.8,"Fees":"No","Expense.Ratio":0.8,"Return.2009":24.8,"X3.Year.Return":8.9,"X5.Year.Return":6.4,"Risk":"Above average"},{"Fund.Number":"FN-171","Type":"Short Term Corporate","Assets":1469.6,"Fees":"Yes","Expense.Ratio":1.08,"Return.2009":29.7,"X3.Year.Return":4.8,"X5.Year.Return":4.3,"Risk":"Above average"},{"Fund.Number":"FN-172","Type":"Short Term Corporate","Assets":80,"Fees":"No","Expense.Ratio":0.7,"Return.2009":9.9,"X3.Year.Return":2.9,"X5.Year.Return":3,"Risk":"Above average"},{"Fund.Number":"FN-173","Type":"Short Term Corporate","Assets":95.5,"Fees":"No","Expense.Ratio":0.66,"Return.2009":19.2,"X3.Year.Return":0,"X5.Year.Return":1.3,"Risk":"Above average"},{"Fund.Number":"FN-174","Type":"Short Term Corporate","Assets":170.5,"Fees":"No","Expense.Ratio":0.46,"Return.2009":15.6,"X3.Year.Return":0.7,"X5.Year.Return":2,"Risk":"Above average"},{"Fund.Number":"FN-175","Type":"Short Term Corporate","Assets":95.4,"Fees":"Yes","Expense.Ratio":1.02,"Return.2009":1.5,"X3.Year.Return":-0.2,"X5.Year.Return":1.8,"Risk":"Below average"},{"Fund.Number":"FN-176","Type":"Short Term Corporate","Assets":237.1,"Fees":"No","Expense.Ratio":0.5,"Return.2009":14.5,"X3.Year.Return":0.7,"X5.Year.Return":1.7,"Risk":"Above average"},{"Fund.Number":"FN-177","Type":"Short Term Corporate","Assets":983,"Fees":"No","Expense.Ratio":0.6,"Return.2009":15.2,"X3.Year.Return":0.2,"X5.Year.Return":1.9,"Risk":"Above average"},{"Fund.Number":"FN-178","Type":"Short Term Corporate","Assets":51.9,"Fees":"No","Expense.Ratio":0.7,"Return.2009":13.4,"X3.Year.Return":0.1,"X5.Year.Return":1.2,"Risk":"Above average"},{"Fund.Number":"FN-179","Type":"Short Term Corporate","Assets":249.7,"Fees":"No","Expense.Ratio":0.55,"Return.2009":2.4,"X3.Year.Return":0.4,"X5.Year.Return":1.5,"Risk":"Average"},{"Fund.Number":"FN-180","Type":"Short Term Corporate","Assets":33.8,"Fees":"No","Expense.Ratio":0.53,"Return.2009":16.4,"X3.Year.Return":0.7,"X5.Year.Return":1.8,"Risk":"Above average"},{"Fund.Number":"FN-181","Type":"Short Term Corporate","Assets":249.8,"Fees":"Yes","Expense.Ratio":0.43,"Return.2009":6.7,"X3.Year.Return":-4.5,"X5.Year.Return":-1.5,"Risk":"Above average"},{"Fund.Number":"FN-182","Type":"Short Term Corporate","Assets":52.9,"Fees":"No","Expense.Ratio":0.87,"Return.2009":5.2,"X3.Year.Return":-3,"X5.Year.Return":-0.7,"Risk":"Above average"},{"Fund.Number":"FN-183","Type":"Short Term Corporate","Assets":39.7,"Fees":"No","Expense.Ratio":0.51,"Return.2009":-8.8,"X3.Year.Return":-13.8,"X5.Year.Return":-7.3,"Risk":"Above average"},{"Fund.Number":"FN-184","Type":"Short Term Corporate","Assets":182.3,"Fees":"No","Expense.Ratio":0.53,"Return.2009":32,"X3.Year.Return":-2.7,"X5.Year.Return":0.2,"Risk":"Above average"}]

Columns

How’s that done? 
toJSON(BondFunds, dataframe = "columns")
{"Fund.Number":["FN-1","FN-2","FN-3","FN-4","FN-5","FN-6","FN-7","FN-8","FN-9","FN-10","FN-11","FN-12","FN-13","FN-14","FN-15","FN-16","FN-17","FN-18","FN-19","FN-20","FN-21","FN-22","FN-23","FN-24","FN-25","FN-26","FN-27","FN-28","FN-29","FN-30","FN-31","FN-32","FN-33","FN-34","FN-35","FN-36","FN-37","FN-38","FN-39","FN-40","FN-41","FN-42","FN-43","FN-44","FN-45","FN-46","FN-47","FN-48","FN-49","FN-50","FN-51","FN-52","FN-53","FN-54","FN-55","FN-56","FN-57","FN-58","FN-59","FN-60","FN-61","FN-62","FN-63","FN-64","FN-65","FN-66","FN-67","FN-68","FN-69","FN-70","FN-71","FN-72","FN-73","FN-74","FN-75","FN-76","FN-77","FN-78","FN-79","FN-80","FN-81","FN-82","FN-83","FN-84","FN-85","FN-86","FN-87","FN-88","FN-89","FN-90","FN-91","FN-92","FN-93","FN-94","FN-95","FN-96","FN-97","FN-98","FN-99","FN-100","FN-101","FN-102","FN-103","FN-104","FN-105","FN-106","FN-107","FN-108","FN-109","FN-110","FN-111","FN-112","FN-113","FN-114","FN-115","FN-116","FN-117","FN-118","FN-119","FN-120","FN-121","FN-122","FN-123","FN-124","FN-125","FN-126","FN-127","FN-128","FN-129","FN-130","FN-131","FN-132","FN-133","FN-134","FN-135","FN-136","FN-137","FN-138","FN-139","FN-140","FN-141","FN-142","FN-143","FN-144","FN-145","FN-146","FN-147","FN-148","FN-149","FN-150","FN-151","FN-152","FN-153","FN-154","FN-155","FN-156","FN-157","FN-158","FN-159","FN-160","FN-161","FN-162","FN-163","FN-164","FN-165","FN-166","FN-167","FN-168","FN-169","FN-170","FN-171","FN-172","FN-173","FN-174","FN-175","FN-176","FN-177","FN-178","FN-179","FN-180","FN-181","FN-182","FN-183","FN-184"],"Type":["Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Intermediate Government","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate","Short Term Corporate"],"Assets":[7268.1,475.1,193,18603.5,142.6,1401.6,985.6,2188.8,390.6,544.1,1407.4,155.5,397.5,906.1,379.1,62.7,1539.1,167.3,448,238.1,557.8,192.7,261.8,135.8,1807.3,4615.4,86.2,291.1,6332.5,110.7,619.7,628.7,274.3,891.8,94.7,676.3,1182.1,135.9,588.8,40,1080.4,309.1,4472.2,498.7,278.2,1525.5,556.6,588.6,332.5,84.9,17.3,104.1,530.7,333.6,1133.3,322.5,123.8,425.6,184.7,122.7,107.2,135.6,82.2,305.7,551.3,24.2,661.2,154.6,106.9,1011.1,634.8,168.7,792.1,583.5,56.1,285.5,640.3,84.7,81.3,611.7,595.1,131.3,88,686.6,3531.8,358,33,139.1,123.9,1922,203.4,66.1,1346,4772.9,77.5,76.2,146.3,49.2,96.1,226.8,122.3,725.9,1248.4,36.5,127.4,605.2,1879.2,964.7,325.3,69.8,177.8,156.6,244.9,475.5,46.1,181.3,63.8,135.4,388,18.6,298.1,461.3,159.9,3662.7,42.6,111.4,114.5,5282.9,17.4,518,262.5,93.9,1130,1101.9,49.9,640.3,477.4,569.4,36.8,145.4,148.9,195.8,2361.1,12.4,26.3,681,486.1,10744.6,108.9,69,128.3,374.4,280.6,456.2,16297.1,517,80.5,119.3,88.3,5701.6,478.4,369.3,297.4,230.6,115.7,6981.5,190.1,278.4,246.1,143.8,1469.6,80,95.5,170.5,95.4,237.1,983,51.9,249.7,33.8,249.8,52.9,39.7,182.3],"Fees":["No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","Yes","No","Yes","No","No","Yes","Yes","No","Yes","No","No","Yes","Yes","Yes","Yes","No","Yes","No","No","Yes","Yes","Yes","No","No","Yes","Yes","Yes","No","No","Yes","Yes","No","No","Yes","No","Yes","Yes","No","No","Yes","No","Yes","No","No","Yes","Yes","Yes","Yes","Yes","Yes","Yes","No","No","No","No","Yes","Yes","No","No","No","No","Yes","No","Yes","No","No","No","Yes","Yes","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","Yes","No","No","Yes","No","No","Yes","No","No","Yes","No","No","No","No","No","Yes","No","No","No","No","No","No","No","No","No","Yes","No","No","No","No","No","No","Yes","No","No","Yes","No","No","Yes","No","No","No","Yes","No","No","Yes","No","No","No","No","No","No","Yes","No","No","Yes","No","Yes","No","No","Yes","No","No","Yes","No","No","No","Yes","No","No","No","No","No","Yes","No","No","No"],"Expense.Ratio":[0.45,0.5,0.71,0.13,0.6,0.54,0.49,0.55,0.67,0.63,0.45,0.91,0.6,0.51,0.57,0.74,0.66,0.6,0.77,1.13,0.74,0.7,1.08,0.65,0.8,0.45,0.61,1.1,0.73,1.08,0.96,0.55,0.8,0.88,0.83,0.93,0.92,0.47,0.96,1.94,0.95,0.98,0.64,0.95,0.2,0.13,0.94,0.96,1,0.71,1.58,0.95,0.92,0.37,0.46,1.13,0.75,0.97,1.03,0.26,0.9,1.15,0.57,0.99,0.52,0.52,0.97,0.9,0.79,0.87,0.9,0.99,1,0.5,0.65,0.36,0.27,1,1.16,0.51,0.55,0.65,0.82,0.94,0.12,1.06,1,0.51,0.32,1.08,1,0.71,0.65,0.56,0.51,0.68,0.55,0.6,0.73,0.45,0.53,0.68,0.72,0.76,0.45,0.3,0.48,0.85,0.53,0.9,0.94,0.63,0.81,0.91,0.92,0.36,0.62,0.7,0.56,0.89,0.51,0.46,0.8,0.52,0.74,0.97,0.65,0.22,0.75,0.72,0.85,0.74,0.86,0.64,0.6,0.54,0.6,0.52,0.38,0.9,1.1,0.52,0.8,0.7,0.49,0.75,0.5,0.46,0.63,0.98,0.55,0.73,0.99,0.37,0.14,0.65,0.7,0.82,0.92,0.69,0.64,0.86,1.05,0.95,0.7,0.45,0.5,0.85,0.75,0.8,1.08,0.7,0.66,0.46,1.02,0.5,0.6,0.7,0.55,0.53,0.43,0.87,0.51,0.53],"Return.2009":[6.9,9.8,6.3,5.4,5.9,5.7,3,7.4,5.3,5.7,0.9,12.4,6,8.1,5.7,4.5,6.4,5.8,10.1,4.4,9,3.2,3.5,-1.1,7.8,1.3,-0.2,5.1,4.8,1.9,5,2.1,12.7,4.2,3.5,22.3,28.6,13,5.2,17.1,3.5,0,2.2,0.9,-3.8,-0.7,7.9,6.2,3.7,11.2,2.1,-3.6,4.6,12,3.4,4.7,6.4,9.1,1.7,-3.6,0.1,3.7,-3.3,3,-1.4,0.7,0,2.9,-4.8,1.4,7.3,-2.9,1.2,6,0.7,7.1,0.2,-0.6,7,6.5,5.5,-3.8,2,7.2,-1.6,0.5,0.2,5.5,5,12.1,8.3,6.8,8.6,5,2.2,2.5,12.2,10,7.3,2.9,7.3,15.5,14,5.5,3.6,8.1,9.6,12.9,10.7,6,8.2,12,16.4,6,5.4,4.9,8.6,6.8,6.7,4.1,11.2,8.4,5.9,9,5.4,9.1,9.5,4.3,2.8,10.8,9.5,9.4,13.2,13,1.6,7,12.9,12,3.6,10.1,7.7,7.2,17.4,3.4,4,11.3,10.3,13.4,11.4,5.2,8.8,13.2,16.6,13.6,14.2,10.6,13.4,6,4.5,6.7,6.8,13.5,12.8,13.9,11.5,7.3,11.6,15.5,11.9,24.8,29.7,9.9,19.2,15.6,1.5,14.5,15.2,13.4,2.4,16.4,6.7,5.2,-8.8,32],"X3.Year.Return":[6.9,7.5,7,6.6,6.7,6.4,6.8,6.4,6.1,6.2,6.2,6.4,6.3,6.1,6.6,7.8,6.2,6.2,6.5,5.5,6,6,5.1,6,6.1,6.7,5.6,5.8,6,5.4,5.9,6.3,6.1,6.6,6.4,9.4,9.4,5.1,6.7,6.6,6,5.8,5.5,4.9,6,7.1,5.5,5.1,4.7,3.9,4.9,4.7,5.5,4.9,2.3,5.6,3.3,4.7,5.6,6.1,5.3,5.9,5.1,6.2,7.3,-0.1,3.2,2.4,5.6,1.6,3.7,6,2.3,7.3,5.2,5.5,6.5,2.5,1,6.8,6.3,4.4,5.8,3.7,7.2,4.9,6.1,5.1,4.4,5.5,5.2,4.9,6.1,4.9,3.7,5.2,5.8,5,4.8,3.6,5.9,5.9,5.5,5,3.3,4.1,4.9,7.1,4.5,4.6,5.4,6.3,5.5,6.4,4.2,4.5,5.5,4.2,4.6,3.4,5,4.5,4.8,5.2,4.6,4.5,4.9,5.6,3.9,6.4,4.4,5.5,6.5,3.5,1.3,2.3,4.6,4.9,1.7,3.1,4.3,4.2,7.1,5.5,6,3.5,5.7,6.5,4.1,4.7,5.9,4.6,8,3.7,4.9,4.7,5.1,5,1,3.4,2.2,2.7,2.6,3.5,1.8,1.7,5.5,4.4,0.8,8.9,4.8,2.9,0,0.7,-0.2,0.7,0.2,0.1,0.4,0.7,-4.5,-3,-13.8,-2.7],"X5.Year.Return":[5.5,6.1,5.6,5.5,5.4,6.2,5.3,5.2,5,5.1,4.7,5.1,5.1,5.1,5.2,5.6,5,5.1,5.3,4.3,4.9,4.9,4,4.6,4.9,5.2,4.4,4.6,4.9,4.2,4.9,5.1,5,5.1,5.1,6.4,6.8,4.5,5.3,5.1,4.7,4.4,4.4,4.1,4.7,5.3,4.3,4.4,4,3.7,3.7,3.7,4.5,4.5,2.5,4.4,3.2,4.1,4.4,4.7,4,4.4,4.2,4.9,5.2,1.2,3,2.6,4.6,2.3,3.4,4.1,2.6,5.7,4.4,4.8,5.2,2.5,1.7,5.5,5.2,3.8,4.5,3.5,5.4,4,4.8,4.3,4.1,5,4.4,4,4.8,4.2,3.5,4.2,4.8,4.6,4.1,3.6,4.6,4.7,4.7,4,3.3,3.7,4.2,5.3,4.1,3.8,4.4,4.9,4.6,4.7,3.6,3.8,4.3,3.7,3.8,3.1,4.3,4,4,4.3,4,3.7,4.1,4.4,3.4,4.9,3.9,4.3,4.9,3.8,2.3,2.7,3.9,4,2.5,3,3.4,3.6,5.1,4.2,4.6,3.3,4.4,4.9,3.6,3.4,4.5,3.8,4.6,3.5,4.4,3.8,4.2,4,1.7,3.1,2.4,2.6,2.7,3.2,2.4,2.4,4.4,3.8,2,6.4,4.3,3,1.3,2,1.8,1.7,1.9,1.2,1.5,1.8,-1.5,-0.7,-7.3,0.2],"Risk":["Below average","Below average","Average","Average","Average","Average","Average","Below average","Below average","Below average","Average","Below average","Below average","Below average","Below average","Above average","Below average","Below average","Below average","Below average","Below average","Average","Below average","Average","Average","Above average","Average","Below average","Below average","Average","Average","Above average","Average","Average","Average","Above average","Above average","Below average","Average","Above average","Average","Above average","Average","Above average","Above average","Above average","Above average","Below average","Average","Below average","Average","Above average","Average","Above average","Below average","Above average","Average","Below average","Above average","Above average","Average","Average","Above average","Above average","Above average","Above average","Above average","Average","Above average","Average","Above average","Above average","Above average","Average","Average","Below average","Above average","Average","Above average","Average","Below average","Above average","Average","Below average","Above average","Average","Below average","Below average","Below average","Average","Below average","Below average","Below average","Below average","Below average","Below average","Average","Average","Below average","Below average","Average","Average","Average","Below average","Below average","Average","Average","Average","Average","Average","Below average","Average","Average","Average","Average","Average","Average","Below average","Below average","Below average","Average","Average","Below average","Average","Below average","Below average","Below average","Average","Below average","Average","Below average","Above average","Above average","Above average","Below average","Below average","Average","Average","Below average","Below average","Average","Average","Above average","Above average","Above average","Average","Above average","Above average","Average","Below average","Above average","Above average","Above average","Average","Above average","Average","Above average","Average","Average","Average","Below average","Above average","Above average","Average","Average","Below average","Above average","Above average","Average","Above average","Above average","Above average","Above average","Above average","Below average","Above average","Above average","Above average","Average","Above average","Above average","Above average","Above average","Above average"]}

Values

How’s that done? 
toJSON(BondFunds, dataframe = "values")
[["FN-1","Intermediate Government",7268.1,"No",0.45,6.9,6.9,5.5,"Below average"],["FN-2","Intermediate Government",475.1,"No",0.5,9.8,7.5,6.1,"Below average"],["FN-3","Intermediate Government",193,"No",0.71,6.3,7,5.6,"Average"],["FN-4","Intermediate Government",18603.5,"No",0.13,5.4,6.6,5.5,"Average"],["FN-5","Intermediate Government",142.6,"No",0.6,5.9,6.7,5.4,"Average"],["FN-6","Intermediate Government",1401.6,"No",0.54,5.7,6.4,6.2,"Average"],["FN-7","Intermediate Government",985.6,"No",0.49,3,6.8,5.3,"Average"],["FN-8","Intermediate Government",2188.8,"No",0.55,7.4,6.4,5.2,"Below average"],["FN-9","Intermediate Government",390.6,"No",0.67,5.3,6.1,5,"Below average"],["FN-10","Intermediate Government",544.1,"No",0.63,5.7,6.2,5.1,"Below average"],["FN-11","Intermediate Government",1407.4,"No",0.45,0.9,6.2,4.7,"Average"],["FN-12","Intermediate Government",155.5,"No",0.91,12.4,6.4,5.1,"Below average"],["FN-13","Intermediate Government",397.5,"No",0.6,6,6.3,5.1,"Below average"],["FN-14","Intermediate Government",906.1,"No",0.51,8.1,6.1,5.1,"Below average"],["FN-15","Intermediate Government",379.1,"No",0.57,5.7,6.6,5.2,"Below average"],["FN-16","Intermediate Government",62.7,"No",0.74,4.5,7.8,5.6,"Above average"],["FN-17","Intermediate Government",1539.1,"No",0.66,6.4,6.2,5,"Below average"],["FN-18","Intermediate Government",167.3,"No",0.6,5.8,6.2,5.1,"Below average"],["FN-19","Intermediate Government",448,"No",0.77,10.1,6.5,5.3,"Below average"],["FN-20","Intermediate Government",238.1,"No",1.13,4.4,5.5,4.3,"Below average"],["FN-21","Intermediate Government",557.8,"No",0.74,9,6,4.9,"Below average"],["FN-22","Intermediate Government",192.7,"No",0.7,3.2,6,4.9,"Average"],["FN-23","Intermediate Government",261.8,"Yes",1.08,3.5,5.1,4,"Below average"],["FN-24","Intermediate Government",135.8,"No",0.65,-1.1,6,4.6,"Average"],["FN-25","Intermediate Government",1807.3,"Yes",0.8,7.8,6.1,4.9,"Average"],["FN-26","Intermediate Government",4615.4,"No",0.45,1.3,6.7,5.2,"Above average"],["FN-27","Intermediate Government",86.2,"No",0.61,-0.2,5.6,4.4,"Average"],["FN-28","Intermediate Government",291.1,"Yes",1.1,5.1,5.8,4.6,"Below average"],["FN-29","Intermediate Government",6332.5,"Yes",0.73,4.8,6,4.9,"Below average"],["FN-30","Intermediate Government",110.7,"No",1.08,1.9,5.4,4.2,"Average"],["FN-31","Intermediate Government",619.7,"Yes",0.96,5,5.9,4.9,"Average"],["FN-32","Intermediate Government",628.7,"No",0.55,2.1,6.3,5.1,"Above average"],["FN-33","Intermediate Government",274.3,"No",0.8,12.7,6.1,5,"Average"],["FN-34","Intermediate Government",891.8,"Yes",0.88,4.2,6.6,5.1,"Average"],["FN-35","Intermediate Government",94.7,"Yes",0.83,3.5,6.4,5.1,"Average"],["FN-36","Intermediate Government",676.3,"Yes",0.93,22.3,9.4,6.4,"Above average"],["FN-37","Intermediate Government",1182.1,"Yes",0.92,28.6,9.4,6.8,"Above average"],["FN-38","Intermediate Government",135.9,"No",0.47,13,5.1,4.5,"Below average"],["FN-39","Intermediate Government",588.8,"Yes",0.96,5.2,6.7,5.3,"Average"],["FN-40","Intermediate Government",40,"No",1.94,17.1,6.6,5.1,"Above average"],["FN-41","Intermediate Government",1080.4,"No",0.95,3.5,6,4.7,"Average"],["FN-42","Intermediate Government",309.1,"Yes",0.98,0,5.8,4.4,"Above average"],["FN-43","Intermediate Government",4472.2,"Yes",0.64,2.2,5.5,4.4,"Average"],["FN-44","Intermediate Government",498.7,"Yes",0.95,0.9,4.9,4.1,"Above average"],["FN-45","Intermediate Government",278.2,"No",0.2,-3.8,6,4.7,"Above average"],["FN-46","Intermediate Government",1525.5,"No",0.13,-0.7,7.1,5.3,"Above average"],["FN-47","Intermediate Government",556.6,"Yes",0.94,7.9,5.5,4.3,"Above average"],["FN-48","Intermediate Government",588.6,"Yes",0.96,6.2,5.1,4.4,"Below average"],["FN-49","Intermediate Government",332.5,"Yes",1,3.7,4.7,4,"Average"],["FN-50","Intermediate Government",84.9,"No",0.71,11.2,3.9,3.7,"Below average"],["FN-51","Intermediate Government",17.3,"No",1.58,2.1,4.9,3.7,"Average"],["FN-52","Intermediate Government",104.1,"Yes",0.95,-3.6,4.7,3.7,"Above average"],["FN-53","Intermediate Government",530.7,"Yes",0.92,4.6,5.5,4.5,"Average"],["FN-54","Intermediate Government",333.6,"No",0.37,12,4.9,4.5,"Above average"],["FN-55","Intermediate Government",1133.3,"No",0.46,3.4,2.3,2.5,"Below average"],["FN-56","Intermediate Government",322.5,"Yes",1.13,4.7,5.6,4.4,"Above average"],["FN-57","Intermediate Government",123.8,"No",0.75,6.4,3.3,3.2,"Average"],["FN-58","Intermediate Government",425.6,"Yes",0.97,9.1,4.7,4.1,"Below average"],["FN-59","Intermediate Government",184.7,"Yes",1.03,1.7,5.6,4.4,"Above average"],["FN-60","Intermediate Government",122.7,"No",0.26,-3.6,6.1,4.7,"Above average"],["FN-61","Intermediate Government",107.2,"No",0.9,0.1,5.3,4,"Average"],["FN-62","Intermediate Government",135.6,"Yes",1.15,3.7,5.9,4.4,"Average"],["FN-63","Intermediate Government",82.2,"No",0.57,-3.3,5.1,4.2,"Above average"],["FN-64","Intermediate Government",305.7,"Yes",0.99,3,6.2,4.9,"Above average"],["FN-65","Intermediate Government",551.3,"No",0.52,-1.4,7.3,5.2,"Above average"],["FN-66","Intermediate Government",24.2,"No",0.52,0.7,-0.1,1.2,"Above average"],["FN-67","Intermediate Government",661.2,"Yes",0.97,0,3.2,3,"Above average"],["FN-68","Intermediate Government",154.6,"Yes",0.9,2.9,2.4,2.6,"Average"],["FN-69","Intermediate Government",106.9,"Yes",0.79,-4.8,5.6,4.6,"Above average"],["FN-70","Intermediate Government",1011.1,"Yes",0.87,1.4,1.6,2.3,"Average"],["FN-71","Intermediate Government",634.8,"Yes",0.9,7.3,3.7,3.4,"Above average"],["FN-72","Intermediate Government",168.7,"Yes",0.99,-2.9,6,4.1,"Above average"],["FN-73","Intermediate Government",792.1,"Yes",1,1.2,2.3,2.6,"Above average"],["FN-74","Intermediate Government",583.5,"No",0.5,6,7.3,5.7,"Average"],["FN-75","Intermediate Government",56.1,"No",0.65,0.7,5.2,4.4,"Average"],["FN-76","Intermediate Government",285.5,"No",0.36,7.1,5.5,4.8,"Below average"],["FN-77","Intermediate Government",640.3,"No",0.27,0.2,6.5,5.2,"Above average"],["FN-78","Intermediate Government",84.7,"Yes",1,-0.6,2.5,2.5,"Average"],["FN-79","Intermediate Government",81.3,"Yes",1.16,7,1,1.7,"Above average"],["FN-80","Intermediate Government",611.7,"No",0.51,6.5,6.8,5.5,"Average"],["FN-81","Intermediate Government",595.1,"No",0.55,5.5,6.3,5.2,"Below average"],["FN-82","Intermediate Government",131.3,"No",0.65,-3.8,4.4,3.8,"Above average"],["FN-83","Intermediate Government",88,"No",0.82,2,5.8,4.5,"Average"],["FN-84","Intermediate Government",686.6,"Yes",0.94,7.2,3.7,3.5,"Below average"],["FN-85","Intermediate Government",3531.8,"No",0.12,-1.6,7.2,5.4,"Above average"],["FN-86","Intermediate Government",358,"Yes",1.06,0.5,4.9,4,"Average"],["FN-87","Intermediate Government",33,"No",1,0.2,6.1,4.8,"Below average"],["FN-88","Short Term Corporate",139.1,"No",0.51,5.5,5.1,4.3,"Below average"],["FN-89","Short Term Corporate",123.9,"No",0.32,5,4.4,4.1,"Below average"],["FN-90","Short Term Corporate",1922,"Yes",1.08,12.1,5.5,5,"Average"],["FN-91","Short Term Corporate",203.4,"Yes",1,8.3,5.2,4.4,"Below average"],["FN-92","Short Term Corporate",66.1,"No",0.71,6.8,4.9,4,"Below average"],["FN-93","Short Term Corporate",1346,"No",0.65,8.6,6.1,4.8,"Below average"],["FN-94","Short Term Corporate",4772.9,"No",0.56,5,4.9,4.2,"Below average"],["FN-95","Short Term Corporate",77.5,"No",0.51,2.2,3.7,3.5,"Below average"],["FN-96","Short Term Corporate",76.2,"No",0.68,2.5,5.2,4.2,"Below average"],["FN-97","Short Term Corporate",146.3,"No",0.55,12.2,5.8,4.8,"Average"],["FN-98","Short Term Corporate",49.2,"No",0.6,10,5,4.6,"Average"],["FN-99","Short Term Corporate",96.1,"No",0.73,7.3,4.8,4.1,"Below average"],["FN-100","Short Term Corporate",226.8,"No",0.45,2.9,3.6,3.6,"Below average"],["FN-101","Short Term Corporate",122.3,"No",0.53,7.3,5.9,4.6,"Average"],["FN-102","Short Term Corporate",725.9,"No",0.68,15.5,5.9,4.7,"Average"],["FN-103","Short Term Corporate",1248.4,"No",0.72,14,5.5,4.7,"Average"],["FN-104","Short Term Corporate",36.5,"No",0.76,5.5,5,4,"Below average"],["FN-105","Short Term Corporate",127.4,"No",0.45,3.6,3.3,3.3,"Below average"],["FN-106","Short Term Corporate",605.2,"No",0.3,8.1,4.1,3.7,"Average"],["FN-107","Short Term Corporate",1879.2,"No",0.48,9.6,4.9,4.2,"Average"],["FN-108","Short Term Corporate",964.7,"Yes",0.85,12.9,7.1,5.3,"Average"],["FN-109","Short Term Corporate",325.3,"No",0.53,10.7,4.5,4.1,"Average"],["FN-110","Short Term Corporate",69.8,"No",0.9,6,4.6,3.8,"Average"],["FN-111","Short Term Corporate",177.8,"Yes",0.94,8.2,5.4,4.4,"Below average"],["FN-112","Short Term Corporate",156.6,"No",0.63,12,6.3,4.9,"Average"],["FN-113","Short Term Corporate",244.9,"No",0.81,16.4,5.5,4.6,"Average"],["FN-114","Short Term Corporate",475.5,"Yes",0.91,6,6.4,4.7,"Average"],["FN-115","Short Term Corporate",46.1,"No",0.92,5.4,4.2,3.6,"Average"],["FN-116","Short Term Corporate",181.3,"No",0.36,4.9,4.5,3.8,"Average"],["FN-117","Short Term Corporate",63.8,"Yes",0.62,8.6,5.5,4.3,"Average"],["FN-118","Short Term Corporate",135.4,"No",0.7,6.8,4.2,3.7,"Below average"],["FN-119","Short Term Corporate",388,"No",0.56,6.7,4.6,3.8,"Below average"],["FN-120","Short Term Corporate",18.6,"No",0.89,4.1,3.4,3.1,"Below average"],["FN-121","Short Term Corporate",298.1,"No",0.51,11.2,5,4.3,"Average"],["FN-122","Short Term Corporate",461.3,"No",0.46,8.4,4.5,4,"Average"],["FN-123","Short Term Corporate",159.9,"Yes",0.8,5.9,4.8,4,"Below average"],["FN-124","Short Term Corporate",3662.7,"No",0.52,9,5.2,4.3,"Average"],["FN-125","Short Term Corporate",42.6,"No",0.74,5.4,4.6,4,"Below average"],["FN-126","Short Term Corporate",111.4,"No",0.97,9.1,4.5,3.7,"Below average"],["FN-127","Short Term Corporate",114.5,"No",0.65,9.5,4.9,4.1,"Below average"],["FN-128","Short Term Corporate",5282.9,"No",0.22,4.3,5.6,4.4,"Average"],["FN-129","Short Term Corporate",17.4,"No",0.75,2.8,3.9,3.4,"Below average"],["FN-130","Short Term Corporate",518,"No",0.72,10.8,6.4,4.9,"Average"],["FN-131","Short Term Corporate",262.5,"No",0.85,9.5,4.4,3.9,"Below average"],["FN-132","Short Term Corporate",93.9,"No",0.74,9.4,5.5,4.3,"Above average"],["FN-133","Short Term Corporate",1130,"Yes",0.86,13.2,6.5,4.9,"Above average"],["FN-134","Short Term Corporate",1101.9,"No",0.64,13,3.5,3.8,"Above average"],["FN-135","Short Term Corporate",49.9,"No",0.6,1.6,1.3,2.3,"Below average"],["FN-136","Short Term Corporate",640.3,"No",0.54,7,2.3,2.7,"Below average"],["FN-137","Short Term Corporate",477.4,"No",0.6,12.9,4.6,3.9,"Average"],["FN-138","Short Term Corporate",569.4,"No",0.52,12,4.9,4,"Average"],["FN-139","Short Term Corporate",36.8,"No",0.38,3.6,1.7,2.5,"Below average"],["FN-140","Short Term Corporate",145.4,"Yes",0.9,10.1,3.1,3,"Below average"],["FN-141","Short Term Corporate",148.9,"No",1.1,7.7,4.3,3.4,"Average"],["FN-142","Short Term Corporate",195.8,"No",0.52,7.2,4.2,3.6,"Average"],["FN-143","Short Term Corporate",2361.1,"Yes",0.8,17.4,7.1,5.1,"Above average"],["FN-144","Short Term Corporate",12.4,"No",0.7,3.4,5.5,4.2,"Above average"],["FN-145","Short Term Corporate",26.3,"No",0.49,4,6,4.6,"Above average"],["FN-146","Short Term Corporate",681,"Yes",0.75,11.3,3.5,3.3,"Average"],["FN-147","Short Term Corporate",486.1,"No",0.5,10.3,5.7,4.4,"Above average"],["FN-148","Short Term Corporate",10744.6,"No",0.46,13.4,6.5,4.9,"Above average"],["FN-149","Short Term Corporate",108.9,"No",0.63,11.4,4.1,3.6,"Average"],["FN-150","Short Term Corporate",69,"Yes",0.98,5.2,4.7,3.4,"Below average"],["FN-151","Short Term Corporate",128.3,"No",0.55,8.8,5.9,4.5,"Above average"],["FN-152","Short Term Corporate",374.4,"No",0.73,13.2,4.6,3.8,"Above average"],["FN-153","Short Term Corporate",280.6,"Yes",0.99,16.6,8,4.6,"Above average"],["FN-154","Short Term Corporate",456.2,"No",0.37,13.6,3.7,3.5,"Average"],["FN-155","Short Term Corporate",16297.1,"No",0.14,14.2,4.9,4.4,"Above average"],["FN-156","Short Term Corporate",517,"No",0.65,10.6,4.7,3.8,"Average"],["FN-157","Short Term Corporate",80.5,"No",0.7,13.4,5.1,4.2,"Above average"],["FN-158","Short Term Corporate",119.3,"No",0.82,6,5,4,"Average"],["FN-159","Short Term Corporate",88.3,"No",0.92,4.5,1,1.7,"Average"],["FN-160","Short Term Corporate",5701.6,"Yes",0.69,6.7,3.4,3.1,"Average"],["FN-161","Short Term Corporate",478.4,"No",0.64,6.8,2.2,2.4,"Below average"],["FN-162","Short Term Corporate",369.3,"No",0.86,13.5,2.7,2.6,"Above average"],["FN-163","Short Term Corporate",297.4,"Yes",1.05,12.8,2.6,2.7,"Above average"],["FN-164","Short Term Corporate",230.6,"No",0.95,13.9,3.5,3.2,"Average"],["FN-165","Short Term Corporate",115.7,"Yes",0.7,11.5,1.8,2.4,"Average"],["FN-166","Short Term Corporate",6981.5,"No",0.45,7.3,1.7,2.4,"Below average"],["FN-167","Short Term Corporate",190.1,"No",0.5,11.6,5.5,4.4,"Above average"],["FN-168","Short Term Corporate",278.4,"Yes",0.85,15.5,4.4,3.8,"Above average"],["FN-169","Short Term Corporate",246.1,"No",0.75,11.9,0.8,2,"Average"],["FN-170","Short Term Corporate",143.8,"No",0.8,24.8,8.9,6.4,"Above average"],["FN-171","Short Term Corporate",1469.6,"Yes",1.08,29.7,4.8,4.3,"Above average"],["FN-172","Short Term Corporate",80,"No",0.7,9.9,2.9,3,"Above average"],["FN-173","Short Term Corporate",95.5,"No",0.66,19.2,0,1.3,"Above average"],["FN-174","Short Term Corporate",170.5,"No",0.46,15.6,0.7,2,"Above average"],["FN-175","Short Term Corporate",95.4,"Yes",1.02,1.5,-0.2,1.8,"Below average"],["FN-176","Short Term Corporate",237.1,"No",0.5,14.5,0.7,1.7,"Above average"],["FN-177","Short Term Corporate",983,"No",0.6,15.2,0.2,1.9,"Above average"],["FN-178","Short Term Corporate",51.9,"No",0.7,13.4,0.1,1.2,"Above average"],["FN-179","Short Term Corporate",249.7,"No",0.55,2.4,0.4,1.5,"Average"],["FN-180","Short Term Corporate",33.8,"No",0.53,16.4,0.7,1.8,"Above average"],["FN-181","Short Term Corporate",249.8,"Yes",0.43,6.7,-4.5,-1.5,"Above average"],["FN-182","Short Term Corporate",52.9,"No",0.87,5.2,-3,-0.7,"Above average"],["FN-183","Short Term Corporate",39.7,"No",0.51,-8.8,-13.8,-7.3,"Above average"],["FN-184","Short Term Corporate",182.3,"No",0.53,32,-2.7,0.2,"Above average"]]

The flipbook

The pages

Slides

Link is here

CADDS

The data set presented is designed to represent a sample of 1,000 DDS consumers (which provides a 95% confidence interval with a margin of error of plus-or-minus 3.5% for this 250,000 consumer population). The data set includes six variables (i.e., fields) which are: ID, age cohort/age (binned/unbinned), gender, expenditures, and ethnicity. NB: The data set originated from DDS’s Client Master File. In order to remain in compliance with California State Legislation, the data have been altered to protect the rights and privacy of specific individual consumers. The provided data set is based on actual attributes of consumers.

ID is the unique identification code for each consumer. It is similar to a social security number and used for identification purposes.

Age cohort/age is a key variable in the case exercise. While age is a legal basis for discrimination in many situations, age is not an attribute that would be considered in a discrimination claim for this particular population. The purpose of providing funds to those with developmental disabilities is to help them live like those without disabilities. As consumers get older, their financial needs increase as they move out of their parent’s home, etc. Therefore, it is expected that expenditures for older consumers will be higher than for the younger consumers.

We have included both binned (Age cohort) and unbinned (Age) variables to represent a consumer’s age. The binned age variable is represented in the data set as six age cohorts. Each consumer is assigned to an age cohort based on their years since birth. The six cohorts include: 0-5 years old, 6-12, 13-17, 18-21, 22-50, and 51+. The cohorts are established based on the amount of financial support typically required during a particular life phase.

The 0-5 cohort (preschool age) has the fewest needs and requires the least amount of funding. For the 6-12 cohort (elementary school age) and 13-17 (high school age), a number of needed services are provided by schools. The 18-21 cohort is typically in a transition phase as the consumers begin moving out from their parents’ homes into community centers or living on their own. The majority of those in the 22-50 cohort no longer live with their parents but may still receive some support from their family. Those in the 51+ cohort have the most needs and require the most amount of funding because they are living on their own or in community centers and often have no living parents.

Gender is included in the data set as another variable to consider because it is an attribute on which many discrimination cases are based.

Expenditures variable represents the annual expenditures the State spends on each consumer in supporting these individuals and their families. It is important that students realize this is the amount each consumer receives from the State. Expenditures include services such as: respite for their families, psychological services, medical expenses, transportation, and costs related to housing such as rent (especially for adult consumers living outside their parent’s home).

Ethnicity is the key demographic variable in the data set as it pertains to the case. Eight ethnic groups are represented in the data set. These groups reflect the demographic profile of the State of California. Our key area of interest will become Hispanic and White, non-Hispanic comparisons.

UCB Admissions

Is there evidence of sex bias in admission practices? Data on admissions to the University of California at Berkeley graduate programs in six departments are presented for the population of applicants. Admit measures whether or not the applicant was admitted; M.F measures the gender of the applicant; Dept measures the department in a classification ranging from A to F.

The class plan:

  1. A spreadsheet is a visualization.
  2. In some ways, so is JSON.
  3. Two types of summary
  4. Two dimensions: center and spread.
  5. Pivots and formulae
  6. Visualizations and types

Your assignment for this time:

  1. Do the reading.
  2. From last time. Collect three data visualizations. Think about the approach to visualization presented and how your graphics manifest it. Post them and describe them. What type of data do they represent and how? What is the name of the type of visualization?

For Next Class:

  1. Reading: Chapters 1 and 2 and Wickham on Data Visualization
  2. Deliverable: An In-class exercise [Assignment 5] if not completed before departing