Combining individual CLAN outputs into an Excel spreadsheet

Leonid Spektor spektor at andrew.cmu.edu
Mon May 28 16:29:56 EDT 2018


Min,

	You can use the nominalization list to count how many times students used those words in their written work. You need to put each nominalization word in a include file, one word per line, and then run FREQ command with +s at nominalization.cut <mailto:s at nominalization.cut> option. This assumes that you call the nominalization list file "nominalization.cut". The format of the "nominalization.cut" file depends on whether you are looking for words on speaker tier or lemmas of words on %mor tier. For speaker tier search just use the words as they appear on speaker tier. For %mor tier search use +sm option format. You can run command "freq +sm" to see more information about this format or read more about it in CLAN manual. Here is a short example of %mor include file format:

m;do
m;be
m;there
m;it

This will look for stems/lemmas of speaker's tier words "do", "be", "there" and "it", but on %mor tier. The prefix "m;" indicates that you want CLAN to search on %mor tier.

If you have any questions about this, then please email to me directly with your data sample file and I will try to give you a more precise suggestion of how to accomplish what you want to do.


Leonid.

> On May 28, 2018, at 14:13, mio033 at mail.harvard.edu wrote:
> 
> Thank you, Leonid!
> 
> I do have one more question. 
> 
> I'm currently doing research that looks at nominalizations in students' written work. To do this, I've attached MOR tags to each student file and have generated a list of nouns and then a list of nominalizations for the whole sample. Now I'd like to check on how many times each student used the words on my nominalization list--is there a way to run the student writing samples against my nominalization list in CLAN to get the number of nominalizations used in each writing file? 
> 
> 
> 
> Thanks so much in advance!
> Min
> 
> 
> 
> 
> 
> 
> On Monday, May 28, 2018 at 3:36:27 AM UTC-5, Leonid Spektor wrote:
> Hi,
> 
> 	FREQ has +f option that will put output into a file instead of output window. FREQ also has +d2 and +d3 options that will create Excel output file. In CLAN Excel output is called "SPREADSHEET format". A lot of CLAN commands have this option.
> 
> 
> Leonid.
> 
>> On May 28, 2018, at 00:12, mio... at mail.harvard.edu <javascript:> wrote:
>> 
>> Hi!
>> 
>> Is there a way to make CLAN automatically combine the individual outputs into an Excel spreadsheet? I have about 100 files for which I'm picking out nouns (freq +sm;*,|n,o%+u*.cha @), and CLAN is giving me the results in the output window. Before I manually copy and paste these outputs for each sample into Excel, I wanted to hear if anyone could give me advice!
>> 
>> 
>> 
>> Thanks in advance! 
>> 
>> -- 
>> You received this message because you are subscribed to the Google Groups "chibolts" group.
>> To unsubscribe from this group and stop receiving emails from it, send an email to chibolts+u... at googlegroups.com <javascript:>.
>> To post to this group, send email to chib... at googlegroups.com <javascript:>.
>> To view this discussion on the web visit https://groups.google.com/d/msgid/chibolts/cc178aaf-6662-413d-b398-fea15e4ef6f7%40googlegroups.com <https://groups.google.com/d/msgid/chibolts/cc178aaf-6662-413d-b398-fea15e4ef6f7%40googlegroups.com?utm_medium=email&utm_source=footer>.
>> For more options, visit https://groups.google.com/d/optout <https://groups.google.com/d/optout>.
> 
> 
> -- 
> You received this message because you are subscribed to the Google Groups "chibolts" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to chibolts+unsubscribe at googlegroups.com <mailto:chibolts+unsubscribe at googlegroups.com>.
> To post to this group, send email to chibolts at googlegroups.com <mailto:chibolts at googlegroups.com>.
> To view this discussion on the web visit https://groups.google.com/d/msgid/chibolts/c2b5a96f-9d48-4b9e-ae87-6d5713cc1916%40googlegroups.com <https://groups.google.com/d/msgid/chibolts/c2b5a96f-9d48-4b9e-ae87-6d5713cc1916%40googlegroups.com?utm_medium=email&utm_source=footer>.
> For more options, visit https://groups.google.com/d/optout <https://groups.google.com/d/optout>.

-- 
You received this message because you are subscribed to the Google Groups "chibolts" group.
To unsubscribe from this group and stop receiving emails from it, send an email to chibolts+unsubscribe at googlegroups.com.
To post to this group, send email to chibolts at googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/chibolts/8993BE7D-9D87-4009-AE7A-A8DDFD9D2919%40andrew.cmu.edu.
For more options, visit https://groups.google.com/d/optout.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listserv.linguistlist.org/pipermail/chibolts/attachments/20180528/111ac398/attachment-0001.html>


More information about the Chibolts mailing list