Fundamental Tools of Data Wrangling

University of Colorado Boulder via Coursera

Go to Course: https://www.coursera.org/learn/fundamental-tools-of-data-wrangling

Introduction

You will be able to describe the fundamentals of programming in Python.

You will be able to identify data structures for efficient organization and manipulation of data.

You will practice using NumPy and Pandas for numerical computing, data manipulation, and analysis.

Syllabus

Python

This week provides an introduction to the Python programming language, covering fundamental concepts and practical applications. You will gain a solid understanding of Python's syntax and semantics, enabling you to write efficient and concise code. We will also cover essential topics such as basic variables and operations, flow control structures, functions, and the utilization of external packages to enhance Python's capabilities.

Data Structures

The "Data Structures" week provides you with a comprehensive understanding of commonly used data structures for efficient organization and manipulation of data. You will explore various data structures, including strings, lists, sets, and dictionaries. Through theoretical explanations and practical examples, you will grasp the advantages of using each data structure and learn the fundamental operations associated with them.

Numpy

The "NumPy" week serves as an introduction to the fundamental concepts and practical applications of NumPy, a powerful library for numerical computing in Python. You will gain insights into the advantages of utilizing NumPy for efficient data manipulation and mathematical operations. The week will cover the underlying data structure of NumPy arrays and guide students through basic array operations, including accessing and manipulation. Moreover, you will delve into advanced operations, such as masking and filtering, to perform complex data manipulations effectively.

Pandas

The "Pandas" week provides you with a comprehensive introduction to Pandas, a powerful and widely used library for data manipulation and analysis in Python. You will explore the advantages of using Pandas for handling structured data efficiently. The week will cover the underlying data structure of Pandas, namely DataFrames and Series, and guide you through basic data operations, including accessing and manipulation. Moreover, you will delve into advanced data manipulations, such as masking, filtering, aggregating, pivot tables, and more, to effectively analyze and transform datasets.

Case Study

The "Case Study" week offers you the opportunity to apply the knowledge you have gained throughout the course in a practical simulation case study. Through hands-on exercises and real-world scenarios, you will use Python and relevant packages to create a dummy dataset, mimicking a real dataset they might encounter in data analysis or scientific research. Throughout the case study, you will face challenges commonly encountered in real-world data analysis and will be encouraged to employ critical thinking and problem-solving skills to overcome them. This practical exercise will not only consolidate their understanding of Python and relevant packages but also foster a deeper appreciation for the importance of data preparation and analysis in various domains.