2023 NPB Active Players

Career statistics of active NPB players

@kaggle.egerber1_2022_npb_active_players

Table List

4 tables(496.45 KB)

Npb Batting

@kaggle.egerber1_2022_npb_active_players.npb_batting

157.46 KB
4239 rows
33 columns

unnamed_0 Unnamed: 0	player_id Player ID	last_name Last Name	first_name First Name	position Position	bats Bats	throws Throws	height Height	weight Weight	born Born	year Year	team Team	g G	pa PA	ab AB	r R	h H	n_2b 2B	n_3b 3B	hr HR	tb TB	rbi RBI	sb SB	cs CS	sh SH	sf SF	bb BB	hp HP	so SO	gdp GDP	avg AVG	slg SLG	obp OBP
	1105153	Abe	Shota	Pitcher	Left	Right	178	80	November 3, 1992	2021	ORIX	4
1	1105153	Abe	Shota	Pitcher	Left	Right	178	80	November 3, 1992	2022	ORIX	44
2	91195116	Abe	Tomohiro	Infielder	Left	Right	181	88	June 24, 1989	2011	Hiroshima	8	20	20	3	3				3								6		0.15	0.15	0.15
3	91195116	Abe	Tomohiro	Infielder	Left	Right	181	88	June 24, 1989	2012	Hiroshima	53	135	119	15	30	3		1	36	2	5	2	9		7		21	1	0.252	0.303	0.294
4	91195116	Abe	Tomohiro	Infielder	Left	Right	181	88	June 24, 1989	2013	Hiroshima	75	142	123	13	27	4		1	34	8	5	2	6	1	12		31	1	0.22	0.276	0.287
5	91195116	Abe	Tomohiro	Infielder	Left	Right	181	88	June 24, 1989	2014	Hiroshima	3	3	3		1				1										0.333	0.333	0.333
6	91195116	Abe	Tomohiro	Infielder	Left	Right	181	88	June 24, 1989	2015	Hiroshima	26	74	70	6	17				17	2	1	2	3		1		6	1	0.243	0.243	0.254
7	91195116	Abe	Tomohiro	Infielder	Left	Right	181	88	June 24, 1989	2016	Hiroshima	115	292	259	23	73	12	4	6	111	33	7		7	5	19	1	64	3	0.282	0.429	0.327
8	91195116	Abe	Tomohiro	Infielder	Left	Right	181	88	June 24, 1989	2017	Hiroshima	123	455	413	63	128	17	4	4	165	49	17	5	12	1	27	2	94	3	0.31	0.4	0.354
9	91195116	Abe	Tomohiro	Infielder	Left	Right	181	88	June 24, 1989	2018	Hiroshima	72	252	220	32	52	11	4	4	83	24	7	1	7	2	21	2	60	1	0.236	0.377	0.306


CREATE TABLE npb_batting (
  "unnamed_0" BIGINT,
  "player_id" BIGINT,
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "position" VARCHAR,
  "bats" VARCHAR,
  "throws" VARCHAR,
  "height" DOUBLE,
  "weight" DOUBLE,
  "born" VARCHAR,
  "year" BIGINT,
  "team" VARCHAR,
  "g" BIGINT,
  "pa" BIGINT,
  "ab" BIGINT,
  "r" BIGINT,
  "h" BIGINT,
  "n_2b" BIGINT,
  "n_3b" BIGINT,
  "hr" BIGINT,
  "tb" BIGINT,
  "rbi" BIGINT,
  "sb" BIGINT,
  "cs" BIGINT,
  "sh" BIGINT,
  "sf" BIGINT,
  "bb" BIGINT,
  "hp" BIGINT,
  "so" BIGINT,
  "gdp" BIGINT,
  "avg" DOUBLE,
  "slg" DOUBLE,
  "obp" DOUBLE
);