Recently I had the pleasure of delivering a data science lecture for the University of Saskatchewan’s School of Public Policy. After that lecture, I decided to re-record a few choice bits for a more global audience.

This series of videos takes a quick look at how to install Anaconda, an all-in-one programming setup for data analytics, and then how to read in CSV (comma-separated value) files, clean them, and export them again.

Part 0: Install Anaconda

Part 1: Intro to Python & Spyder

Part 2: What is a CSV File?

Part 3: Basic Data Cleaning

Part 4: Combine DataFrames

Part 5: Combine DataFrames Continued

Part 6: Filter DataFrames

Part 7: OLS Regressions

Part 8: SQL and R

Part 9: SQL and Python

Links to the Data Files used:

2428.csv – Admissions to the Youth Justice System: Admission Type

2429.csv – Admissions to the Youth Justice System: Most Serious Offence

unemp1.csv – Youth Unemployment Data

Published by Elias

Elias Puurunen is a versatile entrepreneur and President of Northern HCI Solutions Inc., an IT consulting firm which has worked with Fortune 500 companies, governments, and startups. He has spoken at conferences in Canada and the United States and has been published around the world. Part of his work led to an agreement between the Canadian Government and Siemens Canada, creating jobs and investment into green infrastructure. His company's event management app, the Tractus Event Passport connects people at conferences, seminars and symposiums across Canada. Today he is a consultant and advisor to technology firms and government organizations. He lectures at the University of Waterloo on Coding for Policy Analysis for the School of Public Policy. He is the author of Beyond Passwords: Secure Your Business, a cyber-security book for small business owners.

Leave a comment

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: