CLAN and Excel

Mon Feb 23 10:47:06 UTC 2009

Dear all,

I have some questions about importing CLAN outputs to Excel files.

With the help of the CLAN manual, I could learn how to use INSERT, FREQ and
STATFREQ, and the switches +d2 and +d3, in order to import outputs on word
frequencies and/or types, tokens, and type-token ratios to an Excel file.
In section 8.22 STATFREQ it reads that it is also possible to produce code
frequencies, but I don’t seem to be able to find more details about it in
the manual. So, at first, I have tried a COMBO command like that:

combo +s"*|S-DA:T-*" +t%cod +d3 +f +t at ID="*target_child*" @
(where S-DA:T is the code combination searched for: S for subject, DA:T for
bare demonstrative, and S-DA:T together for bare demonstrative in subject
position)

CLAN generated ins.cmb.cex files, but not a stat.out.cex file, as this is
the case with FREQ. As it seems, the +d2 or +d3 switch works only with
FREQ? So, I used the same command line above, but with the command FREQ,
and then STATFREQ, and I can import the stat.out.sat.cex file to Excel,
everything as expected, but, of course, what I have is a table with columns
labelled 'types', 'tokens', and 'TTR'. Of course, in the process of
converting the file into Excel and also later, I can make changes in the
table such that it corresponds to my purposes, but I was wondering whether
I’m missing some switch or something that tells CLAN to generate in the
stat.out.sat.cex a column labelled with the searched string (in the case
above, *|S-DA:T-*). Or should I perhaps use a command other than FREQ?

I was also wondering whether it is possible to have a stat.out.sat.cex file
such that it summarises a series of search operations. For instance, if I
want to make a pivot table with children’s frequencies of several
linguistic units, such as subjects (*|S-*), objects (*|O-*), bare
demonstratives (*|*-DA:T-*), personal pronouns (*|*-PRO:PP-*), bare
demonstratives in subject (*|S-DA:T-*) and  object position (*|O-DA:T-*),
personal pronouns in subject (*|S-PRO:PP-*) and object position
(*|O-PRO:PP-*), etc.: Is there a procedure for getting one only output file
including all of these frequencies, e.g.:

…  speaker   …  *|S-*    *|O-*   *|*-DA:T-*      *|*-PRO:PP-*   
*|S-DA:T-*     *|O-DA:T-*     *|S-PRO:PP-*    *|O-PRO:PP-*    …
…  001       …  n         n      n               n               n     
        n              n               n      
…  002       …  n         n      n               n               n     
        n              n               n      
…                                  

Finally, when using the +d2 switch, the stat.out.sat.cex (and the Excel
file) has a column between ‘situation’ and the first word of the
concordance. It is the 10th column – what does this column mean?

I’d be most grateful for help in clarifying these questions and I
apologise in advance for asking questions about basics the answers to which
are perhaps easily found in the manual.

Best wishes,
Susanna

-- 
*****************************************************************
Susanna Bartsch
bartsch at zas.gwz-berlin.de
http://www.zas.gwz-berlin.de/mitarb/homepage/bartsch
Zentrum fuer Allgemeine Sprachwissenschaft (ZAS)
Centre for General Linguistics
Schuetzenstr. 18
10117 Berlin
Germany
Tel. +49 (0)30 20 192 503
Fax  +49 (0)30 20 192 402 
*****************************************************************

* * * * * * * * * * * * * * * Avira MailGate NOTICE * * * * * * * * * * * * * * *

Avira MailGate has processed a mail addressed to you, which contained no known
potential malicious software.

In case you notice abnormal behavior of your software after opening the
mail or one of its attachments, please forward the complete mail to
Avira GmbH <mailto:support at avira.com> so it can be
checked for unknown new potential malicious software.

-- 
Avira MailGate

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "chibolts" group.
To post to this group, send email to chibolts at googlegroups.com
To unsubscribe from this group, send email to chibolts+unsubscribe at googlegroups.com
For more options, visit this group at http://groups.google.com/group/chibolts?hl=en
-~----------~----~----~----~------~----~------~--~---