Columbia Business School

Python for Managers (Online)

Columbia Business School

AI & Digital Business

About Programme

According to Emsi employment data, monthly active postings for managers with Python skills have increased significantly, by 90% in the past year, and continues to grow at a staggering pace.

Python is designed to be easy to read while still being very powerful, which makes it a great language for beginners to learn. It’s the fastest-growing programming language out there and is becoming an integral part of many professions, from finance and insurance to technology, healthcare, retail, and ecommerce.

Columbia Business School Executive Education’s two-month online program — Python for Managers (Online) — is designed to get you off the sidelines and into the programming action. The program teaches you how to use Python for data analysis and implement basic coding skills for practical business applications. Columbia Business School is at the nexus where technology and business merge, making it the ideal place for executives to learn Python.

The program is divided into two sections: part one is focused on fundamentals and part two is business applications. The curriculum includes mini challenges designed to give you hands-on coding practice. Ultimately, after taking this program, you will be able to organize and analyze data efficiently — by writing your own Python code.

With a focus on business application, the program includes opportunities to read and write scripts, work with simulated data from a case study on a New York restaurant group, and execute a final project with real-world application. At the end of the program, you will be able to organize, aggregate, and analyze large amounts of data using Python.

There are two kinds of people: those who understand technology and those who don’t. People who understand technology can design and control the very structure of the world around them. People who don’t understand it are controlled by those who do.

Mattan Griffel

Hear from the faculty directors about the program.

You will emerge from Columbia Business School Python for Managers (Online) with the capacity to understand and utilize Python for data analysis and practical business applications, fostering a renewed confidence in your decision-making abilities. It will accelerate your ability to have a real impact on your organization and serve as a springboard for your career.

The key takeaways of the program are:

Learn the fundamentals of coding in Python with a focus on practical business applications
Read and write scripts
Learn to communicate effectively with programmers whether you hire, manage, or collaborate with them
Build the capacity to organize and interpret data that extends far beyond Excel’s capabilities
Learn how to combine multiple data sources for better insights
Explore the practical applications of web scraping and APIs

Upon completion of this program, you will earn two credits towards a Certificate in Business Excellence with select alumni and tuition benefits.

Programme Content

Week 1

Python Fundamentals Part 1

Week 1
Review Evolution and Purpose of Python
Week 1
Understanding Your Development Environment
Week 1
Customizing Your Command Line and Practicing Command Line Prompts
Week 1
Start Building a Mental Map of Python Concepts
Week 1
Practice Coding with Basic Python Scripts
Week 2

Python Fundamentals Part 2

Week 2
If Statements
Week 2
Else and Elif Statements
Week 2
Logic Structures
Week 2
Lists
Week 2
For Loops
Week 3

Python Fundamentals Part 3

Week 3
Understanding the Role of Dictionaries, Functions, and Import
Week 3
Practice Writing Code for Dictionaries and Functions
Week 3
Refactor Code for Efficiency and Simplicity
Week 4

Intro to Pandas in Python

Week 4
Intro to Data in Python
Week 4
Review of Jupyter
Week 4
Data Without Pandas
Week 4
Panda Series Data frames
Week 4
Columns and Rows
Week 4
Reading Data
Week 5

Analyzing Data with Python

Week 5
Filtering Data
Week 5
Editing Data frames
Week 5
Data Hygiene: Duplicated and Missing Values
Week 5
Combining Data: An Introduction
Week 5
Combining Data: Choosing the Kind of Join
Week 5
Combining Data: Two Warnings
Week 5
Combining Data: Ensuring You’re Not Missing Anything
Week 5
Constructing Full Orders in the New York restaurant group case
Week 6

APIs and Web Scraping with Python

Week 6
Explore Examples of APIs
Week 6
Use Python to Connect to an API
Week 6
Develop an Understanding of HTML and How Web Scrapers in Python Pull Information from a Page
Week 7

Applying APIs and Web Scraping

Week 7
Loading Nutrition Data
Week 7
Understanding the Structure
Week 7
Scraping the Data
Week 7
Joining It All Together
Week 7
Connecting to Weather API
Week 7
Creating Weather Dataframe
Week 7
Intro to Aggregating Data
Week 8

Tying It Together

Week 8
Advanced Data Aggregation
Week 8
Aggregating with Time
Week 8
Making Pretty Plots
Week 8
Final Project

Programme Audience

Professionals and executives interested in learning practical coding skills that allows them to use Python to analyze and leverage large amounts of data they already have, or that they want to collect, in order to make better business decisions. No prior experience in programming is required.

Representative roles and titles may include:

Product managers, growth hackers, business strategy managers, product marketing managers
Risk managers, portfolio managers, high frequency traders
Data analysts, data scientists, analytics managers and VPs
Project managers
Management consultants
Entrepreneurs
Anyone who has outgrown excel for data analysis

Other programs in this subject area you might find useful

Same topic, Similar duration - Broader exploration across all institutes

Contact us for the further details

Speak with an Advisor

  1. Pedagogy (case method, experiential learning, coaching, simulations)
  2. Programme Objective
  3. Testimonials
  4. Programme Benefits

Prashansa Uttam

Programme Advisor

+91 9403890085[email protected]Mon – Fri, 9am – 5pm IST

Columbia Business School

Executive Education Office

Orlando Fiallo
+1 212-853-3701
https://academics.gsb.columbia.edu
New York, USA

Tell us about your program enquiry

Fill out the form below and our team will get back to you within 24 hours.

Python for Managers | Columbia CBS