Some Wikipedia Stats
What is this page ?
This page is presenting a work of data engineering more than data analytics. However, as it is not easy to showcase data engineering work, I wanted to present the result of the tasks in a more friendly format.
📊 General statistics
Articles and characters
Here are some statistics about the content of French Wikipedia.
Articles
Total characters
Characters per article (avg.)
So French Wikipedia contains 2.7 million articles, that represents 22 billion characters ! This is equivalent of reading Romeo and Juliet 150 000 times.

Creation timeline
Here is a timeline of the creation of articles, every quarter from year 2001.
⚽️ Footballer stats
In this section, you can explore some statistics about football players present in the French Wikipedia.
Countries: 0
5 300Players in selection
Players by country
Dataset is empty - query ran successfully, but no data was returned from the database
Right or left foot ?
Here is a plot displaying the ration of right-footed players compared to the total of players of the country. For most of the countries, the ratio is around 70%.
Dataset is empty - query ran successfully, but no data was returned from the database
🎬 Movies
Genres and countries
You can explore the movies present in Wikipedia. Country, genres and durations are explored in the following graphs.
Countries: 0
5 300Top genres: 0
5 10Movies in selection
Dataset is empty - query ran successfully, but no data was returned from the database
Duration by genre

Are actions movies are actually longer than documentaries ?
Here is the distribution of all movies durations among the selected genres.
Dataset is empty - query ran successfully, but no data was returned from the database
💫 Skyscrapers
Number of skyscrapers for each country, with the height of the tallest building.
Skyscrapers in selection
Countries: 0
5 300Dataset is empty - query ran successfully, but no data was returned from the database
Search the data
With this table, you can search, sort and export the data you need.
Dataset is empty - query ran successfully, but no data was returned from the database
Note: Some Skyscrapers data can be related to projects that haven't been finished as it is the case for this 750m tower in France.
