-
Notifications
You must be signed in to change notification settings - Fork 0
/
meta_data.txt
78 lines (49 loc) · 2.66 KB
/
meta_data.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
This document contains all the meta information regarding the columns described in the CSV files for a comprehensive analysis of IPL matches over the past three years (2021, 2022, 2023). We have provided 4 CSV files:
1. dim_match_summary
2. fact_batting_summary
3. fact_bowling_summary
4. dim_players
Column Description for dim_match_summary:
- team1: Name of the team batting first.
- team2: Name of the team batting second.
- winner: The team that won the match.
- margin: The margin by which the winning team won (runs or wickets).
- matchDate: The date on which the match was played, formatted as MMM DD, YYYY.
- match_id: Unique identifier for each match, prefixed with 'T'.
*******************************************
Column Description for dim_players:
- name: The full name of the player.
- team: The IPL team the player is associated with.
- battingStyle: The batting style of the player (e.g., Right hand Bat, Left hand Bat).
- bowlingStyle: The bowling style of the player (e.g., Right arm Offbreak, Legbreak).
- playingRole: The primary role of the player in the team (e.g., Batter, Bowler, Allrounder).
*******************************************
Column Description for fact_batting_summary:
match_id: Links to the dim_match_summary for match details, prefixed with 'T'.
match: Description of the match in "Team1 Vs Team2" format.
teamInnings: The team that is batting in the specified innings.
battingPos: The batting order position of the player.
batsmanName: The name of the batsman.
out/not_out: Indicates whether the batsman was out or not out.
runs: The number of runs scored by the batsman.
balls: The number of balls faced by the batsman.
4s: The number of boundaries (4 runs) hit by the batsman.
6s: The number of sixes hit by the batsman.
SR (Strike Rate): The strike rate of the batsman during the innings.
*******************************************
Column Description for fact_bowling_summary:
match_id: Links to the dim_match_summary for match details, prefixed with 'T'.
match: Description of the match in "Team1 Vs Team2" format.
bowlingTeam: The team that is bowling in the specified innings.
bowlerName: The name of the bowler.
overs: The number of overs bowled by the player.
maiden: The number of maiden overs bowled.
runs: The number of runs conceded by the bowler.
wickets: The number of wickets taken by the bowler.
economy: The bowler's economy rate.
0s: The number of dot balls bowled.
4s: The number of boundaries conceded.
6s: The number of sixes conceded.
wides: The number of wide balls bowled.
noBalls: The number of no balls bowled.
*******************************************