PRACTICAL FILE REPORT
INFORMATICS PRACTICES
NAME :-
ROLL NO. :-
N . R CONVENT SR SEC SCHOOL, NEW
DELHI
CERTIFICATE
This is to certify that Kunj Bihari Sharma of
class XII, of N.R CONVENT SR SEC SCHOOL, New Delhi
has completed this project report under the guidance of
Mr. SACHIN JAISWAL during the academic year 2023-24.
Signature of the Teacher:
Signature of Head of the School: ________________________
School Seal:
ACKNOWLEDGEMENT
I would like to express my special thanks of gratitude To my
teacher Mr Sachin Jaiswal who gave me the golden
opportunity to do this wonderful project on the topic
IPL – DATA ANALYSIS which also helped me in
doing a lot of research and I came to know about so many
new things.
Secondly I would also like to thank my parents and friends
who helped me a lot in finishing this project within the time
limit.
I am making this project not only for marks but to also
increase my knowledge.
.
Signature of the Student:
INDEX
➢ INTRODUCTION
➢ HARDWARE & SOFTWARE REQUIREMENT
➢ SOURCE CODE
➢ OUTPUT SCREEN
➢ BIBLIOGRAPHY
Hardware & Software Requirement
Hardware Requirement
PC/Laptop/MacBook with
Intel core/i3/i5/i7 or any equivalent
With at least 2 GB RAM
10 MB free space on Hard Disk
LCD/LED
Operating System & Compiler
MS Windows/Ubuntu/MacOS
Python IDLE 3.x
OR
colab.research.google.com (gmail account)
and/or
MS- EXCEL
OR
OPEN OFFICE CALC
Source
Code
import numpy as np # numerical computing
import pandas as pd # data processing, CSV file I/O (e.g. pd.read_csv)
import matplotlib.pyplot as plt #visualization
import seaborn as sns #modern visualization
plt.rcParams['figure.figsize'] = (14, 8)
sns.set_style("darkgrid")
df = pd.read_csv("E:\ipl1.csv")
print('---------------------------------------------------------------------------')
print('---------------------------------------------------------------------------')
print(df.info())
print()
print('---------------------------------------------------------------------------')
print('---------------------------------------------------------------------------')
print('Total Matches are::::',df['id'].max())
print()
print('---------------------------------------------------------------------------')
print('---------------------------------------------------------------------------')
print('How many seasons data we’ve got in the dataset?')
print(df['season'].unique())
print()
print('---------------------------------------------------------------------------')
print('---------------------------------------------------------------------------')
print('Which Team had won by maximum runs?')
print(df.iloc[df['win_by_runs'].idxmax()])
print()
print('---------------------------------------------------------------------------')
print('---------------------------------------------------------------------------')
print('Which Team had won by maximum wickets?')
print(df.iloc[df['win_by_wickets'].idxmax()]['winner'])
print()
print('---------------------------------------------------------------------------')
print('---------------------------------------------------------------------------')
print('Which Team had won by (closest margin) minimum runs?')
print(df.iloc[df[df['win_by_runs'].ge(1)].win_by_runs.idxmin()]['winner'])
print()
print('---------------------------------------------------------------------------')
print('---------------------------------------------------------------------------')
print('Which Team had won by minimum wickets?')
print(df.iloc[df[df['win_by_wickets'].ge(1)].win_by_wickets.idxmin()])
print()
print('---------------------------------------------------------------------------')
print('---------------------------------------------------------------------------')
print('Which season had most number of matches?')
sns.countplot(x='season', data=df)
plt.show()
print()
print('---------------------------------------------------------------------------')
print('---------------------------------------------------------------------------')
print('The Most Successful IPL Team is:::')
data = df.winner.value_counts()
sns.barplot(y = data.index, x = data, orient='h')
print()
print('---------------------------------------------------------------------------')
print('---------------------------------------------------------------------------')
print('The Players who got maximum times Man of the Match are:::')
top_players = df.player_of_match.value_counts()[:10]
#sns.barplot(x="day", y="total_bill", data=tips)
fig, ax = plt.subplots()
ax.set_ylim([0,20])
ax.set_ylabel("Count")
ax.set_title("Top player of the match Winners")
#top_players.plot.bar()
sns.barplot(x = top_players.index, y = top_players, orient='v'); #palette="Blues");
plt.show()
OUTPUT:
---------------------------------------------------------------------------
---------------------------------------------------------------------------
<class 'pandas.core.frame.DataFrame'>
RangeIndex: 670 entries, 0 to 669
Data columns (total 18 columns):
# Column Non-Null Count Dtype
--- ------ -------------- -----
0 id 670 non-null int64
1 season 670 non-null int64
2 city 670 non-null object
3 date 670 non-null object
4 team1 670 non-null object
5 team2 670 non-null object
6 toss_winner 670 non-null object
7 toss_decision 670 non-null object
8 result 636 non-null object
9 dl_applied 636 non-null float64
10 winner 670 non-null object
11 win_by_runs 636 non-null float64
12 win_by_wickets 636 non-null float64
13 player_of_match 633 non-null object
14 venue 636 non-null object
15 umpire1 635 non-null object
16 umpire2 635 non-null object
17 umpire3 0 non-null float64
dtypes: float64(4), int64(2), object(12)
memory usage: 62.9+ KB
None
---------------------------------------------------------------------------
---------------------------------------------------------------------------
Total Matches are:::: 670
---------------------------------------------------------------------------
---------------------------------------------------------------------------
How many seasons data we’ve got in the dataset?
[2017 2008 2009 2010 2011 2012 2013 2014 2015 2016 2018]
---------------------------------------------------------------------------
---------------------------------------------------------------------------
Which Team had won by maximum runs?
id 44
season 2017
city Delhi
date 5/6/2017
team1 Mumbai Indians
team2 Delhi Daredevils
toss_winner Delhi Daredevils
toss_decision field
result normal
dl_applied 0
winner Mumbai Indians
win_by_runs 146
win_by_wickets 0
player_of_match LMP Simmons
venue Feroz Shah Kotla
umpire1 Nitin Menon
umpire2 CK Nandan
umpire3 NaN
Name: 43, dtype: object
---------------------------------------------------------------------------
---------------------------------------------------------------------------
Which Team had won by maximum wickets?
Kolkata Knight Riders
---------------------------------------------------------------------------
---------------------------------------------------------------------------
Which Team had won by (closest margin) minimum runs?
Mumbai Indians
---------------------------------------------------------------------------
---------------------------------------------------------------------------
Which Team had won by minimum wickets?
id 560
season 2015
city Kolkata
date 5/9/2015
team1 Kings XI Punjab
team2 Kolkata Knight Riders
toss_winner Kings XI Punjab
toss_decision bat
result normal
dl_applied 0
winner Kolkata Knight Riders
win_by_runs 0
win_by_wickets 1
player_of_match AD Russell
venue Eden Gardens
umpire1 AK Chaudhary
umpire2 HDPK Dharmasena
umpire3 NaN
Name: 559, dtype: object
---------------------------------------------------------------------------
---------------------------------------------------------------------------
Which season had most number of matches?
---------------------------------------------------------------------------
---------------------------------------------------------------------------
The Most Successful IPL Team is:::
---------------------------------------------------------------------------
---------------------------------------------------------------------------
The Players who got maximum times Man of the Match are:::
BIBLIOGRAPHY
We took the information for our project report from the following
sources:
Reference books:
1. Informatics Practices by Sumita Arora.
2. Complete reference with Python
3. Data Analysis-Python
4. NCERT Text Book
