This wiki has been closed because there have been no edits or logs made within the last 60 days. This wiki is now eligible for being adopted. To adopt this wiki please go to Requests for adoption and make a request. If this wiki is not adopted within 6 months it may be deleted. Note: If you are a bureaucrat on this wiki you can go to Special:ManageWiki and uncheck the "closed" box to reopen it.


From Open Data Scotland
Jump to navigation Jump to search

Data Formats

Common data formats are .csv, .json and .txt files.

Common, more exact, formats include: Turtle (.ttl) and CSV on the Web (.csvw).

Best Practice

For spreadsheets read Data Organization in Spreadsheets by Karl W. Broman & Kara H. Woo


Reading Data

Flatten Tool (json to csv)

Google Sheets: App Script and Google Query Language And a library for version controlling: Clasp

Microsoft Excel

Power Query is an Extract, Transform and Load (ETL) tool built in to Microsoft Excel (from 2016) and Microsoft's Power BI. It has a user interface which allows users to transform data without needing to code, although coding is possible in the "M" language.

Mistakes and open/closed methodologies: Austerity spreadsheet mistake

Data Visualisation

Microsoft PowerBI


R Shiny