Data Tools

Structured/unstructured data

(Guest lecturers: Benjamin Doherty, Caxy in Chicago; and Mahmoud Said, eSpace in Alexandria, Egypt)

I. Formats

Json
XML
CSV

number: numeric value
string: sequence of characters
array: list of elements
hash: key, value mapping

II. Super duper intro to MYSQL

Normalizing data
Querying the data

III. Tools

Open Refine (a data clean-up tool)
http://openrefine.org/

Json Converters

http://codebeautify.org/jsonviewer
http://jsonviewer.stack.hu/

Mozilla PDF Extracting tool

Extract Web Data
https://www.import.io/

IV. Visualizing Tools

Density Design
raw.densitydesign.org

Mazaika
http://www.mazaika.com/

Google Charts
https://developers.google.com/chart/interactive/docs/gallery?hl=en

DMI Database for Tools and Scrapers
https://wiki.digitalmethods.net/Dmi/ToolDatabase

Gephi

Image Plot
Image J

 

 

Advertisements