From the course: Python in Excel: Data Outputs in Custom Data Visualizations and Algorithms
Unlock the full course today
Join today to access over 24,300 courses taught by industry experts.
Importing Python libraries into Excel
From the course: Python in Excel: Data Outputs in Custom Data Visualizations and Algorithms
Importing Python libraries into Excel
- [Instructor] Python has existing functions that we can tap into for writing and running Python code. However, in order to maximize what the language should do, we want to tap into Python packages and libraries and their functions. There's some debate about what's a library and what's a package, but I'm just going to call them all libraries for simplicity. This includes functionalities for data science and data visualization like pandas, numpy scipy, sklearn, and matplotlib. We find them in commonly used Python IDs and notebook environments, so they're already vetted quite well for general use. Here in this text file are the libraries that we're going to import for this course. I've already divided them based on how we're going to use them in the course. We'll copy all these imported libraries from the text file and the Excel file, we'll navigate to the libraries tab and let's import our libraries in C4 in this page. We can import our Python libraries on each worksheet or altogether…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
Breaking down Excel and Python processes1m 48s
-
(Locked)
Leveraging Power Query6m 32s
-
(Locked)
Using the PY Excel function3m 44s
-
(Locked)
Using the XL Excel function and Python variables4m 23s
-
(Locked)
Determining calculation order4m 31s
-
(Locked)
Importing Python libraries into Excel3m 20s
-
(Locked)
Managing errors4m 14s
-
(Locked)
Working with Python objects7m 3s
-
(Locked)
Transforming DataFrame objects7m 41s
-
(Locked)
Challenge: Creating table objects in Excel2m 15s
-
(Locked)
Solution: Creating table objects in Excel3m 9s
-
-
-
-