undp / digital-development-compass Goto Github PK

@idan, @mattrothenberg, Irene, & @Wattenberger (OCTO DX) got together to flesh out the tasks that are needed to make this project a success. We figured this would be the best way to split up the work. Please edit as much as you want!

Data manifest details:
Matt & Amelia dug into the filename matching spreadsheet, and there's a good amount of work that needs to be done to get all of the data into clean csv files. We put together a spreadsheet that lists the necessary info for fetching that data - check out the first two rows and please let us know if anything's unclear.
data_manifest.csv
What we found was that converting between formats (eg. xlsx -> csv) was straightforward, and most of the work here will revolve around figuring out where the data actually lives (eg. in the third spreadsheet in the xlsx download).
We were thinking we could use our current project that fetches data and processes it using Deno scripts. For example, this script to convert xlsx -> csv:

import { xlsx, readXLSX, writeCSV } from "https://deno.land/x/[email protected]/mod.ts";

const inputFilename = Deno.args[0];
const outputFilename = inputFilename.replace(".xlsx", ".csv");

const workbook = await readXLSX(inputFilename);
const sheetData = workbook.Sheets[workbook.SheetNames[0]];
const csvString = await xlsx.utils.sheet_to_csv(sheetData);

await writeCSV(outputFilename, csvString);

          Missing file type?

Originally posted by @mbelinsky in #66 (comment)

From slack discussion, it sounds like we want this to be a React app. Let's stand up an initial app to get started.

• Set up barebones app
• Get app to fetch basic data from "database" (the project repository)

The country borders for Lesotho are not visible on the homepage and the country cannot be selected from the map. But visible in data.

Drawing on the alpha and beta wireframes and the available datasets, do some exploration of what data visualizations we could create. This issue will track designs and async feedback.

Let's confirm how this page(s) will fit into https://data.undp.org/. In the case that this will be a standalone website, this issue will track creating web designs including layout, branding, etc.

Write a script to convert raw data files to CSV.