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: 375	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 __________________ "Baseball gives every American boy a chance to excel, not just to be as good as someone else but to be better than someone else. This is the nature of man and the name of the game. Ted Williams (1918-2002) 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: 375	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 __________________ "Baseball gives every American boy a chance to excel, not just to be as good as someone else but to be better than someone else. This is the nature of man and the name of the game. Ted Williams (1918-2002)

07-05-2007, 09:22 PM	#3 (permalink)
HerbD Minors (Triple A) Join Date: Dec 2001 Location: Indiana Posts: 216	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 Minors (Triple A) Join Date: Dec 2001 Location: Indiana Posts: 216	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. __________________

07-06-2007, 05:55 PM	#6 (permalink)
plannine Major Leagues Join Date: Mar 2003 Location: Michigan Posts: 375	thanks again.....that will save alot of frustration. __________________ "Baseball gives every American boy a chance to excel, not just to be as good as someone else but to be better than someone else. This is the nature of man and the name of the game. Ted Williams (1918-2002)

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