Ukraine CODB bug - Githubissues

USAID-OHA-SI / fastR

Import COP19/20 FAST ER Tool

Other

0 stars 1 forks source link

Ukraine CODB bug #13

Closed achafetz closed 5 years ago

achafetz commented 5 years ago

Vlad noted that Ukraine has extra CODB lines where Ukraine is listed as the funding agency. This shouldn't be the case, so something is going on with the filtering out the second table on the sheet.

achafetz commented 5 years ago

costtype for the three affected rows is COP 20-22. COP should just be COP 19 (and this is what is filtered out). The team must have dragged down and Excel copied the pattern down. These lines should be deleted from the dataset.

Need to adjust ln16 below to filter out any column that starts with "COP" not just "COP 19".

https://github.com/USAID-OHA-SI/fastR/blob/5fac2563d37ce8a20aa1c1230cb34aef393edb24/R/limit_codb.R#L14-L17