You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
"- \"Explain what the OpenRefine software does\"\n"
"- \"Explain how the OpenRefine software can help work with data files\"\n"
"keypoints:\n"
"- \"OpenRefine is 'a tool for working with messy data'\"\n"
"- \"OpenRefine works best with data in a simple tabular format\"\n"
"- \"OpenRefine can help you split data up into more granular parts\"\n"
"- \"OpenRefine can help you match local data up to other data sets\"\n"
"- \"OpenRefine can help you enhance a data set with data from other sources\"\n"
"---"
msgstr""
#:lc-open-refine/_episodes/01-introduction.md:18
# header
msgid"## What is OpenRefine?"
msgstr""
#:lc-open-refine/_episodes/01-introduction.md:19
msgid" OpenRefine is a desktop application that uses your web browser as a graphical interface. It is described as \"a power tool for working with messy data\" ([David Huynh](http://web.archive.org/web/20141021040915/http://davidhuynh.net/spaces/nicar2011/tutorial.pdf)) - but what does this mean? It is probably easiest to describe the kinds of data OpenRefine is good at working with and the sorts of problems it can help you or your team solve."
msgstr""
#:lc-open-refine/_episodes/01-introduction.md:21
msgid"OpenRefine is most useful where you have data in a simple tabular format such as a spreadsheet, a comma separated values file (csv) or a tab delimited file (tsv) but with internal inconsistencies either in data formats, or where data appears, or in terminology used. OpenRefine can be used to standardize and clean data across your file. It can help you:"
msgstr""
#:lc-open-refine/_episodes/01-introduction.md:23
# unordered list
msgid"* Get an overview of a data set"
msgstr""
#:lc-open-refine/_episodes/01-introduction.md:24
# unordered list
msgid"* Resolve inconsistencies in a data set, for example standardizing date formatting"
msgstr""
#:lc-open-refine/_episodes/01-introduction.md:25
# unordered list
msgid"* Help you split data up into more granular parts, for example splitting up cells with multiple authors into separate cells"
msgstr""
#:lc-open-refine/_episodes/01-introduction.md:26
# unordered list
msgid"* Match local data up to other data sets, for example in matching local subjects against the Library of Congress Subject Headings"
msgstr""
#:lc-open-refine/_episodes/01-introduction.md:27
# unordered list
msgid"* Enhance a data set with data from other sources"
msgstr""
#:lc-open-refine/_episodes/01-introduction.md:29
msgid"Some common scenarios might be:"
msgstr""
#:lc-open-refine/_episodes/01-introduction.md:31
# unordered list
msgid"* Where you want to know how many times a particular value (name, publisher, subject) appears in a column in your data"
msgstr""
#:lc-open-refine/_episodes/01-introduction.md:32
# unordered list
msgid"* Where you want to know how values are distributed across your whole data set"
msgstr""
#:lc-open-refine/_episodes/01-introduction.md:33
# unordered list
msgid"* Where you have a list of dates which are formatted in different ways, and want to change all the dates in the list to a single common date format. For example:"
msgstr""
#:lc-open-refine/_episodes/01-introduction.md:35
msgid"| Data you have | Desired data |\n"
"|-----------------|:-------------|\n"
"| 1st January 2014| 2014-01-01 |\n"
"| 01/01/2014 | 2014-01-01 |\n"
"| Jan 1 2014 | 2014-01-01 |\n"
"| 2014-01-01 | 2014-01-01 |"
msgstr""
#:lc-open-refine/_episodes/01-introduction.md:42
# unordered list
msgid"* Where you have a list of names or terms that differ from each other but refer to the same people, places or concepts. For example:"
msgstr""
#:lc-open-refine/_episodes/01-introduction.md:44
msgid"| Data you have | Desired data |\n"
"|-----------------|:-------------|\n"
"| London | London |\n"
"| London] | London |\n"
"| London,] | London |\n"
"| london | London |"
msgstr""
#:lc-open-refine/_episodes/01-introduction.md:51
# unordered list
msgid"* Where you have several bits of data combined together in a single column, and you want to separate them out into individual bits of data with one column for each bit of the data. For example going from a single address field (in the first column), to each part of the address in a separate field:"
msgstr""
#:lc-open-refine/_episodes/01-introduction.md:53
msgid"| Address in single field | Institution | Library name | Address 1 | Address 2 | Town/City | Region | Country | Postcode |\n"
"| University of Wales, Llyfrgell Thomas Parry Library, Llanbadarn Fawr, ABERYSTWYTH, Ceredigion, SY23 3AS, United Kingdom | University of Wales | Llyfrgell Thomas Parry Library | Llanbadarn Fawr | | Aberystwyth | Ceredigion | United Kingdom | SY23 3AS |\n"
"| University of Aberdeen, Queen Mother Library, Meston Walk, ABERDEEN, AB24 3UE, United Kingdom | University of Abderdeen | Queen Mother Library | Meston Walk | | Aberdeen | | United Kingdom | AB24 3UE |\n"
"| University of Birmingham, Barnes Library, Medical School, Edgbaston, BIRMINGHAM, West Midlands, B15 2TT, United Kingdom | University of Birmingham | Barnes Library | Medical School | Edgbaston | Birmingham | West Midlands | United Kingdom | B15 2TT |\n"
"| University of Warwick, Library, Gibbett Hill Road, COVENTRY, CV4 7AL, United Kingdom | University of Warwick | Library | Gibbett Hill Road | | Coventry | | United Kingdom | CV4 7AL |"
msgstr""
#:lc-open-refine/_episodes/01-introduction.md:60
# unordered list
msgid"* Where you want to add to your data from an external data source:"
msgstr""
#:lc-open-refine/_episodes/01-introduction.md:62
msgid"| Data you have | Date of Birth from VIAF (Virtual International Authority File) | Date of Death from VIAF (Virtual International Authority File) |\n"
"| Braddon, M. E. (Mary Elizabeth) | 1835 | 1915 |\n"
"| Rossetti, William Michael | 1829 | 1919 |\n"
"| Prest, Thomas Peckett | 1810 | 1879 |"
msgstr""
#:lc-open-refine/_episodes/01-introduction.md:68
# header
msgid"## What Should I Know When Working With OpenRefine?"
msgstr""
#:lc-open-refine/_episodes/01-introduction.md:69
# unordered list
msgid"* No internet connection is needed, and none of the data or commands you enter in OpenRefine are sent to a remote server."
msgstr""
#:lc-open-refine/_episodes/01-introduction.md:70
# unordered list
msgid"* You are NOT modifying original/raw data."
msgstr""
#:lc-open-refine/_episodes/01-introduction.md:71
# unordered list
msgid"* Projects are autosaved every five minutes and when OpenRefine is properly shut down (Ctrl+C). See [History in User Manual](https://docs.openrefine.org/manual/running/#history-undoredo) for details."
msgstr""
#:lc-open-refine/_episodes/01-introduction.md:72
# unordered list
msgid"* Files are saved locally such that if you are working on two computers you will have to export/import files/projects."
msgstr""
The text was updated successfully, but these errors were encountered:
Translation: Library Carpentry OpenRefine Episode 1
Original lesson: https://librarycarpentry.org/lc-open-refine/01-introduction/index.html
i18n/po/lc-open-refine.ja.po
Lines 465 to 616 in bb59a56
The text was updated successfully, but these errors were encountered: