Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Translation: Library Carpentry OpenRefine Episode 4 #159

Open
joelnitta opened this issue Aug 5, 2021 · 0 comments
Open

Translation: Library Carpentry OpenRefine Episode 4 #159

joelnitta opened this issue Aug 5, 2021 · 0 comments

Comments

@joelnitta
Copy link
Member

Translation: Library Carpentry OpenRefine Episode 4

Original lesson: https://librarycarpentry.org/lc-open-refine/04-faceting-and-filtering/index.html


  • PO fileの編集についてはREADMEをご参照ください
  • あなたが翻訳し始めたと分かるように、翻訳を始める前にこのイシューを自分に割り振って(assign)、あるいはコメントを書いて下さい。
  • 翻訳が終わったら、プルリクエストを開いて、このイシューを参照・リンクして下さい。

i18n/po/lc-open-refine.ja.po

Lines 1008 to 1226 in bb59a56

#: lc-open-refine/_episodes/04-faceting-and-filtering.md:1
# Front Matter
msgid "---\n"
"title: \"Faceting and filtering\"\n"
"teaching: 10\n"
"exercises: 10\n"
"questions:\n"
"- \"What is a facet in OpenRefine?\"\n"
"- \"What is a filter in OpenRefine?\"\n"
"- \"How can I use filters and facets to explore data in OpenRefine?\"\n"
"- \"How can I easily correct common data issues in my data with OpenRefine?\"\n"
"objectives:\n"
"- \"Explain what Facets and Filters are\"\n"
"- \"Answer questions about the content of a data set using Facets\"\n"
"- \"Use facets and filters to work with a subset of data\"\n"
"- \"Correct data problems through a facet\"\n"
"keypoints:\n"
"- \"You can use facets and filters to explore your data\"\n"
"- \"You can use facets and filters work with a subset of data in OpenRefine\"\n"
"- \"You can easily correct common data issues from a Facet\"\n"
"---"
msgstr ""
#: lc-open-refine/_episodes/04-faceting-and-filtering.md:21
# header
msgid "## Facets"
msgstr ""
#: lc-open-refine/_episodes/04-faceting-and-filtering.md:22
msgid "Facets are one of the most useful features of OpenRefine and can help in both getting an overview of the data and to improve the consistency of the data."
msgstr ""
#: lc-open-refine/_episodes/04-faceting-and-filtering.md:24
msgid "A 'Facet' groups all the values that appear in a column, and then allows you to filter the data by these values and edit values across many records at the same time."
msgstr ""
#: lc-open-refine/_episodes/04-faceting-and-filtering.md:26
msgid "The simplest type of Facet is called a 'Text facet'. This simply groups all the text values in a column and lists each value with the number of records it appears in. The facet information always appears in the left hand panel in the OpenRefine interface."
msgstr ""
#: lc-open-refine/_episodes/04-faceting-and-filtering.md:28
msgid "To create a Text Facet for a column, click on the drop down menu at the top of the publisher column and choose `Facet -> Text Facet`. The facet will then appear in the left hand panel."
msgstr ""
#: lc-open-refine/_episodes/04-faceting-and-filtering.md:30
msgid "The facet consists of a list of values used in the data. You can filter the data displayed by clicking on one of these headings."
msgstr ""
#: lc-open-refine/_episodes/04-faceting-and-filtering.md:32
msgid "You can include multiple values from the facet in a filter at one time by using the `Include` option which appears when you put your mouse over a value in the Facet."
msgstr ""
#: lc-open-refine/_episodes/04-faceting-and-filtering.md:34
msgid "You can also `invert` the filter to show all records which do not match your selected values. This option appears at the top of the Facet panel when you select a value from the facet to apply as a filter."
msgstr ""
#: lc-open-refine/_episodes/04-faceting-and-filtering.md:36
msgid ">## Let's create a text facet\n"
">1. Click on the drop down menu at the top of the publisher column and choose `Facet > Text Facet`. The facet will then appear in the left hand panel\n"
">2. To select a single value, just click the relevant line in the facet\n"
">3. To select multiple values click the `Include` option on the appropriate line in the facet (which only appears when you mouse over the line)\n"
">3. You can 'invert' your selections to `exclude`\n"
">4. Include a value and then look at top to invert inclusion."
msgstr ""
#: lc-open-refine/_episodes/04-faceting-and-filtering.md:44
msgid ">## Which licences are used for articles in this file?\n"
"> Use a `text facet` for the `licence` column and answer these questions:\n"
">\n"
">1. What is the most common Licence in the file?\n"
">2. How many articles in the file don't have a licence assigned?\n"
">\n"
">>## Solution\n"
">>1. Create a facet for the 'Licence' column\n"
">>2. Sort values by `count`\n"
">>3. What is the most common Licence in the file? Answer: `CC BY`\n"
">>4. How many articles in the file don't have a licence assigned? Answer: **6**"
msgstr ""
#: lc-open-refine/_episodes/04-faceting-and-filtering.md:55
#: lc-open-refine/_episodes/04-faceting-and-filtering.md:98
#: lc-open-refine/_episodes/04-faceting-and-filtering.md:119
# SC/DC Template label
msgid ">{: .solution}"
msgstr ""
#: lc-open-refine/_episodes/04-faceting-and-filtering.md:58
# header
msgid "## Filters"
msgstr ""
#: lc-open-refine/_episodes/04-faceting-and-filtering.md:59
msgid "As well as using Facets to filter the data displayed in OpenRefine you can also apply 'Text Filters' which looks for a particular piece of text appearing in a column based on a unique text string, like a 'find' feature. Text filters are applied by clicking the drop down menu at the top of the column you want to apply the filter to and choosing 'Text filter'."
msgstr ""
#: lc-open-refine/_episodes/04-faceting-and-filtering.md:61
msgid "As with Facets, the Filter options appear in the left hand panel in OpenRefine. Simply type in the text you want to use in the Filter to display only rows which contain that text in the relevant column."
msgstr ""
#: lc-open-refine/_episodes/04-faceting-and-filtering.md:63
msgid "You can also use [regular expressions](https://librarycarpentry.github.io/lc-data-intro/01-regular-expressions/) in the filter."
msgstr ""
#: lc-open-refine/_episodes/04-faceting-and-filtering.md:65
# header
msgid "## Working with filtered data"
msgstr ""
#: lc-open-refine/_episodes/04-faceting-and-filtering.md:66
msgid "It is very important to note that when you have filtered the data displayed in OpenRefine, any operations you carry out will apply only to the rows that match the filter - that is the data currently being displayed. To confirm you are working with the data you intended to select, check the number of matching records displayed above the data table. "
msgstr ""
#: lc-open-refine/_episodes/04-faceting-and-filtering.md:68
# header
msgid "## Other types of Facet "
msgstr ""
#: lc-open-refine/_episodes/04-faceting-and-filtering.md:69
msgid "As well as 'Text facets' Refine also supports a range of other types of facet. These include:"
msgstr ""
#: lc-open-refine/_episodes/04-faceting-and-filtering.md:71
# unordered list
msgid "* Numeric facets"
msgstr ""
#: lc-open-refine/_episodes/04-faceting-and-filtering.md:72
# unordered list
msgid "* Timeline facets (for dates)"
msgstr ""
#: lc-open-refine/_episodes/04-faceting-and-filtering.md:73
# unordered list
msgid "* Scatterplot facets"
msgstr ""
#: lc-open-refine/_episodes/04-faceting-and-filtering.md:74
# unordered list
msgid "* Custom facets"
msgstr ""
#: lc-open-refine/_episodes/04-faceting-and-filtering.md:77
msgid "**Numeric and Timeline facets** display graphs instead of lists of values. The graph includes 'drag and drop' controls you can use to set a start and end range to filter the data displayed."
msgstr ""
#: lc-open-refine/_episodes/04-faceting-and-filtering.md:79
msgid "**Scatterplot facets** are less commonly used. For further information on these see the tutorial at [https://web.archive.org/web/20190105063215/http://enipedia.tudelft.nl/wiki/OpenRefine_Tutorial#Exploring_the_data_with_scatter_plots](https://web.archive.org/web/20190105063215/http://enipedia.tudelft.nl/wiki/OpenRefine_Tutorial#Exploring_the_data_with_scatter_plots)."
msgstr ""
#: lc-open-refine/_episodes/04-faceting-and-filtering.md:81
msgid "**Custom facets** are a range of different types of facets. Some of the default custom facets are:"
msgstr ""
#: lc-open-refine/_episodes/04-faceting-and-filtering.md:83
# unordered list
msgid "* Word facet - this breaks down text into words and counts the number of records each word appears in"
msgstr ""
#: lc-open-refine/_episodes/04-faceting-and-filtering.md:84
# unordered list
msgid "* Duplicates facet - this results in a binary facet of 'true' or 'false'. Rows appear in the 'true' facet if the value in the selected column is an exact match for a value in the same column in another row"
msgstr ""
#: lc-open-refine/_episodes/04-faceting-and-filtering.md:85
# unordered list
msgid "* Text length facet - creates a numeric facet based on the length (number of characters) of the text in each row for the selected column. This can be useful for spotting incorrect or unusual data in a field where specific lengths are expected (e.g. if the values are expected to be years, any row with a text length more than 4 for that column is likely to be incorrect)"
msgstr ""
#: lc-open-refine/_episodes/04-faceting-and-filtering.md:86
# unordered list
msgid "* Facet by blank - a binary facet of 'true' or 'false'. Rows appear in the 'true' facet if they have no data present in that column. This is useful when looking for rows missing key data."
msgstr ""
#: lc-open-refine/_episodes/04-faceting-and-filtering.md:88
msgid "Facets are intended to group together common values and OpenRefine limits the number of values allowed in a single facet to ensure the software does not perform slowly or run out of memory. If you create a facet where there are many unique values (for example, a facet on a 'book title' column in a data set that has one row per book) the facet created will be very large and may either slow down the application, or OpenRefine will not create the facet."
msgstr ""
#: lc-open-refine/_episodes/04-faceting-and-filtering.md:90
msgid ">## Find all publications without a DOI\n"
">* Use the `Facet by blank` function to find all publications in this data set without a DOI\n"
">\n"
">>## Solution\n"
">>\n"
">>1. On the `DOI` column drop down and select `Facets > Customized facets > Facet by blank`\n"
">>2. `True` means that it is blank, so you can:\n"
">> * Select `include` on True in the facet to filter the list of publications to only those that don't have a DOI"
msgstr ""
#: lc-open-refine/_episodes/04-faceting-and-filtering.md:101
# header
msgid "## Amending data through facets"
msgstr ""
#: lc-open-refine/_episodes/04-faceting-and-filtering.md:102
msgid "If you create a text facet you can edit the values in the facet to change the value for several records at the same time. To do this, simply mouse-over the value you want to edit and click the 'edit' option that appears."
msgstr ""
#: lc-open-refine/_episodes/04-faceting-and-filtering.md:104
msgid "This approach is useful in relatively small facets where you might have small variations through punctuation or typing errors etc. For example, a column that should contain only terms from a small restricted list such as days of the week or months of the year."
msgstr ""
#: lc-open-refine/_episodes/04-faceting-and-filtering.md:106
msgid "The list of values in the facet will update as you make edits."
msgstr ""
#: lc-open-refine/_episodes/04-faceting-and-filtering.md:108
msgid ">## Correct the Language values via a facet\n"
">\n"
">* Create a `Text facet` on the `language` column and correct the variation in the `EN` and `English` values.\n"
">\n"
">>## Solution\n"
">>1. Create a Text facet on the Language column\n"
">>2. Notice that there is both `EN` and `English`\n"
">>3. Put the mouse over the `English` value\n"
">>4. Click `Edit`\n"
">>5. Type `EN` and click `Apply`\n"
">>6. See how the Language facet updates"
msgstr ""

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant