FREQ outputs in long format

[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


On Sep 8, 2023, at 1:22 PM, Mits Ota <mits at 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 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

On Friday, September 8, 2023 at 4:10:26 PM UTC+1 Leonid Spektor wrote:
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... at ling.ed.ac.uk> wrote:

Dear chibolts,

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

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


--
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 view this discussion on the web visit https://groups.google.com/d/msgid/chibolts/ef67a624-286e-42fb-8e1d-a05682a40ccfn%40googlegroups.com<https://groups.google.com/d/msgid/chibolts/ef67a624-286e-42fb-8e1d-a05682a40ccfn%40googlegroups.com?utm_medium=email&utm_source=footer>.

-- 
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 view this discussion on the web visit https://groups.google.com/d/msgid/chibolts/21EFA9B8-6CE5-43BF-92F3-99F082350C7A%40mun.ca.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listserv.linguistlist.org/pipermail/chibolts/attachments/20230908/d3d3072b/attachment.htm>