Forbes Celebrity List + Wikipedia Page Edits Data Set

The Data

Forbes Celebrities List from 1999-2017

Also known as the Celebrity 100, the annual list created by Forbes tracks the world's highest-paid entertainers. This is the definitive global index on the top money makers in the business of entertainment.

The dataset contains records from 1999 to 2017 and consists of 192 rows and 7 columns.

The names of the celebrities

The Variables:

Year  - year
Rank - a celebrity's rank in a particular year
Recipient - celebrity name
Country - celebrity's country of origin
Career - the industry the celebrity is in
Tied
Title - celebrity name

Wikipedia Edits for the Celebrity Pages

Wikipedia is a free online encyclopedia that can be created and edited by just about anyone. It is probably the largest collaboratively edited reference online.

The dataset contains edit information regarding the wikipages of the celebrities on the Forbes Celebrity List.

The dataset contains 724,335 rows and 7 columns.

The upper part of the dataset containing variables

The Variables:

title - celebrity name
parentid
revid - the revision id
timestamp - time created
user - the editor
userid - the editor's userid
size - this is what i assume would be the file size of the edit document

Once merged, the dataset balloons to 1,916,973 rows and 13 columns. Here's what the combined documents look like:

The upper part of the merged Forbes and Wiki documents

Top of the List

The current holder of  number one is musician Sean "Puffy" Combs.

Television personality Oprah Winfrey holds the record for the most number of times to reach pole position. She's achieved this 5 times since 1999.

Relationship Between No. of Users and No. of Page Edits

A correlation coefficient of 0.32 (or 32%) indicates the presence of a moderate to weak (depending on how you set correlation boundaries) positive relationship between the two variables.

However, it is possible that the two may share a non-linear relationship:

Pacquiao vs. Mayweather

Arguably the two best boxers in history whose careers seem intertwined because the public couldn't stop comparing the two. The same could be said about edit histories of their wikipedia pages.

Here we see both of them reach a high number of edits in 2008. This was the year when Pacquiao fought Oscar de la Hoya in what many people first thought was suicide for the smaller and (at that time) still up-and-coming Pacquiao. It turned out to be a mismatch the other way around as de la Hoya threw in the towel during the match and made the Filipino a global sensation. This was also the year the Mayweather decided to retire from boxing the first time and appeared in a much-publicized wrestling match.

The Filipino champion would reach greater heights both in terms of his career and the number of wikipedia page edits in 2010. This was the time he defeated his largest opponent to date Antonio Margarito and bagged his 8th title in as many weight classes.

Career Volume

The page edits of celebrities categorized as musician have the highest volume in terms of data.

Career Frequency

Their pages are also the most edited in total:

Avidness of Fans

On average, the pages of golfers  have the highest number of edits per user

Super Fans

Here are the users with the highest numbers of edits:

*editors are allowed to change accounts in wikipedia. This may lead to misattribution of edits.

Bonus