Help with editing LahmanDB

andymac · 04-05-2005, 03:03 AM

I am trying to create a 2005 roster set by adding 2005 entries into the LahmanDB, but using projected statistics. I was able to do this easily for the pitchers by just adding the entries into the CSV file. However, the batting file is giving me problems because it is already too large to open in Excel and I do not own Access. So, basically, I am asking if there is another way to open/edit the CSV file that I am not aware of. Any help/suggestions on how to approach this would be greatly appreciated.

BravesSince66 · 04-05-2005, 12:37 PM

You can edit it in notepad or any other text base editor. Not as user friendly, of course, but it will work as long as you are careful.

seth70liz76 · 04-05-2005, 12:54 PM

Notepad is what I'm using, but like BravesSince66 says, you have to be careful, since you won't find your errors until you run the DB.

andymac · 04-05-2005, 03:02 PM

OK, what I will probably do is create the entries in a seperate excel file and then copy + paste everything over to notepad once I am done. That should minimize most error risk, I would think. Thanks guys!

Kemp · 04-05-2005, 08:04 PM

I believe the DB is sorted by year (ascending). In the past, I've opened the file in notepad, deleted a lot of the "top" rows, saved it, and then opened it in Excel.

andymac · 04-05-2005, 08:55 PM

Quote:

Originally Posted by Kemp

I believe the DB is sorted by year (ascending). In the past, I've opened the file in notepad, deleted a lot of the "top" rows, saved it, and then opened it in Excel.

Nope, the file I have is sorted by the lahmanID. It would be nice if it was the way you mentioned.

Kemp · 04-06-2005, 07:52 AM

Quote:

Originally Posted by andymac

Nope, the file I have is sorted by the lahmanID. It would be nice if it was the way you mentioned.

Ahhh, sorry. I believe previous versions WERE sorted by year because I know I've done that (deleted rows) in the past.

Maybe it was Ankit's or another custom DB. I don't remember now.

andymac · 04-06-2005, 08:41 AM

Quote:

Originally Posted by Kemp

Ahhh, sorry. I believe previous versions WERE sorted by year because I know I've done that (deleted rows) in the past.

Maybe it was Ankit's or another custom DB. I don't remember now.

Yea, I'm pretty sure at least one of the edited databases are like that.

ctorg · 04-06-2005, 09:49 AM

What I do when I work on Lahman is divide it up into two or three files in notepad, then sort each file how I want in Excel. I then use Excel to recombine the files in the way I want, still divided up, and save as separate files again.

For instance, let's say the batting stats are sorted by year, and you want them sorted by name. In notepad, divide the batting file into three separate files by cutting in pasting. Then open each one in Excel and sort it by name. Then copy, say, A thru J from each into a new Excel spreadsheet, then K thru P, then Q thru Z (just randomly picking letters here). Then sort each of those new spreadsheets by name and close them. Then, if that's all you wanted to do, open them in Notepad and recombine them.

Hopefully that makes some sense. I've done a lot of this stuff, so I might be leaving out things I do automatically.

andymac · 04-06-2005, 10:07 AM

Quote:

Originally Posted by ctorg

What I do when I work on Lahman is divide it up into two or three files in notepad, then sort each file how I want in Excel. I then use Excel to recombine the files in the way I want, still divided up, and save as separate files again.

For instance, let's say the batting stats are sorted by year, and you want them sorted by name. In notepad, divide the batting file into three separate files by cutting in pasting. Then open each one in Excel and sort it by name. Then copy, say, A thru J from each into a new Excel spreadsheet, then K thru P, then Q thru Z (just randomly picking letters here). Then sort each of those new spreadsheets by name and close them. Then, if that's all you wanted to do, open them in Notepad and recombine them.

Hopefully that makes some sense. I've done a lot of this stuff, so I might be leaving out things I do automatically.

Excellent idea, this will save me a ton of time. Thanks!

04-05-2005, 03:03 AM	#1
andymac Hall Of Famer Join Date: Feb 2002 Location: Effingham, IL Posts: 5,725	Help with editing LahmanDB I am trying to create a 2005 roster set by adding 2005 entries into the LahmanDB, but using projected statistics. I was able to do this easily for the pitchers by just adding the entries into the CSV file. However, the batting file is giving me problems because it is already too large to open in Excel and I do not own Access. So, basically, I am asking if there is another way to open/edit the CSV file that I am not aware of. Any help/suggestions on how to approach this would be greatly appreciated. __________________ June Madness: Links FTB: andymac

04-05-2005, 12:54 PM	#3
seth70liz76 All Star Starter Join Date: Feb 2003 Posts: 1,634	Notepad is what I'm using, but like BravesSince66 says, you have to be careful, since you won't find your errors until you run the DB. __________________ It was a mistake to come back.

04-05-2005, 03:02 PM	#4
andymac Hall Of Famer Join Date: Feb 2002 Location: Effingham, IL Posts: 5,725	OK, what I will probably do is create the entries in a seperate excel file and then copy + paste everything over to notepad once I am done. That should minimize most error risk, I would think. Thanks guys! __________________ June Madness: Links FTB: andymac

04-06-2005, 09:49 AM	#9
ctorg Global Moderator Join Date: Nov 2002 Location: Queens, NY Posts: 9,848	What I do when I work on Lahman is divide it up into two or three files in notepad, then sort each file how I want in Excel. I then use Excel to recombine the files in the way I want, still divided up, and save as separate files again. For instance, let's say the batting stats are sorted by year, and you want them sorted by name. In notepad, divide the batting file into three separate files by cutting in pasting. Then open each one in Excel and sort it by name. Then copy, say, A thru J from each into a new Excel spreadsheet, then K thru P, then Q thru Z (just randomly picking letters here). Then sort each of those new spreadsheets by name and close them. Then, if that's all you wanted to do, open them in Notepad and recombine them. Hopefully that makes some sense. I've done a lot of this stuff, so I might be leaving out things I do automatically. __________________ My music "When the trees blow back and forth, that's what makes the wind." - Steven Wright Fjord emena pancreas thorax fornicate marmalade morpheme proteolysis smaxa cabana offal srue vitriol grope hallelujah lentils

04-05-2005, 12:37 PM	#2
BravesSince66 Minors (Triple A) Join Date: Oct 2004 Posts: 238	You can edit it in notepad or any other text base editor. Not as user friendly, of course, but it will work as long as you are careful.

04-05-2005, 08:04 PM	#5
Kemp All Star Starter Join Date: Feb 2002 Posts: 1,181	I believe the DB is sorted by year (ascending). In the past, I've opened the file in notepad, deleted a lot of the "top" rows, saved it, and then opened it in Excel.