STT0003: Parse metadata from Catalog (5)

[spsither]

Description

The metadata for all the departments exist in various formats in their catalog Google Sheets. We need scripts to parse those sheets and get all the metadata associated with audio files.

Completion Criteria

Get the metadata in the TSV/CSV file ready to be consumed on evaluation of the model.

---

Implementation Plan

Subtasks

• [x] set google sheet api and authentication
• [x] divide the main google csv files into departments wise csv file
• [x] script to parse google sheet and return df of google sheet
• [x] script to merge the deparment csv files with corresponding google sheet
• [x] merge all departments csv to main file.
• [x] write test cases

[gangagyatso4364]

additional subtask of creating a meta data dictionary containing the columns to be added in main csv file for each department google sheets.

[gangagyatso4364]

i have to reformat the google sheets by deleting unnecessary columns which do not contribute to the data information gain.

[gangagyatso4364]

split the deparment csv file into different parts if the file name id format differs.