Real-world data are commonly messy, distributed, and heterogeneous. This course introduces core concepts of data cleaning and standardisation, and data integration, that are aimed at converting and mapping raw data into other formats that allow more efficient and convenient use and analysis of data. The courses also discusses data quality, management, and storage issues as relevant to data analytics.

Learning Outcomes

Upon successful completion, students will have the knowledge and skills to:

1. Critically reflect upon different data sources, types, formats, and structures,
2. Research, justify and apply data cleaning, preprocessing, and standardisation for data analytics,
3. Apply data integration concepts and techniques to heterogeneous and distributed data,
4. Interpret, assess and discuss data quality measurements,
5. Research and justify advanced data wrangling, data integration, and database techniques as relevant to data analytics

Recommended Resources

Books

1. Data matching - Concepts and techniques for record linkage, entity resolution and duplicate detection (Peter Christen, Springer, 2012). This book is a required text for major parts of the course. There are several copies available in the ANU library.
2. Data mining: Concepts and techniques, 3rd edition (Jiawei Han, Micheline Kamber and Jian Pei, Morgan Kaufmann, 2011) Note: This is also the text book for the data mining course (COM3425 and COMPP8410).
3. Data mining with Rattle and R is a useful book if you plan to use Rattle in this course as well as the Data Mining course (COMP3425 and COMP8410).

Software

1. Pandas (which is included in Anaconda), based on Python.
2. Matplotlib (also included in Anaconda), based on Python.
3. Rattle, based on R.
4. Code repository for the Data wrangling with Python book: https://github.com/jackiekazil/data-wrangling
5. Code repository for data wrangling with Pandas: https://github.com/fonnesbeck/statistical-analysis-python-tutorial (see 2. Data wrangling with Pandas)

Staff Feedback

Students will be given feedback in the following forms in this course:

• Individual written comments
• Verbal comments
• Feedback to the whole class, to groups, to individuals, and/or focus groups

Student Feedback

ANU is committed to the demonstration of educational excellence and regularly seeks feedback from students. Students are encouraged to offer feedback directly to their Course Convener or through their College and Course representatives (if applicable). The feedback given in these surveys is anonymous and provides the Colleges, University Education Committee and Academic Board with opportunities to recognise excellent teaching, and opportunities for improvement. The Surveys and Evaluation website provides more information on student surveys at ANU and reports on the feedback provided on ANU courses.

Class Schedule

