Course Code: ANL252

Synopsis

ANL252 Python for Data Analytics, as part of the Business Analytics programme, is designed to equip Business Analytics students with the skills and knowledge to use the Python programming language as a tool for data analytics tasks. At the end of this course, students will be competent in writing Python codes to manage and manipulate data, and performing visualisation and data analytics techniques using existing, accessible Python libraries. Since this course is designed to help students with little prior exposure to programming, it will focus on breadth rather than depth. The course provides students with the foundational coding knowledge needed to understand, adapt, debug, and verify AI-generated code for data analytics tasks. This will be reinforced through in-class activities on AI-assisted coding, where students will use generative AI tools to generate code and evaluate whether the generated code is correct, appropriate, and fit for purpose. Through these activities, students will recognise that while AI can support coding, a sound understanding of basic Python remains essential for effective and responsible use of AI-generated code.
Level: 2
Credit Units: 5
Presentation Pattern: EVERY REGULAR SEMESTER

Topics

  • Introduction to Python
  • Variable input and output
  • Conditional statements and loops
  • User-defined functions and libraries
  • Array management using numpy
  • Plotting graphs using matlibplot
  • Importing, merging and subsetting datasets using pandas
  • Editing values in a dataset
  • Introduction to data mining library sklearn
  • Applying decision trees and clustering using sklearn
  • Introduction to SQL
  • Basic SQL in Python for querying data from database using sqlite

Learning Outcome

  • Discuss the various aspects of data analysis using Python programming
  • Apply Python programming for data manipulation
  • Explain the results from analysis or processing of data
  • Develop Python programs with sound logic for data analytics tasks
  • Prepare data for analysis using Python programming
  • Analyse data using appropriate techniques with Python programming and AI-assisted coding tools