On using E-DataAid: WAS: Converting an Edat file into either a .xls or .txt file

Daniel schizophrenicdan at gmail.com
Fri Feb 15 18:25:53 UTC 2013


You're absolutely right and it does seem that there are more things I can 
do with E-DataAid than I realized. I should have been more specific about 
what I had in mind, but the data conversions I run with spss syntax tend to 
be extensive and I was too lazy to type them out. The methods that you 
suggested below will really help with some of my other data sets that need 
less conversions, thank you. The conversions I needed to do involved 
generating probabilities for a bunch of different numbers (and the format 
of the E-DataAid file was less user friendly, but that was because of how 
the task was put together in E-Prime) and then some of my other datasets I 
create distributional plots of accuracy (or other things) by reaction time 
and plot between 5-9 cells of 20+ RT scores or more. So, generally I think 
I need to use either SPSS syntax or Matlab to do this stuff (though I am 
sure Excel could do it too).

I did find a fairly easy way to split after having used e-merge and then 
converting it to an excel document in E-Dataid. I then opened the data in 
excel and got rid of any columns I did not care about and then opened it in 
SPSS. I used the SPSS programmability extension and then installed a custom 
dialog called "SPSSINC_SPLIT_DATASET.spd" which you can get on the IBM spss 
DeveloperWorks website and it easily will split the file by whatever 
variables and spit out the data with any names you want. Then I just ran my 
script (that calculates probability, generates ACC, etc.) using 
"SPSSINC_PROCESS_FILES.spd" which allowed me to iterate over all subject 
files in a folder and spit out the data into a database. 

On Wednesday, February 13, 2013 8:27:06 AM UTC-5, Michiel Sovijärvi-Spapé 
wrote:
>
> Hi,
>
> If you’re not YET doing it, I urge you to have another look at what is 
> possible with e-DataAid. The reason is that I know many students 1) know 
> SPSS fairly well, and a bit of Excel, and try to avoid E-***. Not saying 
> that counts for you as well. Indeed, this is a bit of a shot in the dark, 
> but with such sentences as “I have a large number of subject edat files 
> (500+) and I like the column/row format that the Excel export option that 
> E-DataAid uses so that I can easily convert the data into a format I like 
> using spss syntax”, it’s difficult to avoid guessing! You might want to 
> say something about what you’re planning to do, but in its absence, let’s 
> have an example from my own life, and maybe it helps?
>
> ·         What I like is having a good amount of Repeated Measures ANOVA 
> style formatted columns, say, RTs of 2x4 conditions, one row per subject. 
> For SPSS. What I have is 500 .edats. Arggh, right?
>
> 1.       We merge all files to one big .emrg, which we then open in .edat
>
> 2.       We filter out those RTs we are not interested in, say, the ones 
> in which an error occurs. Also, I don’t like trials 1:20.
>
> 3.       Now, we go to analyze, drag Subject to the Row, and any type of 
> between-subject variable (sex, age, etc). 
>
> 4.       Then drag ConditionP1vs2 to columns, drag ConditionQ1vs2vs3vs4 
> to columns. Drag the critical RT thing to the Data bit. Press Run.
>
> 5.       So, we should see a nice table of at least 500x8. Oops, it’s got 
> two decimals.. why? Make that 4. Select all of it, copy the bunch to excel.
>
> 6.       Inside excel, underneath the two rows with variables (rows A and 
> B), insert a new row (say C). Enter the wonderful formula =A&”_”&B and drag 
> it all across row C.
>
> 7.       Select row C, copy, go stand in an empty bit, paste special: 
> values only, and transpose. Copy that, go to SPSS, paste in variables: now, 
> that’s descriptive indeed. 
>
> 8.       Copy all the values over to SPSS (but you’ll have to reassign 
> string values from numeric for some columns).
>
>  
>
> These 8 steps, lengthy as they may seem, take me about 2 minutes, and I 
> think it’s a great workflow. 
>
> TLDR? Try E-DataAid, it’s ridiculously simple, really rocks, and SPSS is 
> best avoided as they make it slower and buggier with every next release. 
>
>  
>
> PS: Paul, I find Excel not at all slow with large data-files? Much faster 
> than SPSS, at least, or at least it has been between excel 2007 and 2010 
> (2013 beta was running very slow here); it does not cope very well with 
> large and lengthy formulas that need repeated recalculation and take up 
> more than hundreds of MBs, though. 
>
>  
>
> Best,
>
> Michiel
>
>  
>
>  
>
> *From:* e-p... at googlegroups.com <javascript:> [mailto:
> e-p... at googlegroups.com <javascript:>] *On Behalf Of *Daniel
> *Sent:* 11. February 2013 23:02
> *To:* e-p... at googlegroups.com <javascript:>
> *Subject:* Re: Converting an Edat file into either a .xls or .txt file
>
>  
>
> Yeah, I will probably just end up splitting it using a SPSS syntax script 
> (I am not very familiar with Matlab yet), it will be a little bit tedious 
> but faster than doing it manually.
>
>  
>
> Thanks for the input.
>
> On Friday, February 8, 2013 6:49:09 PM UTC-5, Daniel wrote:
>
> I have a large number of subject edat files (500+) and I like the 
> column/row format that the Excel export option that E-DataAid uses so that 
> I can easily convert the data into a format I like using spss syntax. Is 
> there a faster way to convert all of these subject files into the excel 
> format, some sort of way to iterate over all files in a folder, instead of 
> having to open each one and export them separately?
>
>  
>
> Thanks.
>
>  
>
>  
>
> -- 
> You received this message because you are subscribed to the Google Groups 
> "E-Prime" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to e-prime+u... at googlegroups.com <javascript:>.
> To post to this group, send email to e-p... at googlegroups.com <javascript:>
> .
> To view this discussion on the web visit 
> https://groups.google.com/d/msg/e-prime/-/r4EG1vCaqgIJ.
> For more options, visit https://groups.google.com/groups/opt_out.
>  
>  
>

-- 
You received this message because you are subscribed to the Google Groups "E-Prime" group.
To unsubscribe from this group and stop receiving emails from it, send an email to e-prime+unsubscribe at googlegroups.com.
To post to this group, send email to e-prime at googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msg/e-prime/-/0SWbc53V830J.
For more options, visit https://groups.google.com/groups/opt_out.


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listserv.linguistlist.org/pipermail/eprime/attachments/20130215/81884baf/attachment.htm>


More information about the Eprime mailing list