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.

Scruff · 06-25-2013, 05:06 PM

If I edit the teams.csv and teamsfranchise.csv to start with a 6-team league in 1871, then expand to 8 in 1879 and two 8 team leagues in 1882, will auto-expansion add a new league?

Also, will I have the option to add in real life transactions once 1901 rolls around? Or do I have to start in 1901 for that?

Thanks for any help.

Scruff · 06-25-2013, 05:07 PM

Also, will auto-expansion contract 4 teams and combine back to one league in 1892 and contract 4 teams again in 1900 before adding a new league and expanding in 1901; assuming I edit the teams and teamfranchises files appropriately?

06-07-2007, 06:39 PM	#1
plannine All Star Reserve Join Date: Mar 2003 Location: Michigan Posts: 571	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
plannine All Star Reserve Join Date: Mar 2003 Location: Michigan Posts: 571	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-05-2007, 09:22 PM	#3
HerbD All Star Reserve Join Date: Dec 2001 Location: Indiana Posts: 965	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
HerbD All Star Reserve Join Date: Dec 2001 Location: Indiana Posts: 965	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
plannine All Star Reserve Join Date: Mar 2003 Location: Michigan Posts: 571	thanks again.....that will save alot of frustration. __________________ Good pitching will always stop good hitting and vice-versa - Casey Stengel

06-25-2013, 05:06 PM	#7
Scruff Minors (Triple A) Join Date: Sep 2005 Posts: 243	If I edit the teams.csv and teamsfranchise.csv to start with a 6-team league in 1871, then expand to 8 in 1879 and two 8 team leagues in 1882, will auto-expansion add a new league? Also, will I have the option to add in real life transactions once 1901 rolls around? Or do I have to start in 1901 for that? Thanks for any help.

06-25-2013, 05:07 PM	#8
Scruff Minors (Triple A) Join Date: Sep 2005 Posts: 243	Also, will auto-expansion contract 4 teams and combine back to one league in 1892 and contract 4 teams again in 1900 before adding a new league and expanding in 1901; assuming I edit the teams and teamfranchises files appropriately?