sustainabledevelopment-rwanda / sdg-data-archived

Data repository for SDGs
https://sustainabledevelopment-rwanda.github.io/sdg-data
0 stars 2 forks source link

QA of indicators #186

Open Norric1Admin opened 5 years ago

Norric1Admin commented 5 years ago

@Rmuhayiteto @Twibaze @norberthabimana @imanzijc @fsharangabo @johnkab @nechri The indicators should be assessed before you push them to the live site. The two files below give the changes that we recommend, and guidance to performing the QA process. Let me know if you have any questions, by leaving a comment below.

Norric1Admin commented 5 years ago

Here is a list of the published indicators: 1.1.1 1.2.1 1.3.1 1.4.1 1.5.1 2.2.1 3.1.1 3.1.2 3.2.1 3.2.2 3.3.1 3.3.2 3.3.3 3.7.1 3.7.2 4.2.2 4.6.1 5.5.1 5.a.2 6.1.1 7.1.1 8.1.1 8.3.1 8.5.2 8.10.2 10.5.1 13.1.1 15.1.1 16.1.3 16.6.2 17.6.2 17.8.1

Norric1Admin commented 5 years ago

Any questions you have about this, just leave a comment here with @Norric1Admin in the text. I will get the message, and be able to advise you on what to do.

The most important thing I recommend is to view QA changes and start improving the metadata / data. Usually, this requires a small change to the CSV file, or extra metadata fields.

johnkab commented 5 years ago

Thank You Chris

On Feb 18, 2019, at 3:28 PM, Norric1Admin notifications@github.com wrote:

Any questions you have about this, just leave a comment here with @Norric1Admin https://github.com/Norric1Admin in the text. I will get the message, and be able to advise you on what to do.

The most important thing I recommend is to view QA changes https://github.com/sustainabledevelopment-rwanda/sdg-data/blob/develop/in%20progress/QA%20Checklist.csv and start improving the metadata / data. Usually, this requires a small change to the CSV file, or extra metadata fields.

— You are receiving this because you were assigned. Reply to this email directly, view it on GitHub https://github.com/sustainabledevelopment-rwanda/sdg-data/issues/186#issuecomment-464731440, or mute the thread https://github.com/notifications/unsubscribe-auth/AsttozSKf2U7lSf6QnWYVki2SVwZhhlaks5vOqp8gaJpZM4a5th6.

johnkab commented 5 years ago

@Norric1Admin https://github.com/Norric1Admin Check the error in csv of indicator_4-4-1. I try to correct but don’t find. Thank you

On Feb 18, 2019, at 3:28 PM, Norric1Admin notifications@github.com wrote:

Any questions you have about this, just leave a comment here with @Norric1Admin https://github.com/Norric1Admin in the text. I will get the message, and be able to advise you on what to do.

The most important thing I recommend is to view QA changes https://github.com/sustainabledevelopment-rwanda/sdg-data/blob/develop/in%20progress/QA%20Checklist.csv and start improving the metadata / data. Usually, this requires a small change to the CSV file, or extra metadata fields.

— You are receiving this because you were assigned. Reply to this email directly, view it on GitHub https://github.com/sustainabledevelopment-rwanda/sdg-data/issues/186#issuecomment-464731440, or mute the thread https://github.com/notifications/unsubscribe-auth/AsttozSKf2U7lSf6QnWYVki2SVwZhhlaks5vOqp8gaJpZM4a5th6.

Norric1Admin commented 5 years ago

@johnkab Sure - the problems with https://github.com/sustainabledevelopment-rwanda/sdg-data/pull/201 are as follows... data/indicator_4-4-1.csv : Trailing whitespace in column: Age Group data/indicator_4-4-1.csv : Trailing whitespace in column: Province data/indicator_4-4-1.csv : Leading whitespace in column: Age Group data/indicator_4-4-1.csv : Empty row on rows: [198]

So using the '=TRIM()' function on the CSV in Excel, and removing any empty row at the bottom will fix.

johnkab commented 5 years ago

@Norric1Admin https://github.com/Norric1Admin Thank you. It’s done. I already created metadata, so hope to see this indicator is online published.

On Feb 19, 2019, at 12:51 PM, Norric1Admin notifications@github.com wrote:

@johnkab https://github.com/johnkab Sure - the problems with #201 https://github.com/sustainabledevelopment-rwanda/sdg-data/pull/201 are as follows... data/indicator_4-4-1.csv : Trailing whitespace in column: Age Group data/indicator_4-4-1.csv : Trailing whitespace in column: Province data/indicator_4-4-1.csv : Leading whitespace in column: Age Group data/indicator_4-4-1.csv : Empty row on rows: [198]

So using the '=TRIM()' function on the CSV in Excel, and removing any empty row at the bottom will fix.

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/sustainabledevelopment-rwanda/sdg-data/issues/186#issuecomment-465083464, or mute the thread https://github.com/notifications/unsubscribe-auth/Astto0woBmra3C8OrvcUy2w8mmDoFjHRks5vO9dKgaJpZM4a5th6.

Norric1Admin commented 5 years ago

@johnkab Nice work! The updates should appear tomorrow at https://sustainabledevelopment-rwanda.github.io/sdg-indicators/4-4-1 (see: https://github.com/sustainabledevelopment-rwanda/sdg-data/issues/203).

johnkab commented 5 years ago

@Norric1Admin I tried on this Qualitative indicators (indicator_5-1-1). So I am waiting to see how it looks online. Thank you