Sorry, should have been
dat{"1~
not
dat{"1
On Mon, Oct 7, 2013 at 5:53 PM, Devon McCormick <[email protected]> wrote:
> I tend to use delimited text files like this:
>
> 'hdr dat'=. split readcsv '/home/dan/Downloads/Master.csv'
> (<'Joe') +/ . =dat{"1 hdr i. <'nameFirst' NB. How many "Joe"s?
>
> where "split" is ({. ,&< }.).That is, split and assign the header and the
> data in one statement and don't bother assigning "index" because it's more
> self-documenting to generate it from the header as you use it.
>
>
> On Mon, Oct 7, 2013 at 5:41 PM, Dan Farmer <[email protected]> wrote:
>
>> I hope you guys won't mind me extending this question, but just
>> playing around with that data I got to thinking. Ok, I know there are
>> 398 Joe's in here.
>>
>> What is the distribution of names like? Taking off from Ganesh's example
>>
>> NB. How many total?
>>
>> #(index {"1 data )
>>
>> 18125
>>
>> NB. How many unique names?
>>
>> #~. (index {"1 data )
>>
>> 2209
>>
>> Ok, now if I wanted to get counts for each name, I want to connect the
>> names from ~. (index {"1 data ) to the counting phrase Ganesh
>> provided:
>>
>> +/@:= index {"1 data -- but not sure how...?
>>
>> -Dan
>>
>> On Mon, Oct 7, 2013 at 2:04 PM, Dan Bron <[email protected]> wrote:
>> > Ganesh Rapolu
>> >> Because the data is boxed, all comparisons must be boxed.
>> >
>> > This was very well put (one short sentence which both clarifies the
>> problem
>> > and justifies the solution).
>> >
>> > -Dan
>> >
>> >
>> >
>> > ----------------------------------------------------------------------
>> > For information about J forums see http://www.jsoftware.com/forums.htm
>> ----------------------------------------------------------------------
>> For information about J forums see http://www.jsoftware.com/forums.htm
>>
>
>
>
> --
> Devon McCormick, CFA
>
>
--
Devon McCormick, CFA
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
