csvstat results for pitching.csv as of 2012

The entire history of MLB pitching via Sean Lahman's 2012 update

  1. playerID
	<type 'unicode'>
	Nulls: No
	Unique values: 8551
	5 most frequent values:
		newsobo01:	29
		kaatji01:	28
		johnto01:	28
		carltst01:	27
		ryanno01:	27
	Max length: 9
  2. yearID
	<type 'int'>
	Nulls: No
	Min: 1871
	Max: 2011
	Sum: 80815230
	Mean: 1964
	Median: 1973
	Unique values: 141
	5 most frequent values:
		2009:	729
		2007:	718
		2011:	707
		2008:	700
		2006:	700
  3. stint
	<type 'int'>
	Nulls: No
	Values: 1, 2, 3, 4
  4. teamID
	<type 'unicode'>
	Nulls: No
	Unique values: 149
	5 most frequent values:
		PHI:	1983
		SLN:	1934
		CHN:	1919
		PIT:	1914
		CIN:	1850
	Max length: 3
  5. lgID
	<type 'unicode'>
	Nulls: Yes
	Unique values: 6
	5 most frequent values:
		NL:	20892
		AL:	19132
		AA:	658
		FL:	173
		UA:	96
	Max length: 4
  6. W
	<type 'int'>
	Nulls: No
	Min: 0
	Max: 59
	Sum: 199888
	Mean: 4
	Median: 3
	Unique values: 54
	5 most frequent values:
		0:	11343
		1:	5494
		2:	3686
		3:	2825
		4:	2416
  7. L
	<type 'int'>
	Nulls: No
	Min: 0
	Max: 48
	Sum: 199887
	Mean: 4
	Median: 3
	Unique values: 43
	5 most frequent values:
		0:	8494
		1:	5903
		2:	4065
		3:	3194
		4:	2654
  8. G
	<type 'int'>
	Nulls: No
	Min: 1
	Max: 106
	Sum: 966789
	Mean: 23
	Median: 22
	Unique values: 94
	5 most frequent values:
		1:	2490
		2:	1863
		3:	1663
		4:	1444
		5:	1283
  9. GS
	<type 'int'>
	Nulls: No
	Min: 0
	Max: 75
	Sum: 402205
	Mean: 9
	Median: 3
	Unique values: 75
	5 most frequent values:
		0:	14587
		1:	3268
		2:	1997
		3:	1455
		4:	1154
 10. CG
	<type 'int'>
	Nulls: No
	Min: 0
	Max: 75
	Sum: 141123
	Mean: 3
	Median: 0
	Unique values: 74
	5 most frequent values:
		0:	24007
		1:	3825
		2:	2108
		3:	1383
		4:	1114
 11. SHO
	<type 'int'>
	Nulls: No
	Min: 0
	Max: 16
	Sum: 19892
	Mean: 0
	Median: 0
	Unique values: 15
	5 most frequent values:
		0:	31689
		1:	4576
		2:	2232
		3:	1205
		4:	724
 12. SV
	<type 'int'>
	Nulls: No
	Min: 0
	Max: 62
	Sum: 61301
	Mean: 1
	Median: 0
	Unique values: 57
	5 most frequent values:
		0:	28556
		1:	5312
		2:	2256
		3:	1207
		4:	713
 13. IPouts
	<type 'int'>
	Nulls: No
	Min: 0
	Max: 2040
	Sum: 10762918
	Mean: 261
	Median: 174
	Unique values: 1313
	5 most frequent values:
		6:	604
		3:	601
		12:	452
		9:	413
		27:	388
 14. H
	<type 'int'>
	Nulls: No
	Min: 0
	Max: 772
	Sum: 3607816
	Mean: 87
	Median: 58
	Unique values: 533
	5 most frequent values:
		5:	659
		6:	652
		4:	644
		7:	632
		3:	631
 15. ER
	<type 'int'>
	Nulls: No
	Min: 0
	Max: 291
	Sum: 1527867
	Mean: 37
	Median: 26
	Unique values: 216
	5 most frequent values:
		4:	1212
		3:	1107
		0:	1084
		2:	1079
		5:	1076
 16. HR
	<type 'int'>
	Nulls: No
	Min: 0
	Max: 50
	Sum: 265003
	Mean: 6
	Median: 4
	Unique values: 48
	5 most frequent values:
		0:	6908
		1:	4947
		2:	3903
		3:	3294
		4:	2682
 17. BB
	<type 'int'>
	Nulls: No
	Min: 0
	Max: 289
	Sum: 1272113
	Mean: 30
	Median: 23
	Unique values: 210
	5 most frequent values:
		2:	1509
		3:	1458
		1:	1394
		4:	1311
		5:	1214
 18. SO
	<type 'int'>
	Nulls: No
	Min: 0
	Max: 513
	Sum: 1903822
	Mean: 46
	Median: 31
	Unique values: 338
	5 most frequent values:
		0:	1726
		1:	1582
		2:	1409
		3:	1203
		4:	1086
 19. BAOpp
	<type 'float'>
	Nulls: Yes
	Min: 0.0
	Max: 9.99
	Sum: 10987.16
	Mean: 0.328779699563
	Median: 0.26
	Unique values: 79
	5 most frequent values:
		0.25:	3406
		0.26:	3208
		0.27:	2881
		0.24:	2696
		0.28:	2521
 20. ERA
	<type 'float'>
	Nulls: Yes
	Min: 0.0
	Max: 189.0
	Sum: 208250.32
	Mean: 5.07234801247
	Median: 4.14
	Unique values: 1147
	5 most frequent values:
		0.0:	1031
		4.5:	569
		9.0:	569
		3.0:	368
		5.4:	360
 21. IBB
	<type 'int'>
	Nulls: Yes
	Min: 0
	Max: 23
	Sum: 68334
	Mean: 2
	Median: 2.0
	Unique values: 22
	5 most frequent values:
		0:	7569
		1:	4971
		2:	3685
		3:	2785
		4:	2150
 22. WP
	<type 'int'>
	Nulls: Yes
	Min: 0
	Max: 63
	Sum: 104815
	Mean: 2
	Median: 1.0
	Unique values: 52
	5 most frequent values:
		0:	12457
		1:	8078
		2:	5779
		3:	4102
		4:	2988
 23. HBP
	<type 'int'>
	Nulls: Yes
	Min: 0
	Max: 41
	Sum: 92691
	Mean: 2
	Median: 1
	Unique values: 34
	5 most frequent values:
		0:	13872
		1:	8130
		2:	5476
		3:	3782
		4:	2655
 24. BK
	<type 'int'>
	Nulls: Yes
	Min: 0
	Max: 16
	Sum: 12851
	Mean: 0
	Median: 0
	Unique values: 16
	5 most frequent values:
		0:	32518
		1:	6132
		2:	1570
		3:	530
		4:	190
 25. BFP
	<type 'int'>
	Nulls: Yes
	Min: 0
	Max: 2906
	Sum: 14433224
	Mean: 352
	Median: 235.0
	Unique values: 1636
	5 most frequent values:
		0:	1675
		7:	190
		12:	190
		4:	188
		9:	182
 26. GF
	<type 'int'>
	Nulls: Yes
	Min: 0
	Max: 84
	Sum: 260715
	Mean: 6
	Median: 3.0
	Unique values: 78
	5 most frequent values:
		0:	10305
		1:	5974
		2:	3925
		3:	2836
		4:	2347
 27. R
	<type 'int'>
	Nulls: No
	Min: 0
	Max: 519
	Sum: 1830981
	Mean: 44
	Median: 30
	Unique values: 345
	5 most frequent values:
		4:	1052
		5:	1004
		3:	967
		2:	945
		6:	936
 28. SH
	Empty column
 29. SF
	Empty column
 30. GIDP
	Empty column

Row count: 41139