[Eril-l] question about OpenRefine

Fri Mar 5 08:21:16 PST 2021

That's correct! Fill down will only go down through blank rows until it hits a row that contains data. So long as you do it immediately after splitting the cells, without re-sorting, then it should populate everything correctly. Just make sure you're viewing the page as rows instead of records, though, or fill down won't do anything.

____________________________________
Kate Reagor, MSIS
Library Technical Services Specialist
Texas State Library and Archives Commission
texshare at tsl.texas.gov<mailto:texshare at tsl.texas.gov> | kreagor at tsl.texas.gov<mailto:kreagor at tsl.texas.gov>

From: Harper, Cynthia <charper at vts.edu>
Sent: Friday, March 5, 2021 10:15 AM
To: Kate Reagor <kreagor at tsl.texas.gov>; eril-l (eril-l at lists.eril-l.org) <eril-l at lists.eril-l.org>
Subject: RE: question about OpenRefine

Does "Fill down" work so that if in row 1 and row 6 there are values, but not in rows 2,3,4,5 and 7,8,9, it would copy the value of row 1 into 2,3,4,5, and row 6 into 7,8,9, etc over thousands of rows?

Cindy

From: Kate Reagor <kreagor at tsl.texas.gov<mailto:kreagor at tsl.texas.gov>>
Sent: Friday, March 5, 2021 10:51 AM
To: Harper, Cynthia <charper at vts.edu<mailto:charper at vts.edu>>; eril-l (eril-l at lists.eril-l.org<mailto:eril-l at lists.eril-l.org>) <eril-l at lists.eril-l.org<mailto:eril-l at lists.eril-l.org>>
Subject: RE: question about OpenRefine

Hi Cynthia,

You can do this pretty simply in OpenRefine! Try these steps:

  *   Set the page to Show as Rows, not Records
  *   Select row A's dropdown: Edit cells > Split multi-valued cells. Set the separator to: "~"
  *   Then for rows B-R, select the dropdown: Edit cells > Fill down

Also if you want to standardize the format of the numbers in row A so they're all text instead of numbers, you can apply a little extra code. When I tried Edit Cells > Common transforms > To text, it converted the one numberic ISBM (row 18) to Scientific Notation format (9.05774043E8). If it does that for you, you can fix that by using this instead:

Row A > Edit cells > Transform, then input the expression: value.floor().toString()

That will update just the number formatted cells into text.

If you run into any trouble with this or have any questions, feel free to reach out to me directly. I'm happy to help!

-Kate

____________________________________
Kate Reagor, MSIS
Library Technical Services Specialist
Texas State Library and Archives Commission
texshare at tsl.texas.gov<mailto:texshare at tsl.texas.gov> | kreagor at tsl.texas.gov<mailto:kreagor at tsl.texas.gov>

From: Eril-l <eril-l-bounces at lists.eril-l.org<mailto:eril-l-bounces at lists.eril-l.org>> On Behalf Of Harper, Cynthia
Sent: Thursday, March 4, 2021 11:24 AM
To: eril-l (eril-l at lists.eril-l.org<mailto:eril-l at lists.eril-l.org>) <eril-l at lists.eril-l.org<mailto:eril-l at lists.eril-l.org>>
Subject: [Eril-l] question about OpenRefine

Any OpenRefine users here?

Doues OpenRefine have an easy way of taking the multiple-value ISBNs in Coulmn A here

And convert each into a group of rows with an individual ISBN in column A, and the same values that are already in columns B-E?

I wrote an Excel function to do this, but it inserts the rows into the range, and that is too expensive in reordering all the rows every time.

That would be
1a
0877097143
b10000021
The politics of revolution /
JK271 .W563
Revolutions."~"United States Politics and government.
1b
9780877097143
b10000021
The politics of revolution /
JK271 .W563
Revolutions."~"United States Politics and government.
Top of Form
Bottom of Form

Configure Parsing Options
Project name
Tags

020|a
Record Number(Bibliographic)
245|a
Call No.
Subject
1.
0877097143"~"9780877097143
b10000021
The politics of revolution /
JK271 .W563
Revolutions."~"United States Politics and government.
2.
0837011388"~"9780837011387"~"0837011388
b10000057
Woman
FICHE 43
Women in church work."~"Microforms.
3.
0837012201"~"9780837012209"~"0837012201
b10000070
Woman, church and state
FICHE 74
Women's rights."~"Women History."~"Women and religion."~"Microforms.
4.

