Exploring Chapter 2 of Open Refine Pt. 1



I am quick to admit that uploading the GZ file was something new for me, and I struggled with this for over an hour. After testing nearly every option I saw in Open Refine, I finally found where to import a project that has already been “worked on”. When reading the chapter, I do not remember seeing any guidance on how to mess with this data, and I believe clarity with this would go a long way. Alas, it is done so I can begin working on Recipe 1.

Recipe 1
In recipe 1, sorting seemed fairly straight forward and somewhat like the sort feature on Excel. The main difference worth noting, something addressed in Chapter 1, was the ability to easily undo and redo the changes that have been made to the data sets. The convenience of sorting and easily restoring the information to its original state makes the sorting feature rather nice.

Recipe 2
In recipe 2, I learned how to use facets to retrieve records. This can come in handy when I want to weed out the records with obvious errors or even isolate a specific range of records. Similar to what I learned in Chapter 1, I have found that the most beneficial tool in this recipe is the ability to flag multiple entries at once and even filter records to show just the flagged entries.

Recipe 3
In recipe 3, I learned how to extrapolate duplicate records using tiered facets. This was a rather lengthy process, but it was quicker than going through all of the records manually. It was a little confusing during my first attempt, but I later realized that the confusion stemmed from me not clearing the facets from recipe 2. Once I reset my data, I was able to work through the recipe with ease.

In these three recipes, everything seemed pretty straight forward, and having the screenshot images in the text was extremely helpful as it helped me confirm that what I had done was correct.

Comments

Post a Comment

Popular posts from this blog

Working through R: Part. 1

Over the course of the weekend, I have had some time to explore R and its many parts as I worked through parts 1-3 of our assignment. There were many times during the assignment where I felt like throwing my computer across the room… (I admit, I did toss it across the bed and scream) but I persisted, nonetheless. While I have found R a rather fascinating tool when working with data, it is quite frustrating if you are a novice. Muddling through the instructions, I encountered many issues when it came to installing packages, connecting with ORCID, and lastly performing some of the functions on Clarke’s tutorial. Perhaps, this was in part due to the uploading procedures not being as described in the instructions--that could be a Mac issue? Anyway, after I finally got connected and got the data loaded into R, I was ready to go. It started off great, and I was able to easily explore the dataframes. I was even able to receive the same results as Clarke showed in his tutorial; what a succes...
Read more

Working through R: Part. 2

Last night, the amazing Brittani sent me a wonderful tutorial on how to input data on R when using a Mac computer. This was the most beneficial thing I have received for this assignment, as without it I would have been unable to work through part 3 of Clarke’s data exploration tasks. This weekend, I thought I had uploaded the data in its entirety, but I was mistaken. Using the tutorial, I was able to add my data into R and get started on Clarke’s tutorials. With the data in the system, I was able to quickly work through the tutorial and retrieve the intended results. While I did have a few hiccups, Clarke’s tutorial had some slight errors in field names, I was able to resolve the problems and continue through the tutorial. One thing that I noticed during my attempts is that capitalization matters! If you forget to capitalize something it could very well result in an error message. That was a learning experience, but I caught on quickly. Overall, I was able to muddle through the tutoria...
Read more

Experiencing Wikidata Query Service

Today, I took the time to explore Wikidata SPARQL. The first query I ran involved locating triples that had an instance of house cat. The query results appeared in a spreadsheet style format below my search. After learning how to perform these queries, I was able to explore Wikidata and craft my very own queries. To start, I did a simple transition from house cats (Q146) to sloth (Q2274076). Since I kept my property the same but changed the value, I received the same type of exhaustive list that house cats produced but for sloths. Feeling semi-confident about venturing into new queries, I performed additional property value searches that would allow me to text my knowledge of the overall process. During one of my explorations, I wanted to explore books that fell within the same series as Harry Potter and the Philosopher’s Stone . At first, I attempted my query with the property as part of the series (P179) with the value as Harry Potter and the Philosopher’s Stone (Q102438). This sea...
Read more