all match data from local competition without the final match r
Need help with this assignment?Get an original answer from a qualified tutor — from $10/page.
Get it written →all match data from local competition without the final match result. Predict the final match result using machine learning and also show some exploratory analysis of best batswomen and best bowlers,
| match_id | season | start_date | venue | innings | ball | batting_team | bowling_team | striker | non_striker | bowler | runs_off_bat | extras | wides | noballs | byes | legbyes | penalty | wicket_type | player_dismissed | other_wicket_type | other_player_dismissed |
| 1252411 | 2021 | 2021-06-26 | Trent Bridge, Nottingham | 1 | 0.1 | Lightning | South East Stars | SJ Bryce | B Harmer | A Capsey | 0 | 0 | |||||||||
| 1252411 | 2021 | 2021-06-26 | Trent Bridge, Nottingham | 1 | 0.2 | Lightning | South East Stars | SJ Bryce | B Harmer | A Capsey | 1 | 0 | |||||||||
| 1252411 | 2021 | 2021-06-26 | Trent Bridge, Nottingham | 1 | 0.3 | Lightning | South East Stars | B Harmer | SJ Bryce | A Capsey | 1 | 0 | |||||||||
| 1252411 | 2021 | 2021-06-26 | Trent Bridge, Nottingham | 1 | 0.4 | Lightning | South East Stars | SJ Bryce | B Harmer | A Capsey | 0 | 0 | |||||||||
| 1252411 | 2021 | 2021-06-26 | Trent Bridge, Nottingham | 1 | 0.5 | Lightning | South East Stars | SJ Bryce | B Harmer | A Capsey | 0 | 0 | |||||||||
| 1252411 | 2021 | 2021-06-26 | Trent Bridge, Nottingham | 1 | 0.6 | Lightning | South East Stars | SJ Bryce | B Harmer | A Capsey | 0 | 0 | |||||||||
| 1252411 | 2021 | 2021-06-26 | Trent Bridge, Nottingham | 1 | 1.1 | Lightning | South East Stars | B Harmer | SJ Bryce | A Stonehouse | 0 | 0 | |||||||||
| 1252411 | 2021 | 2021-06-26 | Trent Bridge, Nottingham | 1 | 1.2 | Lightning | South East Stars | B Harmer | SJ Bryce | A Stonehouse | 1 | 0 | |||||||||
| 1252411 | 2021 | 2021-06-26 | Trent Bridge, Nottingham | 1 | 1.3 | Lightning | South East Stars | SJ Bryce | B Harmer | A Stonehouse | 0 | 0 | caught | SJ Bryce | |||||||
| 1252411 | 2021 | 2021-06-26 | Trent Bridge, Nottingham | 1 | 1.4 | Lightning | South East Stars | SB Odedra | B Harmer | A Stonehouse | 0 | 0 | |||||||||
| 1252411 | 2021 | 2021-06-26 | Trent Bridge, Nottingham | 1 | 1.5 | Lightning | South East Stars | SB Odedra | B Harmer | A Stonehouse | 1 | 0 | |||||||||
| 1252411 | 2021 | 2021-06-26 | Trent Bridge, Nottingham | 1 | 1.6 | Lightning | South East Stars | B Harmer | SB Odedra | A Stonehouse | 1 | 0 | |||||||||
| 1252411 | 2021 | 2021-06-26 | Trent Bridge, Nottingham | 1 | 2.1 | Lightning | South East Stars | B Harmer | SB Odedra | A Capsey | 1 | 0 | |||||||||
| 1252411 | 2021 | 2021-06-26 | Trent Bridge, Nottingham | 1 | 2.2 | Lightning | South East Stars | SB Odedra | B Harmer | A Capsey | 0 | 0 | |||||||||
| 1252411 | 2021 | 2021-06-26 | Trent Bridge, Nottingham | 1 | 2.3 | Lightning | South East Stars | SB Odedra | B Harmer | A Capsey | 0 | 0 | |||||||||
| 1252411 | 2021 | 2021-06-26 | Trent Bridge, Nottingham | 1 | 2.4 | Lightning | South East Stars | SB Odedra | B Harmer | A Capsey | 0 | 0 | |||||||||
| 1252411 | 2021 | 2021-06-26 | Trent Bridge, Nottingham | 1 | 2.5 | Lightning | South East Stars | SB Odedra | B Harmer | A Capsey | 0 | 0 | |||||||||
| 1252411 | 2021 | 2021-06-26 | Trent Bridge, Nottingham | 1 | 2.6 | Lightning | South East Stars | SB Odedra | B Harmer | A Capsey | 0 | 0 | |||||||||
| 1252411 | 2021 | 2021-06-26 | Trent Bridge, Nottingham | 1 | 3.1 | Lightning | South East Stars | B Harmer | SB Odedra | A Stonehouse | 4 | 0 | |||||||||
| 1252411 | 2021 | 2021-06-26 | Trent Bridge, Nottingham | 1 | 3.2 | Lightning | South East Stars | B Harmer | SB Odedra | A Stonehouse | 4 | 0 | |||||||||
| 1252411 | 2021 | 2021-06-26 | Trent Bridge, Nottingham | 1 | 3.3 | Lightning | South East Stars | B Harmer | SB Odedra | A Stonehouse | 0 | 0 | |||||||||
| 1252411 | 2021 | 2021-06-26 | Trent Bridge, Nottingham | 1 | 3.4 | Lightning | South East Stars | B Harmer | SB Odedra | A Stonehouse | 0 | 1 | 1 | ||||||||
| 1252411 | 2021 | 2021-06-26 | Trent Bridge, Nottingham | 1 | 3.5 | Lightning | South East Stars | B Harmer | SB Odedra | A Stonehouse | 1 | 0 | |||||||||
| 1252411 | 2021 | 2021-06-26 | Trent Bridge, Nottingham | 1 | 3.6 | Lightning | South East Stars | SB Odedra | B Harmer | A Stonehouse | 0 | 0 | |||||||||
| 1252411 | 2021 | 2021-06-26 | Trent Bridge, Nottingham | 1 | 3.7 | Lightning | South East Stars | SB Odedra | B Harmer | A Stonehouse | 0 | 0 | |||||||||
| 1252411 | 2021 | 2021-06-26 | Trent Bridge, Nottingham | 1 | 4.1 | Lightning | South East Stars | B Harmer | SB Odedra | GJ Gibbs | 0 | 0 | |||||||||
| 1252411 | 2021 | 2021-06-26 | Trent Bridge, Nottingham | 1 | 4.2 | Lightning | South East Stars | B Harmer | SB Odedra | GJ Gibbs | 6 | 0 | |||||||||
| 1252411 | 2021 | 2021-06-26 | Trent Bridge, Nottingham | 1 | 4.3 | Lightning | South East Stars | B Harmer | SB Odedra | GJ Gibbs | 0 | 0 | |||||||||
| 1252411 | 2021 | 2021-06-26 | Trent Bridge, Nottingham | 1 | 4.4 | Lightning | South East Stars | B Harmer | SB Odedra | GJ Gibbs | 2 | 0 | |||||||||
| 1252411 | 2021 | 2021-06-26 | Trent Bridge, Nottingham | 1 | 4.5 | Lightning | South East Stars | B Harmer | SB Odedra | GJ Gibbs | 0 | 0 | |||||||||
| 1252411 | 2021 | 2021-06-26 | Trent Bridge, Nottingham | 1 | 4.6 | Lightning | South East Stars | B Harmer | SB Odedra | GJ Gibbs | 4 | 0 | |||||||||
| 1252411 | 2021 | 2021-06-26 | Trent Bridge, Nottingham | 1 | 5.1 | Lightning | South East Stars | SB Odedra | B Harmer | Emma Jones | 0 | 0 | |||||||||
| 1252411 | 2021 | 2021-06-26 | Trent Bridge, Nottingham | 1 | 5.2 | Lightning | South East Stars | SB Odedra | B Harmer | Emma Jones | 0 | 1 | 1 | ||||||||
| 1252411 | 2021 | 2021-06-26 | Trent Bridge, Nottingham | 1 | 5.3 | Lightning | South East Stars | SB Odedra | B Harmer | Emma Jones | 0 | 0 | bowled | SB Odedra | |||||||
| 1252411 | 2021 | 2021-06-26 | Trent Bridge, Nottingham | 1 | 5.4 | Lightning | South East Stars | KE Bryce | B Harmer | Emma Jones | 0 | 0 | |||||||||
| 1252411 | 2021 | 2021-06-26 | Trent Bridge, Nottingham | 1 | 5.5 | Lightning | South East Stars | KE Bryce | B Harmer | Emma Jones | 1 | 0 | |||||||||
| 1252411 | 2021 | 2021-06-26 | Trent Bridge, Nottingham | 1 | 5.6 | Lightning | South East Stars | B Harmer | KE Bryce | Emma Jones | 0 | 0 | |||||||||
| 1252411 | 2021 | 2021-06-26 | Trent Bridge, Nottingham | 1 | 5.7 | Lightning | South East Stars | B Harmer | KE Bryce | Emma Jones | 4 | 0 | |||||||||
| 1252411 | 2021 | 2021-06-26 | Trent Bridge, Nottingham | 1 | 6.1 | Lightning | South East Stars | KE Bryce | B Harmer | D Gregory | 1 | 0 | |||||||||
| 1252411 | 2021 | 2021-06-26 | Trent Bridge, Nottingham | 1 | 6.2 | Lightning | South East Stars | B Harmer | KE Bryce | D Gregory | 0 | 0 | |||||||||
| 1252411 | 2021 | 2021-06-26 | Trent Bridge, Nottingham | 1 | 6.3 | Lightning | South East Stars | B Harmer | KE Bryce | D Gregory | 0 | 1 | 1 | ||||||||
| 1252411 | 2021 | 2021-06-26 | Trent Bridge, Nottingham | 1 | 6.4 | Lightning | South East Stars | B Harmer | KE Bryce | D Gregory | 1 | 0 | |||||||||
| 1252411 | 2021 | 2021-06-26 | Trent Bridge, Nottingham | 1 | 6.5 | Lightning | South East Stars | KE Bryce | B Harmer | D Gregory | 1 | 0 | |||||||||
| 1252411 | 2021 | 2021-06-26 | Trent Bridge, Nottingham | 1 | 6.6 | Lightning | South East Stars | B Harmer | KE Bryce |