opendataam / opendatam-tasks

Public tasks for volunteers, hackathons and contests
Creative Commons Zero v1.0 Universal
8 stars 0 forks source link

[EN] Convert market inspection agency check schedules from Excel to CSV/JSON #20

Open ivbeg opened 1 year ago

ivbeg commented 1 year ago

Goal

To make available Market inspection agency check schedules as JSON or CSV files.

Tasks

Market inspection agency yearly publishes check schedules as Excel files on its website http://www.msib.am/hy/applications Example file ՇՈՒԿԱՅԻ ՎԵՐԱՀՍԿՈՂՈՒԹՅԱՆ ՏԵՍՉԱԿԱՆ ՄԱՐՄՆԻ 2023 ԹՎԱԿԱՆԻ ՍՏՈՒԳՈՒՄՆԵՐԻ ԾՐԱԳԻՐ.xlsx

Tasks are:

  1. Collect all check schedules as Excel files
  2. Analyze Excel files structure
  3. Convert Excel files to CSV or JSON files
  4. Merge data into single CSV or JSON files adding check schedule year to each record

Context

This data is interesting for business, converting it from Excel to open data could help to create services and apps to help business to plan and operate.

Requirements

Wishes

Please write your code as reusable code that could be launched by someone else later since we could need to update this dataset later.

Resources

Prepared by

The Open Data Armenia team prepared this task.