Before analysis comes the messy work of evaluating, cleaning, and transforming data. This hands-on workshop will introduce a free power tool to get the job done: OpenRefine. We will install the latest edition of OpenRefine, create a project, and get oriented to the many features for exploring, scraping, and transforming tabular data.

Participants are encouraged to bring their own device to use during workshops in the Digital Scholarship Commons. Please check in with the Presenter for your workshop to find out if you will need to download any software prior to attending the event. 

If you are not affiliated with the University of Pittsburgh, you will need to register for Wi-Fi access in advance, by following these steps:

CONNECTING TO WIRELESS INTERNET IN THE DIGITAL SCHOLARSHIP COMMONS

FOR CMU AFFILIATES

1. Select the eduroam network from your Wi-Fi list.
2. Log in using your @andrew email address and password (@cmu addresses are not supported).
3. Accept the server's certificate, if prompted.

FOR OTHER EDUROAM AFFILIATES

1. Pitt is an eduroam service provider. You can check to see if your home institution supports using eduroam at remote sites here: https://www.eduroam.us/institutions_list. Your institution must be an “IdP” (Identity Provider) to allow you eduroamaccess.

FOR ALL OTHERS

• Advance online registration is required. Instructions for registration and use follow. This service is for short-term use by visitors on official University business. Guest wireless accounts are limited to 30 consecutive days. If you require wireless access for more than 30 consecutive days, consider using eduroam.
• To set up guest access to wi-fi, please visit http://bit.ly/pittguestwifi to begin the process, as outlined below:
  1. Before you arrive on campus, you must register for access.
  2. Your staff or faculty host will provide you with his/her University Computing Account username which is required for online registration (see below).
  3. Complete the online access request form.
     1. Under Host Information, you will see a field for Host Username. Enter the name of the presenter of your workshop in this field.
     2. You will receive an email, asking you to verify your email address. Click the link in the email and complete the verification form online.
     3. An email will be sent to your host to approve your request. Once approved, you will receive a final email directing you to accept the service usage guideline and select your password.
  4. When you arrive on campus, log in.
     1. Open your wireless network manager and select GUEST-WIRELESS-PITTNET.
     2. Open a Web browser. The Guest Login window will display.
     3. Log in using your email address and the password you selected in advance.