FREQ outputs in long format

[Mits Ota]

Dear chilbolts,

Does anyone know how to send out FREQ outputs in a long spreadsheet format? By default, spreadsheet outputs of FREQ come out in a wide format with speakers in rows but words across columns, like this:

     apple  banana coconut

MOT    4       3      0

FAT     2       0      19

   

I would like to obtain spreadsheet outputs for FREQ in which each row is a unique entry defined by the filename, speaker, word, and its frequency (like KWAL spreadsheet output):

File  Code  Word  Count

abc01 MOT   apple    4

abc01 MOT   banana   3

abc01 FAT   apple    2

abc01 FAT   coconut  19

Any advice is welcome! Thanks.

Mits Ota

[Leonid Spektor]

Hi Mits,

There is no way to reformat FREQ output the way you want it right now. FREQ can be changed fairly easily to produce this kind of output, but this would have to be approved by the powers that be.

The other alternative is for someone else to write a utility to reformat FREQ spreadsheet output the way you want it. The FREQ spreadsheet output is in XML format, so it should be easy to do.

Leonid.

On Sep 8, 2023, at 10:39, Mits Ota <mi...@ling.ed.ac.uk> wrote:

Dear chibolts,

--
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...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/chibolts/150b8a14-d78d-458e-9633-4b159c23229dn%40googlegroups.com.

[Mits Ota]

Hi Leonid,

Thanks for the reply. I suspect that much; otherwise I would have expected to see a relevant option already available on CLAN :-). I don't have enough XML skills to wirte a utility, so for now I'm just going to reshape the current output format on R, but it would be nice to have that option in CLAN in the future if the powers to be are willing to give their blessing.

Best,

Mits

[Leonid Spektor]

Hi Mits,

I have added +d20 option to FREQ to produce spreadsheet output you wanted. Please, get new version of CLAN.

Leonid.

On Sep 8, 2023, at 11:52, Mits Ota <mi...@ling.ed.ac.uk> wrote:

Hi Leonid,

Thanks for the reply. I suspect that much; otherwise I would have expected to see a relevant option already available on CLAN :-). I don't have enough XML skills to write a utility, so for now I'm just going to reshape the current output format on R, but it would be nice to have that option in CLAN in the future if the powers to be are willing to give their blessing.

To view this discussion on the web visit https://groups.google.com/d/msgid/chibolts/ef67a624-286e-42fb-8e1d-a05682a40ccfn%40googlegroups.com.

[Rose, Yvan]

Hi Mits, 

I believe that a basic 'transpose' operation in the spreadsheet of your choice would address this issue. Please send me a personal message if you want  more input about this. 

Kind regards,

Yvan

To view this discussion on the web visit https://groups.google.com/d/msgid/chibolts/ef67a624-286e-42fb-8e1d-a05682a40ccfn%40googlegroups.com.

[Alcock, Katie]

I have achieved this via Excel as Yvan says:

Paste into Excel (Paste Special, using the Transpose option).

It will probably paste all into one column so then I do

Data – Text to Columns (usually Fixed format works better than Delimited, but Delimited with Spaces as delimiter sometimes works).

 

Katie

 

 

Dr Katie Alcock, DPhil, CPsychol

 

Department of Psychology,

Fylde College

Lancaster University

Bailrigg

Lancaster

LA1 4YF

Please note working pattern: Monday through Thursday. I am unavailable on Fridays, and I am currently at Stanford so am unlikely to answer emails during UK working hours.

 

Out now: UK Communicative Development Inventories (Words and Gestures)
https://www.jr-press.co.uk/uk-communicative-development-inventories.html

 

 

 

From: chib...@googlegroups.com <chib...@googlegroups.com> On Behalf Of Rose, Yvan
Sent: Friday, September 8, 2023 9:18 AM
To: chib...@googlegroups.com
Subject: [External] Re: FREQ outputs in long format

 

This email originated outside the University. Check before clicking links or attachments.

To view this discussion on the web visit https://groups.google.com/d/msgid/chibolts/21EFA9B8-6CE5-43BF-92F3-99F082350C7A%40mun.ca.