排行榜

介绍

排行榜是非常常见的功能。以电影网站为例，有各种各样的排行榜，按照打分的总榜单，按照电影类别的榜单(战争，故事，喜剧... )，按照看的人数的榜单等等。

本文以MovieLens数据为例，使用AlinkLab排行榜应用，搭建电影榜单网站。

演示网址: https://app.aboutdata.top/ranklist/#/rank_list

小笨羊网址: https://xiaobenyang.com/

如有问题，请联系小笨羊微信:

具体内容如下，

数据

这个数据是对MovieLens打分数据，做了日期的处理，抽取了年份，月份和天。本示例中计算总榜单，按照上映年份的榜单，和按照各个电影类别的榜单。

表列名和描述

列名	类型	描述
user_id	BIGINT	用户ID
movie_id	BIGINT	电影ID
rating	FLOAT	用户对电影的打分
rate_year	STRING	打分年份
rate_month	STRING	打分月份
rate_day	STRING	打分天
title	STRING	电影名称
movie_year	STRING	电影上映年份
movie_month	STRING	电影上映月份
genre	STRING	电影类型

使用AlinkLab查看数据

查看数据统计信息

搭建步骤

1. 训练模型和部署预测服务

按照下面的步骤搭建训练模型和部署。如果不想搭建，可以跳过下面步骤，从教程任务重直接导入查看。

https://xiaobenyang.com/discuss-post?id=137

1.1. 使用"排行榜"应用，填写参数配置

参数配置如下，

参数名称	参数内容	说明
计算表	mylabdata://xiaobenyanng.com/demo/name/movie_with_genre.ak	示例中的数据放在MyLabData里。这里MovieLens打分数据。
附加表	mylabdata://xiaobenyanng.com/demo/name/u.item	数据放在MyLabData里。电影信息表，包括电影ID, 电影名称等。这里在计算完成榜单之后，还用电影ID，关联电影信息(电影名称等)。
分组列名数组	["genre", "rate_year", ""]	按照 genre(电影类别), rate_year(上映年份), "" (总榜单), 计算出三类榜单
主体列	movie_id	"主体列"，"计算列"和"统计类型"是一组参数，是按照主题列聚合，计算 "计算列"的统计值，作为排序标准。本例中，主题列是movie_id(电影ID), 计算列是rating(电影打分)，统计类型是count(计数), 那么，这里就是计算每个电影的打分次数，作为排序指标。
计算列	rating
统计类型	count
是否降序	是	榜单按照从大到小的顺序排序。这里就是按照电影的打分次数，从大到校排序。也就是打分次数越多，排的越靠前。
个数	10	每个榜单的数据个数。本例是选出电影打分次数最多的10个电影，作为榜单内容。
附加统计列	["rating"]	榜单里不用于排序的统计指标。本例中，附加统计列是rating(打分), 附加列统计类型是mean(均值) 那么，榜单里增加一列统计值，每个电影的平均打分。注意，这个指标不参与排序，只展示在磅单上。
附加列统计类型	["mean"]
关联附加表列	["title"]	榜单关联附加表的列本例中：关联附加表列是title(电影名称) 榜单中是只有MovieId, 需要关联电影名称。
预测服务名称	应用示例/排行榜	运行成功之后，在服务列表中查看预测服务(查看任务，查看模型，并进行预测演示)。

填好参数，填写任务名称，点击运行，进入到运行页面。等任务成功，就可以查看服务了。

1.2. 查看平台搭建好的应用

https://xiaobenyang.com/discuss-post?id=158

1.3. 查看已部署的服务

https://xiaobenyang.com/calc?func=LabPage&proc=ListMyLabPrediction

2. API调用预测服务

2.1. API参数

参数	名称	说明
predServId	服务ID	在服务页面上查看服务名称对应的ID
clause	表达式	"", 是所有数据都返回。如果有内容，按照表达式规则返回。例如"group_name=''western", 那么只返回西部电影的榜单。

2.2. API请求示例

 axios.post(null, {
        'predServId': '44',
        'clause': ""
 })

2.3. API 返回格式

参数	名称	说明
group_name	分组名称	分组名称和分组值，决定了榜单的类别。榜单类别是有上面排行榜应用里"分组列名数组"决定的。 group_name是分组列列名， group_value是分组列的取值本例中，分组列名数组 genre(电影类别), rate_year(上映年份), "" (总榜单) 那么，这里就会有个按照电影类别，上映年份，总榜单，三大类榜单。本例结果中第一对值 group_value是children(儿童) group_name是genre(电影类别) 那么这个榜单是儿童电影的榜单。
group_value	分组值
pred	榜单数据	榜单数据是一个数组，每个值里包含 group_name: 榜单分组列名 group_value：榜单分组列的值主体列关联列参与排序的统计指标附加统计列指标排名对应到本例中的字段: group_name：榜单分组列名 group_value：榜单分组列的值主体列：movie_id（电影ID) 关联列：title(电影名称) 参与排序的统计指标：rate_year_count(打分次数) 附加统计列指标: rating_mean(平均分) rank: 排名

2.4. API结果示例

