CLAN and Excel
Leonid Spektor
spektor at andrew.cmu.edu
Mon Feb 23 20:29:12 UTC 2009
Susanna,
Try this command:
freq +d2 +t at ID="*target_child*" -t* +t%cod +s"%|S-%" +s"%|O-%"
+s"%|%-DA:T-%" +s"%|%-PRO:PP-%" +s"%|S-DA:T-%" +s"%|O-DA:T-%"
+s"%|S-PRO:PP-%" +s"%|O-PRO:PP-%"
Notice I have replaced all the '*' characters with '%' character. The above
example should be on one command line. If this is too much, then you can use
the file "codes.cut" that I am attaching to this email with this command:
freq +d2 +t at ID="*target_child*" -t* +t%cod +s at codes.cut
If this doesn't help you, then please send me a sample of your data file and
further description of what exactly didn't work for you.
In my tests I did not see an extra column between Œsituation¹ and the
first word of the concordance. Perhaps the @ID header tiers in your data
files have an extra element at the end. You can see the correct output by
looking at "sample.cha" and running commands:
freq +d2 +s"pro:%|%" +s"pro|%" sample.cha +t at ID="*mother*" -t* +t%mor
statfreq stat.out.cex +f +d
on it. The "sample.cha" file located in clan/lib/sample/ folder.
Leonid.
On 23-02-09 05:47, "bartsch" <bartsch at zas.gwz-berlin.de> wrote:
>
> 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
>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: codes.cut
URL: <http://listserv.linguistlist.org/pipermail/chibolts/attachments/20090223/2b8d9442/attachment-0001.ksh>
More information about the Chibolts
mailing list