combining output to excel

[Brian Verdine]

Hi,

I am trying to figure out if there is a simple way to run and compile data 
from multiple freq commands.  

Most of the transcripts I have contain only 2 speakers (a child and a 
parent).  However, about 1/3 also have a toy (an iPad) that talks and that 
we transcribed.  I am trying to count the types, tokens, and get TTR for 
different groups of words for these 3 speaker tiers individually.  In 
addition, for those that heard the iPad, I need to produce type/token stats 
for a combination of the parent and iPad.  By getting that data we will be 
able to look at all of the speech a child hears (whether from parent or 
iPad).  These pieces of data are generated into excel files by the 4 
commands below.  They seem to be generating the data I need into excel 
files in (generally) the format I need.

Child:
Freq +d5 +d2 +t at ID=”*|Target_Child|*” +s at CutFileAllCodes.cut +fCHI_AllCodes 
*.cha
Parent:
Freq +d5 +d2 +t at ID=”*|Target_Adult|*” +s at CutFileAllCodes.cut +fPAR_AllCodes 
*.cha
iPad:
Freq +d5 +d2 +t at ID=”*|Toy|*” +s at CutFileAllCodes.cut +fIPA_AllCodes *.cha
Parent and iPad:
Freq +d5 +d2 +t at ID=”*|Target_Adult|*” +t at ID=”*|Toy|*” +o3 
+s at CutFileAllCodes.cut +fPARIPA_AllCodes *.cha

However, I have three problems I am hoping to solve.  I am repeating this 
set of 4 freq analyses for 7 groups of codes/words (which will replace the 
cut file referenced in +s).  So I will have at least 28 commands and 28 
excel files I will need to combine into a single database for analysis.  I 
would love to automate this data generation and combination as much as 
possible.


1)  Every time I run these commands separately they work fine.  If I try to 
run them as a batch by using the attached batch file (command "batch 
BatchCommands.cex") I get an output that says "Using search file: 
C:\talkbank\clan\work\CutFileAllCodes.cut" was found.  CAN'T FIND ANY DATA 
TIERS IN ANY OF INPUT FILES PLEASE PROVIDE A SPECIFIC SPEAKER WITH +t 
OPTION"  The batch commands results in a repeat of this same warning 4 
times and produces nothing.  The batch file is in the "work" directory as 
well as the "CutFileAllCodes.cut" file and all of the chat files.  Not sure 
why it does not seem to be able to find these.  It would be nice to set 
these up in a file and just run them all at once.  Plus it will make the 
stats more easily reproducible and better documented.


2)  Ultimately I would like one database with a single line for each 
transcription and the counts/stats generated from each of my commands in 
rows going across.  Is there a way to have CLAN automatically append data 
and match the data into a single row for each file as each additional 
command is run?  


3)  If there is nothing I can do for number 2, then it would be really nice 
if I could solve another problem.  Since the iPad codes are only in about 
1/3 of the files, when the excel sheet is produced for the iPad commands, 
it doesn't produce a row for every analyzed file.  Therefore, the excel 
file is "shorter" than the rest and when I go to paste this data in with 
the other data, I have to match the iPad data for each participant with the 
data output from the rest of the files.  If I could have CLAN output 
0's/periods/blanks for the files that are analyzed I can write a *very 
simple* copy/paste macro to combine the excel files.  Is there a way to 
tell CLAN to produce output for every analyzed file even if the tier is 
missing?


Thanks for any help!

Brian



-- 
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/f739fe4d-d3f2-4a52-9f7a-95225a4e3a68%40googlegroups.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/20160229/f2292dae/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: BatchCommands.cex
Type: application/octet-stream
Size: 398 bytes
Desc: not available
URL: <http://listserv.linguistlist.org/pipermail/chibolts/attachments/20160229/f2292dae/attachment.obj>