Museums in Romania (9-10)

Context

An essential step in the digitization process of cultural heritage is the collection, structuring, and publication of data. Without real, coherent, and accessible data, any analysis or digital application would remain at a purely theoretical level.

The National Heritage Institute directly contributes to this process by publishing open datasets on the government platform data.gov.ro, providing public access to official information about cultural institutions in Romania. Among these is the dataset regarding museums in Romania, which contains information such as museum names, administrative location, year of establishment, geographical coordinates, and descriptive data.

In this problem, you will perform an exploratory analysis for this dataset.

Dataset structure

The dataset is provided in CSV (Comma-Separated Values) format and contains information about museums in Romania, resulting from the conversion of a JSON format published on the data.gov.ro platform.

Each row in the CSV file corresponds to a museum, and each column describes a certain attribute of it.

Relevant fields

The dataset contains, among others, the following columns:

• _id – internal identifier of the record
• județul – the county where the museum is located
• denumirea (română) – the name of the museum in Romanian
• localitatea – the locality where the museum is located
• anul înființării – the year the museum was established
• categoria (română) – the category of the museum
• latitudine – geographical latitude coordinate
• longitudine – geographical longitude coordinate
• descrierea (română) – textual description of the museum
• URL – the museum's website (if available)

Missing values are marked by empty fields.

Requirements

Task 1 - Total number of records (5 points)

Determine the total number of museums in the dataset.

Task 2 - Number of museums in București (10 points)

Determine the number of museums for which we find the value București in the județul column.

Task 3 - Number of columns with missing values (15 points)

Determine the number of columns that contain at least one missing value (NaN).

Task 4 - Year with the most museums (10 points)

Determine the year when the most museums were established, based on the information we have specified in the anul înființării column.

Task 5 - Distribution of museums by counties (20 points)

Determine for each county that appears in this dataset how many museums exist in that county.

Task 6 - Percentage of completed values (20 points)

For each museum, calculate the percentage of completed columns (non-NaN) out of the total columns. The calculation of this score is performed using the following formula:

Task 7 - Average completeness score (10 points)

Determine the average completeness score for the entire dataset. For this, we will add the scores obtained in requirement 6 and divide the total by the number of museums.

Task 8 - Museums with maximum completeness (10 points)

Determine the percentage of museums that have the maximum completeness score. We define the maximum completeness score as the maximum value among those determined in task 6.

Submission file format

For automatic evaluation, you must upload a file in csv format with the following structure:

• id – row identifier (corresponding to the one in test.csv)

  • for task 1, you will use the value 1 for id
  • for task 2, you will use the value 2 for id
  • for task 3, you will use the value 3 for id
  • for task 4, you will use the value 4 for id
  • for task 5, you will use the name of each county (written exactly as it appears in the dataset) as id
  • for task 6, you will use the internal identifier of the record (the _id column from the dataset)
  • for task 7, you will use the value 7 for id
  • for task 8, you will use the value 8 for id

• subtaskID – requirement identifier:

  • 1 for total number of records (task 1)
  • 2 for number of museums in București (task 2)
  • 3 for number of columns with missing values (task 3)
  • 4 for year with the most museums (task 4)
  • 5 for distribution of museums by counties (task 5)
  • 6 for percentage of completed values (task 6)
  • 7 for average completeness score (task 7)
  • 8 for museums with maximum completeness (task 8)

• answer – the answer corresponding to each task

  • for task 1, will contain the total number of museums in the dataset (integer value)

  • for task 2, will contain the number of museums in București (integer value)

  • for task 3, will contain the number of columns that contain at least one missing value (NaN) (integer value)

  • for task 4, will contain the year when the most museums were established (integer value)

  • for task 5, will contain the number of museums in each county (integer value, one row for each county)

  • for task 6, will contain the percentage of completed fields for each museum, calculated as:

    PythonCopy code

    1(number of completed fields / total number of columns) × 100

    (float value, recommended rounded to 2 decimal places)

  • for task 7, will contain the average completeness score for the entire dataset (float value, recommended rounded to 2 decimal places)

  • for task 8, will contain the percentage of museums that have the maximum completeness score (float value, recommended rounded to 2 decimal places)