crazietalk.net

ArkieDukie wrote:I'm pretty good with Excel, too, which is why I started with VBA. One of the things I do pretty regularly is pull key words (gene symbol) out of a string of text (protein description), group the items in the spreadsheet by gene symbol, and then look up the gene symbols in instances where it wasn't given in the protein name. This can take hours. As it turns out, there's a downloadable database of protein accession numbers and gene symbols. I'm attempting to write a Perl script that will look at the appropriate column (accession number) on the spreadsheet that I get from my boss and pull in the gene symbols from the database.

OZZIE4DUKE wrote:

ArkieDukie wrote:I'm pretty good with Excel, too, which is why I started with VBA. One of the things I do pretty regularly is pull key words (gene symbol) out of a string of text (protein description), group the items in the spreadsheet by gene symbol, and then look up the gene symbols in instances where it wasn't given in the protein name. This can take hours. As it turns out, there's a downloadable database of protein accession numbers and gene symbols. I'm attempting to write a Perl script that will look at the appropriate column (accession number) on the spreadsheet that I get from my boss and pull in the gene symbols from the database.

When you said you were teaching yourself Perl I thought you were going to learn how to knit! I was waiting for BostonDevil to chime in...

We're all excited about seeing you in less than two weeks! Have you made your travel plans yet?

ArkieDukie wrote:

OZZIE4DUKE wrote:

ArkieDukie wrote:I'm pretty good with Excel, too, which is why I started with VBA. One of the things I do pretty regularly is pull key words (gene symbol) out of a string of text (protein description), group the items in the spreadsheet by gene symbol, and then look up the gene symbols in instances where it wasn't given in the protein name. This can take hours. As it turns out, there's a downloadable database of protein accession numbers and gene symbols. I'm attempting to write a Perl script that will look at the appropriate column (accession number) on the spreadsheet that I get from my boss and pull in the gene symbols from the database.

When you said you were teaching yourself Perl I thought you were going to learn how to knit! I was waiting for BostonDevil to chime in...

We're all excited about seeing you in less than two weeks! Have you made your travel plans yet?

The only plan I've made so far, Ozzie, is to drive rather than fly. It gives me more opportunity to bring stuff (camera equipment, beer). Unfortunately I won't be able to leave until Friday, unless I can talk my sub into taking another week of handbell rehearsal for me. Another option would be to pack up my car on Thursday and drive for a couple of hours Thursday night, after I get out of handbell rehearsal at 7:30. Has kickoff time been officially announced yet? Last time I looked it was TBA.

Since I can bring beer, are there any requests? I can bring seasonal selections from O'Fallon's and/or Schlafly's.

ArkieDukie wrote:

OZZIE4DUKE wrote:

ArkieDukie wrote:I'm pretty good with Excel, too, which is why I started with VBA. One of the things I do pretty regularly is pull key words (gene symbol) out of a string of text (protein description), group the items in the spreadsheet by gene symbol, and then look up the gene symbols in instances where it wasn't given in the protein name. This can take hours. As it turns out, there's a downloadable database of protein accession numbers and gene symbols. I'm attempting to write a Perl script that will look at the appropriate column (accession number) on the spreadsheet that I get from my boss and pull in the gene symbols from the database.

When you said you were teaching yourself Perl I thought you were going to learn how to knit! I was waiting for BostonDevil to chime in...

We're all excited about seeing you in less than two weeks! Have you made your travel plans yet?

The only plan I've made so far, Ozzie, is to drive rather than fly. It gives me more opportunity to bring stuff (camera equipment, beer). Unfortunately I won't be able to leave until Friday, unless I can talk my sub into taking another week of handbell rehearsal for me. Another option would be to pack up my car on Thursday and drive for a couple of hours Thursday night, after I get out of handbell rehearsal at 7:30. Has kickoff time been officially announced yet? Last time I looked it was TBA.

Since I can bring beer, are there any requests? I can bring seasonal selections from O'Fallon's and/or Schlafly's.

Turk wrote:

Very Duke Blue wrote:I can't believe I'm brave enough (or crazie enough) to fly Sunday, 9-ll.

I beg to differ, I've done it before. No day would be safer, IMHO. Might need to get to the airport an hour or two earlier for the bonus cavity search, though...

Very Duke Blue wrote:

Turk wrote:

Very Duke Blue wrote:I can't believe I'm brave enough (or crazie enough) to fly Sunday, 9-ll.

I beg to differ, I've done it before. No day would be safer, IMHO. Might need to get to the airport an hour or two earlier for the bonus cavity search, though...

I arrived safe and sound. I wish all airports were as easy as Houston Hobby. I had forgotten how small it is. I had good flights. I actually felt more comfortable on American Eagle than the larger plane. More leg room. Melinda and I had lunch at Kenny and Ziggie's Deli. It was great. I had corn beef on rye. I like it better then Carnegie. No dinner tonight, we were not hungry. I did have a Sam Adams.

