python数据分析：三维数据样条插值并制图

数据（x,y,z）代表导线宽度，长度，和升温30℃时的通流值

• 加载模块，导入数据

import numpy as np
import matplotlib.pyplot as plt
import pandas as pd
from mpl_toolkits.mplot3d import Axes3D
from scipy import interpolate
from matplotlib import cm

data=pd.read_excel('./WHPdata123.xls')  #读取数据
current=data.iloc[0:8,1:7]   #提取用于分析的列
print(current)

   1     2     4     6     8     10
0  11.6  16.6  23.8  29.2  34.6  38.6
1   8.2  11.8  17.2  20.6  23.8  26.8
2   7.0  10.0  14.2  17.6  20.0  22.4
3   6.2   8.8  12.4  15.4  18.2  20.2
4   5.6   8.0  11.4  14.2  16.4  18.0
5   5.2   7.4  10.6  13.2  15.2  17.2
6   4.8   7.0  10.0  12.4  14.0  15.8
7   4.5   6.5   9.4  11.6  13.4  15.2

• 网格化数据

current1 = np.asarray(current)    #转化为numpy数组
length1 = np.arange(1,9)
width1 = np.array([1,2,4,6,8,10])
M,N = np.meshgrid(width1,length1)   #转化为X-Y网格

plt.rcParams['font.sans-serif'] = 'SimHei' ## 设置中文显示
plt.rcParams['axes.unicode_minus'