import pandas as pd
= pd.read_excel('IPL_2023 _Points_Table.xlsx') df
df.head()
Teams | Matches Played | Won Matches | Lost Matches | Tied Matches | No Results Match | Points | Net Run Rate | |
---|---|---|---|---|---|---|---|---|
0 | Gujarat Titans | 8 | 6 | 2 | 0 | 0 | 12 | 0.638 |
1 | Rajasthan Royals | 9 | 5 | 4 | 0 | 0 | 10 | 0.800 |
2 | Lucknow Super Giants | 9 | 5 | 4 | 0 | 0 | 10 | 0.639 |
3 | Chennai Super Kings | 9 | 5 | 4 | 0 | 0 | 10 | 0.329 |
4 | Royal Challengers Bangalore | 9 | 5 | 4 | 0 | 0 | 10 | -0.030 |
= pd.ExcelFile('IPL_2023 _Points_Table.xlsx')
xls = pd.read_excel(xls, 'IPL_2023_Points_Table')
IPL_2023_Points_Table = pd.read_excel(xls, 'Gujarat_Titans')
Gujarat_Titans = pd.read_excel(xls, 'Rajasthan_Royals')
Rajasthan_Royals = pd.read_excel(xls, 'Lucknow_Super_Giants')
Lucknow_Super_Giants = pd.read_excel(xls, 'Chennai_Super_Kings')
Chennai_Super_Kings = pd.read_excel(xls, 'Royal_Challengers_Bangalore')
Royal_Challengers_Bangalore = pd.read_excel(xls, 'Punjab_Kings')
Punjab_Kings = pd.read_excel(xls, 'Mumbai_Indians')
Mumbai_Indians = pd.read_excel(xls, 'Kolkata_Knight_Riders')
Kolkata_Knight_Riders = pd.read_excel(xls, 'Sunrisers_Hyderabad')
Sunrisers_Hyderabad = pd.read_excel(xls, 'Delhi_Capitals') Delhi_Capitals
print(IPL_2023_Points_Table.head())
print(Gujarat_Titans.head())
print(Rajasthan_Royals.head())
print(Lucknow_Super_Giants.head())
print(Chennai_Super_Kings.head())
print(Royal_Challengers_Bangalore.head())
print(Punjab_Kings.head())
print(Mumbai_Indians.head())
print(Kolkata_Knight_Riders.head())
print(Sunrisers_Hyderabad.head())
print(Delhi_Capitals.head())
Teams Matches Played Won Matches Lost Matches \
0 Gujarat Titans 8 6 2
1 Rajasthan Royals 9 5 4
2 Lucknow Super Giants 9 5 4
3 Chennai Super Kings 9 5 4
4 Royal Challengers Bangalore 9 5 4
Tied Matches No Results Match Points Net Run Rate
0 0 0 12 0.638
1 0 0 10 0.800
2 0 0 10 0.639
3 0 0 10 0.329
4 0 0 10 -0.030
Teams Opponent Description Date \
0 Gujarat Titans Chennai Super Kings 1st Match 2023-03-31
1 Gujarat Titans Delhi Capitals 7th Match 2023-04-04
2 Gujarat Titans Kolkata Knight Riders 13th Match 2023-04-09
3 Gujarat Titans Punjab Kings 18th Match 2023-04-13
4 Gujarat Titans Rajasthan Royals 23rd Match 2023-04-16
Result
0 Won by 5 wkts
1 Won by 6 wkts
2 Loss by 3 wkts
3 Won by 6 wkts
4 Loss by 3 wkts
Teams Opponent Description Date \
0 Rajasthan Royals Sunrisers Hyderabad 4th Match 2023-04-02
1 Rajasthan Royals Punjab Kings 8th Match 2023-04-05
2 Rajasthan Royals Delhi Capitals 11th Match 2023-04-08
3 Rajasthan Royals Chennai Super Kings 17th Match 2023-04-12
4 Rajasthan Royals Gujarat Titans 23rd Match 2023-04-16
Result
0 Won by 72 runs
1 Loss by 5 runs
2 Won by 57 runs
3 Won by 3 runs
4 Won by 3 wkts
Teams Opponent Description Date \
0 Lucknow Super Giants Delhi Capitals 3rd Match 2023-04-01
1 Lucknow Super Giants Chennai Super Kings 6th Match 2023-04-03
2 Lucknow Super Giants Sunrisers Hyderabad 10th Match 2023-04-07
3 Lucknow Super Giants Royal Challengers Bangalore 15th Match 2023-04-10
4 Lucknow Super Giants Punjab Kings 21st Match 2023-04-15
Result
0 Won by 50 runs
1 Loss by 12 runs
2 Won by 5 wkts
3 Won by 1 wkt
4 Loss by 2 wkts
Teams Opponent Description Date \
0 Chennai Super Kings Gujarat Titans 1st Match 2023-03-31
1 Chennai Super Kings Lucknow Super Giants 6th Match 2023-04-03
2 Chennai Super Kings Mumbai Indians 12th Match 2023-04-08
3 Chennai Super Kings Rajasthan Royals 17th Match 2023-04-12
4 Chennai Super Kings Royal Challengers Bangalore 24th Match 2023-04-17
Result
0 Loss by 5 wkts
1 Won by 12 runs
2 Won by 7 wkts
3 Loss by 3 runs
4 Won by 8 runs
Teams Opponent Description Date \
0 Royal Challengers Bangalore Mumbai Indians 5th Match 2023-04-02
1 Royal Challengers Bangalore Kolkata Knight Riders 9th Match 2023-04-06
2 Royal Challengers Bangalore Lucknow Super Giants 15th Match 2023-04-10
3 Royal Challengers Bangalore Delhi Capitals 20th Match 2023-04-15
4 Royal Challengers Bangalore Chennai Super Kings 24th Match 2023-04-17
Result
0 Won by 8 wkts
1 Loss by 81 runs
2 Loss by 1 wkt
3 Won by 23 runs
4 Loss by 8 runs
Teams Opponent Description Date \
0 Punjab Kings Kolkata Knight Riders 2nd Match 2023-04-01
1 Punjab Kings Rajasthan Royals 8th Match 2023-04-05
2 Punjab Kings Sunrisers Hyderabad 14th Match 2023-04-09
3 Punjab Kings Gujarat Titans 18th Match 2023-04-13
4 Punjab Kings Lucknow Super Giants 21st Match 2023-04-15
Result
0 Won by 7 runs (DLS method)
1 Won by 5 runs
2 Loss by 8 wkts
3 Loss by 6 wkts
4 Won by 2 wkts
Teams Opponent Description Date \
0 Mumbai Indians Royal Challengers Bangalore 5th Match 2023-04-02
1 Mumbai Indians Chennai Super Kings 12th Match 2023-04-08
2 Mumbai Indians Delhi Capitals 16th Match 2023-04-11
3 Mumbai Indians Kolkata Knight Riders 22nd Match 2023-04-16
4 Mumbai Indians Sunrisers Hyderabad 25th Match 2023-04-18
Result
0 Loss by 8 wkts
1 Loss by 7 wkts
2 Won by 6 wkts
3 Won by 5 wkts
4 Won by 14 runs
Teams Opponent Description Date \
0 Kolkata Knight Riders Punjab Kings 2nd Match 2023-04-01
1 Kolkata Knight Riders Royal Challengers Bangalore 9th Match 2023-04-06
2 Kolkata Knight Riders Gujarat Titans 13th Match 2023-04-09
3 Kolkata Knight Riders Sunrisers Hyderabad 19th Match 2023-04-14
4 Kolkata Knight Riders Mumbai Indians 22nd Match 2023-04-16
Result
0 Loss by 7 runs (DLS method)
1 Won by 81 runs
2 Won by 3 wkts
3 Loss by 23 runs
4 Loss by 5 wkts
Teams Opponent Description Date \
0 Sunrisers Hyderabad Rajasthan Royals 4th Match 2023-04-02
1 Sunrisers Hyderabad Lucknow Super Giants 10th Match 2023-04-07
2 Sunrisers Hyderabad Punjab Kings 14th Match 2023-04-09
3 Sunrisers Hyderabad Kolkata Knight Riders 19th Match 2023-04-14
4 Sunrisers Hyderabad Mumbai Indians 25th Match 2023-04-18
Result
0 Loss by 72 runs
1 Loss by 5 wkts
2 Won by 8 wkts
3 Won by 23 runs
4 Loss by 14 runs
Teams Opponent Description Date \
0 Delhi Capitals Lucknow Super Giants 3rd Match 2023-04-01
1 Delhi Capitals Gujarat Titans 7th Match 2023-04-04
2 Delhi Capitals Rajasthan Royals 11th Match 2023-04-08
3 Delhi Capitals Mumbai Indians 16th Match 2023-04-11
4 Delhi Capitals Royal Challengers Bangalore 20th Match 2023-04-15
Result
0 Loss by 50 runs
1 Loss by 6 wkts
2 Loss by 57 runs
3 Loss by 6 wkts
4 Loss by 23 runs