Python for Managers (Online)
Learn the fundamentals of coding in Python with a focus on practical business applications. You’ll build the capacity to organize and interpret data in a way that extends far beyond Excel’s capabilities, fostering a renewed confidence in your decision-making abilities and accelerating your ability to have a real impact on your organization.
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 implement basic coding skills for practical business applications. Columbia Business School is at the nexus where technology and business merge.
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 executing 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.
Please contact our partners at Emeritus at columbia@emeritus.org, +1 315-982-5094, or +1 315-277-2746 for a personal conversation about this program and how it may benefit you.
Delivered in collaboration with
You will emerge from Columbia Business School Python for Managers (Online) with the capacity to understand and utilize Python, 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 with select alumni and tuition benefits. Learn more.
A hybrid of Python fundamentals and hands-on learnings in the application of Python, this program teaches you how to connect to APIs, scrape data from websites, and access and analyze large volumes of data efficiently and effectively.
For full details of the curriculum, please download the brochure.
Python Fundamentals Part 1
- Review Evolution and Purpose of Python
- Understanding Your Development Environment
- Customizing Your Command Line and Practicing Command Line Prompts
- Start Building a Mental Map of Python Concepts
- Practice Coding with Basic Python Scripts
Python Fundamentals Part 2
- If Statements
- Else and Elif Statements
- Logic Structures
- Lists
- For Loops
Python Fundamentals Part 3
- Understanding the Role of Dictionaries, Functions, and Import
- Practice Writing Code for Dictionaries and Functions
- Refactor Code for Efficiency and Simplicity
Intro to Pandas in Python
- Intro to Data in Python
- Review of Jupyter
- Data Without Pandas
- Panda Series Data frames
- Columns and Rows
- Reading Data
Analyzing Data with Python
- Filtering Data
- Editing Data frames
- Data Hygiene: Duplicated and Missing Values
- Combining Data: An Introduction
- Combining Data: Choosing the Kind of Join
- Combining Data: Two Warnings
- Combining Data: Ensuring You’re Not Missing Anything
- Constructing Full Orders in the New York restaurant group case
APIs and Web Scraping with Python
- Explore Examples of APIs
- Use Python to Connect to an API
- Develop an Understanding of HTML and How Web Scrapers in Python Pull Information from a Page
Applying APIs and Web Scraping
- Loading Nutrition Data
- Understanding the Structure
- Scraping the Data
- Joining It All Together
- Connecting to Weather API
- Creating Weather Dataframe
- Intro to Aggregating Data
Tying It Together
- Advanced Data Aggregation
- Aggregating with Time
- Making Pretty Plots
- Final Project
Professionals interested in learning practical coding skills that allows them to 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
Columbia Business School alumni and up to four of their colleagues are eligible for a 25 percent tuition benefit for this program. More on the Alumni Tuition Benefit.
Upon completion of this program, you will earn credits towards a Certificate with select alumni and tuition benefits.
This program is suitable for professionals who are interested in learning practical coding skills that allow them to leverage large amounts of data in order to make better business decisions.