使用 excel 值在 python 中执行计算

发布于07月27日

我正试图用python做一些计算，使用一个包含几行和三列的excel.

madrid = pd.read_excel('Madrid.xlsx')

ch = []

d=[]
  
L = 8.4

for i in range(0, len(madrid)):

    ch[i] = 0.8 + (1.1*math.log10(madrid['Band'][i]) - 0.7)*madrid['Antenna_Height'][i] - 1.56*math.log10(madrid['Band'][i])

    d[i] = ((L - 69.55 - 26.16*math.log10(madrid['Band'][i]) + 13.82*math.log10(madrid['Antenna_Height'][i]) + ch[i])/(44.9 - 6.55*math.log10(madrid['Antenna_Height'][i])))**10

    madrid['Colors'][i] = d[i]

推荐答案

列表ch为空，因此调用任何元素索引(如ch[0]或ch[1])将导致错误"列表索引超出范围"

我看到你正试图添加到各种列表中.你可以试试(但我不确定公式，请判断一下)

import math

madrid = pd.read_excel('Madrid.xlsx')
ch = []
d=[]
L = 8.4

for i in range(0, len(madrid)):
    ch_temp = 0.8 + (1.1*math.log10(madrid['Band'][i]) - 0.7)*madrid['Antenna_Height'][i] - 1.56*math.log10(madrid['Band'][i])
    ch.append(ch_temp)
    d_temp = ((L - 69.55 - 26.16*math.log10(madrid['Band'][i]) + 13.82*math.log10(madrid['Antenna_Height'][i]) + ch[i])/(44.9 - 6.55*math.log10(madrid['Antenna_Height'][i])))**10
    d.append(d_temp)
    madrid['Colors'][i] = d[i]

print(madrid)

输出:

   Band  Antenna_Height      Colors
0     1               3   18.262619
1     2               3   62.881852
2     3               3  121.442224
3     4               3  188.948366
4     5               3  262.794745
5     6               3  341.404788