YmoBeThere wrote:There is a Wilson sighting...

ArkieDukie wrote:

OZZIE4DUKE wrote:

ArkieDukie wrote:I'm pretty good with Excel, too, which is why I started with VBA. One of the things I do pretty regularly is pull key words (gene symbol) out of a string of text (protein description), group the items in the spreadsheet by gene symbol, and then look up the gene symbols in instances where it wasn't given in the protein name. This can take hours. As it turns out, there's a downloadable database of protein accession numbers and gene symbols. I'm attempting to write a Perl script that will look at the appropriate column (accession number) on the spreadsheet that I get from my boss and pull in the gene symbols from the database.

When you said you were teaching yourself Perl I thought you were going to learn how to knit! I was waiting for BostonDevil to chime in...

We're all excited about seeing you in less than two weeks! Have you made your travel plans yet?

The only plan I've made so far, Ozzie, is to drive rather than fly. It gives me more opportunity to bring stuff (camera equipment, beer). Unfortunately I won't be able to leave until Friday, unless I can talk my sub into taking another week of handbell rehearsal for me. Another option would be to pack up my car on Thursday and drive for a couple of hours Thursday night, after I get out of handbell rehearsal at 7:30. Has kickoff time been officially announced yet? Last time I looked it was TBA.

Since I can bring beer, are there any requests? I can bring seasonal selections from O'Fallon's and/or Schlafly's.

Lavabe wrote:

OZZIE4DUKE wrote:

ArkieDukie wrote:I'm pretty good with Excel, too, which is why I started with VBA. One of the things I do pretty regularly is pull key words (gene symbol) out of a string of text (protein description), group the items in the spreadsheet by gene symbol, and then look up the gene symbols in instances where it wasn't given in the protein name. This can take hours. As it turns out, there's a downloadable database of protein accession numbers and gene symbols. I'm attempting to write a Perl script that will look at the appropriate column (accession number) on the spreadsheet that I get from my boss and pull in the gene symbols from the database.

When you said you were teaching yourself Perl I thought you were going to learn how to knit! I was waiting for BostonDevil to chime in...

We're all excited about seeing you in less than two weeks! Have you made your travel plans yet?

Please forgive my ignorance, but what date is the game?

devildeac wrote:

Lavabe wrote:I'm pretty good with Excel, too, which is why I started with VBA. One of the things I do pretty regularly is pull key words (gene symbol) out of a string of text (protein description), group the items in the spreadsheet by gene symbol, and then look up the gene symbols in instances where it wasn't given in the protein name. This can take hours. As it turns out, there's a downloadable database of protein accession numbers and gene symbols. I'm attempting to write a Perl script that will look at the appropriate column (accession number) on the spreadsheet that I get from my boss and pull in the gene symbols from the database.
When you said you were teaching yourself Perl I thought you were going to learn how to knit! I was waiting for BostonDevil to chime in...

We're all excited about seeing you in less than two weeks! Have you made your travel plans yet?
Please forgive my ignorance, but what date is the game?

9/17-BC-away
9/24-Tulane-home-I'd bet a 1 PM KO time for this one. Brunchgate!

OZZIE4DUKE wrote:

devildeac wrote:

Lavabe wrote:I'm pretty good with Excel, too, which is why I started with VBA. One of the things I do pretty regularly is pull key words (gene symbol) out of a string of text (protein description), group the items in the spreadsheet by gene symbol, and then look up the gene symbols in instances where it wasn't given in the protein name. This can take hours. As it turns out, there's a downloadable database of protein accession numbers and gene symbols. I'm attempting to write a Perl script that will look at the appropriate column (accession number) on the spreadsheet that I get from my boss and pull in the gene symbols from the database.
When you said you were teaching yourself Perl I thought you were going to learn how to knit! I was waiting for BostonDevil to chime in...

We're all excited about seeing you in less than two weeks! Have you made your travel plans yet?
Please forgive my ignorance, but what date is the game?

9/17-BC-away
9/24-Tulane-home-I'd bet a 1 PM KO time for this one. Brunchgate!

We should know today.

DevilAlumna wrote:FutureDA starts daycare tomorrow. I start back to work on Wed.

Just halfdays this week, then fulltime for both of us next week.

DevilAlumna wrote:FutureDA starts daycare tomorrow. I start back to work on Wed.

Just halfdays this week, then fulltime for both of us next week.

DukieInKansas wrote:

DevilAlumna wrote:FutureDA starts daycare tomorrow. I start back to work on Wed.

Just halfdays this week, then fulltime for both of us next week.

Prayers and vibes for a peaceful transition.

ArkieDukie wrote:My boss invited the whole lab out to lunch on Wednesday. I really don't want to go, but I probably should. Bah humbug.