10@10 - Discussion of KFOG's show in general

[Lightnin' Rod]

Oh, if you have a bunch of text files, I can load them into a db -- that's easy.  I should have read this before replying to the other post.

I tried to reply to your PM, and got the following error:

Unable to find member 'lightnin' rod'.

That is odd.  I know Geoff has sent me a PM before.

[dischead]

Oh, if you have a bunch of text files, I can load them into a db -- that's easy.  I should have read this before replying to the other post.

I tried to reply to your PM, and got the following error:
Unable to find member 'lightnin' rod'.

That is odd.  I know Geoff has sent me a PM before.

Apparently javascript is required, probably because your user name contains non-alphabetic
characters.  I usually keep it turned off unless I really need it, and I've been able to use most
features on this board without it.

[ggould]

Oh, if you have a bunch of text files, I can load them into a db -- that's easy.  I should have read this before replying to the other post.

I tried to reply to your PM, and got the following error:
Unable to find member 'lightnin' rod'.

That is odd.  I know Geoff has sent me a PM before.

Apparently javascript is required, probably because your user name contains non-alphabetic
characters.  I usually keep it turned off unless I really need it, and I've been able to use most
features on this board without it.

and I got your test PM yesterday

[Lightnin' Rod]

Oh, if you have a bunch of text files, I can load them into a db -- that's easy.  I should have read this before replying to the other post.

I tried to reply to your PM, and got the following error:
Unable to find member 'lightnin' rod'.

That is odd.  I know Geoff has sent me a PM before.

Apparently javascript is required, probably because your user name contains non-alphabetic
characters.  I usually keep it turned off unless I really need it, and I've been able to use most
features on this board without it.

I was thinking the apostrophe was probably the culprit.  Working in SQL, apostrophe's (or "ticks" in the jargon) have long been a problem.

[dischead]

Oh, if you have a bunch of text files, I can load them into a db -- that's easy.  I should have read this before replying to the other post.

I tried to reply to your PM, and got the following error:
Unable to find member 'lightnin' rod'.

That is odd.  I know Geoff has sent me a PM before.

Apparently javascript is required, probably because your user name contains non-alphabetic
characters.  I usually keep it turned off unless I really need it, and I've been able to use most
features on this board without it.

and I got your test PM yesterday

Which I sent w/o javascript enabled.

[dischead]

Oh, if you have a bunch of text files, I can load them into a db -- that's easy.  I should have read this before replying to the other post.

I tried to reply to your PM, and got the following error:
Unable to find member 'lightnin' rod'.

That is odd.  I know Geoff has sent me a PM before.

Apparently javascript is required, probably because your user name contains non-alphabetic
characters.  I usually keep it turned off unless I really need it, and I've been able to use most
features on this board without it.

I was thinking the apostrophe was probably the culprit.  Working in SQL, apostrophe's (or "ticks" in the jargon) have long been a problem.

Yep... back quotes are often used to probe poorly-designed web forms for vulnerabilities.  You've
probably heard about little Bobby Tables...

http://xkcd.com/327/

[dischead]

I realized I could tease this data out of my files with a few minutes of
screwing around with a programmable text editor and a quick file sort, so I did.
Encore sets noted as such were excluded.  Here then is...


Eleven Months Of Renee

total sets      230
years total     209
themes total     21

themes:
holidays          7
other occasions   6
other topics      8


1963    1
1964    3
1965    4
1966    4
1967    6
1968    5
1969    6

1970    5
1971    6
1972    6
1973    8
1974    6
1975    7
1976    4
1977    5
1978    7
1979    7

1980    5
1981    8
1982    8
1983    7
1984    8
1985    7
1986    7
1987    7
1988    8
1989    5

1990    3
1991    6
1992    5
1993    6
1994    5
1995    5
1996    3
1997    5
1998    3
1999    2

2000    2
2001    3
2002    1

[Big Fingers McGee]

Thanks for doing that... looks like it's not-so-random to me, more like a very gradual bell curve.

[urth]

Thanks for doing that... looks like it's not-so-random to me, more like a very gradual bell curve.

Yep -- at least in this interpretation of the data. It's easy to see that their sweet spot is between 73 and 88, with a gradual dropoff on either side of that. (Wonder what's up with 76 and 77 though?)

I'd be curious to see a month by month breakdown, and also one for the DC months as compared to Bill whatsisface's tenure.

[Lightnin' Rod]

Thanks for doing that... looks like it's not-so-random to me, more like a very gradual bell curve.

Yep -- at least in this interpretation of the data. It's easy to see that their sweet spot is between 73 and 88, with a gradual dropoff on either side of that. (Wonder what's up with 76 and 77 though?)

I'd be curious to see a month by month breakdown, and also one for the DC months as compared to Bill whatsisface's tenure.

Dischead sent me a couple of lists, and I've loaded the 2013 (through 8/30) list into a db.  It's not completely clean yet, but it's getting there.  I just haven't had the time to do much with it since I created it.

I'll probably try to add the 2002 data this weekend.  That's going to a bit more challenging, as the formatting of entries is a bit more chaotic.  And things like "Mystery Year! answer at bottom" is going to play hell with my import algorithm.

Send me some data points you might want to see for this year.  I can write a few queries...

[Tinka Cat]

Thanks for doing that... looks like it's not-so-random to me, more like a very gradual bell curve.

you mean like an inverted geosyncline?

all I need to know is: How much Rush did she play?

[dischead]

Thanks for doing that... looks like it's not-so-random to me, more like a very gradual bell curve.

Yep -- at least in this interpretation of the data. It's easy to see that their sweet spot is between 73 and 88, with a gradual dropoff on either side of that. (Wonder what's up with 76 and 77 though?)

I'd be curious to see a month by month breakdown, and also one for the DC months as compared to Bill whatsisface's tenure.

I have no problem with a lack of '76 & '77 -- two of the worst years ever.

I'm not sure what a month by month breakdown would show.  With a range of forty years,
and just over twenty sets per month, each month would just have ones and zeros that
indicated which years did and did not get played that month.

A comparison of DC and post-DC periods might be more interesting, but he's only been gone
a couple of months.  There's not enough data yet to make a meaningful comparison.

[dischead]

I'll probably try to add the 2002 data this weekend.  That's going to a bit more challenging, as the formatting of entries is a bit more chaotic.  And things like "Mystery Year! answer at bottom" is going to play hell with my import algorithm.

Send me some data points you might want to see for this year.  I can write a few queries...

How does your input process work?  Do you have a template, and anything that doesn't fit
gets flagged for review?

It might be best for me to create special versions of my text files specifically for database input
by deleting all the extraneous information, putting the year on the header line for mystery sets,
etc.  It may be easier to do that than to write the filters or whatever to weed that stuff out
later.  The 2013 file was fairly clean, in large part because whoever is posting the sets on the
KFOG site in the RR era has been putting in minimal effort.  The 2002 file has more irregularities.
Keep track of what the biggest PITA issues are, and maybe I can eliminate them in the future.

What I'd like to see is the most played artist(s) by year, and overall.

[dischead]

all I need to know is: How much Rush did she play?

One song:  New World Man on August 8th of this year.

Whether that's too much or not enough will be left as an exercise for the reader.

[Tinka Cat]

all I need to know is: How much Rush did she play?

One song:  New World Man on August 8th of this year.

Whether that's too much or not enough will be left as an exercise for the reader.

we all know the answer to that.