Improve description of what a record is and how rows and records are different

[ostephens]

How could the content be improved?

At the moment the definition of a record is not very clear or understandable to learners.
We could do with better explanation in the lesson plus instructor notes expanding on this with some examples

Additional thoughts:
Second sentence "row usually reps record"--in terms of tabular data.
Contrast to relational data multiple rows may be linked to one record.

Open Refine concept of record
General data concept of record

Bring in ODLIS definition: each record one row

In OR it's possible for multiple rows to connect to one record/idea

Which part of the content does your suggestion apply to?

https://librarycarpentry.org/lc-open-refine/03-working-with-data.html

[ostephens]

Feedback we've had from learners:

What is a "record" in OR? It has very little to do with rows. Or is my mind stuck in seeing tabular data and assuming it is the best option, when in fact, the table is just the least messy way to provide consistent visuals? The instructor said records share the same first column (but really it's the third column of images after the flag and tick box) so I need to fill in the blanks with the item last seen above; like ditto marks. I have a note about "records are better to facet" but cannot decipher what that means today. And that records are safer than row.record.cells["data"].value[0] but I have no idea what all of that meant at the moment or now.

[ostephens]

See also #293 #96

[ostephens]

I've duplicated this with #329 so will close this in favour of that new issue