[External] Re: FREQ outputs in long format

Tue Sep 26 16:55:11 UTC 2023

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: chibolts at googlegroups.com <chibolts at googlegroups.com> On Behalf Of Rose, Yvan
Sent: Friday, September 8, 2023 9:18 AM
To: chibolts at googlegroups.com
Subject: [External] Re: FREQ outputs in long format

This email originated outside the University. Check before clicking links or attachments.
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<mailto: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<mailto: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<https://groups.google.com/d/msgid/chibolts/21EFA9B8-6CE5-43BF-92F3-99F082350C7A%40mun.ca?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/LO4P265MB6171239AEA2AF3DD39451E9A9FC3A%40LO4P265MB6171.GBRP265.PROD.OUTLOOK.COM.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listserv.linguistlist.org/pipermail/chibolts/attachments/20230926/8be8fb65/attachment-0001.htm>