Filling in the implied values (fixing Excel)

[andkov]

4 imports data from a Population Estimate query editor. It is given as a Microsoft Excel 97-2003 file. However, when opening on a Windows 10 system the prompt did not identified the file as a valid Excel file, but opened nonetheless. We saved the file as ".xlsx" and fed it to the greeter ./manipulation/0-greeter-population.R.

The Population Estimate Query structured results as Excel spreadsheet

When imported into RStudio, the grouped cells in the Excel spreadsheet become NA in the imported dataframe:

TODO

Using a representative data frame (link) develop a solution to fill in the NA values.

[andkov]

Possible logic of the solution:

• new_value = ifelse( is.na(value), lag(value), value)

Tried this solution, but it solves only a single row.

[Jodh]

Started a merge request which solves the issue, but the code could be better written.