## Using AWK to Calculate Correct Responses

Using AWK to Calculate Correct Responses
# 1
Using AWK to Calculate Correct Responses

Hello,

I am trying to count how many times a subject makes a correct switch or a correct stay response in a simple task. I have data on which condition they were in (here, labeled "IMAGINE" and "RECALL"), as well as whether they made a left or right button response, and whether the outcome was an error or a correct outcome.

In the IMAGINE condition, I am coding their response as correct if they receive a correct outcome and make the same response on the next trial. I am also coding their response as correct if they receive an error outcome and switch their response on the next trial.

In the RECALL condition, I am coding their response as correct if they make the same response as they did on the previous trial, regardless of whether they received a correct or error outcome on that trial.

Here is a sample of the output I am trying to run through awk:

The data are in groups of three. For example, the first three lines can be thought of as: "Condition = IMAGINE, Response = left, Outcome = correct".

What I want to do is tally how many correct or incorrect switches they made in each condition. In this example, the first response results in a correct outcome, and the subject makes the same response on the next trial, which would be counted as a correct response. On the RECALL trial, the participant also makes a correct response, since the response is the same as the last trial, even though that trial resulted in an error outcome. The last trial is actually an incorrect response, since it is in the IMAGINE condition and the last outcome was correct, and they switched their response.

Is awk the best tool to use for this? My problem is that I need to store the previous response and outcome, and then compare it against the current response and outcome, taking into account which condition it is. Any help would be greatly appreciated.

Thanks,

-Jahn
 Jahn View Public Profile for Jahn Find all posts by Jahn
# 2
Can you show us what would be the desired output for this sample data?
 bartus11 View Public Profile for bartus11 Find all posts by bartus11
# 3
Yes; in this example, I would expect the output to be:

Thanks,

-Jahn
 Jahn View Public Profile for Jahn Find all posts by Jahn
# 4
So it is as simple as counting "correct" and "error" words in those two sections? If so, then try this:
 bartus11 View Public Profile for bartus11 Find all posts by bartus11
# 5
Not quite. "Correct" and "Error" refer to the outcome that they received, not whether they made the right response or not. For example, in the last IMAGINE condition the participant makes an incorrect response; since the last trial resulted in a correct outcome, they should have made the same response.

Let me know if that makes sense!

-Jahn
 Jahn View Public Profile for Jahn Find all posts by Jahn
# 6
I think the correct output in this case should be: Because you cannot determine whether first record (IMAGINE) is correct or not, as you don't have previous record to analyze response. Try this script: Run it like this: ./script.pl your_file
 bartus11 View Public Profile for bartus11 Find all posts by bartus11

Test Your Knowledge in Computers #942
Difficulty: Medium
The underlying Data Link Layer never poses limits to the maximum frame size.
True or False?

## awk output is not the correct count

The awk below runs and produces the following output on the file2. This is just an example of the format as the file is ~14MB. file1.txt is attached. I am trying to count the ids that match between the two files and out the ids that are missing. Thank you :). file2 970 NM_213590 ...

## How to correct this awk code without eval?

Hi everyone, The following piece of awk code works fine if I use eval builtin var='\$1,\$2' ps | eval "awk '{print \$var}'" But when I try to knock off eval and use awk variable as substitute then I am not getting the expected result ps | awk -v v1=\$var '{print v1}' # output is \$1,\$2 ps |...

## Cannot get the correct ans. Using awk in taking average

Hi all, I think so I’m getting the result is wrong, while using following awk commend, colval=\$(awk 'FNR>1 && NR==FNR{a=\$4;next;} FNR>1 {a+=\$4; print \$2"\t"a/3}' filename_f.tsv filename_f2.tsv filename_f3.tsv) echo \$colval >> Result.tsv it’s doing the condition 2 times, first result...

## Help to get correct data using awk

I have this input.|user1 |10.10.10.10 |23|046|1726 (212) |0 |user2 |10.10.10.11 |23|046|43 (17) |0 |test |10.10.10.12 |23|046|45 (10) |0 |test1 |10.10.10.13 |23|046|89 (32) |0 I need to get the data for a user like thisuser1 1726 user2 43 test 45 test1 89...

## Awk Script Counting of Correct vs. Error Responses

Hello, I have been trying to use an awk script to parse out correct and incorrect answers in a simple tab-delimited text file. I am trying to compare the user's response to the stimulus presented (in this case, an arrow pointing left or right; e.g., "<--" vs. "-->"). I have the data for the...

## AWK or SED for correct columns

Hello, I have the following file, but one of his columns is not in place, and tried with SED and AWK, how I can correct format? In the second line break is wrong, and puts it after the first column of next line I would appreciate if you could guide me on the subject.

## Calculate P Value -Awk

Is there any awk command to calculate P Value ?(Probability) Is it possib;e to calculate P va;ue for this data for ex? 7.891284 8.148193 7.749575 7.958188 7.887702 7.714877 8.141548 7.51845 8.27736 7.929853 7.92456 8.249126 7.989113 8.012573 8.351206

## Awk error -- awk: 0602-562 Field \$() is not correct.

typeset -i i=1 while read -r filename; do Splitfile=`\$Targetfile_\$i.txt` awk 'substr(\$0,1,5) == substr(\$filename,1,5) && substr(\$0,526,2) == substr(\$filename,6,2) && substr(\$0,750,12) == substr(\$filename,8,12)' \$SourceFilename >> \$Splitfile i=i+1 done < /tmp/list.out I am using this logic...

## AWK not giving me correct output.

i have a line like this in my script IP=`get_IP <hostname> | awk '{ print \$1 }' echo \$IP the problem is get_IP <hostname> returns data formated as follows: ip 1.1.1.1 name server_name the code above returns 1.1.1.1 server_name and i just need the 1.1.1.1 I have tried to add "|...

## How to calculate with awk

Hi, I have below awk statement and I need to convert the second field ( substr(\$0,8,6))from minutes to hours with 2 decimail place. How can I achieve this? /usr/bin/awk '{print substr(\$0,23,4),substr(\$0,8,6)}' /tmp/MANAGER_LIST.\$\$ >> /tmp/NEWMANAGER_LIST.\$\$ Thanks for any help!