[
    {
        "group_value": "children",
        "group_name": "genre",
        "pred": "[{\"rating_mean\":2.425,\"group_value\":\"children\",\"group_name\":\"genre\",\"rate_year_count\":80.0,\"rank\":7,\"movie_id\":243,\"title\":\"Jungle2Jungle (1997)\"},{\"rating_mean\":2.712871287128713,\"group_value\":\"children\",\"group_name\":\"genre\",\"rate_year_count\":101.0,\"rank\":4,\"movie_id\":259,\"title\":\"George of the Jungle (1997)\"},{\"rating_mean\":3.574468085106383,\"group_value\":\"children\",\"group_name\":\"genre\",\"rate_year_count\":94.0,\"rank\":5,\"movie_id\":91,\"title\":\"Nightmare Before Christmas, The (1993)\"},{\"rating_mean\":3.045977011494253,\"group_value\":\"children\",\"group_name\":\"genre\",\"rate_year_count\":87.0,\"rank\":6,\"movie_id\":94,\"title\":\"Home Alone (1990)\"},{\"rating_mean\":4.024590163934426,\"group_value\":\"children\",\"group_name\":\"genre\",\"rate_year_count\":122.0,\"rank\":2,\"movie_id\":8,\"title\":\"Babe (1995)\"},{\"rating_mean\":2.9545454545454546,\"group_value\":\"children\",\"group_name\":\"genre\",\"rate_year_count\":66.0,\"rank\":8,\"movie_id\":225,\"title\":\"101 Dalmatians (1996)\"},{\"rating_mean\":3.1538461538461537,\"group_value\":\"children\",\"group_name\":\"genre\",\"rate_year_count\":52.0,\"rank\":9,\"movie_id\":477,\"title\":\"Matilda (1996)\"},{\"rating_mean\":3.0,\"group_value\":\"children\",\"group_name\":\"genre\",\"rate_year_count\":49.0,\"rank\":10,\"movie_id\":63,\"title\":\"Santa Clause, The (1994)\"},{\"rating_mean\":3.675438596491228,\"group_value\":\"children\",\"group_name\":\"genre\",\"rate_year_count\":114.0,\"rank\":3,\"movie_id\":419,\"title\":\"Mary Poppins (1964)\"},{\"rating_mean\":3.8532608695652173,\"group_value\":\"children\",\"group_name\":\"genre\",\"rate_year_count\":184.0,\"rank\":1,\"movie_id\":423,\"title\":\"E.T. the Extra-Terrestrial (1982)\"}]"
    },
    {
        "group_value": "crime",
        "group_name": "genre",
        "pred": "[{\"rating_mean\":4.160130718954249,\"group_value\":\"crime\",\"group_name\":\"genre\",\"rate_year_count\":306.0,\"rank\":1,\"movie_id\":100,\"title\":\"Fargo (1996)\"},{\"rating_mean\":4.032258064516129,\"group_value\":\"crime\",\"group_name\":\"genre\",\"rate_year_count\":248.0,\"rank\":2,\"movie_id\":56,\"title\":\"Pulp Fiction (1994)\"},{\"rating_mean\":4.105882352941176,\"group_value\":\"crime\",\"group_name\":\"genre\",\"rate_year_count\":170.0,\"rank\":3,\"movie_id\":302,\"title\":\"L.A. Confidential (1997)\"},{\"rating_mean\":4.392638036809816,\"group_value\":\"crime\",\"group_name\":\"genre\",\"rate_year_count\":163.0,\"rank\":4,\"movie_id\":12,\"title\":\"Usual Suspects, The (1995)\"},{\"rating_mean\":3.823943661971831,\"group_value\":\"crime\",\"group_name\":\"genre\",\"rate_year_count\":142.0,\"rank\":5,\"movie_id\":11,\"title\":\"Seven (Se7en) (1995)\"},{\"rating_mean\":3.921259842519685,\"group_value\":\"crime\",\"group_name\":\"genre\",\"rate_year_count\":127.0,\"rank\":6,\"movie_id\":182,\"title\":\"GoodFellas (1990)\"},{\"rating_mean\":3.4871794871794872,\"group_value\":\"crime\",\"group_name\":\"genre\",\"rate_year_count\":117.0,\"rank\":7,\"movie_id\":307,\"title\":\"Devil's Advocate, The (1997)\"},{\"rating_mean\":3.764705882352941,\"group_value\":\"crime\",\"group_name\":\"genre\",\"rate_year_count\":102.0,\"rank\":8,\"movie_id\":293,\"title\":\"Donnie Brasco (1997)\"},{\"rating_mean\":3.65,\"group_value\":\"crime\",\"group_name\":\"genre\",\"rate_year_count\":100.0,\"rank\":9,\"movie_id\":55,\"title\":\"Professional, The (1994)\"},{\"rating_mean\":3.6391752577319587,\"group_value\":\"crime\",\"group_name\":\"genre\",\"rate_year_count\":97.0,\"rank\":10,\"movie_id\":628,\"title\":\"Sleepers (1996)\"}]"
    },
    {
        "group_value": "western",
        "group_name": "genre",
        "pred": "[{\"rating_mean\":3.739130434782609,\"group_value\":\"western\",\"group_name\":\"genre\",\"rate_year_count\":23.0,\"rank\":7,\"movie_id\":922,\"title\":\"Dead Man (1995)\"},{\"rating_mean\":3.769230769230769,\"group_value\":\"western\",\"group_name\":\"genre\",\"rate_year_count\":26.0,\"rank\":6,\"movie_id\":646,\"title\":\"Once Upon a Time in the West (1969)\"},{\"rating_mean\":3.962962962962963,\"group_value\":\"western\",\"group_name\":\"genre\",\"rate_year_count\":27.0,\"rank\":5,\"movie_id\":589,\"title\":\"Wild Bunch, The (1969)\"},{\"rating_mean\":3.0555555555555554,\"group_value\":\"western\",\"group_name\":\"genre\",\"rate_year_count\":36.0,\"rank\":4,\"movie_id\":570,\"title\":\"Wyatt Earp (1994)\"},{\"rating_mean\":4.092592592592593,\"group_value\":\"western\",\"group_name\":\"genre\",\"rate_year_count\":54.0,\"rank\":3,\"movie_id\":661,\"title\":\"High Noon (1952)\"},{\"rating_mean\":3.6,\"group_value\":\"western\",\"group_name\":\"genre\",\"rate_year_count\":65.0,\"rank\":2,\"movie_id\":470,\"title\":\"Tombstone (1993)\"},{\"rating_mean\":3.8907563025210083,\"group_value\":\"western\",\"group_name\":\"genre\",\"rate_year_count\":119.0,\"rank\":1,\"movie_id\":203,\"title\":\"Unforgiven (1992)\"},{\"rating_mean\":3.0,\"group_value\":\"western\",\"group_name\":\"genre\",\"rate_year_count\":5.0,\"rank\":10,\"movie_id\":1454,\"title\":\"Angel and the Badman (1947)\"},{\"rating_mean\":3.4,\"group_value\":\"western\",\"group_name\":\"genre\",\"rate_year_count\":5.0,\"rank\":9,\"movie_id\":621,\"title\":\"Davy Crockett, King of the Wild Frontier (1955)\"},{\"rating_mean\":2.857142857142857,\"group_value\":\"western\",\"group_name\":\"genre\",\"rate_year_count\":7.0,\"rank\":8,\"movie_id\":556,\"title\":\"Wild Bill (1995)\"}]"
    },
    {
        "group_value": "musical",
        "group_name": "genre",
        "pred": "[{\"rating_mean\":3.871794871794872,\"group_value\":\"musical\",\"group_name\":\"genre\",\"rate_year_count\":78.0,\"rank\":2,\"movie_id\":705,\"title\":\"Singin' in the Rain (1952)\"},{\"rating_mean\":3.5657894736842106,\"group_value\":\"musical\",\"group_name\":\"genre\",\"rate_year_count\":76.0,\"rank\":3,\"movie_id\":485,\"title\":\"My Fair Lady (1964)\"},{\"rating_mean\":3.1147540983606556,\"group_value\":\"musical\",\"group_name\":\"genre\",\"rate_year_count\":61.0,\"rank\":4,\"movie_id\":155,\"title\":\"Dirty Dancing (1987)\"},{\"rating_mean\":3.696969696969697,\"group_value\":\"musical\",\"group_name\":\"genre\",\"rate_year_count\":33.0,\"rank\":5,\"movie_id\":602,\"title\":\"American in Paris, An (1951)\"},{\"rating_mean\":3.7083333333333335,\"group_value\":\"musical\",\"group_name\":\"genre\",\"rate_year_count\":24.0,\"rank\":6,\"movie_id\":610,\"title\":\"Gigi (1958)\"},{\"rating_mean\":3.8297872340425534,\"group_value\":\"musical\",\"group_name\":\"genre\",\"rate_year_count\":141.0,\"rank\":1,\"movie_id\":143,\"title\":\"Sound of Music, The (1965)\"},{\"rating_mean\":3.375,\"group_value\":\"musical\",\"group_name\":\"genre\",\"rate_year_count\":16.0,\"rank\":7,\"movie_id\":605,\"title\":\"Meet Me in St. Louis (1944)\"},{\"rating_mean\":3.6923076923076925,\"group_value\":\"musical\",\"group_name\":\"genre\",\"rate_year_count\":13.0,\"rank\":8,\"movie_id\":968,\"title\":\"Inspector General, The (1949)\"},{\"rating_mean\":3.25,\"group_value\":\"musical\",\"group_name\":\"genre\",\"rate_year_count\":4.0,\"rank\":9,\"movie_id\":1459,\"title\":\"Madame Butterfly (1995)\"}]"
    },
    {
        "group_value": "war",
        "group_name": "genre",
        "pred": "[{\"rating_mean\":1.0,\"group_value\":\"war\",\"group_name\":\"genre\",\"rate_year_count\":1.0,\"rank\":4,\"movie_id\":1574,\"title\":\"Pharaoh's Army (1995)\"},{\"rating_mean\":2.7142857142857144,\"group_value\":\"war\",\"group_name\":\"genre\",\"rate_year_count\":7.0,\"rank\":1,\"movie_id\":593,\"title\":\"Stalingrad (1993)\"},{\"rating_mean\":2.75,\"group_value\":\"war\",\"group_name\":\"genre\",\"rate_year_count\":4.0,\"rank\":2,\"movie_id\":1501,\"title\":\"Prisoner of the Mountains (Kavkazsky Plennik) (1996)\"},{\"rating_mean\":4.0,\"group_value\":\"war\",\"group_name\":\"genre\",\"rate_year_count\":2.0,\"rank\":3,\"movie_id\":1529,\"title\":\"Underground (1995)\"}]"
    },
    {
        "group_value": "",
        "group_name": "",
        "pred": "[{\"rating_mean\":3.8536585365853657,\"group_value\":\"\",\"group_name\":\"\",\"rate_year_count\":287.0,\"rank\":4,\"movie_id\":258,\"title\":\"Contact (1997)\"},{\"rating_mean\":3.6483516483516483,\"group_value\":\"\",\"group_name\":\"\",\"rate_year_count\":273.0,\"rank\":8,\"movie_id\":286,\"title\":\"English Patient, The (1996)\"},{\"rating_mean\":4.014035087719298,\"group_value\":\"\",\"group_name\":\"\",\"rate_year_count\":285.0,\"rank\":5,\"movie_id\":181,\"title\":\"Return of the Jedi (1983)\"},{\"rating_mean\":3.6842105263157894,\"group_value\":\"\",\"group_name\":\"\",\"rate_year_count\":266.0,\"rank\":9,\"movie_id\":300,\"title\":\"Air Force One (1997)\"},{\"rating_mean\":4.395770392749244,\"group_value\":\"\",\"group_name\":\"\",\"rate_year_count\":331.0,\"rank\":1,\"movie_id\":50,\"title\":\"Star Wars (1977)\"},{\"rating_mean\":3.8362989323843415,\"group_value\":\"\",\"group_name\":\"\",\"rate_year_count\":281.0,\"rank\":7,\"movie_id\":1,\"title\":\"Toy Story (1995)\"},{\"rating_mean\":3.3682432432432434,\"group_value\":\"\",\"group_name\":\"\",\"rate_year_count\":296.0,\"rank\":3,\"movie_id\":288,\"title\":\"Scream (1996)\"},{\"rating_mean\":4.239543726235741,\"group_value\":\"\",\"group_name\":\"\",\"rate_year_count\":263.0,\"rank\":10,\"movie_id\":174,\"title\":\"Raiders of the Lost Ark (1981)\"},{\"rating_mean\":4.160130718954249,\"group_value\":\"\",\"group_name\":\"\",\"rate_year_count\":306.0,\"rank\":2,\"movie_id\":100,\"title\":\"Fargo (1996)\"},{\"rating_mean\":3.136842105263158,\"group_value\":\"\",\"group_name\":\"\",\"rate_year_count\":285.0,\"rank\":6,\"movie_id\":294,\"title\":\"Liar Liar (1997)\"}]"
    },
    {
        "group_value": "action",
        "group_name": "genre",
        "pred": "[{\"rating_mean\":4.209756097560976,\"group_value\":\"action\",\"group_name\":\"genre\",\"rate_year_count\":205.0,\"rank\":10,\"movie_id\":172,\"title\":\"Empire Strikes Back, The (1980)\"},{\"rating_mean\":4.395770392749244,\"group_value\":\"action\",\"group_name\":\"genre\",\"rate_year_count\":331.0,\"rank\":1,\"movie_id\":50,\"title\":\"Star Wars (1977)\"},{\"rating_mean\":4.014035087719298,\"group_value\":\"action\",\"group_name\":\"genre\",\"rate_year_count\":285.0,\"rank\":2,\"movie_id\":181,\"title\":\"Return of the Jedi (1983)\"},{\"rating_mean\":3.6842105263157894,\"group_value\":\"action\",\"group_name\":\"genre\",\"rate_year_count\":266.0,\"rank\":3,\"movie_id\":300,\"title\":\"Air Force One (1997)\"},{\"rating_mean\":4.239543726235741,\"group_value\":\"action\",\"group_name\":\"genre\",\"rate_year_count\":263.0,\"rank\":4,\"movie_id\":174,\"title\":\"Raiders of the Lost Ark (1981)\"},{\"rating_mean\":3.34,\"group_value\":\"action\",\"group_name\":\"genre\",\"rate_year_count\":250.0,\"rank\":5,\"movie_id\":121,\"title\":\"Independence Day (ID4) (1996)\"},{\"rating_mean\":4.292181069958848,\"group_value\":\"action\",\"group_name\":\"genre\",\"rate_year_count\":243.0,\"rank\":6,\"movie_id\":127,\"title\":\"Godfather, The (1972)\"},{\"rating_mean\":3.7111111111111112,\"group_value\":\"action\",\"group_name\":\"genre\",\"rate_year_count\":225.0,\"rank\":7,\"movie_id\":117,\"title\":\"Rock, The (1996)\"},{\"rating_mean\":4.23696682464455,\"group_value\":\"action\",\"group_name\":\"genre\",\"rate_year_count\":211.0,\"rank\":8,\"movie_id\":313,\"title\":\"Titanic (1997)\"},{\"rating_mean\":3.3398058252427183,\"group_value\":\"action\",\"group_name\":\"genre\",\"rate_year_count\":206.0,\"rank\":9,\"movie_id\":405,\"title\":\"Mission: Impossible (1996)\"}]"
    },
    {
        "group_value": "adventure",
        "group_name": "genre",
        "pred": "[{\"rating_mean\":3.605128205128205,\"group_value\":\"adventure\",\"group_name\":\"genre\",\"rate_year_count\":195.0,\"rank\":1,\"movie_id\":151,\"title\":\"Willy Wonka and the Chocolate Factory (1971)\"},{\"rating_mean\":3.757575757575758,\"group_value\":\"adventure\",\"group_name\":\"genre\",\"rate_year_count\":165.0,\"rank\":2,\"movie_id\":97,\"title\":\"Dances with Wolves (1990)\"},{\"rating_mean\":4.029629629629629,\"group_value\":\"adventure\",\"group_name\":\"genre\",\"rate_year_count\":135.0,\"rank\":3,\"movie_id\":132,\"title\":\"Wizard of Oz, The (1939)\"},{\"rating_mean\":3.948148148148148,\"group_value\":\"adventure\",\"group_name\":\"genre\",\"rate_year_count\":135.0,\"rank\":4,\"movie_id\":655,\"title\":\"Stand by Me (1986)\"},{\"rating_mean\":4.2,\"group_value\":\"adventure\",\"group_name\":\"genre\",\"rate_year_count\":90.0,\"rank\":5,\"movie_id\":511,\"title\":\"Lawrence of Arabia (1962)\"},{\"rating_mean\":3.49438202247191,\"group_value\":\"adventure\",\"group_name\":\"genre\",\"rate_year_count\":89.0,\"rank\":6,\"movie_id\":304,\"title\":\"Fly Away Home (1996)\"},{\"rating_mean\":4.051282051282051,\"group_value\":\"adventure\",\"group_name\":\"genre\",\"rate_year_count\":78.0,\"rank\":7,\"movie_id\":520,\"title\":\"Great Escape, The (1963)\"},{\"rating_mean\":3.5211267605633805,\"group_value\":\"adventure\",\"group_name\":\"genre\",\"rate_year_count\":71.0,\"rank\":8,\"movie_id\":331,\"title\":\"Edge, The (1997)\"},{\"rating_mean\":3.35,\"group_value\":\"adventure\",\"group_name\":\"genre\",\"rate_year_count\":60.0,\"rank\":9,\"movie_id\":924,\"title\":\"White Squall (1996)\"},{\"rating_mean\":2.8703703703703702,\"group_value\":\"adventure\",\"group_name\":\"genre\",\"rate_year_count\":54.0,\"rank\":10,\"movie_id\":820,\"title\":\"Space Jam (1996)\"}]"
    },
    {
        "group_value": "animation",
        "group_name": "genre",
        "pred": "[{\"rating_mean\":3.764705882352941,\"group_value\":\"animation\",\"group_name\":\"genre\",\"rate_year_count\":119.0,\"rank\":4,\"movie_id\":588,\"title\":\"Beauty and the Beast (1991)\"},{\"rating_mean\":3.8362989323843415,\"group_value\":\"animation\",\"group_name\":\"genre\",\"rate_year_count\":281.0,\"rank\":1,\"movie_id\":1,\"title\":\"Toy Story (1995)\"},{\"rating_mean\":3.742424242424242,\"group_value\":\"animation\",\"group_name\":\"genre\",\"rate_year_count\":132.0,\"rank\":2,\"movie_id\":71,\"title\":\"Lion King, The (1994)\"},{\"rating_mean\":3.7540983606557377,\"group_value\":\"animation\",\"group_name\":\"genre\",\"rate_year_count\":122.0,\"rank\":3,\"movie_id\":95,\"title\":\"Aladdin (1992)\"},{\"rating_mean\":3.6808510638297873,\"group_value\":\"animation\",\"group_name\":\"genre\",\"rate_year_count\":94.0,\"rank\":5,\"movie_id\":432,\"title\":\"Fantasia (1940)\"},{\"rating_mean\":3.6630434782608696,\"group_value\":\"animation\",\"group_name\":\"genre\",\"rate_year_count\":92.0,\"rank\":6,\"movie_id\":99,\"title\":\"Snow White and the Seven Dwarfs (1937)\"},{\"rating_mean\":2.8636363636363638,\"group_value\":\"animation\",\"group_name\":\"genre\",\"rate_year_count\":88.0,\"rank\":7,\"movie_id\":240,\"title\":\"Beavis and Butt-head Do America (1996)\"},{\"rating_mean\":4.481927710843373,\"group_value\":\"animation\",\"group_name\":\"genre\",\"rate_year_count\":83.0,\"rank\":8,\"movie_id\":169,\"title\":\"Wrong Trousers, The (1993)\"},{\"rating_mean\":3.050632911392405,\"group_value\":\"animation\",\"group_name\":\"genre\",\"rate_year_count\":79.0,\"rank\":9,\"movie_id\":473,\"title\":\"James and the Giant Peach (1996)\"},{\"rating_mean\":3.5454545454545454,\"group_value\":\"animation\",\"group_name\":\"genre\",\"rate_year_count\":77.0,\"rank\":10,\"movie_id\":501,\"title\":\"Dumbo (1941)\"}]"
    },
    {
        "group_value": "comedy",
        "group_name": "genre",
        "pred": "[{\"rating_mean\":3.9072164948453607,\"group_value\":\"comedy\",\"group_name\":\"genre\",\"rate_year_count\":194.0,\"rank\":4,\"movie_id\":269,\"title\":\"Full Monty, The (1997)\"},{\"rating_mean\":3.136842105263158,\"group_value\":\"comedy\",\"group_name\":\"genre\",\"rate_year_count\":285.0,\"rank\":1,\"movie_id\":294,\"title\":\"Liar Liar (1997)\"},{\"rating_mean\":3.8190476190476192,\"group_value\":\"comedy\",\"group_name\":\"genre\",\"rate_year_count\":210.0,\"rank\":2,\"movie_id\":204,\"title\":\"Back to the Future (1985)\"},{\"rating_mean\":3.9846153846153847,\"group_value\":\"comedy\",\"group_name\":\"genre\",\"rate_year_count\":195.0,\"rank\":3,\"movie_id\":168,\"title\":\"Monty Python and the Holy Grail (1974)\"},{\"rating_mean\":3.8125,\"group_value\":\"comedy\",\"group_name\":\"genre\",\"rate_year_count\":192.0,\"rank\":5,\"movie_id\":69,\"title\":\"Forrest Gump (1994)\"},{\"rating_mean\":3.489247311827957,\"group_value\":\"comedy\",\"group_name\":\"genre\",\"rate_year_count\":186.0,\"rank\":6,\"movie_id\":25,\"title\":\"Birdcage, The (1996)\"},{\"rating_mean\":3.9604519774011298,\"group_value\":\"comedy\",\"group_name\":\"genre\",\"rate_year_count\":177.0,\"rank\":7,\"movie_id\":216,\"title\":\"When Harry Met Sally... (1989)\"},{\"rating_mean\":3.4739884393063583,\"group_value\":\"comedy\",\"group_name\":\"genre\",\"rate_year_count\":173.0,\"rank\":8,\"movie_id\":111,\"title\":\"Truth About Cats & Dogs, The (1996)\"},{\"rating_mean\":3.75,\"group_value\":\"comedy\",\"group_name\":\"genre\",\"rate_year_count\":164.0,\"rank\":9,\"movie_id\":202,\"title\":\"Groundhog Day (1993)\"},{\"rating_mean\":3.8645161290322583,\"group_value\":\"comedy\",\"group_name\":\"genre\",\"rate_year_count\":155.0,\"rank\":10,\"movie_id\":238,\"title\":\"Raising Arizona (1987)\"}]"
    },
    {
        "group_value": "documentary",
        "group_name": "genre",
        "pred": "[{\"rating_mean\":3.736842105263158,\"group_value\":\"documentary\",\"group_name\":\"genre\",\"rate_year_count\":19.0,\"rank\":9,\"movie_id\":634,\"title\":\"Microcosmos: Le peuple de l'herbe (1996)\"},{\"rating_mean\":4.098591549295775,\"group_value\":\"documentary\",\"group_name\":\"genre\",\"rate_year_count\":71.0,\"rank\":1,\"movie_id\":48,\"title\":\"Hoop Dreams (1994)\"},{\"rating_mean\":3.8,\"group_value\":\"documentary\",\"group_name\":\"genre\",\"rate_year_count\":45.0,\"rank\":2,\"movie_id\":32,\"title\":\"Crumb (1994)\"},{\"rating_mean\":3.888888888888889,\"group_value\":\"documentary\",\"group_name\":\"genre\",\"rate_year_count\":36.0,\"rank\":3,\"movie_id\":813,\"title\":\"Celluloid Closet, The (1995)\"},{\"rating_mean\":3.466666666666667,\"group_value\":\"documentary\",\"group_name\":\"genre\",\"rate_year_count\":30.0,\"rank\":4,\"movie_id\":847,\"title\":\"Looking for Richard (1996)\"},{\"rating_mean\":4.0,\"group_value\":\"documentary\",\"group_name\":\"genre\",\"rate_year_count\":30.0,\"rank\":5,\"movie_id\":1142,\"title\":\"When We Were Kings (1996)\"},{\"rating_mean\":3.1379310344827585,\"group_value\":\"documentary\",\"group_name\":\"genre\",\"rate_year_count\":29.0,\"rank\":6,\"movie_id\":1065,\"title\":\"Koyaanisqatsi (1983)\"},{\"rating_mean\":3.4782608695652173,\"group_value\":\"documentary\",\"group_name\":\"genre\",\"rate_year_count\":23.0,\"rank\":7,\"movie_id\":1022,\"title\":\"Fast, Cheap & Out of Control (1997)\"},{\"rating_mean\":3.6363636363636362,\"group_value\":\"documentary\",\"group_name\":\"genre\",\"rate_year_count\":22.0,\"rank\":8,\"movie_id\":644,\"title\":\"Thin Blue Line, The (1988)\"},{\"rating_mean\":3.823529411764706,\"group_value\":\"documentary\",\"group_name\":\"genre\",\"rate_year_count\":17.0,\"rank\":10,\"movie_id\":645,\"title\":\"Paris Is Burning (1990)\"}]"
    },
    {
        "group_value": "drama",
        "group_name": "genre",
        "pred": "[{\"rating_mean\":3.8536585365853657,\"group_value\":\"drama\",\"group_name\":\"genre\",\"rate_year_count\":287.0,\"rank\":1,\"movie_id\":258,\"title\":\"Contact (1997)\"},{\"rating_mean\":3.933333333333333,\"group_value\":\"drama\",\"group_name\":\"genre\",\"rate_year_count\":180.0,\"rank\":8,\"movie_id\":9,\"title\":\"Dead Man Walking (1995)\"},{\"rating_mean\":4.472527472527473,\"group_value\":\"drama\",\"group_name\":\"genre\",\"rate_year_count\":182.0,\"rank\":7,\"movie_id\":318,\"title\":\"Schindler's List (1993)\"},{\"rating_mean\":3.796875,\"group_value\":\"drama\",\"group_name\":\"genre\",\"rate_year_count\":192.0,\"rank\":6,\"movie_id\":15,\"title\":\"Mr. Holland's Opus (1995)\"},{\"rating_mean\":3.6519823788546257,\"group_value\":\"drama\",\"group_name\":\"genre\",\"rate_year_count\":227.0,\"rank\":5,\"movie_id\":237,\"title\":\"Jerry Maguire (1996)\"},{\"rating_mean\":4.346320346320346,\"group_value\":\"drama\",\"group_name\":\"genre\",\"rate_year_count\":231.0,\"rank\":4,\"movie_id\":98,\"title\":\"Silence of the Lambs, The (1991)\"},{\"rating_mean\":3.8025751072961373,\"group_value\":\"drama\",\"group_name\":\"genre\",\"rate_year_count\":233.0,\"rank\":3,\"movie_id\":7,\"title\":\"Twelve Monkeys (1995)\"},{\"rating_mean\":3.6483516483516483,\"group_value\":\"drama\",\"group_name\":\"genre\",\"rate_year_count\":273.0,\"rank\":2,\"movie_id\":286,\"title\":\"English Patient, The (1996)\"},{\"rating_mean\":4.127167630057803,\"group_value\":\"drama\",\"group_name\":\"genre\",\"rate_year_count\":173.0,\"rank\":9,\"movie_id\":191,\"title\":\"Amadeus (1984)\"},{\"rating_mean\":3.6820809248554913,\"group_value\":\"drama\",\"group_name\":\"genre\",\"rate_year_count\":173.0,\"rank\":10,\"movie_id\":276,\"title\":\"Leaving Las Vegas (1995)\"}]"
    },
    {
        "group_value": "film_noir",
        "group_name": "genre",
        "pred": "[{\"rating_mean\":4.217948717948718,\"group_value\":\"film_noir\",\"group_name\":\"genre\",\"rate_year_count\":78.0,\"rank\":4,\"movie_id\":657,\"title\":\"Manchurian Candidate, The (1962)\"},{\"rating_mean\":4.111111111111111,\"group_value\":\"film_noir\",\"group_name\":\"genre\",\"rate_year_count\":162.0,\"rank\":1,\"movie_id\":89,\"title\":\"Blade Runner (1982)\"},{\"rating_mean\":4.2298850574712645,\"group_value\":\"film_noir\",\"group_name\":\"genre\",\"rate_year_count\":87.0,\"rank\":2,\"movie_id\":654,\"title\":\"Chinatown (1974)\"},{\"rating_mean\":4.188235294117647,\"group_value\":\"film_noir\",\"group_name\":\"genre\",\"rate_year_count\":85.0,\"rank\":3,\"movie_id\":484,\"title\":\"Maltese Falcon, The (1941)\"},{\"rating_mean\":3.576923076923077,\"group_value\":\"film_noir\",\"group_name\":\"genre\",\"rate_year_count\":52.0,\"rank\":5,\"movie_id\":673,\"title\":\"Cape Fear (1962)\"},{\"rating_mean\":4.061224489795919,\"group_value\":\"film_noir\",\"group_name\":\"genre\",\"rate_year_count\":49.0,\"rank\":6,\"movie_id\":525,\"title\":\"Big Sleep, The (1946)\"},{\"rating_mean\":4.382352941176471,\"group_value\":\"film_noir\",\"group_name\":\"genre\",\"rate_year_count\":34.0,\"rank\":7,\"movie_id\":488,\"title\":\"Sunset Blvd. (1950)\"},{\"rating_mean\":4.133333333333334,\"group_value\":\"film_noir\",\"group_name\":\"genre\",\"rate_year_count\":30.0,\"rank\":8,\"movie_id\":489,\"title\":\"Notorious (1946)\"},{\"rating_mean\":3.0,\"group_value\":\"film_noir\",\"group_name\":\"genre\",\"rate_year_count\":8.0,\"rank\":9,\"movie_id\":1313,\"title\":\"Palmetto (1998)\"},{\"rating_mean\":3.25,\"group_value\":\"film_noir\",\"group_name\":\"genre\",\"rate_year_count\":8.0,\"rank\":10,\"movie_id\":691,\"title\":\"Dark City (1998)\"}]"
    },
    {
        "group_value": "mystery",
        "group_name": "genre",
        "pred": "[{\"rating_mean\":3.5524475524475525,\"group_value\":\"mystery\",\"group_name\":\"genre\",\"rate_year_count\":143.0,\"rank\":1,\"movie_id\":333,\"title\":\"Game, The (1997)\"},{\"rating_mean\":4.216216216216216,\"group_value\":\"mystery\",\"group_name\":\"genre\",\"rate_year_count\":37.0,\"rank\":10,\"movie_id\":493,\"title\":\"Thin Man, The (1934)\"},{\"rating_mean\":3.9743589743589745,\"group_value\":\"mystery\",\"group_name\":\"genre\",\"rate_year_count\":39.0,\"rank\":9,\"movie_id\":505,\"title\":\"Dial M for Murder (1954)\"},{\"rating_mean\":4.232558139534884,\"group_value\":\"mystery\",\"group_name\":\"genre\",\"rate_year_count\":43.0,\"rank\":8,\"movie_id\":513,\"title\":\"Third Man, The (1949)\"},{\"rating_mean\":3.3518518518518516,\"group_value\":\"mystery\",\"group_name\":\"genre\",\"rate_year_count\":54.0,\"rank\":7,\"movie_id\":159,\"title\":\"Basic Instinct (1992)\"},{\"rating_mean\":3.1594202898550723,\"group_value\":\"mystery\",\"group_name\":\"genre\",\"rate_year_count\":69.0,\"rank\":6,\"movie_id\":324,\"title\":\"Lost Highway (1997)\"},{\"rating_mean\":3.380281690140845,\"group_value\":\"mystery\",\"group_name\":\"genre\",\"rate_year_count\":71.0,\"rank\":5,\"movie_id\":291,\"title\":\"Absolute Power (1997)\"},{\"rating_mean\":4.326732673267327,\"group_value\":\"mystery\",\"group_name\":\"genre\",\"rate_year_count\":101.0,\"rank\":4,\"movie_id\":479,\"title\":\"Vertigo (1958)\"},{\"rating_mean\":4.366666666666666,\"group_value\":\"mystery\",\"group_name\":\"genre\",\"rate_year_count\":120.0,\"rank\":3,\"movie_id\":603,\"title\":\"Rear Window (1954)\"},{\"rating_mean\":3.062015503875969,\"group_value\":\"mystery\",\"group_name\":\"genre\",\"rate_year_count\":129.0,\"rank\":2,\"movie_id\":322,\"title\":\"Murder at 1600 (1997)\"}]"
    },
    {
        "group_value": "thriller",
        "group_name": "genre",
        "pred": "[{\"rating_mean\":4.056338028169014,\"group_value\":\"thriller\",\"group_name\":\"genre\",\"rate_year_count\":71.0,\"rank\":2,\"movie_id\":198,\"title\":\"Nikita (La Femme Nikita) (1990)\"},{\"rating_mean\":3.2857142857142856,\"group_value\":\"thriller\",\"group_name\":\"genre\",\"rate_year_count\":56.0,\"rank\":3,\"movie_id\":3,\"title\":\"Four Rooms (1995)\"},{\"rating_mean\":3.85,\"group_value\":\"thriller\",\"group_name\":\"genre\",\"rate_year_count\":40.0,\"rank\":4,\"movie_id\":1073,\"title\":\"Shallow Grave (1994)\"},{\"rating_mean\":3.789473684210526,\"group_value\":\"thriller\",\"group_name\":\"genre\",\"rate_year_count\":38.0,\"rank\":5,\"movie_id\":466,\"title\":\"Red Rock West (1992)\"},{\"rating_mean\":4.057142857142857,\"group_value\":\"thriller\",\"group_name\":\"genre\",\"rate_year_count\":35.0,\"rank\":6,\"movie_id\":615,\"title\":\"39 Steps, The (1935)\"},{\"rating_mean\":3.0,\"group_value\":\"thriller\",\"group_name\":\"genre\",\"rate_year_count\":33.0,\"rank\":7,\"movie_id\":595,\"title\":\"Fan, The (1996)\"},{\"rating_mean\":3.1379310344827585,\"group_value\":\"thriller\",\"group_name\":\"genre\",\"rate_year_count\":29.0,\"rank\":8,\"movie_id\":1046,\"title\":\"Malice (1993)\"},{\"rating_mean\":2.9285714285714284,\"group_value\":\"thriller\",\"group_name\":\"genre\",\"rate_year_count\":28.0,\"rank\":9,\"movie_id\":984,\"title\":\"Shadow Conspiracy (1997)\"},{\"rating_mean\":2.8,\"group_value\":\"thriller\",\"group_name\":\"genre\",\"rate_year_count\":25.0,\"rank\":10,\"movie_id\":1217,\"title\":\"Assassins (1995)\"},{\"rating_mean\":3.4953271028037385,\"group_value\":\"thriller\",\"group_name\":\"genre\",\"rate_year_count\":107.0,\"rank\":1,\"movie_id\":218,\"title\":\"Cape Fear (1991)\"}]"
    },
    {
        "group_value": "1997",
        "group_name": "rate_year",
        "pred": "[{\"rating_mean\":4.397905759162303,\"group_value\":\"1997\",\"group_name\":\"rate_year\",\"rate_year_count\":191.0,\"rank\":1,\"movie_id\":50,\"title\":\"Star Wars (1977)\"},{\"rating_mean\":3.8129496402877696,\"group_value\":\"1997\",\"group_name\":\"rate_year\",\"rate_year_count\":139.0,\"rank\":10,\"movie_id\":7,\"title\":\"Twelve Monkeys (1995)\"},{\"rating_mean\":3.2714285714285714,\"group_value\":\"1997\",\"group_name\":\"rate_year\",\"rate_year_count\":140.0,\"rank\":9,\"movie_id\":294,\"title\":\"Liar Liar (1997)\"},{\"rating_mean\":4.142857142857143,\"group_value\":\"1997\",\"group_name\":\"rate_year\",\"rate_year_count\":140.0,\"rank\":8,\"movie_id\":56,\"title\":\"Pulp Fiction (1994)\"},{\"rating_mean\":3.359154929577465,\"group_value\":\"1997\",\"group_name\":\"rate_year\",\"rate_year_count\":142.0,\"rank\":7,\"movie_id\":121,\"title\":\"Independence Day (ID4) (1996)\"},{\"rating_mean\":4.295302013422819,\"group_value\":\"1997\",\"group_name\":\"rate_year\",\"rate_year_count\":149.0,\"rank\":6,\"movie_id\":174,\"title\":\"Raiders of the Lost Ark (1981)\"},{\"rating_mean\":4.295302013422819,\"group_value\":\"1997\",\"group_name\":\"rate_year\",\"rate_year_count\":149.0,\"rank\":5,\"movie_id\":127,\"title\":\"Godfather, The (1972)\"},{\"rating_mean\":4.0,\"group_value\":\"1997\",\"group_name\":\"rate_year\",\"rate_year_count\":160.0,\"rank\":4,\"movie_id\":181,\"title\":\"Return of the Jedi (1983)\"},{\"rating_mean\":3.871165644171779,\"group_value\":\"1997\",\"group_name\":\"rate_year\",\"rate_year_count\":163.0,\"rank\":3,\"movie_id\":1,\"title\":\"Toy Story (1995)\"},{\"rating_mean\":4.21978021978022,\"group_value\":\"1997\",\"group_name\":\"rate_year\",\"rate_year_count\":182.0,\"rank\":2,\"movie_id\":100,\"title\":\"Fargo (1996)\"}]"
    },
    {
        "group_value": "",
        "group_name": "genre",
        "pred": "[{\"rating_mean\":3.1666666666666665,\"group_value\":\"\",\"group_name\":\"genre\",\"rate_year_count\":6.0,\"rank\":1,\"movie_id\":267,\"title\":\"unknown\"},{\"rating_mean\":1.0,\"group_value\":\"\",\"group_name\":\"genre\",\"rate_year_count\":1.0,\"rank\":2,\"movie_id\":1373,\"title\":\"Good Morning (1971)\"}]"
    },
    {
        "group_value": "fantasy",
        "group_name": "genre",
        "pred": "[{\"rating_mean\":1.0,\"group_value\":\"fantasy\",\"group_name\":\"genre\",\"rate_year_count\":1.0,\"rank\":1,\"movie_id\":1576,\"title\":\"Hungarian Fairy Tale, A (1987)\"}]"
    },
    {
        "group_value": "horror",
        "group_name": "genre",
        "pred": "[{\"rating_mean\":3.3682432432432434,\"group_value\":\"horror\",\"group_name\":\"genre\",\"rate_year_count\":296.0,\"rank\":1,\"movie_id\":288,\"title\":\"Scream (1996)\"},{\"rating_mean\":4.057971014492754,\"group_value\":\"horror\",\"group_name\":\"genre\",\"rate_year_count\":138.0,\"rank\":2,\"movie_id\":185,\"title\":\"Psycho (1960)\"},{\"rating_mean\":3.7857142857142856,\"group_value\":\"horror\",\"group_name\":\"genre\",\"rate_year_count\":126.0,\"rank\":3,\"movie_id\":200,\"title\":\"Shining, The (1980)\"},{\"rating_mean\":3.780952380952381,\"group_value\":\"horror\",\"group_name\":\"genre\",\"rate_year_count\":105.0,\"rank\":4,\"movie_id\":443,\"title\":\"Birds, The (1963)\"},{\"rating_mean\":3.211267605633803,\"group_value\":\"horror\",\"group_name\":\"genre\",\"rate_year_count\":71.0,\"rank\":5,\"movie_id\":217,\"title\":\"Bram Stoker's Dracula (1992)\"},{\"rating_mean\":3.4411764705882355,\"group_value\":\"horror\",\"group_name\":\"genre\",\"rate_year_count\":68.0,\"rank\":6,\"movie_id\":447,\"title\":\"Carrie (1976)\"},{\"rating_mean\":3.257575757575758,\"group_value\":\"horror\",\"group_name\":\"genre\",\"rate_year_count\":66.0,\"rank\":7,\"movie_id\":219,\"title\":\"Nightmare on Elm Street, A (1984)\"},{\"rating_mean\":3.1363636363636362,\"group_value\":\"horror\",\"group_name\":\"genre\",\"rate_year_count\":66.0,\"rank\":8,\"movie_id\":895,\"title\":\"Scream 2 (1997)\"},{\"rating_mean\":3.0161290322580645,\"group_value\":\"horror\",\"group_name\":\"genre\",\"rate_year_count\":62.0,\"rank\":9,\"movie_id\":682,\"title\":\"I Know What You Did Last Summer (1997)\"},{\"rating_mean\":3.381818181818182,\"group_value\":\"horror\",\"group_name\":\"genre\",\"rate_year_count\":55.0,\"rank\":10,\"movie_id\":448,\"title\":\"Omen, The (1976)\"}]"
    },
    {
        "group_value": "romance",
        "group_name": "genre",
        "pred": "[{\"rating_mean\":3.9696969696969697,\"group_value\":\"romance\",\"group_name\":\"genre\",\"rate_year_count\":33.0,\"rank\":1,\"movie_id\":607,\"title\":\"Rebecca (1940)\"},{\"rating_mean\":4.148148148148148,\"group_value\":\"romance\",\"group_name\":\"genre\",\"rate_year_count\":27.0,\"rank\":2,\"movie_id\":694,\"title\":\"Persuasion (1995)\"},{\"rating_mean\":3.230769230769231,\"group_value\":\"romance\",\"group_name\":\"genre\",\"rate_year_count\":26.0,\"rank\":3,\"movie_id\":886,\"title\":\"Life Less Ordinary, A (1997)\"},{\"rating_mean\":3.16,\"group_value\":\"romance\",\"group_name\":\"genre\",\"rate_year_count\":25.0,\"rank\":4,\"movie_id\":872,\"title\":\"Love Jones (1997)\"},{\"rating_mean\":4.176470588235294,\"group_value\":\"romance\",\"group_name\":\"genre\",\"rate_year_count\":17.0,\"rank\":5,\"movie_id\":966,\"title\":\"Affair to Remember, An (1957)\"},{\"rating_mean\":3.25,\"group_value\":\"romance\",\"group_name\":\"genre\",\"rate_year_count\":16.0,\"rank\":6,\"movie_id\":1152,\"title\":\"In Love and War (1996)\"},{\"rating_mean\":3.0,\"group_value\":\"romance\",\"group_name\":\"genre\",\"rate_year_count\":12.0,\"rank\":7,\"movie_id\":532,\"title\":\"Kama Sutra: A Tale of Love (1996)\"},{\"rating_mean\":3.7777777777777777,\"group_value\":\"romance\",\"group_name\":\"genre\",\"rate_year_count\":9.0,\"rank\":8,\"movie_id\":1124,\"title\":\"Farewell to Arms, A (1932)\"},{\"rating_mean\":3.6666666666666665,\"group_value\":\"romance\",\"group_name\":\"genre\",\"rate_year_count\":6.0,\"rank\":9,\"movie_id\":1024,\"title\":\"Mrs. Dalloway (1997)\"},{\"rating_mean\":2.6666666666666665,\"group_value\":\"romance\",\"group_name\":\"genre\",\"rate_year_count\":6.0,\"rank\":10,\"movie_id\":1434,\"title\":\"Shooting Fish (1997)\"}]"
    },
    {
        "group_value": "sci_fi",
        "group_name": "genre",
        "pred": "[{\"rating_mean\":3.8285714285714287,\"group_value\":\"sci_fi\",\"group_name\":\"genre\",\"rate_year_count\":35.0,\"rank\":6,\"movie_id\":434,\"title\":\"Forbidden Planet (1956)\"},{\"rating_mean\":3.976923076923077,\"group_value\":\"sci_fi\",\"group_name\":\"genre\",\"rate_year_count\":130.0,\"rank\":1,\"movie_id\":179,\"title\":\"Clockwork Orange, A (1971)\"},{\"rating_mean\":3.680672268907563,\"group_value\":\"sci_fi\",\"group_name\":\"genre\",\"rate_year_count\":119.0,\"rank\":2,\"movie_id\":175,\"title\":\"Brazil (1985)\"},{\"rating_mean\":4.201754385964913,\"group_value\":\"sci_fi\",\"group_name\":\"genre\",\"rate_year_count\":114.0,\"rank\":3,\"movie_id\":474,\"title\":\"Dr. Strangelove or: How I Learned to Stop Worrying and Love the Bomb (1963)\"},{\"rating_mean\":2.984848484848485,\"group_value\":\"sci_fi\",\"group_name\":\"genre\",\"rate_year_count\":66.0,\"rank\":4,\"movie_id\":38,\"title\":\"Net, The (1995)\"},{\"rating_mean\":2.9074074074074074,\"group_value\":\"sci_fi\",\"group_name\":\"genre\",\"rate_year_count\":54.0,\"rank\":5,\"movie_id\":264,\"title\":\"Mimic (1997)\"},{\"rating_mean\":2.2941176470588234,\"group_value\":\"sci_fi\",\"group_name\":\"genre\",\"rate_year_count\":34.0,\"rank\":7,\"movie_id\":931,\"title\":\"Island of Dr. Moreau, The (1996)\"},{\"rating_mean\":2.793103448275862,\"group_value\":\"sci_fi\",\"group_name\":\"genre\",\"rate_year_count\":29.0,\"rank\":8,\"movie_id\":552,\"title\":\"Species (1995)\"},{\"rating_mean\":2.4814814814814814,\"group_value\":\"sci_fi\",\"group_name\":\"genre\",\"rate_year_count\":27.0,\"rank\":9,\"movie_id\":760,\"title\":\"Screamers (1995)\"},{\"rating_mean\":2.380952380952381,\"group_value\":\"sci_fi\",\"group_name\":\"genre\",\"rate_year_count\":21.0,\"rank\":10,\"movie_id\":1210,\"title\":\"Virtuosity (1995)\"}]"
    },
    {
        "group_value": "1998",
        "group_name": "rate_year",
        "pred": "[{\"rating_mean\":4.242718446601942,\"group_value\":\"1998\",\"group_name\":\"rate_year\",\"rate_year_count\":206.0,\"rank\":1,\"movie_id\":313,\"title\":\"Titanic (1997)\"},{\"rating_mean\":3.7222222222222223,\"group_value\":\"1998\",\"group_name\":\"rate_year\",\"rate_year_count\":162.0,\"rank\":2,\"movie_id\":258,\"title\":\"Contact (1997)\"},{\"rating_mean\":3.6772151898734178,\"group_value\":\"1998\",\"group_name\":\"rate_year\",\"rate_year_count\":158.0,\"rank\":3,\"movie_id\":300,\"title\":\"Air Force One (1997)\"},{\"rating_mean\":3.3503184713375798,\"group_value\":\"1998\",\"group_name\":\"rate_year\",\"rate_year_count\":157.0,\"rank\":4,\"movie_id\":288,\"title\":\"Scream (1996)\"},{\"rating_mean\":3.0068965517241377,\"group_value\":\"1998\",\"group_name\":\"rate_year\",\"rate_year_count\":145.0,\"rank\":5,\"movie_id\":294,\"title\":\"Liar Liar (1997)\"},{\"rating_mean\":4.392857142857143,\"group_value\":\"1998\",\"group_name\":\"rate_year\",\"rate_year_count\":140.0,\"rank\":6,\"movie_id\":50,\"title\":\"Star Wars (1977)\"},{\"rating_mean\":3.5755395683453237,\"group_value\":\"1998\",\"group_name\":\"rate_year\",\"rate_year_count\":139.0,\"rank\":7,\"movie_id\":286,\"title\":\"English Patient, The (1996)\"},{\"rating_mean\":4.032,\"group_value\":\"1998\",\"group_name\":\"rate_year\",\"rate_year_count\":125.0,\"rank\":8,\"movie_id\":181,\"title\":\"Return of the Jedi (1983)\"},{\"rating_mean\":4.07258064516129,\"group_value\":\"1998\",\"group_name\":\"rate_year\",\"rate_year_count\":124.0,\"rank\":9,\"movie_id\":100,\"title\":\"Fargo (1996)\"},{\"rating_mean\":4.275,\"group_value\":\"1998\",\"group_name\":\"rate_year\",\"rate_year_count\":120.0,\"rank\":10,\"movie_id\":272,\"title\":\"Good Will Hunting (1997)\"}]"
    }
]

ALinkLab

排行榜

介绍

数据