Combining individual CLAN outputs into an Excel spreadsheet

Min Hyun Oh mio033 at mail.harvard.edu
Mon May 28 18:03:50 EDT 2018


This is great! Thanks so much, Leonid.


Best,
Min

On Mon, May 28, 2018 at 3:29 PM, Leonid Spektor <spektor at andrew.cmu.edu>
wrote:

> 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 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 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.
>> To post to this group, send email to chib... at googlegroups.com.
>> To view this discussion on the web visit https://groups.google.co
>> m/d/msgid/chibolts/cc178aaf-6662-413d-b398-fea15e4ef6f7%40go
>> oglegroups.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.
>>
>>
>>
> --
> 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/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.
>
>
> --
> 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
> <https://groups.google.com/d/msgid/chibolts/8993BE7D-9D87-4009-AE7A-A8DDFD9D2919%40andrew.cmu.edu?utm_medium=email&utm_source=footer>
> .
>
> For more options, visit 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/CAL2XvR%2B7VsgK2%3D6_pm0s1pztGjWSkO-0Zmem1D0muJd9nMr6pg%40mail.gmail.com.
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/a299d5f8/attachment.html>


More information about the Chibolts mailing list