all match data from local competition without the final match r
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 |
