使用pd.IntervalIndex和loc尝试以下操作：

import pandas as pd

df = pd.read_clipboard() # Copy input from question above
df1 = pd.read_clipboard() # Copy input from question above

df1 = df1.set_index(df1.columns[0]) #Create index with first column

#Create IntervalIndex from ranges in index and column headers
df1.columns = pd.IntervalIndex.from_arrays([0,30,55],[30,55,70]) 
df1.index = pd.IntervalIndex.from_arrays([0,50,75],[50,75,100])

#Test getting value by stacking columns and index to create multiIndex
df1.stack().loc[(40,25)] #returns .1

# Create list of tuples for "lookup" in df1 with zip
df['Ratio Give by grid'] = df1.stack().loc[zip(df['Sum total'], df['Sum partial'])].to_numpy()

df

输出：

ID  Sum total  Sum partial  Ratio Give by grid
0  A1         40           25                0.10
1  A2         70           50                0.18
2  A3        100           40                0.27