Change data format of the CSV file with exported answer data - Githubissues

NRGI / rgi-assessment-tool

MEAN build of RGI 2015 assessment tool

MIT License

5 stars 1 forks source link

Change data format of the CSV file with exported answer data #585

Closed alexander-elgin closed 7 years ago

alexander-elgin commented 7 years ago

[x] See Copy of raw_data2016-12-16-LM_12.1.17_KT.xlsx Yellow columns = remove, green columns = add (for comments, add as many columns as there are comments if possible)
1. REMOVE
  - iso2_country_code
  - iso2_code (answer ID)
  - answer_ID
  - external_answer_letter
  - external_justification
  - external_comment
2. ADD
  - final score justification
3. REPLACE
  - the set {score_history_dateN, score_history_orderN, score_history_score_letterN} for researcher / reviewer with commentN
[x] strip the tags e.g. <p/>
[x] Change the Python script