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 Puurunen
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.
View more posts