In [1]:
%pylab inline
Populating the interactive namespace from numpy and matplotlib
In [2]:
import pandas as pd
inFile = "GESTASL-s001-Run1_log.csv"
df = pd.read_csv(inFile)
In [99]:
df
Out[99]:
Date
Time
File
Subj
Cond
Block
Trial
Order
Resp
Name
...
Stim 3
Time 3
Stim 4
Time 4
Stim 5
Time 5
Stim 6
Time 6
Unnamed: 28
StimType
0
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
0
1.01
41
GRAVE
...
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
1
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
0
2.01
-1
NaN
...
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
2
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
1
3.01
1
1
...
CTRL_GES_VMP_13.wmv (640x480) <1>
5406
NaN
2101
ctrl_yes.bmp <2>
0
ctrl_no.bmp <2>
2103
NaN
CTR
3
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
2
4.01
1
1
...
CTRL_GES_VMP_16.wmv (640x480) <1>
9594
NaN
1819
ctrl_no.bmp <2>
0
ctrl_yes.bmp <2>
2152
NaN
CTR
4
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
3
5.01
2
2
...
GES_PIC_10.wmv (640x480) <1>
6907
NaN
2051
GES_PIC_10_foil.bmp <2>
0
GES_PIC_10_target.bmp <2>
3053
NaN
GES
5
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
4
6.01
2
2
...
GES_PIC_06.wmv (640x480) <1>
7107
NaN
1619
GES_PIC_06_foil.bmp <2>
0
GES_PIC_06_target.bmp <2>
2336
NaN
GES
6
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
5
7.01
1
1
...
CTRL_GES_VMP_3.wmv (640x480) <1>
5706
NaN
1251
ctrl_yes.bmp <2>
0
ctrl_no.bmp <2>
1219
NaN
CTR
7
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
6
8.01
1
1
...
GES_PIC_18.wmv (640x480) <1>
4606
NaN
1751
GES_PIC_18_target.bmp <2>
0
GES_PIC_18_foil.bmp <2>
2519
NaN
GES
8
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
7
9.01
2
2
...
CTRL_GES_PIC_1.wmv (640x480) <1>
4504
NaN
2704
ctrl_yes.bmp <2>
0
ctrl_no.bmp <2>
1151
NaN
CTR
9
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
8
10.01
2
2
...
CTRL_GES_VMP_9.wmv (640x480) <1>
9593
NaN
1818
ctrl_no.bmp <2>
0
ctrl_yes.bmp <2>
1468
NaN
CTR
10
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
9
11.01
2
2
...
CTRL_GES_PIC_16.wmv (640x480) <1>
9092
NaN
434
ctrl_yes.bmp <2>
0
ctrl_no.bmp <2>
1352
NaN
CTR
11
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
10
12.01
2
2
...
CTRL_GES_PIC_8.wmv (640x480) <1>
7591
NaN
2687
ctrl_no.bmp <2>
0
ctrl_yes.bmp <2>
2786
NaN
CTR
12
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
11
13.01
2
2
...
GES_PIC_32.wmv (640x480) <1>
6606
NaN
2186
GES_PIC_32_foil.bmp <2>
0
GES_PIC_32_target.bmp <2>
2552
NaN
GES
13
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
12
14.01
1
1
...
CTRL_GES_PIC_15.wmv (640x480) <1>
9093
NaN
2652
ctrl_no.bmp <2>
0
ctrl_yes.bmp <2>
735
NaN
CTR
14
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
13
15.01
1
1
...
CTRL_GES_VMP_18.wmv (640x480) <1>
8193
NaN
734
ctrl_yes.bmp <2>
0
ctrl_no.bmp <2>
2152
NaN
CTR
15
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
14
16.01
1
1
...
GES_VMP_01.wmv (640x480) <1>
3804
NaN
2420
GES_VMP_01_target.bmp <2>
0
GES_VMP_01_foil.bmp <2>
2837
NaN
GES
16
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
15
17.01
2
2
...
GES_VMP_37.wmv (640x480) <1>
9994
NaN
1768
GES_VMP_37_foil.bmp <2>
0
GES_VMP_37_target.bmp <2>
2503
NaN
GES
17
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
16
18.01
1
1
...
CTRL_GES_VMP_15.wmv (640x480) <1>
7407
NaN
2637
ctrl_no.bmp <2>
0
ctrl_yes.bmp <2>
2536
NaN
CTR
18
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
17
19.01
2
2
...
GES_VMP_11.wmv (640x480) <1>
5806
NaN
2586
GES_VMP_11_foil.bmp <2>
0
GES_VMP_11_target.bmp <2>
3154
NaN
GES
19
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
18
20.01
2
2
...
GES_PIC_02.wmv (640x480) <1>
5890
NaN
417
GES_PIC_02_foil.bmp <2>
0
GES_PIC_02_target.bmp <2>
2653
NaN
GES
20
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
19
21.01
1
1
...
GES_VMP_39.wmv (640x480) <1>
10094
NaN
617
GES_VMP_39_target.bmp <2>
0
GES_VMP_39_foil.bmp <2>
2553
NaN
GES
21
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
20
22.01
1
1
...
CTRL_GES_PIC_5.wmv (640x480) <1>
6791
NaN
968
ctrl_no.bmp <2>
0
ctrl_yes.bmp <2>
685
NaN
CTR
22
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
21
23.01
2
2
...
CTRL_GES_VMP_20.wmv (640x480) <1>
8708
NaN
1702
ctrl_no.bmp <2>
0
ctrl_yes.bmp <2>
2536
NaN
CTR
23
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
22
24.01
1
1
...
GES_PIC_34.wmv (640x480) <1>
6791
NaN
2151
GES_PIC_34_target.bmp <2>
0
GES_PIC_34_foil.bmp <2>
1936
NaN
GES
24
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
23
25.01
-1
-1
...
GES_VMP_03.wmv (640x480) <1>
4203
NaN
1536
GES_VMP_03_foil.bmp <2>
0
GES_VMP_03_target.bmp <2>
3503
NaN
GES
25
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
24
26.01
2
2
...
CTRL_GES_PIC_19.wmv (640x480) <1>
6591
NaN
2386
ctrl_no.bmp <2>
0
ctrl_yes.bmp <2>
851
NaN
CTR
26
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
25
27.01
1
1
...
GES_PIC_30.wmv (640x480) <1>
9093
NaN
1919
GES_PIC_30_target.bmp <2>
0
GES_PIC_30_foil.bmp <2>
2687
NaN
GES
27
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
26
28.01
2
2
...
GES_VMP_29.wmv (640x480) <1>
9192
NaN
2470
GES_VMP_29_foil.bmp <2>
0
GES_VMP_29_target.bmp <2>
2936
NaN
GES
28
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
27
29.01
2
2
...
CTRL_GES_PIC_12.wmv (640x480) <1>
6590
NaN
968
ctrl_yes.bmp <2>
0
ctrl_no.bmp <2>
1402
NaN
CTR
29
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
28
30.01
1
1
...
GES_VMP_09.wmv (640x480) <1>
5589
NaN
701
GES_VMP_09_target.bmp <2>
0
GES_VMP_09_foil.bmp <2>
3371
NaN
GES
30
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
29
31.01
2
2
...
CTRL_GES_VMP_4.wmv (640x480) <1>
5806
NaN
1351
ctrl_yes.bmp <2>
0
ctrl_no.bmp <2>
1469
NaN
CTR
31
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
30
32.01
1
1
...
GES_PIC_22.wmv (640x480) <1>
7491
NaN
2485
GES_PIC_22_target.bmp <2>
0
GES_PIC_22_foil.bmp <2>
2453
NaN
GES
32
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
31
33.01
2
2
...
CTRL_GES_VMP_6.wmv (640x480) <1>
7191
NaN
1418
ctrl_no.bmp <2>
0
ctrl_yes.bmp <2>
985
NaN
CTR
33
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
32
34.01
1
1
...
CTRL_GES_PIC_7.wmv (640x480) <1>
7391
NaN
1552
ctrl_yes.bmp <2>
0
ctrl_no.bmp <2>
868
NaN
CTR
34
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
33
35.01
2
2
...
GES_VMP_27.wmv (640x480) <1>
8893
NaN
1150
GES_VMP_27_foil.bmp <2>
0
GES_VMP_27_target.bmp <2>
3238
NaN
GES
35
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
34
36.01
2
2
...
GES_PIC_16.wmv (640x480) <1>
6606
NaN
2186
GES_PIC_16_foil.bmp <2>
0
GES_PIC_16_target.bmp <2>
2803
NaN
GES
36
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
35
37.01
1
1
...
GES_VMP_25.wmv (640x480) <1>
8693
NaN
2837
GES_VMP_25_target.bmp <2>
0
GES_VMP_25_foil.bmp <2>
3053
NaN
GES
37
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
36
38.01
2
2
...
CTRL_GES_PIC_17.wmv (640x480) <1>
5005
NaN
1768
ctrl_no.bmp <2>
0
ctrl_yes.bmp <2>
885
NaN
CTR
38
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
37
39.01
2
2
...
CTRL_GES_PIC_13.wmv (640x480) <1>
6991
NaN
1351
ctrl_yes.bmp <2>
0
ctrl_no.bmp <2>
1152
NaN
CTR
39
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
38
40.01
-1
-1
...
GES_VMP_31.wmv (640x480) <1>
9593
NaN
2469
GES_VMP_31_target.bmp <2>
0
GES_VMP_31_foil.bmp <2>
3504
NaN
GES
40 rows × 30 columns
Get list of all column names and data type of each:
In [100]:
df.dtypes
Out[100]:
Date object
Time object
File object
Subj int64
Cond int64
Block int64
Trial int64
Order float64
Resp int64
Name object
Stim object
RT int64
Correct bool
Started@ int64
LoadTime int64
TotalInt int64
Stim 1 object
Time 1 int64
Stim 2 object
Time 2 float64
Stim 3 object
Time 3 float64
Stim 4 float64
Time 4 float64
Stim 5 object
Time 5 float64
Stim 6 object
Time 6 float64
Unnamed: 28 float64
StimType object
dtype: object
In [83]:
df['Correct']
Out[83]:
0 True
1 True
2 True
3 False
4 True
5 True
6 True
7 True
8 False
9 True
10 False
11 True
12 True
13 False
14 True
15 True
16 True
17 False
18 True
19 True
20 True
21 False
22 True
23 True
24 False
25 True
26 True
27 True
28 False
29 True
30 False
31 True
32 True
33 True
34 True
35 True
36 True
37 True
38 False
39 False
Name: Correct, dtype: bool
In [84]:
df['Stim 3']
Out[84]:
Stim 3
RT
0
NaN
18582
1
NaN
7996
2
CTRL_GES_VMP_13.wmv (640x480) <1>
2086
3
CTRL_GES_VMP_16.wmv (640x480) <1>
2143
4
GES_PIC_10.wmv (640x480) <1>
3046
5
GES_PIC_06.wmv (640x480) <1>
2331
6
CTRL_GES_VMP_3.wmv (640x480) <1>
1216
7
GES_PIC_18.wmv (640x480) <1>
2513
8
CTRL_GES_PIC_1.wmv (640x480) <1>
1147
9
CTRL_GES_VMP_9.wmv (640x480) <1>
1463
10
CTRL_GES_PIC_16.wmv (640x480) <1>
1348
11
CTRL_GES_PIC_8.wmv (640x480) <1>
2774
12
GES_PIC_32.wmv (640x480) <1>
2546
13
CTRL_GES_PIC_15.wmv (640x480) <1>
729
14
CTRL_GES_VMP_18.wmv (640x480) <1>
2149
15
GES_VMP_01.wmv (640x480) <1>
2827
16
GES_VMP_37.wmv (640x480) <1>
2493
17
CTRL_GES_VMP_15.wmv (640x480) <1>
2530
18
GES_VMP_11.wmv (640x480) <1>
3146
19
GES_PIC_02.wmv (640x480) <1>
2637
20
GES_VMP_39.wmv (640x480) <1>
2541
21
CTRL_GES_PIC_5.wmv (640x480) <1>
670
22
CTRL_GES_VMP_20.wmv (640x480) <1>
2527
23
GES_PIC_34.wmv (640x480) <1>
1929
24
GES_VMP_03.wmv (640x480) <1>
3501
25
CTRL_GES_PIC_19.wmv (640x480) <1>
844
26
GES_PIC_30.wmv (640x480) <1>
2674
27
GES_VMP_29.wmv (640x480) <1>
2929
28
CTRL_GES_PIC_12.wmv (640x480) <1>
1396
29
GES_VMP_09.wmv (640x480) <1>
3360
30
CTRL_GES_VMP_4.wmv (640x480) <1>
1466
31
GES_PIC_22.wmv (640x480) <1>
2439
32
CTRL_GES_VMP_6.wmv (640x480) <1>
971
33
CTRL_GES_PIC_7.wmv (640x480) <1>
860
34
GES_VMP_27.wmv (640x480) <1>
3236
35
GES_PIC_16.wmv (640x480) <1>
2795
36
GES_VMP_25.wmv (640x480) <1>
3042
37
CTRL_GES_PIC_17.wmv (640x480) <1>
882
38
CTRL_GES_PIC_13.wmv (640x480) <1>
1150
39
GES_VMP_31.wmv (640x480) <1>
3501
In [21]:
df['Stim 3'][3:5]
Out[21]:
3 CTRL_GES_VMP_16.wmv (640x480) <1>
4 GES_PIC_10.wmv (640x480) <1>
Name: Stim 3, dtype: object
In [85]:
df[['Stim 3','Correct']][3:5]
Out[85]:
Stim 3
Correct
3
CTRL_GES_VMP_16.wmv (640x480) <1>
False
4
GES_PIC_10.wmv (640x480) <1>
True
In [53]:
df['Stim 3'][0:5].str[:3]
Out[53]:
0 NaN
1 NaN
2 CTR
3 CTR
4 GES
Name: Stim 3, dtype: object
In [72]:
df['Stim 3'][0:5].str[:3].isin(['GES','CTR'])
Out[72]:
0 False
1 False
2 True
3 True
4 True
Name: Stim 3, dtype: bool
In [92]:
df['StimType'] = df['Stim 3'].str[:3]
df
Out[92]:
Date
Time
File
Subj
Cond
Block
Trial
Order
Resp
Name
...
Stim 3
Time 3
Stim 4
Time 4
Stim 5
Time 5
Stim 6
Time 6
Unnamed: 28
StimType
0
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
0
1.01
41
GRAVE
...
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
1
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
0
2.01
-1
NaN
...
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
2
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
1
3.01
1
1
...
CTRL_GES_VMP_13.wmv (640x480) <1>
5406
NaN
2101
ctrl_yes.bmp <2>
0
ctrl_no.bmp <2>
2103
NaN
CTR
3
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
2
4.01
1
1
...
CTRL_GES_VMP_16.wmv (640x480) <1>
9594
NaN
1819
ctrl_no.bmp <2>
0
ctrl_yes.bmp <2>
2152
NaN
CTR
4
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
3
5.01
2
2
...
GES_PIC_10.wmv (640x480) <1>
6907
NaN
2051
GES_PIC_10_foil.bmp <2>
0
GES_PIC_10_target.bmp <2>
3053
NaN
GES
5
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
4
6.01
2
2
...
GES_PIC_06.wmv (640x480) <1>
7107
NaN
1619
GES_PIC_06_foil.bmp <2>
0
GES_PIC_06_target.bmp <2>
2336
NaN
GES
6
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
5
7.01
1
1
...
CTRL_GES_VMP_3.wmv (640x480) <1>
5706
NaN
1251
ctrl_yes.bmp <2>
0
ctrl_no.bmp <2>
1219
NaN
CTR
7
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
6
8.01
1
1
...
GES_PIC_18.wmv (640x480) <1>
4606
NaN
1751
GES_PIC_18_target.bmp <2>
0
GES_PIC_18_foil.bmp <2>
2519
NaN
GES
8
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
7
9.01
2
2
...
CTRL_GES_PIC_1.wmv (640x480) <1>
4504
NaN
2704
ctrl_yes.bmp <2>
0
ctrl_no.bmp <2>
1151
NaN
CTR
9
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
8
10.01
2
2
...
CTRL_GES_VMP_9.wmv (640x480) <1>
9593
NaN
1818
ctrl_no.bmp <2>
0
ctrl_yes.bmp <2>
1468
NaN
CTR
10
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
9
11.01
2
2
...
CTRL_GES_PIC_16.wmv (640x480) <1>
9092
NaN
434
ctrl_yes.bmp <2>
0
ctrl_no.bmp <2>
1352
NaN
CTR
11
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
10
12.01
2
2
...
CTRL_GES_PIC_8.wmv (640x480) <1>
7591
NaN
2687
ctrl_no.bmp <2>
0
ctrl_yes.bmp <2>
2786
NaN
CTR
12
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
11
13.01
2
2
...
GES_PIC_32.wmv (640x480) <1>
6606
NaN
2186
GES_PIC_32_foil.bmp <2>
0
GES_PIC_32_target.bmp <2>
2552
NaN
GES
13
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
12
14.01
1
1
...
CTRL_GES_PIC_15.wmv (640x480) <1>
9093
NaN
2652
ctrl_no.bmp <2>
0
ctrl_yes.bmp <2>
735
NaN
CTR
14
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
13
15.01
1
1
...
CTRL_GES_VMP_18.wmv (640x480) <1>
8193
NaN
734
ctrl_yes.bmp <2>
0
ctrl_no.bmp <2>
2152
NaN
CTR
15
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
14
16.01
1
1
...
GES_VMP_01.wmv (640x480) <1>
3804
NaN
2420
GES_VMP_01_target.bmp <2>
0
GES_VMP_01_foil.bmp <2>
2837
NaN
GES
16
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
15
17.01
2
2
...
GES_VMP_37.wmv (640x480) <1>
9994
NaN
1768
GES_VMP_37_foil.bmp <2>
0
GES_VMP_37_target.bmp <2>
2503
NaN
GES
17
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
16
18.01
1
1
...
CTRL_GES_VMP_15.wmv (640x480) <1>
7407
NaN
2637
ctrl_no.bmp <2>
0
ctrl_yes.bmp <2>
2536
NaN
CTR
18
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
17
19.01
2
2
...
GES_VMP_11.wmv (640x480) <1>
5806
NaN
2586
GES_VMP_11_foil.bmp <2>
0
GES_VMP_11_target.bmp <2>
3154
NaN
GES
19
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
18
20.01
2
2
...
GES_PIC_02.wmv (640x480) <1>
5890
NaN
417
GES_PIC_02_foil.bmp <2>
0
GES_PIC_02_target.bmp <2>
2653
NaN
GES
20
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
19
21.01
1
1
...
GES_VMP_39.wmv (640x480) <1>
10094
NaN
617
GES_VMP_39_target.bmp <2>
0
GES_VMP_39_foil.bmp <2>
2553
NaN
GES
21
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
20
22.01
1
1
...
CTRL_GES_PIC_5.wmv (640x480) <1>
6791
NaN
968
ctrl_no.bmp <2>
0
ctrl_yes.bmp <2>
685
NaN
CTR
22
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
21
23.01
2
2
...
CTRL_GES_VMP_20.wmv (640x480) <1>
8708
NaN
1702
ctrl_no.bmp <2>
0
ctrl_yes.bmp <2>
2536
NaN
CTR
23
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
22
24.01
1
1
...
GES_PIC_34.wmv (640x480) <1>
6791
NaN
2151
GES_PIC_34_target.bmp <2>
0
GES_PIC_34_foil.bmp <2>
1936
NaN
GES
24
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
23
25.01
-1
-1
...
GES_VMP_03.wmv (640x480) <1>
4203
NaN
1536
GES_VMP_03_foil.bmp <2>
0
GES_VMP_03_target.bmp <2>
3503
NaN
GES
25
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
24
26.01
2
2
...
CTRL_GES_PIC_19.wmv (640x480) <1>
6591
NaN
2386
ctrl_no.bmp <2>
0
ctrl_yes.bmp <2>
851
NaN
CTR
26
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
25
27.01
1
1
...
GES_PIC_30.wmv (640x480) <1>
9093
NaN
1919
GES_PIC_30_target.bmp <2>
0
GES_PIC_30_foil.bmp <2>
2687
NaN
GES
27
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
26
28.01
2
2
...
GES_VMP_29.wmv (640x480) <1>
9192
NaN
2470
GES_VMP_29_foil.bmp <2>
0
GES_VMP_29_target.bmp <2>
2936
NaN
GES
28
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
27
29.01
2
2
...
CTRL_GES_PIC_12.wmv (640x480) <1>
6590
NaN
968
ctrl_yes.bmp <2>
0
ctrl_no.bmp <2>
1402
NaN
CTR
29
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
28
30.01
1
1
...
GES_VMP_09.wmv (640x480) <1>
5589
NaN
701
GES_VMP_09_target.bmp <2>
0
GES_VMP_09_foil.bmp <2>
3371
NaN
GES
30
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
29
31.01
2
2
...
CTRL_GES_VMP_4.wmv (640x480) <1>
5806
NaN
1351
ctrl_yes.bmp <2>
0
ctrl_no.bmp <2>
1469
NaN
CTR
31
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
30
32.01
1
1
...
GES_PIC_22.wmv (640x480) <1>
7491
NaN
2485
GES_PIC_22_target.bmp <2>
0
GES_PIC_22_foil.bmp <2>
2453
NaN
GES
32
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
31
33.01
2
2
...
CTRL_GES_VMP_6.wmv (640x480) <1>
7191
NaN
1418
ctrl_no.bmp <2>
0
ctrl_yes.bmp <2>
985
NaN
CTR
33
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
32
34.01
1
1
...
CTRL_GES_PIC_7.wmv (640x480) <1>
7391
NaN
1552
ctrl_yes.bmp <2>
0
ctrl_no.bmp <2>
868
NaN
CTR
34
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
33
35.01
2
2
...
GES_VMP_27.wmv (640x480) <1>
8893
NaN
1150
GES_VMP_27_foil.bmp <2>
0
GES_VMP_27_target.bmp <2>
3238
NaN
GES
35
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
34
36.01
2
2
...
GES_PIC_16.wmv (640x480) <1>
6606
NaN
2186
GES_PIC_16_foil.bmp <2>
0
GES_PIC_16_target.bmp <2>
2803
NaN
GES
36
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
35
37.01
1
1
...
GES_VMP_25.wmv (640x480) <1>
8693
NaN
2837
GES_VMP_25_target.bmp <2>
0
GES_VMP_25_foil.bmp <2>
3053
NaN
GES
37
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
36
38.01
2
2
...
CTRL_GES_PIC_17.wmv (640x480) <1>
5005
NaN
1768
ctrl_no.bmp <2>
0
ctrl_yes.bmp <2>
885
NaN
CTR
38
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
37
39.01
2
2
...
CTRL_GES_PIC_13.wmv (640x480) <1>
6991
NaN
1351
ctrl_yes.bmp <2>
0
ctrl_no.bmp <2>
1152
NaN
CTR
39
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
38
40.01
-1
-1
...
GES_VMP_31.wmv (640x480) <1>
9593
NaN
2469
GES_VMP_31_target.bmp <2>
0
GES_VMP_31_foil.bmp <2>
3504
NaN
GES
40 rows × 30 columns
In [103]:
startTime = df['Started@'][1]
# Uncomment to check we're getting the right value:
# startTime
Out[103]:
18886
In [108]:
# Get start time of each movie, in seconds, relative to start time of MRI scan:
df['MovieStartTime'] = (df['Started@'] - startTime + df['TotalInt'] + df['Time 1'] + df['Time 2'])/1000
# Check results:
df['MovieStartTime']
Out[108]:
0 NaN
1 NaN
2 13.796
3 26.926
4 48.050
5 61.596
6 74.142
7 85.804
8 96.132
9 105.993
10 122.175
11 134.354
12 148.753
13 161.399
14 175.179
15 189.561
16 199.939
17 215.506
18 229.403
19 242.283
20 252.661
21 267.225
22 284.962
23 303.297
24 315.477
25 328.022
26 339.267
27 354.334
28 370.233
29 380.527
30 391.489
31 403.502
32 423.238
33 434.133
34 451.301
35 467.919
36 482.883
37 504.757
38 515.718
39 532.586
Name: MovieStartTime, dtype: float64
In [117]:
df['MovieDuration'] = df['Time 3']/1000
df['MovieDuration']
Out[117]:
0 NaN
1 NaN
2 5.406
3 9.594
4 6.907
5 7.107
6 5.706
7 4.606
8 4.504
9 9.593
10 9.092
11 7.591
12 6.606
13 9.093
14 8.193
15 3.804
16 9.994
17 7.407
18 5.806
19 5.890
20 10.094
21 6.791
22 8.708
23 6.791
24 4.203
25 6.591
26 9.093
27 9.192
28 6.590
29 5.589
30 5.806
31 7.491
32 7.191
33 7.391
34 8.893
35 6.606
36 8.693
37 5.005
38 6.991
39 9.593
Name: MovieDuration, dtype: float64
In [118]:
df[df['Stim 3'].str[:3].isin(['GES','CTR'])]
Out[118]:
Date
Time
File
Subj
Cond
Block
Trial
Order
Resp
Name
...
Stim 4
Time 4
Stim 5
Time 5
Stim 6
Time 6
Unnamed: 28
StimType
MovieStartTime
MovieDuration
2
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
1
3.01
1
1
...
NaN
2101
ctrl_yes.bmp <2>
0
ctrl_no.bmp <2>
2103
NaN
CTR
13.796
5.406
3
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
2
4.01
1
1
...
NaN
1819
ctrl_no.bmp <2>
0
ctrl_yes.bmp <2>
2152
NaN
CTR
26.926
9.594
4
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
3
5.01
2
2
...
NaN
2051
GES_PIC_10_foil.bmp <2>
0
GES_PIC_10_target.bmp <2>
3053
NaN
GES
48.050
6.907
5
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
4
6.01
2
2
...
NaN
1619
GES_PIC_06_foil.bmp <2>
0
GES_PIC_06_target.bmp <2>
2336
NaN
GES
61.596
7.107
6
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
5
7.01
1
1
...
NaN
1251
ctrl_yes.bmp <2>
0
ctrl_no.bmp <2>
1219
NaN
CTR
74.142
5.706
7
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
6
8.01
1
1
...
NaN
1751
GES_PIC_18_target.bmp <2>
0
GES_PIC_18_foil.bmp <2>
2519
NaN
GES
85.804
4.606
8
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
7
9.01
2
2
...
NaN
2704
ctrl_yes.bmp <2>
0
ctrl_no.bmp <2>
1151
NaN
CTR
96.132
4.504
9
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
8
10.01
2
2
...
NaN
1818
ctrl_no.bmp <2>
0
ctrl_yes.bmp <2>
1468
NaN
CTR
105.993
9.593
10
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
9
11.01
2
2
...
NaN
434
ctrl_yes.bmp <2>
0
ctrl_no.bmp <2>
1352
NaN
CTR
122.175
9.092
11
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
10
12.01
2
2
...
NaN
2687
ctrl_no.bmp <2>
0
ctrl_yes.bmp <2>
2786
NaN
CTR
134.354
7.591
12
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
11
13.01
2
2
...
NaN
2186
GES_PIC_32_foil.bmp <2>
0
GES_PIC_32_target.bmp <2>
2552
NaN
GES
148.753
6.606
13
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
12
14.01
1
1
...
NaN
2652
ctrl_no.bmp <2>
0
ctrl_yes.bmp <2>
735
NaN
CTR
161.399
9.093
14
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
13
15.01
1
1
...
NaN
734
ctrl_yes.bmp <2>
0
ctrl_no.bmp <2>
2152
NaN
CTR
175.179
8.193
15
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
14
16.01
1
1
...
NaN
2420
GES_VMP_01_target.bmp <2>
0
GES_VMP_01_foil.bmp <2>
2837
NaN
GES
189.561
3.804
16
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
15
17.01
2
2
...
NaN
1768
GES_VMP_37_foil.bmp <2>
0
GES_VMP_37_target.bmp <2>
2503
NaN
GES
199.939
9.994
17
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
16
18.01
1
1
...
NaN
2637
ctrl_no.bmp <2>
0
ctrl_yes.bmp <2>
2536
NaN
CTR
215.506
7.407
18
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
17
19.01
2
2
...
NaN
2586
GES_VMP_11_foil.bmp <2>
0
GES_VMP_11_target.bmp <2>
3154
NaN
GES
229.403
5.806
19
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
18
20.01
2
2
...
NaN
417
GES_PIC_02_foil.bmp <2>
0
GES_PIC_02_target.bmp <2>
2653
NaN
GES
242.283
5.890
20
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
19
21.01
1
1
...
NaN
617
GES_VMP_39_target.bmp <2>
0
GES_VMP_39_foil.bmp <2>
2553
NaN
GES
252.661
10.094
21
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
20
22.01
1
1
...
NaN
968
ctrl_no.bmp <2>
0
ctrl_yes.bmp <2>
685
NaN
CTR
267.225
6.791
22
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
21
23.01
2
2
...
NaN
1702
ctrl_no.bmp <2>
0
ctrl_yes.bmp <2>
2536
NaN
CTR
284.962
8.708
23
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
22
24.01
1
1
...
NaN
2151
GES_PIC_34_target.bmp <2>
0
GES_PIC_34_foil.bmp <2>
1936
NaN
GES
303.297
6.791
24
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
23
25.01
-1
-1
...
NaN
1536
GES_VMP_03_foil.bmp <2>
0
GES_VMP_03_target.bmp <2>
3503
NaN
GES
315.477
4.203
25
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
24
26.01
2
2
...
NaN
2386
ctrl_no.bmp <2>
0
ctrl_yes.bmp <2>
851
NaN
CTR
328.022
6.591
26
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
25
27.01
1
1
...
NaN
1919
GES_PIC_30_target.bmp <2>
0
GES_PIC_30_foil.bmp <2>
2687
NaN
GES
339.267
9.093
27
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
26
28.01
2
2
...
NaN
2470
GES_VMP_29_foil.bmp <2>
0
GES_VMP_29_target.bmp <2>
2936
NaN
GES
354.334
9.192
28
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
27
29.01
2
2
...
NaN
968
ctrl_yes.bmp <2>
0
ctrl_no.bmp <2>
1402
NaN
CTR
370.233
6.590
29
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
28
30.01
1
1
...
NaN
701
GES_VMP_09_target.bmp <2>
0
GES_VMP_09_foil.bmp <2>
3371
NaN
GES
380.527
5.589
30
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
29
31.01
2
2
...
NaN
1351
ctrl_yes.bmp <2>
0
ctrl_no.bmp <2>
1469
NaN
CTR
391.489
5.806
31
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
30
32.01
1
1
...
NaN
2485
GES_PIC_22_target.bmp <2>
0
GES_PIC_22_foil.bmp <2>
2453
NaN
GES
403.502
7.491
32
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
31
33.01
2
2
...
NaN
1418
ctrl_no.bmp <2>
0
ctrl_yes.bmp <2>
985
NaN
CTR
423.238
7.191
33
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
32
34.01
1
1
...
NaN
1552
ctrl_yes.bmp <2>
0
ctrl_no.bmp <2>
868
NaN
CTR
434.133
7.391
34
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
33
35.01
2
2
...
NaN
1150
GES_VMP_27_foil.bmp <2>
0
GES_VMP_27_target.bmp <2>
3238
NaN
GES
451.301
8.893
35
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
34
36.01
2
2
...
NaN
2186
GES_PIC_16_foil.bmp <2>
0
GES_PIC_16_target.bmp <2>
2803
NaN
GES
467.919
6.606
36
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
35
37.01
1
1
...
NaN
2837
GES_VMP_25_target.bmp <2>
0
GES_VMP_25_foil.bmp <2>
3053
NaN
GES
482.883
8.693
37
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
36
38.01
2
2
...
NaN
1768
ctrl_no.bmp <2>
0
ctrl_yes.bmp <2>
885
NaN
CTR
504.757
5.005
38
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
37
39.01
2
2
...
NaN
1351
ctrl_yes.bmp <2>
0
ctrl_no.bmp <2>
1152
NaN
CTR
515.718
6.991
39
2/24/2006
15:34
C:\Documents and Settings\lab\Desktop\Aaron's ...
1
1
1
38
40.01
-1
-1
...
NaN
2469
GES_VMP_31_target.bmp <2>
0
GES_VMP_31_foil.bmp <2>
3504
NaN
GES
532.586
9.593
38 rows × 32 columns
In [122]:
behavData = df[df['Stim 3'].str[:3].isin(['GES','CTR'])][['StimType','Correct','RT']]
behavData
Out[122]:
StimType
Correct
RT
2
CTR
True
2086
3
CTR
False
2143
4
GES
True
3046
5
GES
True
2331
6
CTR
True
1216
7
GES
True
2513
8
CTR
False
1147
9
CTR
True
1463
10
CTR
False
1348
11
CTR
True
2774
12
GES
True
2546
13
CTR
False
729
14
CTR
True
2149
15
GES
True
2827
16
GES
True
2493
17
CTR
False
2530
18
GES
True
3146
19
GES
True
2637
20
GES
True
2541
21
CTR
False
670
22
CTR
True
2527
23
GES
True
1929
24
GES
False
3501
25
CTR
True
844
26
GES
True
2674
27
GES
True
2929
28
CTR
False
1396
29
GES
True
3360
30
CTR
False
1466
31
GES
True
2439
32
CTR
True
971
33
CTR
True
860
34
GES
True
3236
35
GES
True
2795
36
GES
True
3042
37
CTR
True
882
38
CTR
False
1150
39
GES
False
3501
In [128]:
behavData.to_csv(inFile.split('_')[0] + '_behav.csv')
In [123]:
fmriData = df[df['Stim 3'].str[:3].isin(['GES','CTR'])][['StimType','MovieStartTime','MovieDuration']]
In [124]:
fmriData['Col3'] = 1
In [148]:
fmriData
Out[148]:
StimType
MovieStartTime
MovieDuration
Col3
2
CTR
13.796
5.406
1
3
CTR
26.926
9.594
1
4
GES
48.050
6.907
1
5
GES
61.596
7.107
1
6
CTR
74.142
5.706
1
7
GES
85.804
4.606
1
8
CTR
96.132
4.504
1
9
CTR
105.993
9.593
1
10
CTR
122.175
9.092
1
11
CTR
134.354
7.591
1
12
GES
148.753
6.606
1
13
CTR
161.399
9.093
1
14
CTR
175.179
8.193
1
15
GES
189.561
3.804
1
16
GES
199.939
9.994
1
17
CTR
215.506
7.407
1
18
GES
229.403
5.806
1
19
GES
242.283
5.890
1
20
GES
252.661
10.094
1
21
CTR
267.225
6.791
1
22
CTR
284.962
8.708
1
23
GES
303.297
6.791
1
24
GES
315.477
4.203
1
25
CTR
328.022
6.591
1
26
GES
339.267
9.093
1
27
GES
354.334
9.192
1
28
CTR
370.233
6.590
1
29
GES
380.527
5.589
1
30
CTR
391.489
5.806
1
31
GES
403.502
7.491
1
32
CTR
423.238
7.191
1
33
CTR
434.133
7.391
1
34
GES
451.301
8.893
1
35
GES
467.919
6.606
1
36
GES
482.883
8.693
1
37
CTR
504.757
5.005
1
38
CTR
515.718
6.991
1
39
GES
532.586
9.593
1
In [146]:
fmriDataG = fmriData[fmriData['StimType'].isin(['GES'])][['MovieStartTime','MovieDuration','Col3']]
In [150]:
fmriDataG.to_csv(inFile.split('_')[0] + '_MRIlog_GES.txt', sep='\t', header=False, index=False)
In [149]:
fmriDataC = fmriData[fmriData['StimType'].isin(['CTR'])][['MovieStartTime','MovieDuration','Col3']]
fmriDataC.to_csv(inFile.split('_')[0] + '_MRIlog_CTRL.txt', sep='\t', header=False, index=False)
In [ ]:
Content source: espressofiend/NCIL-SOC-2015
Similar notebooks: