develop script to calculate FAIRscore metrics

usap-dc-dev / usap-dc-website

repository for usap-dc website. Includes javascript client side app and python/flask server side.

2 stars 0 forks source link

develop script to calculate FAIRscore metrics #48

Open fnitsche2001 opened 4 months ago

fnitsche2001 commented 4 months ago

To track the improvement (hopefully) of the FAIRscore of the submissions over time, we want to determine and calculate a matrix and related statistics. A script could generate a file that has the average score per datasets and the dataset creation date. This could be used to calculate various statistics (total average score, or average score per year. If we run this script every year or six months, we can track if there is any improvement over time.

astrong-ldeo commented 3 months ago

Potential solution:

Make view in DB that shows dataset ID, creation date/time, and overall FAIR score
Periodically (2-4 times a year) export this view as a CSV
Add data from these CSV files to a graph on the usap-dc.org/stats page

astrong-ldeo commented 3 months ago

I made the view dataset_fairness_score in the dev database to be examined by other members of the team. If it looks good I will duplicate it in prod.