From the course: Advanced Python in Excel: Machine Learning
Join today to access over 25,500 courses taught by industry experts.
Numerical analysis with NumPy
From the course: Advanced Python in Excel: Machine Learning
Numerical analysis with NumPy
- [Instructor] Numerical analysis is a fundamental aspect of data analysis, and NumPy is one of the most powerful libraries in Python for this purpose. This library will help you perform efficient mathematical and logical operations on arrays and matrices, which is crucial for financial analysis. Within Excel, you'll start by importing NumPy as np. Then, to create a NumPy array from a list, you can have the data like 100 to 108, and then call the function, array, from NumPy. You can perform statistical analysis with NumPy, such as getting the mean, the median, and the standard deviation of that array. In here for example, we're displaying the analysis results for the mean. And in this cell, we're displaying the standard deviation. If you want to display the full matrix, you can also do it by calling matrix_a, and then, it will display the matrix that we have created. Finally, in this code, we're also performing some complex operations, like creating two by two matrices, matrix…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.