Course Details

01:198:210 Data Management for Data Science

  • Course Code: 01:198:210
  • Title: Data Management for Data Science
  • Short Description: This course is designed to provide students with the knowledge and skills needed to acquire and curate real word data, to explore the data to discover patterns and distributions, and to manage large datasets with databases.
  • Semester(s) Offered: Spring
  • Degree Type (BA/BS): Foundational Courses (All Tracks)
  • Track Option: Chemical Data Science Track (Code: NB219CJ), Computer Science Track (Code: NB219SJ), Economics Track (Code: NB219EJ), Societal Impact Track (Code: NB219IJ), Statistics Track Courses (Code: NB219TJ)
  • Degree Option: Foundational Courses (All Tracks)
  • Prerequisite: CS 142 (Data 101: Data Literacy) OR CS 111 (Introduction to Computer Science) CS students may use this course as an elective for the major.
  • Learning Goals:

    At the end of the course, students will be able to use basic Python and a small set of libraries to acquire data from various online sources including CSV files and JSON formatted files. They will be able to store data from these sources using simple, easy to use Python storage structures. Students will be able to perform curation using basic Python programming and regular expressions. They will be able to understand and further curate various aspects of dataset attributes using the Python libraries NumPy and Pandas. They will be able to explore and find patterns and distributions in data through visualization using the Python library matplotlib. Students will be able to get structured data into a relational database and manage it using SQL, and get unstructured data into a NoSQL database and manage it with NoSQL management features.