Using OpenRefine, Excel, or any other program, MAKE THREE (3) Transformations to the original dataset.a. Transformations may include (but are not limited to) things like: i. Reformatting a dataset so that it works in OpenRefine or Excel; ii. Data cleaning within any column; iii. Adding a column of relevant but previously missing values; iv. Splitting one column into two, where useful; v. Reformatting dates; vi. Transforming the data file from one format (such as Excel) to another, more sustainable format (such as CSV); vii. Cleaning up whitespace; etc.b. You MUST BE ABLE TO JUSTIFYthe transformations you made in terms of the needs of a designated community for the data. You will not write the justification in this assignment, but you will include it in your final project. Please see the final project instructions for clarification on this. In the final project, you will be asked to cite two external information sources (such as scholarly articles) that demonstrate you have researched your designated communities, so you can justify transformations you make. 3. Save both copies of your dataset (the original and the transformed version) as separate files. Your transformed dataset should be in CSV, JSON, XLXS, XLS, or XML.4. Generate an MD5 checksum for your original dataset. (using the onlinemd5 tool linked on slide 68 of the Unit 4 Powerpoint.)5. Create a METS file per the instructions given during Unit 5. Fill out all of the relevant information in the METS file, about yourself (as the curator) and your original data file.
0 comments