Author Topic: VGuitarForums - Member location stats?  (Read 2607 times)

0 Members and 1 Guest are viewing this topic.

Offline Elantric

Re: VGuitarForums - Member location stats?
« Reply #25 on: June 10, 2015, 10:19:08 AM »
Quote
I 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

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


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

Offline shawnb

Re: VGuitarForums - Member location stats?
« Reply #26 on: June 10, 2015, 11:02:30 AM »
But 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).

I would love to see one more graph - same as the first one but with "Unknown" thrown out.

Below!
« Last Edit: June 10, 2015, 11:08:22 AM by shawnb »
Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

Offline ericar123

Re: VGuitarForums - Member location stats?
« Reply #27 on: June 10, 2015, 11:32:19 AM »
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 :)

Offline whippinpost91850

Re: VGuitarForums - Member location stats?
« Reply #28 on: June 10, 2015, 02:02:45 PM »
Thats pretty cool. Shawn, Thanks for the effort

 

Blog