The drupal.org country statistics visualized
Tue, 2008/05/27 - 20:04 — balu
Dries posted the drupal.org demographic statistics in a semi-digestable form, I decided I will play around a bit with the Google Chart API in order to visualize this data. Sadly the drupal chart api has no Drupal 6 port (nor is there any sign in the CVS), so I had to do the things manually. For reference the code I used can be downloaded from attachment.
Per Karoly’s suggestion I also weighed the country percentage by the population, interesting results.
Note that I removed Afghanistan from the second graph as it is probably just the result of people being lazy.
| Attachment | Size |
|---|---|
| chart_balanced.png | 76.12 KB |
| chart.png | 74.02 KB |
| drupaldata.php.txt | 2.81 KB |
Comments
Wed, 2008/05/28 - 06:04 — Anonymous
pretty cool - however, I was hoping to see the balanced graph sorted by size instead of in the same order as the regular graph. Is that possible to add?
Wed, 2008/05/28 - 08:22 — Anonymous
For every ten million people you have this many Drupalers
array (
'China' => 0.147277295959,
'Pakistan' => 0.269291030161,
'India' => 0.501177060208,
'Iran' => 0.645994832041,
'Mexico' => 0.647674473178,
'Indonesia' => 0.682131185052,
'Brazil' => 0.845294635845,
'Vietnam' => 0.881258941345,
'Philippines' => 1.11770173788,
'Russian Federation' => 1.11964892317,
'Ukraine' => 1.16663078197,
'Thailand' => 1.18975389655,
'Turkey' => 1.37420519938,
'Argentina' => 1.39024390244,
'South Africa' => 1.44198517472,
'Poland' => 2.38745090738,
'Malaysia' => 2.62275103197,
'Romania' => 2.65883011475,
'France' => 2.77634996527,
'Italy' => 3.07831210865,
'Germany' => 3.68415933077,
'Spain' => 4.22559481718,
'Portugal' => 4.89503906618,
'Austria' => 5.15938603306,
'Czech Republic' => 6.26136075745,
'Israel' => 6.45427080472,
'Switzerland' => 6.56185201711,
'United Kingdom' => 8.48362610646,
'Sweden' => 8.80796004709,
'Singapore' => 9.39970091861,
'Denmark' => 9.48512895945,
'Norway' => 9.65676498373,
'Hungary' => 10.2558996316,
'Australia' => 10.4200891809,
'New Zealand' => 10.5480534153,
'United States' => 10.8886835937,
'Netherlands' => 11.2015003192,
'Canada' => 12.712513862,
'Belgium' => 12.7544585336,
)
Wed, 2008/05/28 - 08:27 — Anonymous
Erm, no, sorry the number is calculated $a[$country] = $v[1] / $v[6] * 1e8; this way. So, consider the number meaningless and just compare relatively. This ranking much more reflects my expectations than the original.
Wed, 2008/05/28 - 12:53 — balu
yeah its only meaningful relatively, the 1e8 is just a scale so the chart still gets calculated (for too small numbers the API ignores the values)
Wed, 2008/05/28 - 14:17 — Anonymous
for drupal 6 try http://drupal.org/project/charts
a guy from here, brazil, did it ;)
