Skip to content

Instantly share code, notes, and snippets.

@ryanpitts

ryanpitts/The entire history of MLB batting via Sean Lahman's 2012 update

Created February 7, 2012 00:26
Show Gist options
  • Save ryanpitts/1756147 to your computer and use it in GitHub Desktop.
Save ryanpitts/1756147 to your computer and use it in GitHub Desktop.
Download ZIP
csvstat results for batting.csv as of 2012
Raw
The entire history of MLB batting via Sean Lahman's 2012 update
1. playerID
<type 'unicode'>
Nulls: No
Unique values: 17661
5 most frequent values:
mcguide01: 31
henderi01: 29
newsobo01: 29
kaatji01: 28
johnto01: 28
Max length: 9
2. yearID
<type 'int'>
Nulls: No
Min: 1871
Max: 2011
Sum: 186610336
Mean: 1960
Median: 1969
Unique values: 141
5 most frequent values:
2008: 1385
2007: 1385
2000: 1384
2006: 1377
2003: 1347
3. stint
<type 'int'>
Nulls: No
Values: 1, 2, 3, 4, 5
4. teamID
<type 'unicode'>
Nulls: No
Unique values: 149
5 most frequent values:
CHN: 4611
PHI: 4522
PIT: 4478
SLN: 4446
CIN: 4316
Max length: 3
5. lgID
<type 'unicode'>
Nulls: Yes
Unique values: 6
5 most frequent values:
NL: 48494
AL: 43124
AA: 1891
FL: 470
UA: 332
Max length: 4
6. G
<type 'int'>
Nulls: No
Min: 1
Max: 165
Sum: 4918590
Mean: 51
Median: 35
Unique values: 165
5 most frequent values:
1: 3476
2: 2782
3: 2502
4: 2258
5: 2018
7. G_batting
<type 'int'>
Nulls: No
Min: 0
Max: 165
Sum: 4672021
Mean: 49
Median: 32
Unique values: 166
5 most frequent values:
0: 6285
1: 4549
2: 3355
3: 2660
4: 2329
8. AB
<type 'int'>
Nulls: Yes
Min: 0
Max: 716
Sum: 13762182
Mean: 154
Median: 62
Unique values: 698
5 most frequent values:
0: 6576
1: 3486
2: 2497
3: 2198
4: 1999
9. R
<type 'int'>
Nulls: Yes
Min: 0
Max: 192
Sum: 1831115
Mean: 20
Median: 5
Unique values: 167
5 most frequent values:
0: 22084
1: 7920
2: 5036
3: 3771
4: 3135
10. H
<type 'int'>
Nulls: Yes
Min: 0
Max: 262
Sum: 3608446
Mean: 40
Median: 12
Unique values: 250
5 most frequent values:
0: 16910
1: 6366
2: 3921
3: 2980
4: 2442
11. 2B
<type 'int'>
Nulls: Yes
Min: 0
Max: 67
Sum: 605512
Mean: 6
Median: 2
Unique values: 64
5 most frequent values:
0: 33350
1: 9872
2: 5747
3: 3877
4: 2921
12. 3B
<type 'int'>
Nulls: Yes
Min: 0
Max: 36
Sum: 128607
Mean: 1
Median: 0
Unique values: 32
5 most frequent values:
0: 53560
1: 11766
2: 6458
3: 4301
4: 3082
13. HR
<type 'int'>
Nulls: Yes
Min: 0
Max: 73
Sum: 264983
Mean: 2
Median: 0
Unique values: 66
5 most frequent values:
0: 51681
1: 9394
2: 5178
3: 3543
4: 2579
14. RBI
<type 'int'>
Nulls: Yes
Min: 0
Max: 191
Sum: 1642662
Mean: 18
Median: 5
Unique values: 175
5 most frequent values:
0: 25640
1: 6831
2: 4837
3: 3497
4: 2915
15. SB
<type 'int'>
Nulls: Yes
Min: 0
Max: 138
Sum: 288468
Mean: 3
Median: 0
Unique values: 114
5 most frequent values:
0: 52027
1: 8782
2: 5013
3: 3357
4: 2480
16. CS
<type 'int'>
Nulls: Yes
Min: 0
Max: 42
Sum: 92054
Mean: 1
Median: 0.0
Unique values: 36
5 most frequent values:
0: 41520
1: 7503
2: 4422
3: 3016
4: 2143
17. BB
<type 'int'>
Nulls: Yes
Min: 0
Max: 232
Sum: 1270989
Mean: 14
Median: 4
Unique values: 154
5 most frequent values:
0: 25606
1: 8936
2: 5545
3: 3966
4: 3026
18. SO
<type 'int'>
Nulls: Yes
Min: 0
Max: 223
Sum: 1762866
Mean: 21
Median: 11
Unique values: 197
5 most frequent values:
0: 11917
1: 6219
2: 4305
3: 3337
4: 2772
19. IBB
<type 'int'>
Nulls: Yes
Min: 0
Max: 120
Sum: 68322
Mean: 1
Median: 0.0
Unique values: 45
5 most frequent values:
0: 35088
1: 5279
2: 3151
3: 2219
4: 1572
20. HBP
<type 'int'>
Nulls: Yes
Min: 0
Max: 51
Sum: 97676
Mean: 1
Median: 0
Unique values: 41
5 most frequent values:
0: 53830
1: 12492
2: 6542
3: 4145
4: 2710
21. SH
<type 'int'>
Nulls: Yes
Min: 0
Max: 67
Sum: 215425
Mean: 2
Median: 1.0
Unique values: 54
5 most frequent values:
0: 37299
1: 12374
2: 7424
3: 5476
4: 4129
22. SF
<type 'int'>
Nulls: Yes
Min: 0
Max: 19
Sum: 64230
Mean: 1
Median: 0
Unique values: 20
5 most frequent values:
0: 31848
1: 6737
2: 4249
3: 3122
4: 2354
23. GIDP
<type 'int'>
Nulls: Yes
Min: 0
Max: 36
Sum: 210267
Mean: 3
Median: 1.0
Unique values: 35
5 most frequent values:
0: 27723
1: 7705
2: 4441
3: 3247
4: 2516
24. G_old
<type 'int'>
Nulls: Yes
Min: 0
Max: 165
Sum: 4727211
Mean: 50
Median: 34
Unique values: 166
5 most frequent values:
1: 3873
2: 3253
3: 2728
4: 2399
5: 2089
Row count: 95195
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment