Research in programming Wikidata/University

This research is devoted to the study of the Wikidata object - "University". With the help of SPARQL query to Wikidata, the following tasks were solved:

building a list of all universities;

building a bubble chart showing the ratio of universities in different countries;

the mapping of universities located in Russia.

In the course of the work, information was supplemented at the Wikidata objects corresponding to the universities of Russia, conclusions were drawn about the completeness of the data presented in Wikipedia and in the Wikidata.

The data that can be obtained by looking at these categories are different from those used in the international university rankings. This is due to the fact that many pages of universities are not properly filled in both Wikipedia and Wikidata, they have insufficient information and do not belong to the categories considered. For example, an article in the English Wikipedia Lincoln University of Business and Management has only the category Companies based in Sharjah, which has nothing to do with universities.

According to the website Statistics of Russian education[3] for 2004, there were 4157 universities in Russia. Let's build a SPARQL query to find out how many universities have information in Wikidata:

#added 2017-03#Number of universities in RussiaSELECT?university?universityLabel?countryWHERE{?universitywdt:P31wd:Q3918;# instance of university wdt:P17wd:Q159;# with country Russiardfs:label?item_label.FILTER(LANG(?item_label)="en").SERVICEwikibase:label{bd:serviceParamwikibase:language"en".}}

Bubble chart visualization of number of universities in different countries

Altogether, out of 250 countries, two hundred have universities. Leaders in the number of universities are: the United States of America - 1,608 universities, India - 930, Japan - 836. Russia is in fifth place with 453 universities.

As a result of the script, Petrozavodsk State University (PetrSU) will not be displayed on the map. It is caused by the fact that the object on the Wiktidata, corresponding to PetrSU, does not have the property "coordinate location". To fix this, the coordinates were added to the PetrSU object.

Incorrect filling of the property "coordinate location" caused Tver State Universite float at the ocean

As you can see in the screenshot below, the Tver State University (TSU) is displayed on a map in the Atlantic Ocean. This was also caused by the incorrect filling of the property "coordinate location". This problem was also fixed.

Map of Wikidata objects corresponding to Russian universities and having the property "coordinate location"

Let's data on the location of one hundred universities in the Wikidata. Let's check the success of the filling, once again running the SPARQL query, presented above. As of May, it will return 308 records.

The graph of universities and scientists was drawn with the help of SPARQL script. Vertices are universities and scientists. The edge corresponds to the property "educated at", which shows that the scientist studied at this university.

Visualization in the form of graph: universities and scientists who studied in them. The vertices are universities and scientists. The "educated at" property is an edge

List all universities named after someone ("named after" property). For this list:

to learn the names of people universities are called by. What profession they have? The answer should be in the form of a bubble diagram.

to learn universities are called by the names of living or dead people? How many of those and other countries?

to draw a graph (histogram), where the X axis is the number of years since the death of the person who gave the name to the university, to the institution's founding, along the Y axis - how many such universities (for example, Ivanov AA died in 1825, established his name in 1850 , Then on the X axis at 25 add a single line to the histogram (by Y).

Find universities with founders ("founded by" property). Mark them on the map.

Make a ranking of universities by the number of awards according to the data of the Wikidata ("award received" property).

Find the oldest university and output the following information:

The city in which it is located,

Calculate how old the university is now,

A list of famous scientists who studied at this university.

To draw up a columnar diagram of the number of universities in the cities of Russia.