Skip to content

Instantly share code, notes, and snippets.

@DeBraid
Created February 27, 2014 15:52
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save DeBraid/9252789 to your computer and use it in GitHub Desktop.
Save DeBraid/9252789 to your computer and use it in GitHub Desktop.
Canada Assets 2012
{"description":"Canada Assets 2012","endpoint":"","display":"svg","public":true,"require":[],"fileconfigs":{"inlet.js":{"default":true,"vim":false,"emacs":false,"fontSize":12},"nw.csv":{"default":true,"vim":false,"emacs":false,"fontSize":12},"_.md":{"default":true,"vim":false,"emacs":false,"fontSize":12},"config.json":{"default":true,"vim":false,"emacs":false,"fontSize":12},"nw2.csv":{"default":true,"vim":false,"emacs":false,"fontSize":12}},"fullscreen":false,"play":false,"loop":false,"restart":false,"autoinit":true,"pause":true,"loop_type":"pingpong","bv":false,"nclones":15,"clone_opacity":0.4,"duration":3000,"ease":"linear","dt":0.01,"thumbnail":"http://i.imgur.com/r4S7CmF.png"}
/*
* data from statscan http://www5.statcan.gc.ca/cansim/a26?lang=eng&retrLang=eng&id=2050001&pattern=&csid=
* basic sortable bar chart bl.ocks.org/mbostock/1584697
*
*
*
*
*
*/
var data = tributary.nw2;
var years = d3.keys(data[0]).filter(function(key){
return key !== "Type";
});
data.forEach(function(d){
// do stuff
d.groups = years.map(function(year) {
return {year: year, total: +d[year]}
});
});
console.log(years);
/*
var svg = d3.select("svg")
.attr("width", width + margin.left + margin.right)
.attr("height", height + margin.top + margin.bottom)
.append("g")
.attr("transform", "translate(" + margin.left + "," + margin.top + ")");
var chart = function (data) {
var ageNames = d3.keys(data[0]).filter(function(key) { return key !== "State"; });
data.forEach(function(d) {
d.ages = ageNames.map(function(name) { return {name: name, value: +d[name]}; });
});
x0.domain(data.map(function(d) { return d.State; }));
x1.domain(ageNames).rangeRoundBands([0, x0.rangeBand()]);
y.domain([0, d3.max(data, function(d) { return d3.max(d.ages, function(d) { return d.value; }); })]);
svg.append("g")
.attr("class", "x axis")
.attr("transform", "translate(0," + height + ")")
.call(xAxis);
*/
Type 1999 2005 2012
Total assets 4489109 6395134 9410656
Private pension assets 1309523 1856089 2829705
Registered Plans (RRSPs RRIFs LIRA) 536422 674706 958571
Employer-sponsored Pension Plans 773101 1181383 1871134
Non-pension Financial assets 554126 664900 1047214
Bank Deposits 207339 269929 343984
Mutual and investment funds + income trusts 103102 152129 239468
Stocks 117919 117222 204864
Bonds 33172 39375 24378
TFSA 0 0 65939
Other financial assets 92595 86246 168580
Non-financial assets 2176597 3203286 4744580
Principal residence 1418971 2137890 3254275
Other real estate 302863 546886 931762
Vehicles 161343 194726 245520
Other non-financial assets 293420 323785 313023
Equity in business 448863 670859 789158
Total debts 586095 864625 1337071
Mortgages 453557 650751 1029811
Principal residence 388119 552849 821010
Other real estate 65438 97901 208801
Line of credit 33220 77492 144946
Credit card and installment debt 18507 29316 35321
Student loans 19623 22718 28272
Vehicle loans 37093 52439 75814
Other debt 24096 31909 22908
Net Worth 3903014 5530509 8073585
We can make this file beautiful and searchable if this error is corrected: It looks like row 11 should actually have 6 columns, instead of 7. in line 10.
Type,1999,2005,2012,pc2005,pc2012
Total assets,4489109,6395134,9410656,42.5,47.2
Private pension assets,1309523,1856089,2829705,41.7,52.5
Registered Plans (RRSPs RRIFs LIRA),536422,674706,958571,25.8,42.1
Employer-sponsored Pension Plans,773101,1181383,1871134,52.8,58.4
Non-pension Financial assets,554126,664900,1047214,20.0,57.5
Bank Deposits,207339,269929,343984,30.2,27.4
Mutual and investment funds + income trusts,103102,152129,239468,47.6,57.4
Stocks,117919,117222,204864,-0.6,74.8
Bonds,33172,39375,24378,18.7,-38.1
TFSA,0,0,65939,,0,65939
Other financial assets,92595,86246,168580,-6.9,95.5
Non-financial assets,2176597,3203286,4744580,47.2,48.1
Principal residence,1418971,2137890,3254275,50.7,52.2
Other real estate,302863,546886,931762,80.6,70.4
Vehicles,161343,194726,245520,20.7,26.1
Other non-financial assets,293420,323785,313023,10.3,-3.3
Equity in business,448863,670859,789158,49.5,17.6
Total debts,586095,864625,1337071,47.5,54.6
Mortgages,453557,650751,1029811,43.5,58.2
Principal residence,388119,552849,821010,42.4,48.5
Other real estate,65438,97901,20880,149.6,113.3
Line of credit,33220,77492,144946,133.3,87.0
Credit card and installment debt,18507,29316,35321,58.4,20.5
Student loans,19623,22718,28272,15.8,24.4
Vehicle loans,37093,52439,75814,41.4,44.6
Other debt,24096,31909,22908,32.4,-28.2
Net Worth,3903014,5530509,8073585,41.7,46.0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment