# Project Euler Statistics by Country

If you are a member of the Project Euler web site, you my know that the site tracks various statistics about its members.  I did some analysis of the members and my report is below.

If you log into the Project Euler site you can get statistics on several categories.

### Project Euler Stats by Country

To get the country statistics, I scraped the data from the P.E. web site using Excel. I then had to prepare the data which required some clean up.

The country name was repeated in one field and I had to get rid of the duplicate country name in all the records. This turned out to be simple because the country field had three non-breaking spaces (Decimal 160, Hex A0) between the duplicate country names.

Some countries like the Dominican Republic have two or more words in the name. Trying to separate the duplicates by splitting on the spaces between the words would have been somewhat complicated.

Excel has a feature that splits columns. To make this work, I converted the non-breaking spaces into X’s so I could see them with the following computed column values in Excel.

• =TRIM(SUBSTITUTE(A2,CHAR(160),”X”))

I then copied the values, not the formula, into a new column so I could perform the column split.

This split the duplicate country names into two columns. I then deleted one of the duplicate country columns. This works because no country has X in its name. If one country did have an X, you could use a semi-colon to do the split.

You can get the complete data by clicking on the image below.

### Geographic Location of Members by Country

The chart below shows the location of the countries with 1500 or more Project Euler members. These countries represent the ones with largest number of Project Euler members. Click on the chart below to get an interactive version of the chart.

Copyright OpenStreetMap Contributors, Geographic Location of Members by Country

### Relative Membership Size By Country

This chart really surprised me. I initially create a bar chart but the USA so dominated the graphic that I looked for a better presentation method. I chose the bubble chart below because of the quadratic nature of the area. If you double the diameter of a circle, you quadruple the area. As you can see below the USA is about twice the diameter of the second largest country, India. I think the bubble chart is a better way to visualize the membership totals.

Relative Membership Size By Country

### Level 1+ Enthusiasts Percentage by Country

The chart chart was really a surprise to me.  I thought Russia, Canada, and some smaller European countries would have the highest percentge of enthusiasts. Project Euler defines an enthusiast as someone who has reach level one or higher. I only included countries with 200 or more members so that the results are not skewed by countries with extremely small membership sizes.

When you solve 25 problems you have reached level one. That probably takes most people fifty or more hours of work to get to that level. Achieving that level is possible if you have the persistence and excellent algorithm problem solving abilities. You have to solve twenty-five problems but you get to choose which ones you solve.  That’s a big advantage in that you can skip a problem if you cannot solve it.

As you can see from the chart Japan and Taiwan came out on top.  No one was even close. Look at the distance to third place and you can see that these two countries clearly won the award.

Level 1+ Project Euler Enthusiasts Percentage by Country

### Conclusion

Project Euler is growing by leaps and bounds.  About two years ago it have about 500,000 members. Now there are over 730,000. I do not think that the original founder could have imagined that his creation would have turned into such a mammoth success.