b10000082
The social and civil status of woman
FICHE 55
Women's rights."~"Women Religious aspects Christianity."~"Microforms.
5.

b10000100
The old faith and the new woman
FICHE 57
Women Religious aspects Christianity."~"Microforms.
6.
0814315119"~"9780814315118
b10000124
Mythopoesis :
PN56.M95 S5
Mythology in literature.
7.

b10000136
Critical examination of some passages in Gen. 1
FICHE 200
Bible. Genesis Criticism, interpretation, etc."~"Bible and geology."~"Microforms.
8.
0521443636"~"9780521443630"~"0521479320"~"9780521479325
b1000015x
Reinhold Niebuhr and Christian realism /
BX4827.N5 L68 1995
Niebuhr, Reinhold, 1892-1971."~"Christian sociology History 20th century."~"Christianity and politics History 20th century."~"Christian ethics History 20th century.
9.
0837012376"~"9780837012377"~"0837012376
b10000161
Observations on Professor W. R. Smith's article "Bible" in the Encyclopædia britannica
FICHE 120
Smith, W. Robertson (William Robertson), 1846-1894. Bible."~"Microforms.
10.
0905774043
b10000197
Thanksgiving for a liberated prophet :
BS1520.2.Z72 W6
Bible. Isaiah LIII Criticism, interpretation, etc.
11.
0837007437"~"9780837007434"~"0837007437
b10000203
The text of the Old Testament considered
FICHE 171
Bible. Old Testament Introductions."~"Bible. Old Testament Criticism, Textual."~"Bible Hermeneutics."~"Apocryphal books (Old Testament) Criticism, interpretation, etc."~"Microforms.
12.
0837012341"~"9780837012346"~"0837012341
b10000215
Miscellanies
FICHE 203
Congregational churches Sermons."~"Microforms.
13.
083701235X"~"9780837012353"~"083701235X
b10000227
The obligations and duties of the female sex to Christianity
FICHE 92
Women and religion."~"Microforms.
14.
0837012449"~"9780837012445"~"0837012449
b10000252
A discourse on the transient and permanent in Christianity
FICHE 191
Unitarian churches Sermons."~"Microforms.
15.
0829407464"~"9780829407464"~"0829407464
b10000264
Pentecostal unity :
BX9.5.B34 C76 1993
Assemblies of God Relations Catholic Church."~"Catholic Church Relations Assemblies of God."~"Catholic Church Doctrines."~"Assemblies of God Doctrines."~"Baptism in the Holy Spirit and Christian union."~"Pentecostalism Catholic Church."~"Pentecostal churches Doctrines.
16.

b10000276
Woman's voice in the church
FICHE 76
Women Religious life."~"Women Religious aspects Christianity."~"Microforms.
17.
0837012538"~"9780837012537"~"0837012538
b10000288
Women of the Bible
FICHE 63
Bible Biography."~"Women in the Bible."~"Microforms.
18.
0300059523"~"9780300059526"~"0300070632"~"9780300070637"~"0300059523
b10000379
Who are the people of God? :
BV598 .K26 1995
People of God History of doctrines Early church, ca. 30-600."~"Church History of doctrines Early church, ca. 30-600."~"Christianity Origin.
19.
0819105775"~"9780819105776
b10000410
The Necessity of systematic theology /
BT45 .N364
Philosophical theology."~"Theology, Doctrinal.
20.
0932180043"~"9780932180049"~"0567023591"~"9780567023599"~"0932180043
b10000446
Perspectives on Luke-Acts /
BS2589 .P467
Bible. Luke and Acts Criticism, interpretation, etc.

Cindy Harper
Electronic Services and Periodicals Librarian
Virginia Theological Seminary, Box 159
3737 Seminary Road
Alexandria, VA 22304
charper at vts.edu<mailto:charper at vts.edu>
(703)461-1794

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.eril-l.org/pipermail/eril-l-eril-l.org/attachments/20210305/f38e999a/attachment.html>