Module 1: Python & Pandas - An Unexpected Friendship

In this module, you will be introduced to dataframes, the Python package Pandas, simple manipulations and Visualizations.

0Module Learning Outcomes

1Introduction to Dataframes

2Describing a Dataframe

3Introduction to Pandas


5Your First Code!

6Your Second Code!

7Slicing with Pandas Using .loc[]

8Slicing and Dicing Practice

9 Practicing Rows Slicing

10Practicing Column Slicing

11 Slicing Columns Using .loc[]

12Slicing Columns Only

13Selecting Using .loc[]

14Rearranging Columns and Rows

15Practicing Selecting Using Index Labels

16Obtaining Dataframe Values

17Practicing Selecting Values

18Selecting a Single Column

19Practicing Selecting

20Slicing and Selecting Using df.iloc[]

21Practicing Slicing and Selecting Using Index Position

22Practicing Slicing Using Index Position

23Practicing Selecting Using Index Position

24Sorting Dataframes

25Practice Sorting

26Summary Statistics

27Fruit Bowl Statistics

28Using df.describe()

29Frequency Tables and Writing CSVs

30Practicing Frequency Tables

31Quick Viz with Altair

32Practicing Bar Charts

33Practicing Scatterplots

34What Did We Just Learn?

About this course

Learn the fundamentals of programming in Python, including how to clean, filter, arrange, aggregate and transform data. You will learn the foundations of programming in Python while writing human-readable code that sets a foundation of best practices and coding style. You will gain the skills to clean, filter, manipulate (wrangle) and summarize data using Python libraries for more effective data analysis. An overview of data structures, iteration, flow control and program design relevant to data exploration and analysis will be addressed along with fundamental programming concepts such as loops, conditionals and data structures that create a solid foundation in data science programming.

About the program

The University of British Columbia (UBC) is a comprehensive research-intensive university, consistently ranked among the 40 best universities in the world. The Key Capabilities in Data Science program was launched in September 2020 and is developed and taught by many of the same instructors as the UBC Master of Data Science program.