Open Refine for Ecology: Instructor Notes

Note the file types OpenRefine handles: TSV, CSF, *SV, Excel (.xls .xlsx), JSON, XML, RDF as XML, Google Data documents. Support for other formats can be added with OpenRefine extensions. In this first step, we’ll browse our computer to the sample data file for this lesson (If you haven’t already, download the data from: https://www.dropbox.com/s/kbb4k00eanm19lg/Portalrodents19772002scinameUUIDs.csv). In this case, I’ve modified the Portalrodents.csv file. I added several columns: scientificName, locality, county, state, country and I generated several more columns in the lesson itself (JSON, decimalLatitude, decimalLongitude). Data in locality, county, country, JSON, decimalLatitude and decimalLongitude are contrived and are in no way related to the original dataset. Once OpenRefine is open, you’ll be asked if you want to Create, Open, or Import a Project. Exploring data by applying multiple filters OpenRefine supports faceted browsing as a mechanism for

Remote updated date: 2017-04-25

External resources:
Open Refine for Ecology: Instructor Notes https://tess.elixir-europe.org/materials/open-refine-for-ecology-instructor-noteslesson Note the file types OpenRefine handles: TSV, CSF, *SV, Excel (.xls .xlsx), JSON, XML, RDF as XML, Google Data documents. Support for other formats can be added with OpenRefine extensions. In this first step, we’ll browse our computer to the sample data file for this lesson (If you haven’t already, download the data from: https://www.dropbox.com/s/kbb4k00eanm19lg/Portal_rodents_19772002_scinameUUIDs.csv). In this case, I’ve modified the Portal_rodents.csv file. I added several columns: scientificName, locality, county, state, country and I generated several more columns in the lesson itself (JSON, decimalLatitude, decimalLongitude). Data in locality, county, country, JSON, decimalLatitude and decimalLongitude are contrived and are in no way related to the original dataset. Once OpenRefine is open, you’ll be asked if you want to Create, Open, or Import a Project. Exploring data by applying multiple filters OpenRefine supports faceted browsing as a mechanism for 2017-04-25

This Material is currently not included in any packages.

scraper updated Open Refine for Ecology: Instructor Notes at 2017-04-25 03:03:04 UTC.
changed Remote updated date to: 2017-04-25
scraper updated Open Refine for Ecology: Instructor Notes at 2017-04-24 03:03:11 UTC.
changed Remote updated date to: 2017-04-24
scraper updated Open Refine for Ecology: Instructor Notes at 2017-04-23 03:03:18 UTC.
changed Remote updated date to: 2017-04-23
scraper updated Open Refine for Ecology: Instructor Notes at 2017-04-22 03:02:55 UTC.
changed Remote updated date to: 2017-04-22
changed Short description to: Note the file types OpenRefine handles: TSV, CSF, *SV, Excel (.xls .xlsx), JSON, XML, RDF as XML, Google Data documents. Support for other formats can be added with OpenRefine extensions. In this first step, we’ll browse our computer to the sample data file for this lesson (If you haven’t already, download the data from: https://www.dropbox.com/s/kbb4k00eanm19lg/Portal_rodents_19772002_scinameUUIDs.csv). In this case, I’ve modified the Portal_rodents.csv file. I added several columns: scientificName, locality, county, state, country and I generated several more columns in the lesson itself (JSON, decimalLatitude, decimalLongitude). Data in locality, county, country, JSON, decimalLatitude and decimalLongitude are contrived and are in no way related to the original dataset. Once OpenRefine is open, you’ll be asked if you want to Create, Open, or Import a Project. Exploring data by applying multiple filters OpenRefine supports faceted browsing as a mechanism for
changed Title to: Open Refine for Ecology: Instructor Notes
scraper updated Open Refine for Ecology: Instructor Notes at 2017-04-21 03:03:04 UTC.
changed Remote updated date to: 2017-04-21
scraper created Open Refine for Ecology: Instructor Notes at 2017-04-20 03:05:13 UTC.