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

2.707M

Total characters

21.66B

Characters per article (avg.)

8.0k

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 300

Players in selection

Players by country

Bar Chart

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%.

Scatter Plot

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 300

Top genres: 0

5 10

Movies in selection

Bar Chart

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.

Box Plot

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 300

Bar Chart

Dataset 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.

Data Table

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.