Creating Data and Metadata Files for Uploading to Wikiprogress.stat
From Wikiprogress.org
Contents |
Create a data file for loading into wikiprogress.stat
From an Original Excel table (NUMBERS are ABITRARY):
This is an example of some data in Excel that I wish to upload to wikiProgress.Stat. There are 3 dimensions:
• Time
• Country
• Indicator
Note that you can have as many dimensions as you wish, but the common dimensions must be named in a common fashion. The common dimensions are:
• Country/Location. The dimension name must be Location in the .csv file file. An example is below
• Gender/Sex. The dimension name must be Sex
• Year/Time. The dimension name must be Time. An example is below
Steps to produce the csv file to upload data From the above excel example
1. Change the country names to their ISO 3166-1 alpha 3 equivalents. You can find the codes here.
For example:
Australia becomes AUS
France becomes FRA
2. ‘Pivot’ the table to produce a ‘flat’ structure. Each line should contain 1 data point:
1. Change the column headings to match the wikiprogress.Stat ‘common’ dimensions, and add a Value heading:
- Country becomes Location
- Year becomes Time
Resulting in:
3. Concatenate the columns together to produce a ‘CSV’ file using a formula like this:
=A10&","&B10&","&C10&","&D10
The results of this formula should produce these results:
4. Open Notepad or a similar text editor and Copy & Paste the results table in step 4 into a new file. Save the file with a .csv extension, e.g. ‘data.csv’
Use this file as your ‘data file’ in the wikiProgress.Stat Loader application.
Create a metadata file for loading into wikiprogress.stat
Wiki.Stat metadata files are simple text files (.txt). Metadata can be attached at the dataset level to describe your dataset. Perform these steps to create the .txt file
