{ "cells": [ { "cell_type": "code", "execution_count": 1, "id": "3fc7b6bb-9320-4dd4-82b8-90f5055c6ddc", "metadata": {}, "outputs": [], "source": [ "\n", "import pandas as pd\n", "import numpy as np " ] }, { "cell_type": "code", "execution_count": 116, "id": "0551b2bb-8a40-41c3-8290-7a04cf10f2f4", "metadata": {}, "outputs": [], "source": [ "import pickle" ] }, { "cell_type": "code", "execution_count": 117, "id": "0b9e8bfe-1fb6-4e46-a89c-35e9199a060b", "metadata": {}, "outputs": [], "source": [ "df=pickle.load(open('dataset_level2.pkl','rb'))" ] }, { "cell_type": "code", "execution_count": 118, "id": "912a730f-2918-4ee9-98e4-d281be103461", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", " | match_id | \n", "batting_team | \n", "bowling_team | \n", "ball | \n", "runs | \n", "player_dismissed | \n", "city | \n", "venue | \n", "
---|---|---|---|---|---|---|---|---|
0 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.1 | \n", "0 | \n", "0 | \n", "Durban | \n", "Kingsmead | \n", "
1 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.2 | \n", "1 | \n", "0 | \n", "Durban | \n", "Kingsmead | \n", "
2 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.3 | \n", "0 | \n", "0 | \n", "Durban | \n", "Kingsmead | \n", "
3 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.4 | \n", "0 | \n", "0 | \n", "Durban | \n", "Kingsmead | \n", "
4 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.5 | \n", "0 | \n", "0 | \n", "Durban | \n", "Kingsmead | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
519641 | \n", "1800 | \n", "Afghanistan | \n", "Bangladesh | \n", "49.2 | \n", "4 | \n", "0 | \n", "Abu Dhabi | \n", "Sheikh Zayed Stadium | \n", "
519642 | \n", "1800 | \n", "Afghanistan | \n", "Bangladesh | \n", "49.3 | \n", "4 | \n", "0 | \n", "Abu Dhabi | \n", "Sheikh Zayed Stadium | \n", "
519643 | \n", "1800 | \n", "Afghanistan | \n", "Bangladesh | \n", "49.4 | \n", "2 | \n", "0 | \n", "Abu Dhabi | \n", "Sheikh Zayed Stadium | \n", "
519644 | \n", "1800 | \n", "Afghanistan | \n", "Bangladesh | \n", "49.5 | \n", "4 | \n", "0 | \n", "Abu Dhabi | \n", "Sheikh Zayed Stadium | \n", "
519645 | \n", "1800 | \n", "Afghanistan | \n", "Bangladesh | \n", "49.6 | \n", "4 | \n", "0 | \n", "Abu Dhabi | \n", "Sheikh Zayed Stadium | \n", "
312984 rows × 8 columns
\n", "\n", " | match_id | \n", "batting_team | \n", "bowling_team | \n", "ball | \n", "runs | \n", "player_dismissed | \n", "city | \n", "venue | \n", "
---|---|---|---|---|---|---|---|---|
3124 | \n", "13 | \n", "Australia | \n", "South Africa | \n", "0.1 | \n", "0 | \n", "0 | \n", "NaN | \n", "Melbourne Cricket Ground | \n", "
3125 | \n", "13 | \n", "Australia | \n", "South Africa | \n", "0.2 | \n", "0 | \n", "0 | \n", "NaN | \n", "Melbourne Cricket Ground | \n", "
3126 | \n", "13 | \n", "Australia | \n", "South Africa | \n", "0.3 | \n", "1 | \n", "0 | \n", "NaN | \n", "Melbourne Cricket Ground | \n", "
3127 | \n", "13 | \n", "Australia | \n", "South Africa | \n", "0.4 | \n", "1 | \n", "0 | \n", "NaN | \n", "Melbourne Cricket Ground | \n", "
3128 | \n", "13 | \n", "Australia | \n", "South Africa | \n", "0.5 | \n", "1 | \n", "0 | \n", "NaN | \n", "Melbourne Cricket Ground | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
517245 | \n", "1792 | \n", "Australia | \n", "South Africa | \n", "49.2 | \n", "1 | \n", "0 | \n", "NaN | \n", "Harare Sports Club | \n", "
517246 | \n", "1792 | \n", "Australia | \n", "South Africa | \n", "49.3 | \n", "2 | \n", "0 | \n", "NaN | \n", "Harare Sports Club | \n", "
517247 | \n", "1792 | \n", "Australia | \n", "South Africa | \n", "49.4 | \n", "0 | \n", "JP Faulkner | \n", "NaN | \n", "Harare Sports Club | \n", "
517248 | \n", "1792 | \n", "Australia | \n", "South Africa | \n", "49.5 | \n", "2 | \n", "0 | \n", "NaN | \n", "Harare Sports Club | \n", "
517249 | \n", "1792 | \n", "Australia | \n", "South Africa | \n", "49.6 | \n", "0 | \n", "0 | \n", "NaN | \n", "Harare Sports Club | \n", "
56082 rows × 8 columns
\n", "\n", " | match_id | \n", "batting_team | \n", "bowling_team | \n", "ball | \n", "runs | \n", "player_dismissed | \n", "city | \n", "
---|---|---|---|---|---|---|---|
0 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.1 | \n", "0 | \n", "0 | \n", "Durban | \n", "
1 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.2 | \n", "1 | \n", "0 | \n", "Durban | \n", "
2 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.3 | \n", "0 | \n", "0 | \n", "Durban | \n", "
3 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.4 | \n", "0 | \n", "0 | \n", "Durban | \n", "
4 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.5 | \n", "0 | \n", "0 | \n", "Durban | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
519641 | \n", "1800 | \n", "Afghanistan | \n", "Bangladesh | \n", "49.2 | \n", "4 | \n", "0 | \n", "Abu Dhabi | \n", "
519642 | \n", "1800 | \n", "Afghanistan | \n", "Bangladesh | \n", "49.3 | \n", "4 | \n", "0 | \n", "Abu Dhabi | \n", "
519643 | \n", "1800 | \n", "Afghanistan | \n", "Bangladesh | \n", "49.4 | \n", "2 | \n", "0 | \n", "Abu Dhabi | \n", "
519644 | \n", "1800 | \n", "Afghanistan | \n", "Bangladesh | \n", "49.5 | \n", "4 | \n", "0 | \n", "Abu Dhabi | \n", "
519645 | \n", "1800 | \n", "Afghanistan | \n", "Bangladesh | \n", "49.6 | \n", "4 | \n", "0 | \n", "Abu Dhabi | \n", "
276744 rows × 7 columns
\n", "\n", " | match_id | \n", "batting_team | \n", "bowling_team | \n", "ball | \n", "runs | \n", "player_dismissed | \n", "city | \n", "current_score | \n", "
---|---|---|---|---|---|---|---|---|
0 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.1 | \n", "0 | \n", "0 | \n", "Durban | \n", "0 | \n", "
1 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.2 | \n", "1 | \n", "0 | \n", "Durban | \n", "1 | \n", "
2 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.3 | \n", "0 | \n", "0 | \n", "Durban | \n", "1 | \n", "
3 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.4 | \n", "0 | \n", "0 | \n", "Durban | \n", "1 | \n", "
4 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.5 | \n", "0 | \n", "0 | \n", "Durban | \n", "1 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
519641 | \n", "1800 | \n", "Afghanistan | \n", "Bangladesh | \n", "49.2 | \n", "4 | \n", "0 | \n", "Abu Dhabi | \n", "241 | \n", "
519642 | \n", "1800 | \n", "Afghanistan | \n", "Bangladesh | \n", "49.3 | \n", "4 | \n", "0 | \n", "Abu Dhabi | \n", "245 | \n", "
519643 | \n", "1800 | \n", "Afghanistan | \n", "Bangladesh | \n", "49.4 | \n", "2 | \n", "0 | \n", "Abu Dhabi | \n", "247 | \n", "
519644 | \n", "1800 | \n", "Afghanistan | \n", "Bangladesh | \n", "49.5 | \n", "4 | \n", "0 | \n", "Abu Dhabi | \n", "251 | \n", "
519645 | \n", "1800 | \n", "Afghanistan | \n", "Bangladesh | \n", "49.6 | \n", "4 | \n", "0 | \n", "Abu Dhabi | \n", "255 | \n", "
276744 rows × 8 columns
\n", "\n", " | match_id | \n", "batting_team | \n", "bowling_team | \n", "ball | \n", "runs | \n", "player_dismissed | \n", "city | \n", "current_score | \n", "over | \n", "ball_no | \n", "
---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.1 | \n", "0 | \n", "0 | \n", "Durban | \n", "0 | \n", "0 | \n", "1 | \n", "
1 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.2 | \n", "1 | \n", "0 | \n", "Durban | \n", "1 | \n", "0 | \n", "2 | \n", "
2 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.3 | \n", "0 | \n", "0 | \n", "Durban | \n", "1 | \n", "0 | \n", "3 | \n", "
3 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.4 | \n", "0 | \n", "0 | \n", "Durban | \n", "1 | \n", "0 | \n", "4 | \n", "
4 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.5 | \n", "0 | \n", "0 | \n", "Durban | \n", "1 | \n", "0 | \n", "5 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
519641 | \n", "1800 | \n", "Afghanistan | \n", "Bangladesh | \n", "49.2 | \n", "4 | \n", "0 | \n", "Abu Dhabi | \n", "241 | \n", "49 | \n", "2 | \n", "
519642 | \n", "1800 | \n", "Afghanistan | \n", "Bangladesh | \n", "49.3 | \n", "4 | \n", "0 | \n", "Abu Dhabi | \n", "245 | \n", "49 | \n", "3 | \n", "
519643 | \n", "1800 | \n", "Afghanistan | \n", "Bangladesh | \n", "49.4 | \n", "2 | \n", "0 | \n", "Abu Dhabi | \n", "247 | \n", "49 | \n", "4 | \n", "
519644 | \n", "1800 | \n", "Afghanistan | \n", "Bangladesh | \n", "49.5 | \n", "4 | \n", "0 | \n", "Abu Dhabi | \n", "251 | \n", "49 | \n", "5 | \n", "
519645 | \n", "1800 | \n", "Afghanistan | \n", "Bangladesh | \n", "49.6 | \n", "4 | \n", "0 | \n", "Abu Dhabi | \n", "255 | \n", "49 | \n", "6 | \n", "
276744 rows × 10 columns
\n", "\n", " | match_id | \n", "batting_team | \n", "bowling_team | \n", "ball | \n", "runs | \n", "player_dismissed | \n", "city | \n", "current_score | \n", "over | \n", "ball_no | \n", "balls_bowled | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.1 | \n", "0 | \n", "0 | \n", "Durban | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "
1 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.2 | \n", "1 | \n", "0 | \n", "Durban | \n", "1 | \n", "0 | \n", "2 | \n", "2 | \n", "
2 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.3 | \n", "0 | \n", "0 | \n", "Durban | \n", "1 | \n", "0 | \n", "3 | \n", "3 | \n", "
3 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.4 | \n", "0 | \n", "0 | \n", "Durban | \n", "1 | \n", "0 | \n", "4 | \n", "4 | \n", "
4 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.5 | \n", "0 | \n", "0 | \n", "Durban | \n", "1 | \n", "0 | \n", "5 | \n", "5 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
519641 | \n", "1800 | \n", "Afghanistan | \n", "Bangladesh | \n", "49.2 | \n", "4 | \n", "0 | \n", "Abu Dhabi | \n", "241 | \n", "49 | \n", "2 | \n", "296 | \n", "
519642 | \n", "1800 | \n", "Afghanistan | \n", "Bangladesh | \n", "49.3 | \n", "4 | \n", "0 | \n", "Abu Dhabi | \n", "245 | \n", "49 | \n", "3 | \n", "297 | \n", "
519643 | \n", "1800 | \n", "Afghanistan | \n", "Bangladesh | \n", "49.4 | \n", "2 | \n", "0 | \n", "Abu Dhabi | \n", "247 | \n", "49 | \n", "4 | \n", "298 | \n", "
519644 | \n", "1800 | \n", "Afghanistan | \n", "Bangladesh | \n", "49.5 | \n", "4 | \n", "0 | \n", "Abu Dhabi | \n", "251 | \n", "49 | \n", "5 | \n", "299 | \n", "
519645 | \n", "1800 | \n", "Afghanistan | \n", "Bangladesh | \n", "49.6 | \n", "4 | \n", "0 | \n", "Abu Dhabi | \n", "255 | \n", "49 | \n", "6 | \n", "300 | \n", "
276744 rows × 11 columns
\n", "\n", " | match_id | \n", "batting_team | \n", "bowling_team | \n", "ball | \n", "runs | \n", "player_dismissed | \n", "city | \n", "current_score | \n", "over | \n", "ball_no | \n", "balls_bowled | \n", "balls_left | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.1 | \n", "0 | \n", "0 | \n", "Durban | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "299 | \n", "
1 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.2 | \n", "1 | \n", "0 | \n", "Durban | \n", "1 | \n", "0 | \n", "2 | \n", "2 | \n", "298 | \n", "
2 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.3 | \n", "0 | \n", "0 | \n", "Durban | \n", "1 | \n", "0 | \n", "3 | \n", "3 | \n", "297 | \n", "
3 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.4 | \n", "0 | \n", "0 | \n", "Durban | \n", "1 | \n", "0 | \n", "4 | \n", "4 | \n", "296 | \n", "
4 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.5 | \n", "0 | \n", "0 | \n", "Durban | \n", "1 | \n", "0 | \n", "5 | \n", "5 | \n", "295 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
519641 | \n", "1800 | \n", "Afghanistan | \n", "Bangladesh | \n", "49.2 | \n", "4 | \n", "0 | \n", "Abu Dhabi | \n", "241 | \n", "49 | \n", "2 | \n", "296 | \n", "4 | \n", "
519642 | \n", "1800 | \n", "Afghanistan | \n", "Bangladesh | \n", "49.3 | \n", "4 | \n", "0 | \n", "Abu Dhabi | \n", "245 | \n", "49 | \n", "3 | \n", "297 | \n", "3 | \n", "
519643 | \n", "1800 | \n", "Afghanistan | \n", "Bangladesh | \n", "49.4 | \n", "2 | \n", "0 | \n", "Abu Dhabi | \n", "247 | \n", "49 | \n", "4 | \n", "298 | \n", "2 | \n", "
519644 | \n", "1800 | \n", "Afghanistan | \n", "Bangladesh | \n", "49.5 | \n", "4 | \n", "0 | \n", "Abu Dhabi | \n", "251 | \n", "49 | \n", "5 | \n", "299 | \n", "1 | \n", "
519645 | \n", "1800 | \n", "Afghanistan | \n", "Bangladesh | \n", "49.6 | \n", "4 | \n", "0 | \n", "Abu Dhabi | \n", "255 | \n", "49 | \n", "6 | \n", "300 | \n", "0 | \n", "
276744 rows × 12 columns
\n", "\n", " | match_id | \n", "batting_team | \n", "bowling_team | \n", "ball | \n", "runs | \n", "player_dismissed | \n", "city | \n", "current_score | \n", "over | \n", "ball_no | \n", "balls_bowled | \n", "balls_left | \n", "wickets | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.1 | \n", "0 | \n", "0 | \n", "Durban | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "299 | \n", "0 | \n", "
1 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.2 | \n", "1 | \n", "0 | \n", "Durban | \n", "1 | \n", "0 | \n", "2 | \n", "2 | \n", "298 | \n", "0 | \n", "
2 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.3 | \n", "0 | \n", "0 | \n", "Durban | \n", "1 | \n", "0 | \n", "3 | \n", "3 | \n", "297 | \n", "0 | \n", "
3 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.4 | \n", "0 | \n", "0 | \n", "Durban | \n", "1 | \n", "0 | \n", "4 | \n", "4 | \n", "296 | \n", "0 | \n", "
4 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.5 | \n", "0 | \n", "0 | \n", "Durban | \n", "1 | \n", "0 | \n", "5 | \n", "5 | \n", "295 | \n", "0 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
519641 | \n", "1800 | \n", "Afghanistan | \n", "Bangladesh | \n", "49.2 | \n", "4 | \n", "7 | \n", "Abu Dhabi | \n", "241 | \n", "49 | \n", "2 | \n", "296 | \n", "4 | \n", "7 | \n", "
519642 | \n", "1800 | \n", "Afghanistan | \n", "Bangladesh | \n", "49.3 | \n", "4 | \n", "7 | \n", "Abu Dhabi | \n", "245 | \n", "49 | \n", "3 | \n", "297 | \n", "3 | \n", "7 | \n", "
519643 | \n", "1800 | \n", "Afghanistan | \n", "Bangladesh | \n", "49.4 | \n", "2 | \n", "7 | \n", "Abu Dhabi | \n", "247 | \n", "49 | \n", "4 | \n", "298 | \n", "2 | \n", "7 | \n", "
519644 | \n", "1800 | \n", "Afghanistan | \n", "Bangladesh | \n", "49.5 | \n", "4 | \n", "7 | \n", "Abu Dhabi | \n", "251 | \n", "49 | \n", "5 | \n", "299 | \n", "1 | \n", "7 | \n", "
519645 | \n", "1800 | \n", "Afghanistan | \n", "Bangladesh | \n", "49.6 | \n", "4 | \n", "7 | \n", "Abu Dhabi | \n", "255 | \n", "49 | \n", "6 | \n", "300 | \n", "0 | \n", "7 | \n", "
276744 rows × 13 columns
\n", "\n", " | match_id | \n", "batting_team | \n", "bowling_team | \n", "ball | \n", "runs | \n", "player_dismissed | \n", "city | \n", "current_score | \n", "over | \n", "ball_no | \n", "balls_bowled | \n", "balls_left | \n", "wickets | \n", "crr | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.1 | \n", "0 | \n", "0 | \n", "Durban | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "299 | \n", "0 | \n", "0.000000 | \n", "
1 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.2 | \n", "1 | \n", "0 | \n", "Durban | \n", "1 | \n", "0 | \n", "2 | \n", "2 | \n", "298 | \n", "0 | \n", "3.000000 | \n", "
2 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.3 | \n", "0 | \n", "0 | \n", "Durban | \n", "1 | \n", "0 | \n", "3 | \n", "3 | \n", "297 | \n", "0 | \n", "2.000000 | \n", "
3 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.4 | \n", "0 | \n", "0 | \n", "Durban | \n", "1 | \n", "0 | \n", "4 | \n", "4 | \n", "296 | \n", "0 | \n", "1.500000 | \n", "
4 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.5 | \n", "0 | \n", "0 | \n", "Durban | \n", "1 | \n", "0 | \n", "5 | \n", "5 | \n", "295 | \n", "0 | \n", "1.200000 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
519641 | \n", "1800 | \n", "Afghanistan | \n", "Bangladesh | \n", "49.2 | \n", "4 | \n", "7 | \n", "Abu Dhabi | \n", "241 | \n", "49 | \n", "2 | \n", "296 | \n", "4 | \n", "7 | \n", "4.885135 | \n", "
519642 | \n", "1800 | \n", "Afghanistan | \n", "Bangladesh | \n", "49.3 | \n", "4 | \n", "7 | \n", "Abu Dhabi | \n", "245 | \n", "49 | \n", "3 | \n", "297 | \n", "3 | \n", "7 | \n", "4.949495 | \n", "
519643 | \n", "1800 | \n", "Afghanistan | \n", "Bangladesh | \n", "49.4 | \n", "2 | \n", "7 | \n", "Abu Dhabi | \n", "247 | \n", "49 | \n", "4 | \n", "298 | \n", "2 | \n", "7 | \n", "4.973154 | \n", "
519644 | \n", "1800 | \n", "Afghanistan | \n", "Bangladesh | \n", "49.5 | \n", "4 | \n", "7 | \n", "Abu Dhabi | \n", "251 | \n", "49 | \n", "5 | \n", "299 | \n", "1 | \n", "7 | \n", "5.036789 | \n", "
519645 | \n", "1800 | \n", "Afghanistan | \n", "Bangladesh | \n", "49.6 | \n", "4 | \n", "7 | \n", "Abu Dhabi | \n", "255 | \n", "49 | \n", "6 | \n", "300 | \n", "0 | \n", "7 | \n", "5.100000 | \n", "
276744 rows × 14 columns
\n", "\n", " | match_id | \n", "batting_team | \n", "bowling_team | \n", "ball | \n", "runs | \n", "player_dismissed | \n", "city | \n", "current_score | \n", "over | \n", "ball_no | \n", "balls_bowled | \n", "balls_left | \n", "wickets | \n", "crr | \n", "last_five_runs | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.1 | \n", "0 | \n", "0 | \n", "Durban | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "299 | \n", "0 | \n", "0.000000 | \n", "NaN | \n", "
1 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.2 | \n", "1 | \n", "0 | \n", "Durban | \n", "1 | \n", "0 | \n", "2 | \n", "2 | \n", "298 | \n", "0 | \n", "3.000000 | \n", "NaN | \n", "
2 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.3 | \n", "0 | \n", "0 | \n", "Durban | \n", "1 | \n", "0 | \n", "3 | \n", "3 | \n", "297 | \n", "0 | \n", "2.000000 | \n", "NaN | \n", "
3 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.4 | \n", "0 | \n", "0 | \n", "Durban | \n", "1 | \n", "0 | \n", "4 | \n", "4 | \n", "296 | \n", "0 | \n", "1.500000 | \n", "NaN | \n", "
4 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.5 | \n", "0 | \n", "0 | \n", "Durban | \n", "1 | \n", "0 | \n", "5 | \n", "5 | \n", "295 | \n", "0 | \n", "1.200000 | \n", "NaN | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
595 | \n", "4 | \n", "New Zealand | \n", "England | \n", "18.4 | \n", "2 | \n", "4 | \n", "Christchurch | \n", "65 | \n", "18 | \n", "4 | \n", "112 | \n", "188 | \n", "4 | \n", "3.482143 | \n", "21.0 | \n", "
596 | \n", "4 | \n", "New Zealand | \n", "England | \n", "18.5 | \n", "1 | \n", "4 | \n", "Christchurch | \n", "66 | \n", "18 | \n", "5 | \n", "113 | \n", "187 | \n", "4 | \n", "3.504425 | \n", "21.0 | \n", "
597 | \n", "4 | \n", "New Zealand | \n", "England | \n", "18.6 | \n", "1 | \n", "4 | \n", "Christchurch | \n", "67 | \n", "18 | \n", "6 | \n", "114 | \n", "186 | \n", "4 | \n", "3.526316 | \n", "22.0 | \n", "
598 | \n", "4 | \n", "New Zealand | \n", "England | \n", "19.1 | \n", "0 | \n", "4 | \n", "Christchurch | \n", "67 | \n", "19 | \n", "1 | \n", "115 | \n", "185 | \n", "4 | \n", "3.495652 | \n", "22.0 | \n", "
599 | \n", "4 | \n", "New Zealand | \n", "England | \n", "19.2 | \n", "1 | \n", "4 | \n", "Christchurch | \n", "68 | \n", "19 | \n", "2 | \n", "116 | \n", "184 | \n", "4 | \n", "3.517241 | \n", "22.0 | \n", "
600 rows × 15 columns
\n", "\n", " | match_id | \n", "batting_team | \n", "bowling_team | \n", "ball | \n", "runs | \n", "player_dismissed | \n", "city | \n", "current_score | \n", "over | \n", "ball_no | \n", "balls_bowled | \n", "balls_left | \n", "wickets | \n", "crr | \n", "last_five_runs | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.1 | \n", "0 | \n", "0 | \n", "Durban | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "299 | \n", "0 | \n", "0.000000 | \n", "NaN | \n", "
1 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.2 | \n", "1 | \n", "0 | \n", "Durban | \n", "1 | \n", "0 | \n", "2 | \n", "2 | \n", "298 | \n", "0 | \n", "3.000000 | \n", "NaN | \n", "
2 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.3 | \n", "0 | \n", "0 | \n", "Durban | \n", "1 | \n", "0 | \n", "3 | \n", "3 | \n", "297 | \n", "0 | \n", "2.000000 | \n", "NaN | \n", "
3 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.4 | \n", "0 | \n", "0 | \n", "Durban | \n", "1 | \n", "0 | \n", "4 | \n", "4 | \n", "296 | \n", "0 | \n", "1.500000 | \n", "NaN | \n", "
4 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.5 | \n", "0 | \n", "0 | \n", "Durban | \n", "1 | \n", "0 | \n", "5 | \n", "5 | \n", "295 | \n", "0 | \n", "1.200000 | \n", "NaN | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
595 | \n", "4 | \n", "New Zealand | \n", "England | \n", "18.4 | \n", "2 | \n", "4 | \n", "Christchurch | \n", "65 | \n", "18 | \n", "4 | \n", "112 | \n", "188 | \n", "4 | \n", "3.482143 | \n", "21.0 | \n", "
596 | \n", "4 | \n", "New Zealand | \n", "England | \n", "18.5 | \n", "1 | \n", "4 | \n", "Christchurch | \n", "66 | \n", "18 | \n", "5 | \n", "113 | \n", "187 | \n", "4 | \n", "3.504425 | \n", "21.0 | \n", "
597 | \n", "4 | \n", "New Zealand | \n", "England | \n", "18.6 | \n", "1 | \n", "4 | \n", "Christchurch | \n", "67 | \n", "18 | \n", "6 | \n", "114 | \n", "186 | \n", "4 | \n", "3.526316 | \n", "22.0 | \n", "
598 | \n", "4 | \n", "New Zealand | \n", "England | \n", "19.1 | \n", "0 | \n", "4 | \n", "Christchurch | \n", "67 | \n", "19 | \n", "1 | \n", "115 | \n", "185 | \n", "4 | \n", "3.495652 | \n", "22.0 | \n", "
599 | \n", "4 | \n", "New Zealand | \n", "England | \n", "19.2 | \n", "1 | \n", "4 | \n", "Christchurch | \n", "68 | \n", "19 | \n", "2 | \n", "116 | \n", "184 | \n", "4 | \n", "3.517241 | \n", "22.0 | \n", "
600 rows × 15 columns
\n", "\n", " | match_id | \n", "batting_team | \n", "bowling_team | \n", "ball | \n", "runs | \n", "player_dismissed | \n", "city | \n", "current_score | \n", "over | \n", "ball_no | \n", "balls_bowled | \n", "balls_left | \n", "wickets | \n", "crr | \n", "last_five_runs | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.1 | \n", "0 | \n", "0 | \n", "Durban | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "299 | \n", "0 | \n", "0.000000 | \n", "NaN | \n", "
1 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.2 | \n", "1 | \n", "0 | \n", "Durban | \n", "1 | \n", "0 | \n", "2 | \n", "2 | \n", "298 | \n", "0 | \n", "3.000000 | \n", "NaN | \n", "
2 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.3 | \n", "0 | \n", "0 | \n", "Durban | \n", "1 | \n", "0 | \n", "3 | \n", "3 | \n", "297 | \n", "0 | \n", "2.000000 | \n", "NaN | \n", "
3 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.4 | \n", "0 | \n", "0 | \n", "Durban | \n", "1 | \n", "0 | \n", "4 | \n", "4 | \n", "296 | \n", "0 | \n", "1.500000 | \n", "NaN | \n", "
4 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.5 | \n", "0 | \n", "0 | \n", "Durban | \n", "1 | \n", "0 | \n", "5 | \n", "5 | \n", "295 | \n", "0 | \n", "1.200000 | \n", "NaN | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
519641 | \n", "1800 | \n", "Afghanistan | \n", "Bangladesh | \n", "49.2 | \n", "4 | \n", "7 | \n", "Abu Dhabi | \n", "241 | \n", "49 | \n", "2 | \n", "296 | \n", "4 | \n", "7 | \n", "4.885135 | \n", "NaN | \n", "
519642 | \n", "1800 | \n", "Afghanistan | \n", "Bangladesh | \n", "49.3 | \n", "4 | \n", "7 | \n", "Abu Dhabi | \n", "245 | \n", "49 | \n", "3 | \n", "297 | \n", "3 | \n", "7 | \n", "4.949495 | \n", "NaN | \n", "
519643 | \n", "1800 | \n", "Afghanistan | \n", "Bangladesh | \n", "49.4 | \n", "2 | \n", "7 | \n", "Abu Dhabi | \n", "247 | \n", "49 | \n", "4 | \n", "298 | \n", "2 | \n", "7 | \n", "4.973154 | \n", "NaN | \n", "
519644 | \n", "1800 | \n", "Afghanistan | \n", "Bangladesh | \n", "49.5 | \n", "4 | \n", "7 | \n", "Abu Dhabi | \n", "251 | \n", "49 | \n", "5 | \n", "299 | \n", "1 | \n", "7 | \n", "5.036789 | \n", "NaN | \n", "
519645 | \n", "1800 | \n", "Afghanistan | \n", "Bangladesh | \n", "49.6 | \n", "4 | \n", "7 | \n", "Abu Dhabi | \n", "255 | \n", "49 | \n", "6 | \n", "300 | \n", "0 | \n", "7 | \n", "5.100000 | \n", "NaN | \n", "
276744 rows × 15 columns
\n", "\n", " | match_id | \n", "batting_team | \n", "bowling_team | \n", "ball | \n", "runs | \n", "player_dismissed | \n", "city | \n", "current_score | \n", "over | \n", "ball_no | \n", "balls_bowled | \n", "balls_left | \n", "wickets | \n", "crr | \n", "last_five_runs | \n", "total_score | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.1 | \n", "0 | \n", "0 | \n", "Durban | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "299 | \n", "0 | \n", "0.000000 | \n", "NaN | \n", "211 | \n", "
1 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.2 | \n", "1 | \n", "0 | \n", "Durban | \n", "1 | \n", "0 | \n", "2 | \n", "2 | \n", "298 | \n", "0 | \n", "3.000000 | \n", "NaN | \n", "211 | \n", "
2 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.3 | \n", "0 | \n", "0 | \n", "Durban | \n", "1 | \n", "0 | \n", "3 | \n", "3 | \n", "297 | \n", "0 | \n", "2.000000 | \n", "NaN | \n", "211 | \n", "
3 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.4 | \n", "0 | \n", "0 | \n", "Durban | \n", "1 | \n", "0 | \n", "4 | \n", "4 | \n", "296 | \n", "0 | \n", "1.500000 | \n", "NaN | \n", "211 | \n", "
4 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.5 | \n", "0 | \n", "0 | \n", "Durban | \n", "1 | \n", "0 | \n", "5 | \n", "5 | \n", "295 | \n", "0 | \n", "1.200000 | \n", "NaN | \n", "211 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
595 | \n", "4 | \n", "New Zealand | \n", "England | \n", "18.4 | \n", "2 | \n", "4 | \n", "Christchurch | \n", "65 | \n", "18 | \n", "4 | \n", "112 | \n", "188 | \n", "4 | \n", "3.482143 | \n", "21.0 | \n", "223 | \n", "
596 | \n", "4 | \n", "New Zealand | \n", "England | \n", "18.5 | \n", "1 | \n", "4 | \n", "Christchurch | \n", "66 | \n", "18 | \n", "5 | \n", "113 | \n", "187 | \n", "4 | \n", "3.504425 | \n", "21.0 | \n", "223 | \n", "
597 | \n", "4 | \n", "New Zealand | \n", "England | \n", "18.6 | \n", "1 | \n", "4 | \n", "Christchurch | \n", "67 | \n", "18 | \n", "6 | \n", "114 | \n", "186 | \n", "4 | \n", "3.526316 | \n", "22.0 | \n", "223 | \n", "
598 | \n", "4 | \n", "New Zealand | \n", "England | \n", "19.1 | \n", "0 | \n", "4 | \n", "Christchurch | \n", "67 | \n", "19 | \n", "1 | \n", "115 | \n", "185 | \n", "4 | \n", "3.495652 | \n", "22.0 | \n", "223 | \n", "
599 | \n", "4 | \n", "New Zealand | \n", "England | \n", "19.2 | \n", "1 | \n", "4 | \n", "Christchurch | \n", "68 | \n", "19 | \n", "2 | \n", "116 | \n", "184 | \n", "4 | \n", "3.517241 | \n", "22.0 | \n", "223 | \n", "
600 rows × 16 columns
\n", "\n", " | match_id | \n", "batting_team | \n", "bowling_team | \n", "ball | \n", "runs | \n", "player_dismissed | \n", "city | \n", "current_score | \n", "over | \n", "ball_no | \n", "balls_bowled | \n", "balls_left | \n", "wickets | \n", "crr | \n", "last_five_runs | \n", "total_score | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.1 | \n", "0 | \n", "0 | \n", "Durban | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "299 | \n", "0 | \n", "0.000000 | \n", "NaN | \n", "211 | \n", "
1 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.2 | \n", "1 | \n", "0 | \n", "Durban | \n", "1 | \n", "0 | \n", "2 | \n", "2 | \n", "298 | \n", "0 | \n", "3.000000 | \n", "NaN | \n", "211 | \n", "
2 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.3 | \n", "0 | \n", "0 | \n", "Durban | \n", "1 | \n", "0 | \n", "3 | \n", "3 | \n", "297 | \n", "0 | \n", "2.000000 | \n", "NaN | \n", "211 | \n", "
3 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.4 | \n", "0 | \n", "0 | \n", "Durban | \n", "1 | \n", "0 | \n", "4 | \n", "4 | \n", "296 | \n", "0 | \n", "1.500000 | \n", "NaN | \n", "211 | \n", "
4 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.5 | \n", "0 | \n", "0 | \n", "Durban | \n", "1 | \n", "0 | \n", "5 | \n", "5 | \n", "295 | \n", "0 | \n", "1.200000 | \n", "NaN | \n", "211 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
1695 | \n", "11 | \n", "Australia | \n", "England | \n", "20.4 | \n", "1 | \n", "2 | \n", "Manchester | \n", "106 | \n", "20 | \n", "4 | \n", "124 | \n", "176 | \n", "2 | \n", "5.129032 | \n", "17.0 | \n", "315 | \n", "
1696 | \n", "11 | \n", "Australia | \n", "England | \n", "20.5 | \n", "0 | \n", "2 | \n", "Manchester | \n", "106 | \n", "20 | \n", "5 | \n", "125 | \n", "175 | \n", "2 | \n", "5.088000 | \n", "17.0 | \n", "315 | \n", "
1697 | \n", "11 | \n", "Australia | \n", "England | \n", "20.6 | \n", "0 | \n", "2 | \n", "Manchester | \n", "106 | \n", "20 | \n", "6 | \n", "126 | \n", "174 | \n", "2 | \n", "5.047619 | \n", "18.0 | \n", "315 | \n", "
1698 | \n", "11 | \n", "Australia | \n", "England | \n", "21.1 | \n", "4 | \n", "2 | \n", "Manchester | \n", "110 | \n", "21 | \n", "1 | \n", "127 | \n", "173 | \n", "2 | \n", "5.196850 | \n", "14.0 | \n", "315 | \n", "
1699 | \n", "11 | \n", "Australia | \n", "England | \n", "21.2 | \n", "1 | \n", "2 | \n", "Manchester | \n", "111 | \n", "21 | \n", "2 | \n", "128 | \n", "172 | \n", "2 | \n", "5.203125 | \n", "14.0 | \n", "315 | \n", "
1700 rows × 16 columns
\n", "\n", " | match_id | \n", "batting_team | \n", "bowling_team | \n", "ball | \n", "runs | \n", "player_dismissed | \n", "city | \n", "current_score | \n", "over | \n", "ball_no | \n", "balls_bowled | \n", "balls_left | \n", "wickets | \n", "crr | \n", "last_five_runs | \n", "total_score | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.1 | \n", "0 | \n", "0 | \n", "Durban | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "299 | \n", "0 | \n", "0.000000 | \n", "NaN | \n", "211 | \n", "
1 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.2 | \n", "1 | \n", "0 | \n", "Durban | \n", "1 | \n", "0 | \n", "2 | \n", "2 | \n", "298 | \n", "0 | \n", "3.000000 | \n", "NaN | \n", "211 | \n", "
2 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.3 | \n", "0 | \n", "0 | \n", "Durban | \n", "1 | \n", "0 | \n", "3 | \n", "3 | \n", "297 | \n", "0 | \n", "2.000000 | \n", "NaN | \n", "211 | \n", "
3 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.4 | \n", "0 | \n", "0 | \n", "Durban | \n", "1 | \n", "0 | \n", "4 | \n", "4 | \n", "296 | \n", "0 | \n", "1.500000 | \n", "NaN | \n", "211 | \n", "
4 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.5 | \n", "0 | \n", "0 | \n", "Durban | \n", "1 | \n", "0 | \n", "5 | \n", "5 | \n", "295 | \n", "0 | \n", "1.200000 | \n", "NaN | \n", "211 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
1695 | \n", "11 | \n", "Australia | \n", "England | \n", "20.4 | \n", "1 | \n", "2 | \n", "Manchester | \n", "106 | \n", "20 | \n", "4 | \n", "124 | \n", "176 | \n", "2 | \n", "5.129032 | \n", "17.0 | \n", "315 | \n", "
1696 | \n", "11 | \n", "Australia | \n", "England | \n", "20.5 | \n", "0 | \n", "2 | \n", "Manchester | \n", "106 | \n", "20 | \n", "5 | \n", "125 | \n", "175 | \n", "2 | \n", "5.088000 | \n", "17.0 | \n", "315 | \n", "
1697 | \n", "11 | \n", "Australia | \n", "England | \n", "20.6 | \n", "0 | \n", "2 | \n", "Manchester | \n", "106 | \n", "20 | \n", "6 | \n", "126 | \n", "174 | \n", "2 | \n", "5.047619 | \n", "18.0 | \n", "315 | \n", "
1698 | \n", "11 | \n", "Australia | \n", "England | \n", "21.1 | \n", "4 | \n", "2 | \n", "Manchester | \n", "110 | \n", "21 | \n", "1 | \n", "127 | \n", "173 | \n", "2 | \n", "5.196850 | \n", "14.0 | \n", "315 | \n", "
1699 | \n", "11 | \n", "Australia | \n", "England | \n", "21.2 | \n", "1 | \n", "2 | \n", "Manchester | \n", "111 | \n", "21 | \n", "2 | \n", "128 | \n", "172 | \n", "2 | \n", "5.203125 | \n", "14.0 | \n", "315 | \n", "
1700 rows × 16 columns
\n", "\n", " | match_id | \n", "batting_team | \n", "bowling_team | \n", "ball | \n", "runs | \n", "player_dismissed | \n", "city | \n", "current_score | \n", "over | \n", "ball_no | \n", "balls_bowled | \n", "balls_left | \n", "wickets | \n", "crr | \n", "last_five_runs | \n", "total_score | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.1 | \n", "0 | \n", "0 | \n", "Durban | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "299 | \n", "0 | \n", "0.000000 | \n", "0.0 | \n", "211 | \n", "
1 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.2 | \n", "1 | \n", "0 | \n", "Durban | \n", "1 | \n", "0 | \n", "2 | \n", "2 | \n", "298 | \n", "0 | \n", "3.000000 | \n", "0.0 | \n", "211 | \n", "
2 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.3 | \n", "0 | \n", "0 | \n", "Durban | \n", "1 | \n", "0 | \n", "3 | \n", "3 | \n", "297 | \n", "0 | \n", "2.000000 | \n", "0.0 | \n", "211 | \n", "
3 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.4 | \n", "0 | \n", "0 | \n", "Durban | \n", "1 | \n", "0 | \n", "4 | \n", "4 | \n", "296 | \n", "0 | \n", "1.500000 | \n", "0.0 | \n", "211 | \n", "
4 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.5 | \n", "0 | \n", "0 | \n", "Durban | \n", "1 | \n", "0 | \n", "5 | \n", "5 | \n", "295 | \n", "0 | \n", "1.200000 | \n", "0.0 | \n", "211 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
195 | \n", "2 | \n", "South Africa | \n", "England | \n", "32.2 | \n", "1 | \n", "4 | \n", "Durban | \n", "124 | \n", "32 | \n", "2 | \n", "194 | \n", "106 | \n", "4 | \n", "3.835052 | \n", "20.0 | \n", "211 | \n", "
196 | \n", "2 | \n", "South Africa | \n", "England | \n", "32.3 | \n", "1 | \n", "4 | \n", "Durban | \n", "125 | \n", "32 | \n", "3 | \n", "195 | \n", "105 | \n", "4 | \n", "3.846154 | \n", "20.0 | \n", "211 | \n", "
197 | \n", "2 | \n", "South Africa | \n", "England | \n", "32.4 | \n", "1 | \n", "4 | \n", "Durban | \n", "126 | \n", "32 | \n", "4 | \n", "196 | \n", "104 | \n", "4 | \n", "3.857143 | \n", "20.0 | \n", "211 | \n", "
198 | \n", "2 | \n", "South Africa | \n", "England | \n", "32.5 | \n", "1 | \n", "4 | \n", "Durban | \n", "127 | \n", "32 | \n", "5 | \n", "197 | \n", "103 | \n", "4 | \n", "3.868020 | \n", "20.0 | \n", "211 | \n", "
199 | \n", "2 | \n", "South Africa | \n", "England | \n", "32.6 | \n", "4 | \n", "4 | \n", "Durban | \n", "131 | \n", "32 | \n", "6 | \n", "198 | \n", "102 | \n", "4 | \n", "3.969697 | \n", "24.0 | \n", "211 | \n", "
200 rows × 16 columns
\n", "\n", " | match_id | \n", "batting_team | \n", "bowling_team | \n", "overs | \n", "current_score | \n", "balls_left | \n", "wickets | \n", "crr | \n", "last_five_runs | \n", "total_score | \n", "
---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.1 | \n", "0 | \n", "299 | \n", "0 | \n", "0.000000 | \n", "0.0 | \n", "211 | \n", "
1 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.2 | \n", "1 | \n", "298 | \n", "0 | \n", "3.000000 | \n", "0.0 | \n", "211 | \n", "
2 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.3 | \n", "1 | \n", "297 | \n", "0 | \n", "2.000000 | \n", "0.0 | \n", "211 | \n", "
3 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.4 | \n", "1 | \n", "296 | \n", "0 | \n", "1.500000 | \n", "0.0 | \n", "211 | \n", "
4 | \n", "2 | \n", "South Africa | \n", "England | \n", "0.5 | \n", "1 | \n", "295 | \n", "0 | \n", "1.200000 | \n", "0.0 | \n", "211 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
276739 | \n", "1800 | \n", "Afghanistan | \n", "Bangladesh | \n", "49.2 | \n", "241 | \n", "4 | \n", "7 | \n", "4.885135 | \n", "0.0 | \n", "255 | \n", "
276740 | \n", "1800 | \n", "Afghanistan | \n", "Bangladesh | \n", "49.3 | \n", "245 | \n", "3 | \n", "7 | \n", "4.949495 | \n", "0.0 | \n", "255 | \n", "
276741 | \n", "1800 | \n", "Afghanistan | \n", "Bangladesh | \n", "49.4 | \n", "247 | \n", "2 | \n", "7 | \n", "4.973154 | \n", "0.0 | \n", "255 | \n", "
276742 | \n", "1800 | \n", "Afghanistan | \n", "Bangladesh | \n", "49.5 | \n", "251 | \n", "1 | \n", "7 | \n", "5.036789 | \n", "0.0 | \n", "255 | \n", "
276743 | \n", "1800 | \n", "Afghanistan | \n", "Bangladesh | \n", "49.6 | \n", "255 | \n", "0 | \n", "7 | \n", "5.100000 | \n", "0.0 | \n", "255 | \n", "
276744 rows × 10 columns
\n", "\n", " | match_id | \n", "batting_team | \n", "bowling_team | \n", "overs | \n", "current_score | \n", "balls_left | \n", "wickets | \n", "crr | \n", "last_five_runs | \n", "total_score | \n", "
---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "2 | \n", "8 | \n", "3 | \n", "0.1 | \n", "0 | \n", "299 | \n", "0 | \n", "0.0 | \n", "0.0 | \n", "211 | \n", "
1 | \n", "2 | \n", "8 | \n", "3 | \n", "0.2 | \n", "1 | \n", "298 | \n", "0 | \n", "3.0 | \n", "0.0 | \n", "211 | \n", "
2 | \n", "2 | \n", "8 | \n", "3 | \n", "0.3 | \n", "1 | \n", "297 | \n", "0 | \n", "2.0 | \n", "0.0 | \n", "211 | \n", "
3 | \n", "2 | \n", "8 | \n", "3 | \n", "0.4 | \n", "1 | \n", "296 | \n", "0 | \n", "1.5 | \n", "0.0 | \n", "211 | \n", "
4 | \n", "2 | \n", "8 | \n", "3 | \n", "0.5 | \n", "1 | \n", "295 | \n", "0 | \n", "1.2 | \n", "0.0 | \n", "211 | \n", "
DecisionTreeRegressor()In a Jupyter environment, please rerun this cell to show the HTML representation or trust the notebook.
DecisionTreeRegressor()
LinearRegression()In a Jupyter environment, please rerun this cell to show the HTML representation or trust the notebook.
LinearRegression()
RandomForestRegressor()In a Jupyter environment, please rerun this cell to show the HTML representation or trust the notebook.
RandomForestRegressor()
XGBRegressor(base_score=None, booster=None, callbacks=None,\n", " colsample_bylevel=None, colsample_bynode=None,\n", " colsample_bytree=None, device=None, early_stopping_rounds=None,\n", " enable_categorical=False, eval_metric=None, feature_types=None,\n", " gamma=None, grow_policy=None, importance_type=None,\n", " interaction_constraints=None, learning_rate=None, max_bin=None,\n", " max_cat_threshold=None, max_cat_to_onehot=None,\n", " max_delta_step=None, max_depth=None, max_leaves=None,\n", " min_child_weight=None, missing=nan, monotone_constraints=None,\n", " multi_strategy=None, n_estimators=None, n_jobs=None,\n", " num_parallel_tree=None, random_state=None, ...)In a Jupyter environment, please rerun this cell to show the HTML representation or trust the notebook.
XGBRegressor(base_score=None, booster=None, callbacks=None,\n", " colsample_bylevel=None, colsample_bynode=None,\n", " colsample_bytree=None, device=None, early_stopping_rounds=None,\n", " enable_categorical=False, eval_metric=None, feature_types=None,\n", " gamma=None, grow_policy=None, importance_type=None,\n", " interaction_constraints=None, learning_rate=None, max_bin=None,\n", " max_cat_threshold=None, max_cat_to_onehot=None,\n", " max_delta_step=None, max_depth=None, max_leaves=None,\n", " min_child_weight=None, missing=nan, monotone_constraints=None,\n", " multi_strategy=None, n_estimators=None, n_jobs=None,\n", " num_parallel_tree=None, random_state=None, ...)
KNeighborsRegressor()In a Jupyter environment, please rerun this cell to show the HTML representation or trust the notebook.
KNeighborsRegressor()
\n", " | match_id | \n", "batting_team | \n", "bowling_team | \n", "overs | \n", "current_score | \n", "balls_left | \n", "wickets | \n", "crr | \n", "last_five_runs | \n", "total_score | \n", "
---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "2 | \n", "8 | \n", "3 | \n", "0.1 | \n", "0 | \n", "299 | \n", "0 | \n", "0.000000 | \n", "0.0 | \n", "211 | \n", "
1 | \n", "2 | \n", "8 | \n", "3 | \n", "0.2 | \n", "1 | \n", "298 | \n", "0 | \n", "3.000000 | \n", "0.0 | \n", "211 | \n", "
2 | \n", "2 | \n", "8 | \n", "3 | \n", "0.3 | \n", "1 | \n", "297 | \n", "0 | \n", "2.000000 | \n", "0.0 | \n", "211 | \n", "
3 | \n", "2 | \n", "8 | \n", "3 | \n", "0.4 | \n", "1 | \n", "296 | \n", "0 | \n", "1.500000 | \n", "0.0 | \n", "211 | \n", "
4 | \n", "2 | \n", "8 | \n", "3 | \n", "0.5 | \n", "1 | \n", "295 | \n", "0 | \n", "1.200000 | \n", "0.0 | \n", "211 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
276739 | \n", "1800 | \n", "0 | \n", "2 | \n", "49.2 | \n", "241 | \n", "4 | \n", "7 | \n", "4.885135 | \n", "0.0 | \n", "255 | \n", "
276740 | \n", "1800 | \n", "0 | \n", "2 | \n", "49.3 | \n", "245 | \n", "3 | \n", "7 | \n", "4.949495 | \n", "0.0 | \n", "255 | \n", "
276741 | \n", "1800 | \n", "0 | \n", "2 | \n", "49.4 | \n", "247 | \n", "2 | \n", "7 | \n", "4.973154 | \n", "0.0 | \n", "255 | \n", "
276742 | \n", "1800 | \n", "0 | \n", "2 | \n", "49.5 | \n", "251 | \n", "1 | \n", "7 | \n", "5.036789 | \n", "0.0 | \n", "255 | \n", "
276743 | \n", "1800 | \n", "0 | \n", "2 | \n", "49.6 | \n", "255 | \n", "0 | \n", "7 | \n", "5.100000 | \n", "0.0 | \n", "255 | \n", "
276744 rows × 10 columns
\n", "\n", " | match_id | \n", "batting_team | \n", "bowling_team | \n", "overs | \n", "current_score | \n", "balls_left | \n", "wickets | \n", "crr | \n", "last_five_runs | \n", "total_score | \n", "
---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "2 | \n", "8 | \n", "3 | \n", "0.1 | \n", "0 | \n", "299 | \n", "0 | \n", "0.000000 | \n", "0.0 | \n", "211 | \n", "
1 | \n", "2 | \n", "8 | \n", "3 | \n", "0.2 | \n", "1 | \n", "298 | \n", "0 | \n", "3.000000 | \n", "0.0 | \n", "211 | \n", "
2 | \n", "2 | \n", "8 | \n", "3 | \n", "0.3 | \n", "1 | \n", "297 | \n", "0 | \n", "2.000000 | \n", "0.0 | \n", "211 | \n", "
3 | \n", "2 | \n", "8 | \n", "3 | \n", "0.4 | \n", "1 | \n", "296 | \n", "0 | \n", "1.500000 | \n", "0.0 | \n", "211 | \n", "
4 | \n", "2 | \n", "8 | \n", "3 | \n", "0.5 | \n", "1 | \n", "295 | \n", "0 | \n", "1.200000 | \n", "0.0 | \n", "211 | \n", "
5 | \n", "2 | \n", "8 | \n", "3 | \n", "0.6 | \n", "1 | \n", "294 | \n", "0 | \n", "1.000000 | \n", "0.0 | \n", "211 | \n", "
6 | \n", "2 | \n", "8 | \n", "3 | \n", "1.1 | \n", "1 | \n", "293 | \n", "0 | \n", "0.857143 | \n", "0.0 | \n", "211 | \n", "
7 | \n", "2 | \n", "8 | \n", "3 | \n", "1.2 | \n", "1 | \n", "292 | \n", "0 | \n", "0.750000 | \n", "0.0 | \n", "211 | \n", "
8 | \n", "2 | \n", "8 | \n", "3 | \n", "1.3 | \n", "1 | \n", "291 | \n", "0 | \n", "0.666667 | \n", "0.0 | \n", "211 | \n", "
9 | \n", "2 | \n", "8 | \n", "3 | \n", "1.4 | \n", "1 | \n", "290 | \n", "0 | \n", "0.600000 | \n", "0.0 | \n", "211 | \n", "
10 | \n", "2 | \n", "8 | \n", "3 | \n", "1.5 | \n", "1 | \n", "289 | \n", "0 | \n", "0.545455 | \n", "0.0 | \n", "211 | \n", "
11 | \n", "2 | \n", "8 | \n", "3 | \n", "1.6 | \n", "1 | \n", "288 | \n", "0 | \n", "0.500000 | \n", "0.0 | \n", "211 | \n", "
12 | \n", "2 | \n", "8 | \n", "3 | \n", "2.1 | \n", "1 | \n", "287 | \n", "0 | \n", "0.461538 | \n", "0.0 | \n", "211 | \n", "
13 | \n", "2 | \n", "8 | \n", "3 | \n", "2.2 | \n", "1 | \n", "286 | \n", "0 | \n", "0.428571 | \n", "0.0 | \n", "211 | \n", "
14 | \n", "2 | \n", "8 | \n", "3 | \n", "2.3 | \n", "1 | \n", "285 | \n", "0 | \n", "0.400000 | \n", "0.0 | \n", "211 | \n", "
15 | \n", "2 | \n", "8 | \n", "3 | \n", "2.4 | \n", "1 | \n", "284 | \n", "0 | \n", "0.375000 | \n", "0.0 | \n", "211 | \n", "
16 | \n", "2 | \n", "8 | \n", "3 | \n", "2.5 | \n", "1 | \n", "283 | \n", "0 | \n", "0.352941 | \n", "0.0 | \n", "211 | \n", "
17 | \n", "2 | \n", "8 | \n", "3 | \n", "2.6 | \n", "1 | \n", "282 | \n", "0 | \n", "0.333333 | \n", "0.0 | \n", "211 | \n", "
18 | \n", "2 | \n", "8 | \n", "3 | \n", "3.1 | \n", "1 | \n", "281 | \n", "1 | \n", "0.315789 | \n", "0.0 | \n", "211 | \n", "
19 | \n", "2 | \n", "8 | \n", "3 | \n", "3.2 | \n", "1 | \n", "280 | \n", "2 | \n", "0.300000 | \n", "0.0 | \n", "211 | \n", "
20 | \n", "2 | \n", "8 | \n", "3 | \n", "3.3 | \n", "3 | \n", "279 | \n", "2 | \n", "0.857143 | \n", "0.0 | \n", "211 | \n", "
21 | \n", "2 | \n", "8 | \n", "3 | \n", "3.4 | \n", "3 | \n", "278 | \n", "2 | \n", "0.818182 | \n", "0.0 | \n", "211 | \n", "
22 | \n", "2 | \n", "8 | \n", "3 | \n", "3.5 | \n", "3 | \n", "277 | \n", "2 | \n", "0.782609 | \n", "0.0 | \n", "211 | \n", "
23 | \n", "2 | \n", "8 | \n", "3 | \n", "3.6 | \n", "3 | \n", "276 | \n", "2 | \n", "0.750000 | \n", "0.0 | \n", "211 | \n", "
24 | \n", "2 | \n", "8 | \n", "3 | \n", "4.1 | \n", "3 | \n", "275 | \n", "2 | \n", "0.720000 | \n", "0.0 | \n", "211 | \n", "
25 | \n", "2 | \n", "8 | \n", "3 | \n", "4.2 | \n", "3 | \n", "274 | \n", "2 | \n", "0.692308 | \n", "0.0 | \n", "211 | \n", "
26 | \n", "2 | \n", "8 | \n", "3 | \n", "4.3 | \n", "3 | \n", "273 | \n", "2 | \n", "0.666667 | \n", "0.0 | \n", "211 | \n", "
27 | \n", "2 | \n", "8 | \n", "3 | \n", "4.4 | \n", "3 | \n", "272 | \n", "2 | \n", "0.642857 | \n", "0.0 | \n", "211 | \n", "
28 | \n", "2 | \n", "8 | \n", "3 | \n", "4.5 | \n", "3 | \n", "271 | \n", "2 | \n", "0.620690 | \n", "0.0 | \n", "211 | \n", "
29 | \n", "2 | \n", "8 | \n", "3 | \n", "4.6 | \n", "3 | \n", "270 | \n", "2 | \n", "0.600000 | \n", "3.0 | \n", "211 | \n", "
30 | \n", "2 | \n", "8 | \n", "3 | \n", "5.1 | \n", "3 | \n", "269 | \n", "2 | \n", "0.580645 | \n", "3.0 | \n", "211 | \n", "
31 | \n", "2 | \n", "8 | \n", "3 | \n", "5.2 | \n", "3 | \n", "268 | \n", "2 | \n", "0.562500 | \n", "2.0 | \n", "211 | \n", "
32 | \n", "2 | \n", "8 | \n", "3 | \n", "5.3 | \n", "3 | \n", "267 | \n", "2 | \n", "0.545455 | \n", "2.0 | \n", "211 | \n", "
33 | \n", "2 | \n", "8 | \n", "3 | \n", "5.4 | \n", "4 | \n", "266 | \n", "2 | \n", "0.705882 | \n", "3.0 | \n", "211 | \n", "
34 | \n", "2 | \n", "8 | \n", "3 | \n", "5.5 | \n", "8 | \n", "265 | \n", "2 | \n", "1.371429 | \n", "7.0 | \n", "211 | \n", "
35 | \n", "2 | \n", "8 | \n", "3 | \n", "5.6 | \n", "8 | \n", "264 | \n", "2 | \n", "1.333333 | \n", "7.0 | \n", "211 | \n", "
36 | \n", "2 | \n", "8 | \n", "3 | \n", "6.1 | \n", "8 | \n", "263 | \n", "2 | \n", "1.297297 | \n", "7.0 | \n", "211 | \n", "
37 | \n", "2 | \n", "8 | \n", "3 | \n", "6.2 | \n", "8 | \n", "262 | \n", "2 | \n", "1.263158 | \n", "7.0 | \n", "211 | \n", "
38 | \n", "2 | \n", "8 | \n", "3 | \n", "6.3 | \n", "8 | \n", "261 | \n", "2 | \n", "1.230769 | \n", "7.0 | \n", "211 | \n", "
39 | \n", "2 | \n", "8 | \n", "3 | \n", "6.4 | \n", "8 | \n", "260 | \n", "2 | \n", "1.200000 | \n", "7.0 | \n", "211 | \n", "
40 | \n", "2 | \n", "8 | \n", "3 | \n", "6.5 | \n", "9 | \n", "259 | \n", "2 | \n", "1.317073 | \n", "8.0 | \n", "211 | \n", "
41 | \n", "2 | \n", "8 | \n", "3 | \n", "6.6 | \n", "9 | \n", "258 | \n", "2 | \n", "1.285714 | \n", "8.0 | \n", "211 | \n", "
42 | \n", "2 | \n", "8 | \n", "3 | \n", "7.1 | \n", "13 | \n", "257 | \n", "2 | \n", "1.813953 | \n", "12.0 | \n", "211 | \n", "
43 | \n", "2 | \n", "8 | \n", "3 | \n", "7.2 | \n", "17 | \n", "256 | \n", "2 | \n", "2.318182 | \n", "16.0 | \n", "211 | \n", "
44 | \n", "2 | \n", "8 | \n", "3 | \n", "7.3 | \n", "17 | \n", "255 | \n", "2 | \n", "2.266667 | \n", "16.0 | \n", "211 | \n", "
45 | \n", "2 | \n", "8 | \n", "3 | \n", "7.4 | \n", "17 | \n", "254 | \n", "2 | \n", "2.217391 | \n", "16.0 | \n", "211 | \n", "
46 | \n", "2 | \n", "8 | \n", "3 | \n", "7.5 | \n", "17 | \n", "253 | \n", "2 | \n", "2.170213 | \n", "16.0 | \n", "211 | \n", "
47 | \n", "2 | \n", "8 | \n", "3 | \n", "7.6 | \n", "17 | \n", "252 | \n", "2 | \n", "2.125000 | \n", "16.0 | \n", "211 | \n", "
48 | \n", "2 | \n", "8 | \n", "3 | \n", "8.1 | \n", "17 | \n", "251 | \n", "2 | \n", "2.081633 | \n", "16.0 | \n", "211 | \n", "
49 | \n", "2 | \n", "8 | \n", "3 | \n", "8.2 | \n", "18 | \n", "250 | \n", "2 | \n", "2.160000 | \n", "17.0 | \n", "211 | \n", "