VGuitarForums - Member location stats?

Started by Hennisdk, February 13, 2011, 11:47:37 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Elantric

QuoteI was expecting Japan to be up there too - maybe something else in play in local language ?

Roland Japan supports a proper User to User Forum

https://www.vguitarforums.com/smf/index.php?topic=13299.msg103577#msg103577


http://okbizcs.okwave.jp/roland/questionlist/?cid=80

shawnb

#26
Quote from:  mbenigni on June 10, 2015, 08:37:16 AMBut location is a free text field.  How are you parsing out country, state, etc?

The work was manual.  Most people entered usable info. 

An awful lot of data filtering & global replaces in Excel.  Plus a lot of assumptions, such as 'cali' = California.   In the screenshots below, the raw location info is on the left.   I would filter on something, like "cali", then copy 'CA' where it made sense (Calicut stands out in the screenshot below).

Quote from:  MusicOverGear on June 10, 2015, 07:49:42 AM
I would love to see one more graph - same as the first one but with "Unknown" thrown out.

Below!
Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

ericar123

Being a proud Canadian , I am impressed with our number compared to our smallish population.
Nothing to do in a snow storm but play with guitar gear :)

whippinpost91850

Thats pretty cool. Shawn, Thanks for the effort