numpy处理矩阵，求平均、最值、获取excel

numpy获取数组元素，处理矩阵。

1.对数组求平均值

import numpy as np
a = np.array([[1, 2], [3, 4]])
print(a)
print(type(a))
print(np.mean(a))
print(np.mean(a, axis=0)) # axis=0，计算每一列的均值
print(np.mean(a, axis=1)) # 计算每一行的均值
2.对矩阵求平均值

import numpy as np
num1 = np.array([[1,2,3],[2,3,4],[3,4,5],[4,5,6]])
 
num2 = np.mat(num1)
print(num2)
print(type(num2))
print(np.mean(num2)) # 对所有元素求均值
print(np.mean(num2,0)) # 对各列求均值

3.numpy求数组某行某列的最大值

Examples

a = np.arange(4).reshape((2,2))
a
array([[0, 1],
       [2, 3]])
np.amax(a)           # Maximum of the flattened array
3
np.amax(a, axis=0)   # Maxima along the first axis
array([2, 3])
np.amax(a, axis=1)   # Maxima along the second axis
array([1, 3])
np.amax(a, where=[False, True], initial=-1, axis=0)
array([-1,  3])
b = np.arange(5, dtype=float)
b[2] = np.NaN
np.amax(b)
nan
np.amax(b, where=~np.isnan(b), initial=-1)
4.0
np.nanmax(b)
4.0

4.导入excel