Python 两种方法一维插值interp

可以用interp1d或interp两个变量来插值

import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
from scipy import interpolate
#导入数据
df = pd.read_excel(r"D:\Test\M24p4 360V efficiency.xlsx",
                   sheet_name="interp1d")
#定义X,Y轴
x = df.iloc[0:, 0]
y = df.iloc[0:, 1]
x1 = df.iloc[0:, 3]
#第一种方法
# f = interpolate.interp1d(x, y)
# y1=f(x1)

#第二种方法
y1 = np.interp(x1, x, y)

plt.plot(x,y,'o',x1,y1,'*')
plt.show()