Result comparison graph

 

Take a certain number of samples, and draw the true value and the predicted value on a graph, which is the result comparison graph.

The result comparison chart can directly show the difference and trend between the predicted result and the true value


A

1

=T("houseprice_result.xls").to(100)

2

=canvas()

3

=A2.plot("NumericAxis","name":"x")

4

=A2.plot("NumericAxis","name":"y","location":2,"autoRangeFromZero":false)

5

=A2.plot("Line","markerStyle":0,"lineColor":-16776961,"axis1":"x","data1":to(A1.len()),"axis2":"y","data2": A1.(SalePrice))

6

=A2.plot("Line","markerStyle":0,"lineColor":-61184,"axis1":"x","data1":to(A1.len()),"axis2":"y","data2": A1.(SalePrice_predictvalue))

7

=A2.draw(800,400)

A1 Take 100 samples. Users can choose samples according to actual needs

A2-A7 The number of samples is taken as the X-axis, the true value (blue line) and the predicted value (red line) are drawn as the Y-axis, and the comparison chart of the results is obtained

..