|
|
A spreadsheet is an easy way to keep track of the experimental variables associated with your data. This examples goes through how to:
|
|
|
|
|
|
1. Export metadata from a dataset to a csv file
|
|
|
2. Add metadata to data set from a csv file
|
|
|
|
|
|
In this example we will be using the guess-who images which can be downloaded from **add repo location**.
|
|
|
|
|
|
|
|
|
## 1. Export key-value metadata
|
|
|
|
|
|
**1. Select the dataset**
|
|
|
|
|
|
**2. Select the script** by clicking on the `Run Script` icon ![Run Script](./media/icon_50.png) and navigate to `MIF > Key Val to csv...`
|
|
|
![Select dataset and run the script](./media/run_script2_50.png)
|
|
|
|
|
|
**3. Click `Run Script`**. The script will already have the dataset ID filled in from the selected dataset. You can select multiple datasets by holding shift or add other IDs in the box. The script will say `Done` and have a green tick when it has run.
|
|
|
|
|
|
![Script options](./media/script_options_50.png)
|
|
|
|
|
|
**4. Click the attachment** to download it.
|
|
|
The dataset now has an attachment (you may need to press the `Refresh` button ![Refresh](./media/refresh_icon_50.png). The attachment is the name of dataset
|
|
|
|
|
|
![The attached csv](./media/csv_added_50.png)
|
|
|
|
|
|
|
|
|
## 2. Edit the csv in Excel
|
|
|
After downloading open it in Excel. The file will have a single column
|
|
|
|
|
|
|
|
|
|