100 Greatest Generals in History

This video shows the 100 generals that have won the most battles in history (according to Wikipedia).
To make that video, I created a query that searches every battle article in Wikipedia and identifies the general that won the battle.

List of battles won by general: https://docs.google.com/document/d/1XGYI0YGDp5ntYQQlcDLq3kCkoGqudUq2fCVPauJIi4U/edit?usp=sharing

Methodology:
1. I created a query with Wikidata Query to get the list of all articles tagged as "battle" by Wikipedia. This gives me about 12,000 battles
2. I downloaded the data that is included in the top right hand table of every of those Wikipedia article. I did it for the following versions of Wikipedia: English, French, German, Spanish, Portuguese, Italian, Arabic, Chinese, Russian, Greek, Turkish, Serbo-Croatian, Japanese, Danish, Norwegian, Slovakian, Dutch, Polish, Hungarian, Czech, Hindi, Hebrew, Basque, Bulgarian, Romanian, Catalan, Finnish, Swedish, Vietnamese, Persian, Indonesian, Korean
3. I cleaned up the data on Excel to remove double entries

Limitations :
- Missing data. You probably noticed that Europe concentrates the majority of battles. Possible explanations include the fact that Wikipedia is used more in Europe, the ban of Wikipedia in China or Turkey, or the lack of documentation of military records in some countries. But still, Wikipedia remains one of the most comprehensive sources available.

Видео 100 Greatest Generals in History канала Cottereau