评估数据需要帮助！ [英] Help needed with evaluating data!

问题描述

我有一个使用国家/地区的模型，但我希望每个国家都对该模型进行评估。我可以进入SQL转换并选择一个国家，然后选择另一个国家。但我认为必须有一些简单的方法将数据分成几个国家。几乎
就像将一个国家/地区字段放入数据透视表的Excel列区域。这是可能吗。我看起来按国家分层，但这似乎没有给我我想要的东西。我想要的如下图所示：

I have a model that uses countries, but I want the model evaluated by each individual country. I can go into SQL transform and select a country, then another and another. But I am thinking there must be some easy way to slice the data into countries. Almost like dropping a country field into the Excel column area of a Pivot table. Is this at all possible. I have looked a stratify by country but this doesn't seem to give me my what I want. What I want is illustrated below:

Country1：

Score Bin 	Positive Examples 	Negative Examples 	Fraction Above Threshold 	Accuracy 	F1 Score 	Precision 	Recall 	Negative Precision 	Negative Recall 	Cumulative AUC
(0.900,1.000] 	620 	0 	0.096 	0.997 	0.984 	1.000 	0.969 	0.997 	1.000 	0.000

Country2：

Score Bin 	Positive Examples 	Negative Examples 	Fraction Above Threshold 	Accuracy 	F1 Score 	Precision 	Recall 	Negative Precision 	Negative Recall 	Cumulative AUC
(0.900,1.000] 	620 	0 	0.096 	0.997 	0.984 	1.000 	0.969 	0.997 	1.000 	0.000

国家（n）.................

Country(n).................

非常感谢您提供的任何帮助。

Any help you can give would be greatly appreciated.

提前致谢....

推荐答案

你好，

您可以使用Excel工作表来确定批量预测每个国家的结果，而不对您当前的实验进行任何更改。以下是使用
批量预测的
视频 kaggle titanic数据集 以获得所有乘客幸存的结果。我认为您可以类似地为每个国家/地区使用它来获得所需的预测。

You could use the batch prediction using the excel sheet to determine the results for each of the country without making any changes to your current experiment. Here is an video of using batch prediction with the kaggle titanic data set to get results of all the passengers if they survived. I think you can similarly use it for each country to get the required predictions.

-Rohit

这篇关于评估数据需要帮助！的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！