Week/Session	Summary of Activities	Assessment
1	Introduction to Data Wrangling Lecture 1: What is data wrangling; and course overview. Lecture 2: The data wrangling process; understanding data. Lecture 3: Data extraction and storage, data warehousing. Interactive lecture Friday 29 July Discussion of issues raised in recorded lectures 1 to 3.	Reading material (all students) Rahm and Do (2000): Data cleaning: Problems and current approaches. New York Times article (2014): For Big Data Scientists, ‘Janitor Work’ is Key Hurdle to Insights
2	Data quality, exploration and cleaning Lecture 4: Web scraping and geocoding of data. Lecture 5: Data quality assessment, data quality dimensions, data profiling, data visualisation, real-world data is dirty. Lecture 6: Resolving data quality issues, data cleaning overview, dealing with missing data. Interactive lecture Friday 5 August Discussion of issues raised in recorded lectures 4 to 6.	Reading material (COMP8430 students only) Strong, Lee and Wang (1997): Data Quality in Context. Online quiz 1 (progress questions weeks 1 and 2). Release of assignment 1.
3	Data pre-processing Lecture 7: Data transformation, aggregation and reduction, Metadata. Lecture 8: Data parsing and standardisation, special case of personal data. Lecture 9: Example data cleaning using Rattle (R based) and Python (Pandas). Tutorial/lab 1 Data exploration using Rattle and practical Pandas exercises. Interactive lecture Friday 12 August Discussion of issues raised in recorded lectures 7 to 9.	Reading material (COMP8430 students only) Krishnan, Haas, Franklin and Wu (2016): Towards Reliable Interactive Data Cleaning: A User Survey and Recommendations.
4	Data integration Lecture 10: Overview of data integration and its importance. Lecture 11: Schema mapping and matching. Lecture 12: Overview of record linkage (process, history, challenges). Tutorial/lab 2 Data cleaning and preprocessing using practical Rattle and Pandas exercises. Interactive lecture Friday 19 August Discussion of issues raised in recorded lectures 10 to 12.	Reading material (all students) First two chapters of Christen (2012): Data Matching – Introduction and the Data Matching Process.
5	Record linkage Lecture 13: Blocking and indexing for record linkage Lecture 14: More on blocking/indexing (phonetic encoding). No practical lab/tutorial (work on assignment 1). Interactive lecture Friday 26 August Discussion of issues raised in recorded lectures 13 to 14.	Reading material (all students) Chapter 4 of Christen (2012): Data Matching – Indexing. Online quiz 2 (progress questions weeks 2 to 5, average of two best quiz marks is worth 5% of total course mark.
6	Record linkage (2) Lecture 15: Record linkage comparison (basics). Lecture 16: Record linkage comparison (string comparison functions). Tutorial/lab 3 Record linkage blocking using Python. Interactive lecture Friday 2 September Discussion of issues raised recorded lectures 15 to 16.	Reading material (all students) Chapter 5 of Christen (2012): Data matching – Field and Record Comparison. Assignment 1 due (Friday 2 September). Release of assignment 2. Release of assignment 3. Release of research paper assignment (COMP8430).
7	Record linkage (3) Lecture 17: Record linkage classification (basics). Lecture 18: Record linkage classification (advanced). Tutorial/lab 4 Record linkage comparison using Python. Interactive lecture Friday 23 September Discussion of issues raised recorded lectures 17 to 18.	Reading material (all students) Chapter 6 of Christen (2012): Data Matching – Classification.
8	Record linkage (4) Lecture 19: Record linkage scalability evaluation, test data generation. Lecture 20: Record linkage quality evaluation, clerical review. Tutorial/lab 5 Record linkage classification using Python. Interactive lecture Friday 30 September Discussion of issues raised recorded lectures 19 to 20.	Reading material (all students) Chapter 7 of Christen (2012): Data Matching – Evaluation of Matching Quality and Completeness.
9	Advanced record linkage Lecture 21: Data fusion, merging records after integration. Lecture 22: Group linkage, collective linkage, active learning, geocode matching, linking temporal and dynamic data, and real-time linkage. Lecture 23: Privacy aspects in data wrangling, and privacy-preserving record linkage. Tutorial/lab 6 Record linkage evaluation using Python. Interactive lecture Friday 7 October Discussion of issues raised recorded lectures 21 to 23.	Reading material (all students) Chapters 8 and 9 of Christen (2012): Data Matching – Privacy Aspects of Data Matching and Further Topics and Research Directions (all students). Schnell et al. (2009): Privacy-Preserving Record Linkage using Bloom Filters (COMP8430 students only). Assignment 2 due (Friday 7 October).
10	Data fusion and ontologies Lecture 24: Ontology mapping and matching. Lecture 25: Wrangling dynamic data and data streams and location (spatial) data. Tutorial/lab 7 Applying Python linkage program to other provided data sets and linkage evaluation. Interactive lecture Friday 14 October Discussion of issues raised in recorded lectures 24 to 25 and assignment issues and questions.
11	Wrangling dynamic data and data streams - Optional tutorial/lab Experiments on privacy-preserving record linkage (comparing linkage quality and performance). There will be no actual lab sessions, but we will provide the lab document and skeleton program and will provide support via Wattle.	Assignment 3 due (Friday 21 October).
12	Course summary - Interactive lecture Friday 28 October Summary of course topics (the main important aspects for the students to get out of this course), and discussion of the final examination.	Research paper assignment due (Friday 28 October - COMP8430 students only).

Tutorial Registration

Sign-up for lab sessions will be available via Wattle.

Assessment Summary

Assessment task	Value	Due Date	Return of assessment	Learning Outcomes
Practical data exploration	10 %	02/09/2022	30/09/2022	LO1: Critically reflect upon different data sources, types, formats, and structures LO2: Research, justify and apply data cleaning, pre-processing, and standardisation for data analytics LO4: Interpret, assess and discuss data quality measurements
Practical data cleaning	15 %	07/10/2022	21/10/2022	LO1: Critically reflect upon different data sources, types, formats, and structures LO2: Research, justify and apply data cleaning, pre-processing, and standardisation for data analytics LO4: Interpret, assess and discuss data quality measurements
Practical record linkage	20 %	21/10/2022	04/11/2022	LO1: Critically reflect upon different data sources, types, formats, and structures LO2: Research, justify and apply data cleaning, pre-processing, and standardisation for data analytics LO3: Apply data integration concepts and techniques to heterogeneous and distributed data LO4: Interpret, assess and discuss data quality measurements LO5: Research and justify advanced data wrangling, data integration, and database techniques as relevant to data analytics
Research paper assessment	10 %	28/10/2022	11/11/2022	LO1: Critically reflect upon different data sources, types, formats, and structures LO2: Research, justify and apply data cleaning, pre-processing, and standardisation for data analytics LO3: Apply data integration concepts and techniques to heterogeneous and distributed data LO4: Interpret, assess and discuss data quality measurements LO5: Research and justify advanced data wrangling, data integration, and database techniques as relevant to data analytics
Online Quizzes	5 %	*	*	LO1: Critically reflect upon different data sources, types, formats, and structures LO2: Research, justify and apply data cleaning, pre-processing, and standardisation for data analytics LO3: Apply data integration concepts and techniques to heterogeneous and distributed data LO4: Interpret, assess and discuss data quality measurements
Final examination	40 %	*	*	LO1: Critically reflect upon different data sources, types, formats, and structures LO2: Research, justify and apply data cleaning, pre-processing, and standardisation for data analytics LO3: Apply data integration concepts and techniques to heterogeneous and distributed data LO4: Interpret, assess and discuss data quality measurements LO5: Research and justify advanced data wrangling, data integration, and database techniques as relevant to data analytics

* If the Due Date and Return of Assessment date are blank, see the Assessment Tab for specific Assessment Task details

Policies

ANU has educational policies, procedures and guidelines, which are designed to ensure that staff and students are aware of the University’s academic standards, and implement them. Students are expected to have read the Academic Misconduct Rule before the commencement of their course. Other key policies and guidelines include:

• Student Assessment (Coursework) Policy and Procedure
• Special Assessment Consideration Policy and General Information
• Student Surveys and Evaluations
• Deferred Examinations
• Student Complaint Resolution Policy and Procedure

Assessment Requirements

The ANU is using Turnitin to enhance student citation and referencing techniques, and to assess assignment submissions as a component of the University's approach to managing Academic Integrity. For additional information regarding Turnitin please visit the ANU Online website Students may choose not to submit assessment items through Turnitin. In this instance you will be required to submit, alongside the assessment item itself, hard copies of all references included in the assessment item.

Moderation of Assessment

Marks that are allocated during Semester are to be considered provisional until formalised by the College examiners meeting at the end of each Semester. If appropriate, some moderation of marks might be applied prior to final results being released.

Participation

You are expected to go to every laboratory session.

Assessment Task 1

Practical data exploration

This assessment covers the topics of data quality, data exploration, and data profiling as presented in the first few weeks of the course. It also includes questions about what data wrangling is, why it is important, and how it fits into the broader field of data analytics.

Assessment Task 2

Practical data cleaning

This assessment covers the topics of data integration and data cleaning, with a focus on identifying possible data quality problems in data sets and taking necessary steps to correct them. It will reflect the real world data cleaning aspects where where students will need to take decisions based on final goal.

Assessment Task 3

Practical record linkage

This assessment covers the topics of record linkage, with a focus on identifying and applying appropriate record linkage techniques in each step of the process; blocking, comparison, classification, and evaluation. Th students will work with different data sets in this assessment.

Assessment Task 4

Research paper assessment

This assignment requires the students to select and read a research paper relevant to data wrangling, and then to summarise and critically analyse this paper.

Assessment Task 5

Online Quizzes

Online Quizzes will cover topics of data quality, data exploration, data profiling, data integration, data cleaning, and record linkage.

Assessment Task 6

Final examination

Final examination will cover every course content students learned during the course.

Hurdle - Students must obtain a final exam mark of at least 45% and a total mark over 50% to pass the course

Academic Integrity

Academic integrity is a core part of our culture as a community of scholars. At its heart, academic integrity is about behaving ethically. This means that all members of the community commit to honest and responsible scholarly practice and to upholding these values with respect and fairness. The Australian National University commits to embedding the values of academic integrity in our teaching and learning. We ensure that all members of our community understand how to engage in academic work in ways that are consistent with, and actively support academic integrity. The ANU expects staff and students to uphold high standards of academic integrity and act ethically and honestly, to ensure the quality and value of the qualification that you will graduate with. The University has policies and procedures in place to promote academic integrity and manage academic misconduct. Visit the following Academic honesty & plagiarism website for more information about academic integrity and what the ANU considers academic misconduct. The ANU offers a number of services to assist students with their assignments, examinations, and other learning activities. The Academic Skills and Learning Centre offers a number of workshops and seminars that you may find useful for your studies.

Online Submission

The ANU uses Turnitin to enhance student citation and referencing techniques, and to assess assignment submissions as a component of the University's approach to managing Academic Integrity. While the use of Turnitin is not mandatory, the ANU highly recommends Turnitin is used by both teaching staff and students. For additional information regarding Turnitin please visit the ANU Online website.

Hardcopy Submission

No hard copy submissions

Late Submission

No submission of assessment tasks without an extension after the due date will be permitted. If an assessment task is not submitted by the due date, a mark of 0 will be awarded.

Referencing Requirements

Accepted academic practice for referencing sources that you use in presentations can be found via the links on the Wattle site, under the file named “ANU and College Policies, Program Information, Student Support Services and Assessment”. Alternatively, you can seek help through the Students Learning Development website.

Extensions and Penalties

Extensions and late submission of assessment pieces are covered by the Student Assessment (Coursework) Policy and Procedure The Course Convener may grant extensions for assessment pieces that are not examinations or take-home examinations. If you need an extension, you must request an extension in writing on or before the due date. If you have documented and appropriate medical evidence that demonstrates you were not able to request an extension on or before the due date, you may be able to request it after the due date.

Privacy Notice

The ANU has made a number of third party, online, databases available for students to use. Use of each online database is conditional on student end users first agreeing to the database licensor’s terms of service and/or privacy policy. Students should read these carefully. In some cases student end users will be required to register an account with the database licensor and submit personal information, including their: first name; last name; ANU email address; and other information. In cases where student end users are asked to submit ‘content’ to a database, such as an assignment or short answers, the database licensor may only use the student’s ‘content’ in accordance with the terms of service — including any (copyright) licence the student grants to the database licensor. Any personal information or content a student submits may be stored by the licensor, potentially offshore, and will be used to process the database service in accordance with the licensors terms of service and/or privacy policy. If any student chooses not to agree to the database licensor’s terms of service or privacy policy, the student will not be able to access and use the database. In these circumstances students should contact their lecturer to enquire about alternative arrangements that are available.

Distribution of grades policy

Academic Quality Assurance Committee monitors the performance of students, including attrition, further study and employment rates and grade distribution, and College reports on quality assurance processes for assessment activities, including alignment with national and international disciplinary and interdisciplinary standards, as well as qualification type learning outcomes. Since first semester 1994, ANU uses a grading scale for all courses. This grading scale is used by all academic areas of the University.

Support for students

The University offers students support through several different services. You may contact the services listed below directly or seek advice from your Course Convener, Student Administrators, or your College and Course representatives (if applicable).

• ANU Health, safety & wellbeing for medical services, counselling, mental health and spiritual support
• ANU Diversity and inclusion for students with a disability or ongoing or chronic illness
• ANU Dean of Students for confidential, impartial advice and help to resolve problems between students and the academic or administrative areas of the University
• ANU Academic Skills and Learning Centre supports you make your own decisions about how you learn and manage your workload.
• ANU Counselling Centre promotes, supports and enhances mental health and wellbeing within the University student community.
• ANUSA supports and represents undergraduate and ANU College students
• PARSA supports and represents postgraduate and research students