6.4 KiB
6.4 KiB
In [1]:
import pandas as pd
In [2]:
power_eva = pd.read_csv('./发电测试结果.csv')
In [4]:
power_eva.columns = ['real', 'pred'] power_eva['error'] = (power_eva.pred - power_eva.real).apply(abs) / power_eva.real
In [15]:
power_eva.sample(10)
Out[15]:
real | pred | error | |
---|---|---|---|
222 | 0.517443 | 0.518051 | 0.001175 |
54 | 0.701795 | 0.671254 | 0.043519 |
201 | 0.539900 | 0.541033 | 0.002099 |
30 | 0.532658 | 0.530621 | 0.003823 |
124 | 0.410033 | 0.420981 | 0.026701 |
37 | 0.390315 | 0.391309 | 0.002548 |
7 | 0.571029 | 0.579793 | 0.015347 |
232 | 0.580826 | 0.579876 | 0.001635 |
165 | 0.352021 | 0.374194 | 0.062987 |
139 | 0.584566 | 0.567410 | 0.029348 |
In [7]:
heat_eva = pd.read_csv('./供热测试结果.csv') heat_eva.columns = ['real', 'pred'] heat_eva['error'] = (heat_eva.pred - heat_eva.real).apply(abs) / heat_eva.real
In [9]:
heat_eva.sample(10)
Out[9]:
real | pred | error | |
---|---|---|---|
131 | 0.071626 | 0.071494 | 0.001839 |
256 | 0.076446 | 0.069821 | 0.086672 |
141 | 0.067995 | 0.068865 | 0.012802 |
71 | 0.071438 | 0.071276 | 0.002270 |
284 | 0.072052 | 0.071835 | 0.003018 |
294 | 0.075010 | 0.074507 | 0.006716 |
77 | 0.052603 | 0.055783 | 0.060461 |
96 | 0.062181 | 0.063483 | 0.020932 |
176 | 0.077847 | 0.077317 | 0.006807 |
164 | 0.082962 | 0.082844 | 0.001420 |
In [ ]: