End to End Projects
  • About
import pandas as pd
df =  pd.read_excel('IPL_2023 _Points_Table.xlsx')
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
xls = pd.ExcelFile('IPL_2023 _Points_Table.xlsx')
IPL_2023_Points_Table = pd.read_excel(xls, 'IPL_2023_Points_Table')
Gujarat_Titans = pd.read_excel(xls, 'Gujarat_Titans')
Rajasthan_Royals = pd.read_excel(xls, 'Rajasthan_Royals')
Lucknow_Super_Giants = pd.read_excel(xls, 'Lucknow_Super_Giants')
Chennai_Super_Kings = pd.read_excel(xls, 'Chennai_Super_Kings')
Royal_Challengers_Bangalore = pd.read_excel(xls, 'Royal_Challengers_Bangalore')
Punjab_Kings = pd.read_excel(xls, 'Punjab_Kings')
Mumbai_Indians = pd.read_excel(xls, 'Mumbai_Indians')    
Kolkata_Knight_Riders = pd.read_excel(xls, 'Kolkata_Knight_Riders')
Sunrisers_Hyderabad = pd.read_excel(xls, 'Sunrisers_Hyderabad')
Delhi_Capitals = pd.read_excel(xls, '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