{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "Visualising DROID CSV\n", "=====================\n", "\n", "This is a quick experiment in visualising format results from DROID using a Jupyter Notebook.\n", "\n", "First we load in some example results...." ] }, { "cell_type": "code", "execution_count": 13, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", " | ID | \n", "PARENT_ID | \n", "URI | \n", "FILE_PATH | \n", "NAME | \n", "METHOD | \n", "STATUS | \n", "SIZE | \n", "TYPE | \n", "EXT | \n", "LAST_MODIFIED | \n", "EXTENSION_MISMATCH | \n", "SHA1_HASH | \n", "FORMAT_COUNT | \n", "PUID | \n", "MIME_TYPE | \n", "FORMAT_NAME | \n", "FORMAT_VERSION | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "2 | \n", "0 | \n", "file:////10.1.4.222/gda/archives-sample-files/... | \n", "\\\\10.1.4.222\\gda\\archives-sample-files\\opf-for... | \n", "format-corpus | \n", "\n", " | Done | \n", "\n", " | Folder | \n", "\n", " | 2014-02-28T15:49:11 | \n", "False | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
1 | \n", "3 | \n", "2 | \n", "file:////10.1.4.222/gda/archives-sample-files/... | \n", "\\\\10.1.4.222\\gda\\archives-sample-files\\opf-for... | \n", "video | \n", "\n", " | Done | \n", "\n", " | Folder | \n", "\n", " | 2014-02-28T15:48:47 | \n", "False | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
2 | \n", "4 | \n", "3 | \n", "file:////10.1.4.222/gda/archives-sample-files/... | \n", "\\\\10.1.4.222\\gda\\archives-sample-files\\opf-for... | \n", "Quicktime | \n", "\n", " | Done | \n", "\n", " | Folder | \n", "\n", " | 2014-02-28T15:48:59 | \n", "False | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
3 | \n", "5 | \n", "4 | \n", "file:////10.1.4.222/gda/archives-sample-files/... | \n", "\\\\10.1.4.222\\gda\\archives-sample-files\\opf-for... | \n", "apple-intermediate-codec.mov | \n", "Signature | \n", "Done | \n", "319539 | \n", "File | \n", "mov | \n", "2014-02-18T16:58:16 | \n", "False | \n", "d097cf36467373f52b974542d48bec134279fa3f | \n", "1 | \n", "x-fmt/384 | \n", "video/quicktime | \n", "Quicktime | \n", "\n", " |
4 | \n", "6 | \n", "4 | \n", "file:////10.1.4.222/gda/archives-sample-files/... | \n", "\\\\10.1.4.222\\gda\\archives-sample-files\\opf-for... | \n", "animation.mov | \n", "Signature | \n", "Done | \n", "1020209 | \n", "File | \n", "mov | \n", "2014-02-18T16:58:16 | \n", "False | \n", "edb5226b963f449ce58054809149cb812bdf8c0a | \n", "1 | \n", "x-fmt/384 | \n", "video/quicktime | \n", "Quicktime | \n", "\n", " |
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
394 | \n", "396 | \n", "395 | \n", "file:////10.1.4.222/gda/archives-sample-files/... | \n", "\\\\10.1.4.222\\gda\\archives-sample-files\\opf-for... | \n", "InDesign | \n", "\n", " | Done | \n", "\n", " | Folder | \n", "\n", " | 2014-02-28T15:49:11 | \n", "False | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
395 | \n", "397 | \n", "396 | \n", "file:////10.1.4.222/gda/archives-sample-files/... | \n", "\\\\10.1.4.222\\gda\\archives-sample-files\\opf-for... | \n", "Neddy_Flyer_ft_HeatherRyan.jpg | \n", "Signature | \n", "Done | \n", "1620612 | \n", "File | \n", "jpg | \n", "2014-02-18T16:58:08 | \n", "False | \n", "884de50cb1c052c0e10bef306850ee995d965175 | \n", "1 | \n", "fmt/41 | \n", "image/jpeg | \n", "Raw JPEG Stream | \n", "\n", " |
396 | \n", "398 | \n", "396 | \n", "file:////10.1.4.222/gda/archives-sample-files/... | \n", "\\\\10.1.4.222\\gda\\archives-sample-files\\opf-for... | \n", "Neddy_Flyer_HeatherRyan.pdf | \n", "Signature | \n", "Done | \n", "59106 | \n", "File | \n", "2014-02-18T16:58:08 | \n", "False | \n", "9e19b76e8364c840945bc380ab5f98f00a23ab80 | \n", "1 | \n", "fmt/17 | \n", "application/pdf | \n", "Acrobat PDF 1.3 - Portable Document Format | \n", "1.3 | \n", "|
397 | \n", "399 | \n", "396 | \n", "file:////10.1.4.222/gda/archives-sample-files/... | \n", "\\\\10.1.4.222\\gda\\archives-sample-files\\opf-for... | \n", "Neddy_Flyer_HeatherRyan.indd | \n", "Signature | \n", "Done | \n", "1503232 | \n", "File | \n", "indd | \n", "2014-02-18T16:58:08 | \n", "False | \n", "d9211fe38e79f34fb7a043fe34df59527fb6e179 | \n", "1 | \n", "fmt/196 | \n", "\n", " | Adobe InDesign Document | \n", "CS | \n", "
398 | \n", "400 | \n", "396 | \n", "file:////10.1.4.222/gda/archives-sample-files/... | \n", "\\\\10.1.4.222\\gda\\archives-sample-files\\opf-for... | \n", "Neddy_Flyer_README_HeatherRyan.md.rtf | \n", "Signature | \n", "Done | \n", "1210 | \n", "File | \n", "rtf | \n", "2014-02-18T16:58:08 | \n", "False | \n", "3665b0c1457f996359939746752fe86f2025b68d | \n", "1 | \n", "fmt/50 | \n", "application/rtf, text/rtf | \n", "Rich Text Format | \n", "1.5-1.6 | \n", "
399 rows × 18 columns
\n", "