changing teams.csv file

plannine · 06-07-2007, 06:39 PM

(re-wrote question......maybe someone will know)

What fields does the game require from the teams.csv file, if you wish to create a 'new' historical structure. (i.e. eliminate divisions, change expansion date & team name changes, )?

thanks

plannine · 07-05-2007, 09:12 PM

100 views, no response. Maybe the question was off.....

one more time.

What are the required fields for the game in the 'team' file when importing from a database (lahman or others). Are only the first few and a couple at the end needed (with a bunch of commas) ?

yearID Year
lgID League
teamID Team
franchID Franchise (links to TeamsFranchise table)
divID Team's division
Rank Position in final standings
G Games played
GHome Games played at home
W Wins
L Losses
DivWin Division Winner (Y or N)
WCWin Wild Card Winner (Y or N)
LgWin League Champion(Y or N)
WSWin World Series Winner (Y or N)
R Runs scored
AB At bats
H Hits by batters
2B Doubles
3B Triples
HR Homeruns by batters
BB Walks by batters
SO Strikeouts by batters
SB Stolen bases
CS Caught stealing
HBP Batters hit by pitch
SF Sacrifice flies
RA Opponents runs scored
ER Earned runs allowed
ERA Earned run average
CG Complete games
SHO Shutouts
SV Saves
IPOuts Outs Pitched (innings pitched x 3)
HA Hits allowed
HRA Homeruns allowed
BBA Walks allowed
SOA Strikeouts by pitchers
E Errors
DP Double Plays
FP Fielding percentage
name Team's full name
park Name of team's home ballpark
attendance Home attendance total
BPF Three-year park factor for batters
PPF Three-year park factor for pitchers
teamIDBR Team ID used by Baseball Reference website
teamIDlahman45 Team ID used in Lahman database version 4.5
teamIDretro Team ID used by Retrosheet

HerbD · 07-05-2007, 09:22 PM

I don't think you have to have any of the stats but they will not be imported if you don't have them. You do need these:

yearID Year
lgID League
teamID Team
franchID Franchise (links to TeamsFranchise table)
divID Team's division
team full name

If you are doing MLB history and you want to change the structure then all you need to do is change the league and divisions to where you want them to be.

I am building a DB for an online league and I have the league history importing from this file. It's also important to have the franchise file filled out.

plannine · 07-06-2007, 02:20 PM

Quote:

Originally Posted by HerbD

I don't think you have to have any of the stats but they will not be imported if you don't have them. You do need these:

yearID Year
lgID League
teamID Team
franchID Franchise (links to TeamsFranchise table)
divID Team's division
team full name

If you are doing MLB history and you want to change the structure then all you need to do is change the league and divisions to where you want them to be.

that's kind what i was hoping, but wanted to be sure before i edited 100 years of baseball history.

Quote:

It's also important to have the franchise file filled out.

is the franchise file (mentioned above) the franchise ID or another file???

thanks
p9

HerbD · 07-06-2007, 05:35 PM

yes...it is the franchise ID file...every team in the teamID file needs to be linked to a franchise in the franchiseID file or they will show up as defunct...I had this happen when I put in the wrong franchise ID in the team ID file.

plannine · 07-06-2007, 05:55 PM

thanks again.....that will save alot of frustration.

06-07-2007, 06:39 PM	#1 (permalink)
plannine Major Leagues Join Date: Mar 2003 Location: Michigan Posts: 489 Thanks: 12 Thanked 6x in 6 posts	Teams file editing (re-wrote question......maybe someone will know) What fields does the game require from the teams.csv file, if you wish to create a 'new' historical structure. (i.e. eliminate divisions, change expansion date & team name changes, )? thanks __________________ Good pitching will always stop good hitting and vice-versa - Casey Stengel Last edited by plannine; 06-08-2007 at 01:46 PM.

07-05-2007, 09:12 PM	#2 (permalink)
plannine Major Leagues Join Date: Mar 2003 Location: Michigan Posts: 489 Thanks: 12 Thanked 6x in 6 posts	100 views, no response. Maybe the question was off..... one more time. What are the required fields for the game in the 'team' file when importing from a database (lahman or others). Are only the first few and a couple at the end needed (with a bunch of commas) ? yearID Year lgID League teamID Team franchID Franchise (links to TeamsFranchise table) divID Team's division Rank Position in final standings G Games played GHome Games played at home W Wins L Losses DivWin Division Winner (Y or N) WCWin Wild Card Winner (Y or N) LgWin League Champion(Y or N) WSWin World Series Winner (Y or N) R Runs scored AB At bats H Hits by batters 2B Doubles 3B Triples HR Homeruns by batters BB Walks by batters SO Strikeouts by batters SB Stolen bases CS Caught stealing HBP Batters hit by pitch SF Sacrifice flies RA Opponents runs scored ER Earned runs allowed ERA Earned run average CG Complete games SHO Shutouts SV Saves IPOuts Outs Pitched (innings pitched x 3) HA Hits allowed HRA Homeruns allowed BBA Walks allowed SOA Strikeouts by pitchers E Errors DP Double Plays FP Fielding percentage name Team's full name park Name of team's home ballpark attendance Home attendance total BPF Three-year park factor for batters PPF Three-year park factor for pitchers teamIDBR Team ID used by Baseball Reference website teamIDlahman45 Team ID used in Lahman database version 4.5 teamIDretro Team ID used by Retrosheet __________________ Good pitching will always stop good hitting and vice-versa - Casey Stengel

07-06-2007, 05:55 PM	#6 (permalink)
plannine Major Leagues Join Date: Mar 2003 Location: Michigan Posts: 489 Thanks: 12 Thanked 6x in 6 posts	thanks again.....that will save alot of frustration. __________________ Good pitching will always stop good hitting and vice-versa - Casey Stengel

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

07-05-2007, 09:22 PM	#3 (permalink)
HerbD Major Leagues Join Date: Dec 2001 Location: Indiana Posts: 315 Thanks: 14 Thanked 19x in 15 posts	I don't think you have to have any of the stats but they will not be imported if you don't have them. You do need these: yearID Year lgID League teamID Team franchID Franchise (links to TeamsFranchise table) divID Team's division team full name If you are doing MLB history and you want to change the structure then all you need to do is change the league and divisions to where you want them to be. I am building a DB for an online league and I have the league history importing from this file. It's also important to have the franchise file filled out.

07-06-2007, 05:35 PM	#5 (permalink)
HerbD Major Leagues Join Date: Dec 2001 Location: Indiana Posts: 315 Thanks: 14 Thanked 19x in 15 posts	yes...it is the franchise ID file...every team in the teamID file needs to be linked to a franchise in the franchiseID file or they will show up as defunct...I had this happen when I put in the wrong franchise ID in the team ID file.