蓝桥杯2015年第六届真题-表格计算-题解（Python代码）

解题思路:

注意事项:

参考代码:

def su(j):
        l1=[]
        l2=[]
        for k in j:
                if k.isdigit():
                        l1.append(k)
        for x in range(int(l1[0])-1,int(l1[2])):
                for y in range(int(l1[1])-1,int(l1[3])):
                        if not str(l[x][y]).isdigit():
                                if 'SUM' in l[x][y]:
                                        l[x][y]=su(l[x][y])
                                        
                                elif 'AVG' in l[x][y]:
                                        l[x][y]=av(l[x][y])
                                        
                                elif 'STD' in l[x][y]:
                                        l[x][y]=st(l[x][y])
                        
                        l2.append(int(l[x][y]))
                        
        return sum(l2)
def av(j):
        l1=[]
        l2=[]
        for k in j:
                if k.isdigit():
                        l1.append(k)
        for x in range(int(l1[0])-1,int(l1[2])):
                for y in range(int(l1[1])-1,int(l1[3])):
                        if not str(l[x][y]).isdigit():
                                if 'SUM' in l[x][y]:
                                        l[x][y]=su(l[x][y])
                                        
                                elif 'AVG' in l[x][y]:
                                        l[x][y]=av(l[x][y])
                                        
                                elif 'STD' in l[x][y]:
                                        l[x][y]=st(l[x][y])
                        
                        l2.append(int(l[x][y]))
        return sum(l2)/len(l2)
def st(j):
        l1=[]
        l2=[]
        l3=[]
        for k in j:
                if k.isdigit():
                        l1.append(k)
        for x in range(int(l1[0])-1,int(l1[2])):
                for y in range(int(l1[1])-1,int(l1[3])):
                        if not str(l[x][y]).isdigit():
                                if 'SUM' in l[x][y]:
                                        l[x][y]=su(l[x][y])
                                        
                                elif 'AVG' in l[x][y]:
                                        l[x][y]=av(l[x][y])
                                        
                                elif 'STD' in l[x][y]:
                                        l[x][y]=st(l[x][y])
                        l2.append(int(l[x][y]))
        a=sum(l2)/len(l2)
        for b in l2:
                l3.append((b-a)**2)
        return (sum(l3)/len(l3))**0.5
                
n,m=map(int,input().split())
l=[list(input().strip().split()) for i in range(n)]
for i in l:
        for j in i:
                if not str(j).isdigit():                       
                        if 'SUM' in j:
                                j=su(j)
                                print(f"{float(j):.2f}",end=' ')
                                
                        elif 'AVG' in j:
                                j=av(j)
                                print(f"{float(j):.2f}",end=' ')
                                
                                
                        elif 'STD' in j:
                                j=st(j)
                                print(f"{float(j):.2f}",end=' ')
                else:
                        print(f"{float(j):.2f}",end=' ')
        print()