API tools faq
paste
Advertisement
Guest User

Untitled

a guest
May 3rd, 2015
250
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 48.85 KB | None | 0 0
raw download clone embed print report
  1. {
  2. "metadata": {
  3. "name": "",
  4. "signature": "sha256:60a5d8fac7481a500c1f7f226a9c3a6f0a6a5c1f77c9cebdc4622608875a00f9"
  5. },
  6. "nbformat": 3,
  7. "nbformat_minor": 0,
  8. "worksheets": [
  9. {
  10. "cells": [
  11. {
  12. "cell_type": "code",
  13. "collapsed": false,
  14. "input": [
  15. "import os\n",
  16. "from glob import glob\n",
  17. "import numpy as np\n",
  18. "import pandas as pd\n",
  19. "import csv\n",
  20. "from scipy.io import loadmat\n",
  21. "from StringIO import StringIO"
  22. ],
  23. "language": "python",
  24. "metadata": {},
  25. "outputs": [],
  26. "prompt_number": 2
  27. },
  28. {
  29. "cell_type": "heading",
  30. "level": 5,
  31. "metadata": {},
  32. "source": [
  33. " sart onsets"
  34. ]
  35. },
  36. {
  37. "cell_type": "code",
  38. "collapsed": false,
  39. "input": [
  40. "csv_logs = sorted(glob('/home/jminas/Dropbox/SART/fMRI/data/p3_schedule*.log'))\n",
  41. "print csv_logs"
  42. ],
  43. "language": "python",
  44. "metadata": {},
  45. "outputs": [
  46. {
  47. "output_type": "stream",
  48. "stream": "stdout",
  49. "text": [
  50. "['/home/jminas/Dropbox/SART/fMRI/data/p3_schedule1.log', '/home/jminas/Dropbox/SART/fMRI/data/p3_schedule2.log', '/home/jminas/Dropbox/SART/fMRI/data/p3_schedule3.log', '/home/jminas/Dropbox/SART/fMRI/data/p3_schedule4.log', '/home/jminas/Dropbox/SART/fMRI/data/p3_schedulepractice.log']\n"
  51. ]
  52. }
  53. ],
  54. "prompt_number": 3
  55. },
  56. {
  57. "cell_type": "code",
  58. "collapsed": false,
  59. "input": [
  60. "runs = [1,2,3,4]\n",
  61. "subjects = ['p3'] #, 'p3']\n",
  62. "names = ['on', 'off','aware', 'unaware'] \n",
  63. "\n",
  64. " \n",
  65. "for run in runs:\n",
  66. " for sub in subjects:\n",
  67. " df = pd.DataFrame()\n",
  68. " \n",
  69. " df = df.append(pd.read_csv('/home/jminas/Dropbox/SART/fMRI/data/%s_schedule%d.log' % (sub, run), delimiter='\\t', header=None), ignore_index=True)\n",
  70. " df.columns = ['onsets', 'log2', 'log3']\n",
  71. " df['run'] = run\n",
  72. " df['subject'] = sub\n",
  73. " df['trigger_time'] = df.apply(lambda row:( row['onsets'] if (row['log3']=='Keypress: num_add') else None), axis=1)\n",
  74. " #df['condition'] = df.apply(lambda row: ('probe2' if row[row['log3'].str.contains(\"'probe2'\")==True] else None), axis=1) \n",
  75. " #else 'probe2' if (row[row['log3'].str.contains(\"'probe2'\")]) \n",
  76. " #else 'target' if (row[row['log3'].str.contains(\"'stim': 3\")]) \n",
  77. " #else 'nontarget'), axis=1)\n",
  78. " \n",
  79. "#This is what it looks like:\n",
  80. "df"
  81. ],
  82. "language": "python",
  83. "metadata": {},
  84. "outputs": [
  85. {
  86. "html": [
  87. "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
  88. "<table border=\"1\" class=\"dataframe\">\n",
  89. " <thead>\n",
  90. " <tr style=\"text-align: right;\">\n",
  91. " <th></th>\n",
  92. " <th>onsets</th>\n",
  93. " <th>log2</th>\n",
  94. " <th>log3</th>\n",
  95. " <th>run</th>\n",
  96. " <th>subject</th>\n",
  97. " <th>trigger_time</th>\n",
  98. " </tr>\n",
  99. " </thead>\n",
  100. " <tbody>\n",
  101. " <tr>\n",
  102. " <th>0 </th>\n",
  103. " <td> 8.8150</td>\n",
  104. " <td> WARNING</td>\n",
  105. " <td> User requested fullscreen with size [1024 768...</td>\n",
  106. " <td> 4</td>\n",
  107. " <td> p3</td>\n",
  108. " <td> NaN</td>\n",
  109. " </tr>\n",
  110. " <tr>\n",
  111. " <th>1 </th>\n",
  112. " <td> 8.9658</td>\n",
  113. " <td> EXP</td>\n",
  114. " <td> Set Window color=[ 0. 0. 0.] (rgb)</td>\n",
  115. " <td> 4</td>\n",
  116. " <td> p3</td>\n",
  117. " <td> NaN</td>\n",
  118. " </tr>\n",
  119. " <tr>\n",
  120. " <th>2 </th>\n",
  121. " <td> 9.4842</td>\n",
  122. " <td> EXP</td>\n",
  123. " <td> Started presenting scanner</td>\n",
  124. " <td> 4</td>\n",
  125. " <td> p3</td>\n",
  126. " <td> NaN</td>\n",
  127. " </tr>\n",
  128. " <tr>\n",
  129. " <th>3 </th>\n",
  130. " <td> 193.8210</td>\n",
  131. " <td> DATA</td>\n",
  132. " <td> Keypress: num_add</td>\n",
  133. " <td> 4</td>\n",
  134. " <td> p3</td>\n",
  135. " <td> 193.8210</td>\n",
  136. " </tr>\n",
  137. " <tr>\n",
  138. " <th>4 </th>\n",
  139. " <td> 193.8370</td>\n",
  140. " <td> EXP</td>\n",
  141. " <td> Stopped presenting scanner</td>\n",
  142. " <td> 4</td>\n",
  143. " <td> p3</td>\n",
  144. " <td> NaN</td>\n",
  145. " </tr>\n",
  146. " <tr>\n",
  147. " <th>5 </th>\n",
  148. " <td> 193.8370</td>\n",
  149. " <td> EXP</td>\n",
  150. " <td> Started presenting initial_fix</td>\n",
  151. " <td> 4</td>\n",
  152. " <td> p3</td>\n",
  153. " <td> NaN</td>\n",
  154. " </tr>\n",
  155. " <tr>\n",
  156. " <th>6 </th>\n",
  157. " <td> 195.8550</td>\n",
  158. " <td> EXP</td>\n",
  159. " <td> Created sequence: sequential, trialTypes=358, ...</td>\n",
  160. " <td> 4</td>\n",
  161. " <td> p3</td>\n",
  162. " <td> NaN</td>\n",
  163. " </tr>\n",
  164. " <tr>\n",
  165. " <th>7 </th>\n",
  166. " <td> 195.9244</td>\n",
  167. " <td> EXP</td>\n",
  168. " <td> New trial (rep=0, index=0): {'stim': 2}</td>\n",
  169. " <td> 4</td>\n",
  170. " <td> p3</td>\n",
  171. " <td> NaN</td>\n",
  172. " </tr>\n",
  173. " <tr>\n",
  174. " <th>8 </th>\n",
  175. " <td> 195.9410</td>\n",
  176. " <td> EXP</td>\n",
  177. " <td> Stopped presenting initial_fix</td>\n",
  178. " <td> 4</td>\n",
  179. " <td> p3</td>\n",
  180. " <td> NaN</td>\n",
  181. " </tr>\n",
  182. " <tr>\n",
  183. " <th>9 </th>\n",
  184. " <td> 195.9410</td>\n",
  185. " <td> EXP</td>\n",
  186. " <td> Set text text=2</td>\n",
  187. " <td> 4</td>\n",
  188. " <td> p3</td>\n",
  189. " <td> NaN</td>\n",
  190. " </tr>\n",
  191. " <tr>\n",
  192. " <th>10 </th>\n",
  193. " <td> 195.9410</td>\n",
  194. " <td> EXP</td>\n",
  195. " <td> Started presenting text</td>\n",
  196. " <td> 4</td>\n",
  197. " <td> p3</td>\n",
  198. " <td> NaN</td>\n",
  199. " </tr>\n",
  200. " <tr>\n",
  201. " <th>11 </th>\n",
  202. " <td> 196.2555</td>\n",
  203. " <td> EXP</td>\n",
  204. " <td> Stopped presenting text</td>\n",
  205. " <td> 4</td>\n",
  206. " <td> p3</td>\n",
  207. " <td> NaN</td>\n",
  208. " </tr>\n",
  209. " <tr>\n",
  210. " <th>12 </th>\n",
  211. " <td> 196.2555</td>\n",
  212. " <td> EXP</td>\n",
  213. " <td> Started presenting fix</td>\n",
  214. " <td> 4</td>\n",
  215. " <td> p3</td>\n",
  216. " <td> NaN</td>\n",
  217. " </tr>\n",
  218. " <tr>\n",
  219. " <th>13 </th>\n",
  220. " <td> 196.3225</td>\n",
  221. " <td> DATA</td>\n",
  222. " <td> Keypress: num_add</td>\n",
  223. " <td> 4</td>\n",
  224. " <td> p3</td>\n",
  225. " <td> 196.3225</td>\n",
  226. " </tr>\n",
  227. " <tr>\n",
  228. " <th>14 </th>\n",
  229. " <td> 196.4723</td>\n",
  230. " <td> DATA</td>\n",
  231. " <td> Keypress: 1</td>\n",
  232. " <td> 4</td>\n",
  233. " <td> p3</td>\n",
  234. " <td> NaN</td>\n",
  235. " </tr>\n",
  236. " <tr>\n",
  237. " <th>15 </th>\n",
  238. " <td> 197.9409</td>\n",
  239. " <td> EXP</td>\n",
  240. " <td> New trial (rep=0, index=1): {'stim': 4}</td>\n",
  241. " <td> 4</td>\n",
  242. " <td> p3</td>\n",
  243. " <td> NaN</td>\n",
  244. " </tr>\n",
  245. " <tr>\n",
  246. " <th>16 </th>\n",
  247. " <td> 197.9567</td>\n",
  248. " <td> EXP</td>\n",
  249. " <td> Stopped presenting fix</td>\n",
  250. " <td> 4</td>\n",
  251. " <td> p3</td>\n",
  252. " <td> NaN</td>\n",
  253. " </tr>\n",
  254. " <tr>\n",
  255. " <th>17 </th>\n",
  256. " <td> 197.9567</td>\n",
  257. " <td> EXP</td>\n",
  258. " <td> Set text text=4</td>\n",
  259. " <td> 4</td>\n",
  260. " <td> p3</td>\n",
  261. " <td> NaN</td>\n",
  262. " </tr>\n",
  263. " <tr>\n",
  264. " <th>18 </th>\n",
  265. " <td> 197.9567</td>\n",
  266. " <td> EXP</td>\n",
  267. " <td> Started presenting text</td>\n",
  268. " <td> 4</td>\n",
  269. " <td> p3</td>\n",
  270. " <td> NaN</td>\n",
  271. " </tr>\n",
  272. " <tr>\n",
  273. " <th>19 </th>\n",
  274. " <td> 198.2735</td>\n",
  275. " <td> EXP</td>\n",
  276. " <td> Stopped presenting text</td>\n",
  277. " <td> 4</td>\n",
  278. " <td> p3</td>\n",
  279. " <td> NaN</td>\n",
  280. " </tr>\n",
  281. " <tr>\n",
  282. " <th>20 </th>\n",
  283. " <td> 198.2735</td>\n",
  284. " <td> EXP</td>\n",
  285. " <td> Started presenting fix</td>\n",
  286. " <td> 4</td>\n",
  287. " <td> p3</td>\n",
  288. " <td> NaN</td>\n",
  289. " </tr>\n",
  290. " <tr>\n",
  291. " <th>21 </th>\n",
  292. " <td> 198.3904</td>\n",
  293. " <td> DATA</td>\n",
  294. " <td> Keypress: 1</td>\n",
  295. " <td> 4</td>\n",
  296. " <td> p3</td>\n",
  297. " <td> NaN</td>\n",
  298. " </tr>\n",
  299. " <tr>\n",
  300. " <th>22 </th>\n",
  301. " <td> 198.8238</td>\n",
  302. " <td> DATA</td>\n",
  303. " <td> Keypress: num_add</td>\n",
  304. " <td> 4</td>\n",
  305. " <td> p3</td>\n",
  306. " <td> 198.8238</td>\n",
  307. " </tr>\n",
  308. " <tr>\n",
  309. " <th>23 </th>\n",
  310. " <td> 199.9421</td>\n",
  311. " <td> EXP</td>\n",
  312. " <td> New trial (rep=0, index=2): {'stim': 0}</td>\n",
  313. " <td> 4</td>\n",
  314. " <td> p3</td>\n",
  315. " <td> NaN</td>\n",
  316. " </tr>\n",
  317. " <tr>\n",
  318. " <th>24 </th>\n",
  319. " <td> 199.9579</td>\n",
  320. " <td> EXP</td>\n",
  321. " <td> Stopped presenting fix</td>\n",
  322. " <td> 4</td>\n",
  323. " <td> p3</td>\n",
  324. " <td> NaN</td>\n",
  325. " </tr>\n",
  326. " <tr>\n",
  327. " <th>25 </th>\n",
  328. " <td> 199.9579</td>\n",
  329. " <td> EXP</td>\n",
  330. " <td> Set text text=0</td>\n",
  331. " <td> 4</td>\n",
  332. " <td> p3</td>\n",
  333. " <td> NaN</td>\n",
  334. " </tr>\n",
  335. " <tr>\n",
  336. " <th>26 </th>\n",
  337. " <td> 199.9579</td>\n",
  338. " <td> EXP</td>\n",
  339. " <td> Started presenting text</td>\n",
  340. " <td> 4</td>\n",
  341. " <td> p3</td>\n",
  342. " <td> NaN</td>\n",
  343. " </tr>\n",
  344. " <tr>\n",
  345. " <th>27 </th>\n",
  346. " <td> 200.2750</td>\n",
  347. " <td> EXP</td>\n",
  348. " <td> Stopped presenting text</td>\n",
  349. " <td> 4</td>\n",
  350. " <td> p3</td>\n",
  351. " <td> NaN</td>\n",
  352. " </tr>\n",
  353. " <tr>\n",
  354. " <th>28 </th>\n",
  355. " <td> 200.2750</td>\n",
  356. " <td> EXP</td>\n",
  357. " <td> Started presenting fix</td>\n",
  358. " <td> 4</td>\n",
  359. " <td> p3</td>\n",
  360. " <td> NaN</td>\n",
  361. " </tr>\n",
  362. " <tr>\n",
  363. " <th>29 </th>\n",
  364. " <td> 200.7252</td>\n",
  365. " <td> DATA</td>\n",
  366. " <td> Keypress: 1</td>\n",
  367. " <td> 4</td>\n",
  368. " <td> p3</td>\n",
  369. " <td> NaN</td>\n",
  370. " </tr>\n",
  371. " <tr>\n",
  372. " <th>...</th>\n",
  373. " <td>...</td>\n",
  374. " <td>...</td>\n",
  375. " <td>...</td>\n",
  376. " <td>...</td>\n",
  377. " <td>...</td>\n",
  378. " <td>...</td>\n",
  379. " </tr>\n",
  380. " <tr>\n",
  381. " <th>2799</th>\n",
  382. " <td> 1021.2428</td>\n",
  383. " <td> EXP</td>\n",
  384. " <td> Started presenting fix</td>\n",
  385. " <td> 4</td>\n",
  386. " <td> p3</td>\n",
  387. " <td> NaN</td>\n",
  388. " </tr>\n",
  389. " <tr>\n",
  390. " <th>2800</th>\n",
  391. " <td> 1021.7270</td>\n",
  392. " <td> DATA</td>\n",
  393. " <td> Keypress: 1</td>\n",
  394. " <td> 4</td>\n",
  395. " <td> p3</td>\n",
  396. " <td> NaN</td>\n",
  397. " </tr>\n",
  398. " <tr>\n",
  399. " <th>2801</th>\n",
  400. " <td> 1021.7604</td>\n",
  401. " <td> DATA</td>\n",
  402. " <td> Keypress: num_add</td>\n",
  403. " <td> 4</td>\n",
  404. " <td> p3</td>\n",
  405. " <td> 1021.7604</td>\n",
  406. " </tr>\n",
  407. " <tr>\n",
  408. " <th>2802</th>\n",
  409. " <td> 1022.9114</td>\n",
  410. " <td> EXP</td>\n",
  411. " <td> New trial (rep=0, index=354): {'stim': 6}</td>\n",
  412. " <td> 4</td>\n",
  413. " <td> p3</td>\n",
  414. " <td> NaN</td>\n",
  415. " </tr>\n",
  416. " <tr>\n",
  417. " <th>2803</th>\n",
  418. " <td> 1022.9283</td>\n",
  419. " <td> EXP</td>\n",
  420. " <td> Stopped presenting fix</td>\n",
  421. " <td> 4</td>\n",
  422. " <td> p3</td>\n",
  423. " <td> NaN</td>\n",
  424. " </tr>\n",
  425. " <tr>\n",
  426. " <th>2804</th>\n",
  427. " <td> 1022.9283</td>\n",
  428. " <td> EXP</td>\n",
  429. " <td> Set text text=6</td>\n",
  430. " <td> 4</td>\n",
  431. " <td> p3</td>\n",
  432. " <td> NaN</td>\n",
  433. " </tr>\n",
  434. " <tr>\n",
  435. " <th>2805</th>\n",
  436. " <td> 1022.9283</td>\n",
  437. " <td> EXP</td>\n",
  438. " <td> Started presenting text</td>\n",
  439. " <td> 4</td>\n",
  440. " <td> p3</td>\n",
  441. " <td> NaN</td>\n",
  442. " </tr>\n",
  443. " <tr>\n",
  444. " <th>2806</th>\n",
  445. " <td> 1023.2441</td>\n",
  446. " <td> EXP</td>\n",
  447. " <td> Stopped presenting text</td>\n",
  448. " <td> 4</td>\n",
  449. " <td> p3</td>\n",
  450. " <td> NaN</td>\n",
  451. " </tr>\n",
  452. " <tr>\n",
  453. " <th>2807</th>\n",
  454. " <td> 1023.2441</td>\n",
  455. " <td> EXP</td>\n",
  456. " <td> Started presenting fix</td>\n",
  457. " <td> 4</td>\n",
  458. " <td> p3</td>\n",
  459. " <td> NaN</td>\n",
  460. " </tr>\n",
  461. " <tr>\n",
  462. " <th>2808</th>\n",
  463. " <td> 1023.6284</td>\n",
  464. " <td> DATA</td>\n",
  465. " <td> Keypress: 1</td>\n",
  466. " <td> 4</td>\n",
  467. " <td> p3</td>\n",
  468. " <td> NaN</td>\n",
  469. " </tr>\n",
  470. " <tr>\n",
  471. " <th>2809</th>\n",
  472. " <td> 1024.9127</td>\n",
  473. " <td> EXP</td>\n",
  474. " <td> New trial (rep=0, index=355): {'stim': 6}</td>\n",
  475. " <td> 4</td>\n",
  476. " <td> p3</td>\n",
  477. " <td> NaN</td>\n",
  478. " </tr>\n",
  479. " <tr>\n",
  480. " <th>2810</th>\n",
  481. " <td> 1024.9291</td>\n",
  482. " <td> EXP</td>\n",
  483. " <td> Stopped presenting fix</td>\n",
  484. " <td> 4</td>\n",
  485. " <td> p3</td>\n",
  486. " <td> NaN</td>\n",
  487. " </tr>\n",
  488. " <tr>\n",
  489. " <th>2811</th>\n",
  490. " <td> 1024.9291</td>\n",
  491. " <td> EXP</td>\n",
  492. " <td> Set text text=6</td>\n",
  493. " <td> 4</td>\n",
  494. " <td> p3</td>\n",
  495. " <td> NaN</td>\n",
  496. " </tr>\n",
  497. " <tr>\n",
  498. " <th>2812</th>\n",
  499. " <td> 1024.9291</td>\n",
  500. " <td> EXP</td>\n",
  501. " <td> Started presenting text</td>\n",
  502. " <td> 4</td>\n",
  503. " <td> p3</td>\n",
  504. " <td> NaN</td>\n",
  505. " </tr>\n",
  506. " <tr>\n",
  507. " <th>2813</th>\n",
  508. " <td> 1025.2454</td>\n",
  509. " <td> EXP</td>\n",
  510. " <td> Stopped presenting text</td>\n",
  511. " <td> 4</td>\n",
  512. " <td> p3</td>\n",
  513. " <td> NaN</td>\n",
  514. " </tr>\n",
  515. " <tr>\n",
  516. " <th>2814</th>\n",
  517. " <td> 1025.2454</td>\n",
  518. " <td> EXP</td>\n",
  519. " <td> Started presenting fix</td>\n",
  520. " <td> 4</td>\n",
  521. " <td> p3</td>\n",
  522. " <td> NaN</td>\n",
  523. " </tr>\n",
  524. " <tr>\n",
  525. " <th>2815</th>\n",
  526. " <td> 1026.0632</td>\n",
  527. " <td> DATA</td>\n",
  528. " <td> Keypress: 1</td>\n",
  529. " <td> 4</td>\n",
  530. " <td> p3</td>\n",
  531. " <td> NaN</td>\n",
  532. " </tr>\n",
  533. " <tr>\n",
  534. " <th>2816</th>\n",
  535. " <td> 1026.9141</td>\n",
  536. " <td> EXP</td>\n",
  537. " <td> New trial (rep=0, index=356): {'stim': 4}</td>\n",
  538. " <td> 4</td>\n",
  539. " <td> p3</td>\n",
  540. " <td> NaN</td>\n",
  541. " </tr>\n",
  542. " <tr>\n",
  543. " <th>2817</th>\n",
  544. " <td> 1026.9301</td>\n",
  545. " <td> EXP</td>\n",
  546. " <td> Stopped presenting fix</td>\n",
  547. " <td> 4</td>\n",
  548. " <td> p3</td>\n",
  549. " <td> NaN</td>\n",
  550. " </tr>\n",
  551. " <tr>\n",
  552. " <th>2818</th>\n",
  553. " <td> 1026.9301</td>\n",
  554. " <td> EXP</td>\n",
  555. " <td> Set text text=4</td>\n",
  556. " <td> 4</td>\n",
  557. " <td> p3</td>\n",
  558. " <td> NaN</td>\n",
  559. " </tr>\n",
  560. " <tr>\n",
  561. " <th>2819</th>\n",
  562. " <td> 1026.9301</td>\n",
  563. " <td> EXP</td>\n",
  564. " <td> Started presenting text</td>\n",
  565. " <td> 4</td>\n",
  566. " <td> p3</td>\n",
  567. " <td> NaN</td>\n",
  568. " </tr>\n",
  569. " <tr>\n",
  570. " <th>2820</th>\n",
  571. " <td> 1027.2467</td>\n",
  572. " <td> EXP</td>\n",
  573. " <td> Stopped presenting text</td>\n",
  574. " <td> 4</td>\n",
  575. " <td> p3</td>\n",
  576. " <td> NaN</td>\n",
  577. " </tr>\n",
  578. " <tr>\n",
  579. " <th>2821</th>\n",
  580. " <td> 1027.2467</td>\n",
  581. " <td> EXP</td>\n",
  582. " <td> Started presenting fix</td>\n",
  583. " <td> 4</td>\n",
  584. " <td> p3</td>\n",
  585. " <td> NaN</td>\n",
  586. " </tr>\n",
  587. " <tr>\n",
  588. " <th>2822</th>\n",
  589. " <td> 1027.6310</td>\n",
  590. " <td> DATA</td>\n",
  591. " <td> Keypress: 1</td>\n",
  592. " <td> 4</td>\n",
  593. " <td> p3</td>\n",
  594. " <td> NaN</td>\n",
  595. " </tr>\n",
  596. " <tr>\n",
  597. " <th>2823</th>\n",
  598. " <td> 1028.9153</td>\n",
  599. " <td> EXP</td>\n",
  600. " <td> New trial (rep=0, index=357): {'stim': 3}</td>\n",
  601. " <td> 4</td>\n",
  602. " <td> p3</td>\n",
  603. " <td> NaN</td>\n",
  604. " </tr>\n",
  605. " <tr>\n",
  606. " <th>2824</th>\n",
  607. " <td> 1028.9313</td>\n",
  608. " <td> EXP</td>\n",
  609. " <td> Stopped presenting fix</td>\n",
  610. " <td> 4</td>\n",
  611. " <td> p3</td>\n",
  612. " <td> NaN</td>\n",
  613. " </tr>\n",
  614. " <tr>\n",
  615. " <th>2825</th>\n",
  616. " <td> 1028.9313</td>\n",
  617. " <td> EXP</td>\n",
  618. " <td> Set text text=3</td>\n",
  619. " <td> 4</td>\n",
  620. " <td> p3</td>\n",
  621. " <td> NaN</td>\n",
  622. " </tr>\n",
  623. " <tr>\n",
  624. " <th>2826</th>\n",
  625. " <td> 1028.9313</td>\n",
  626. " <td> EXP</td>\n",
  627. " <td> Started presenting text</td>\n",
  628. " <td> 4</td>\n",
  629. " <td> p3</td>\n",
  630. " <td> NaN</td>\n",
  631. " </tr>\n",
  632. " <tr>\n",
  633. " <th>2827</th>\n",
  634. " <td> 1029.2480</td>\n",
  635. " <td> EXP</td>\n",
  636. " <td> Stopped presenting text</td>\n",
  637. " <td> 4</td>\n",
  638. " <td> p3</td>\n",
  639. " <td> NaN</td>\n",
  640. " </tr>\n",
  641. " <tr>\n",
  642. " <th>2828</th>\n",
  643. " <td> 1029.2480</td>\n",
  644. " <td> EXP</td>\n",
  645. " <td> Started presenting fix</td>\n",
  646. " <td> 4</td>\n",
  647. " <td> p3</td>\n",
  648. " <td> NaN</td>\n",
  649. " </tr>\n",
  650. " </tbody>\n",
  651. "</table>\n",
  652. "<p>2829 rows \u00d7 6 columns</p>\n",
  653. "</div>"
  654. ],
  655. "metadata": {},
  656. "output_type": "pyout",
  657. "prompt_number": 6,
  658. "text": [
  659. " onsets log2 log3 \\\n",
  660. "0 8.8150 WARNING User requested fullscreen with size [1024 768... \n",
  661. "1 8.9658 EXP Set Window color=[ 0. 0. 0.] (rgb) \n",
  662. "2 9.4842 EXP Started presenting scanner \n",
  663. "3 193.8210 DATA Keypress: num_add \n",
  664. "4 193.8370 EXP Stopped presenting scanner \n",
  665. "5 193.8370 EXP Started presenting initial_fix \n",
  666. "6 195.8550 EXP Created sequence: sequential, trialTypes=358, ... \n",
  667. "7 195.9244 EXP New trial (rep=0, index=0): {'stim': 2} \n",
  668. "8 195.9410 EXP Stopped presenting initial_fix \n",
  669. "9 195.9410 EXP Set text text=2 \n",
  670. "10 195.9410 EXP Started presenting text \n",
  671. "11 196.2555 EXP Stopped presenting text \n",
  672. "12 196.2555 EXP Started presenting fix \n",
  673. "13 196.3225 DATA Keypress: num_add \n",
  674. "14 196.4723 DATA Keypress: 1 \n",
  675. "15 197.9409 EXP New trial (rep=0, index=1): {'stim': 4} \n",
  676. "16 197.9567 EXP Stopped presenting fix \n",
  677. "17 197.9567 EXP Set text text=4 \n",
  678. "18 197.9567 EXP Started presenting text \n",
  679. "19 198.2735 EXP Stopped presenting text \n",
  680. "20 198.2735 EXP Started presenting fix \n",
  681. "21 198.3904 DATA Keypress: 1 \n",
  682. "22 198.8238 DATA Keypress: num_add \n",
  683. "23 199.9421 EXP New trial (rep=0, index=2): {'stim': 0} \n",
  684. "24 199.9579 EXP Stopped presenting fix \n",
  685. "25 199.9579 EXP Set text text=0 \n",
  686. "26 199.9579 EXP Started presenting text \n",
  687. "27 200.2750 EXP Stopped presenting text \n",
  688. "28 200.2750 EXP Started presenting fix \n",
  689. "29 200.7252 DATA Keypress: 1 \n",
  690. "... ... ... ... \n",
  691. "2799 1021.2428 EXP Started presenting fix \n",
  692. "2800 1021.7270 DATA Keypress: 1 \n",
  693. "2801 1021.7604 DATA Keypress: num_add \n",
  694. "2802 1022.9114 EXP New trial (rep=0, index=354): {'stim': 6} \n",
  695. "2803 1022.9283 EXP Stopped presenting fix \n",
  696. "2804 1022.9283 EXP Set text text=6 \n",
  697. "2805 1022.9283 EXP Started presenting text \n",
  698. "2806 1023.2441 EXP Stopped presenting text \n",
  699. "2807 1023.2441 EXP Started presenting fix \n",
  700. "2808 1023.6284 DATA Keypress: 1 \n",
  701. "2809 1024.9127 EXP New trial (rep=0, index=355): {'stim': 6} \n",
  702. "2810 1024.9291 EXP Stopped presenting fix \n",
  703. "2811 1024.9291 EXP Set text text=6 \n",
  704. "2812 1024.9291 EXP Started presenting text \n",
  705. "2813 1025.2454 EXP Stopped presenting text \n",
  706. "2814 1025.2454 EXP Started presenting fix \n",
  707. "2815 1026.0632 DATA Keypress: 1 \n",
  708. "2816 1026.9141 EXP New trial (rep=0, index=356): {'stim': 4} \n",
  709. "2817 1026.9301 EXP Stopped presenting fix \n",
  710. "2818 1026.9301 EXP Set text text=4 \n",
  711. "2819 1026.9301 EXP Started presenting text \n",
  712. "2820 1027.2467 EXP Stopped presenting text \n",
  713. "2821 1027.2467 EXP Started presenting fix \n",
  714. "2822 1027.6310 DATA Keypress: 1 \n",
  715. "2823 1028.9153 EXP New trial (rep=0, index=357): {'stim': 3} \n",
  716. "2824 1028.9313 EXP Stopped presenting fix \n",
  717. "2825 1028.9313 EXP Set text text=3 \n",
  718. "2826 1028.9313 EXP Started presenting text \n",
  719. "2827 1029.2480 EXP Stopped presenting text \n",
  720. "2828 1029.2480 EXP Started presenting fix \n",
  721. "\n",
  722. " run subject trigger_time \n",
  723. "0 4 p3 NaN \n",
  724. "1 4 p3 NaN \n",
  725. "2 4 p3 NaN \n",
  726. "3 4 p3 193.8210 \n",
  727. "4 4 p3 NaN \n",
  728. "5 4 p3 NaN \n",
  729. "6 4 p3 NaN \n",
  730. "7 4 p3 NaN \n",
  731. "8 4 p3 NaN \n",
  732. "9 4 p3 NaN \n",
  733. "10 4 p3 NaN \n",
  734. "11 4 p3 NaN \n",
  735. "12 4 p3 NaN \n",
  736. "13 4 p3 196.3225 \n",
  737. "14 4 p3 NaN \n",
  738. "15 4 p3 NaN \n",
  739. "16 4 p3 NaN \n",
  740. "17 4 p3 NaN \n",
  741. "18 4 p3 NaN \n",
  742. "19 4 p3 NaN \n",
  743. "20 4 p3 NaN \n",
  744. "21 4 p3 NaN \n",
  745. "22 4 p3 198.8238 \n",
  746. "23 4 p3 NaN \n",
  747. "24 4 p3 NaN \n",
  748. "25 4 p3 NaN \n",
  749. "26 4 p3 NaN \n",
  750. "27 4 p3 NaN \n",
  751. "28 4 p3 NaN \n",
  752. "29 4 p3 NaN \n",
  753. "... ... ... ... \n",
  754. "2799 4 p3 NaN \n",
  755. "2800 4 p3 NaN \n",
  756. "2801 4 p3 1021.7604 \n",
  757. "2802 4 p3 NaN \n",
  758. "2803 4 p3 NaN \n",
  759. "2804 4 p3 NaN \n",
  760. "2805 4 p3 NaN \n",
  761. "2806 4 p3 NaN \n",
  762. "2807 4 p3 NaN \n",
  763. "2808 4 p3 NaN \n",
  764. "2809 4 p3 NaN \n",
  765. "2810 4 p3 NaN \n",
  766. "2811 4 p3 NaN \n",
  767. "2812 4 p3 NaN \n",
  768. "2813 4 p3 NaN \n",
  769. "2814 4 p3 NaN \n",
  770. "2815 4 p3 NaN \n",
  771. "2816 4 p3 NaN \n",
  772. "2817 4 p3 NaN \n",
  773. "2818 4 p3 NaN \n",
  774. "2819 4 p3 NaN \n",
  775. "2820 4 p3 NaN \n",
  776. "2821 4 p3 NaN \n",
  777. "2822 4 p3 NaN \n",
  778. "2823 4 p3 NaN \n",
  779. "2824 4 p3 NaN \n",
  780. "2825 4 p3 NaN \n",
  781. "2826 4 p3 NaN \n",
  782. "2827 4 p3 NaN \n",
  783. "2828 4 p3 NaN \n",
  784. "\n",
  785. "[2829 rows x 6 columns]"
  786. ]
  787. }
  788. ],
  789. "prompt_number": 6
  790. },
  791. {
  792. "cell_type": "code",
  793. "collapsed": false,
  794. "input": [
  795. "#Now I want to add a column with condition name. First I need to find a partial string, this works:\n",
  796. "df[df['log3'].str.contains(\"'probe2'\")==True]"
  797. ],
  798. "language": "python",
  799. "metadata": {},
  800. "outputs": [
  801. {
  802. "html": [
  803. "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
  804. "<table border=\"1\" class=\"dataframe\">\n",
  805. " <thead>\n",
  806. " <tr style=\"text-align: right;\">\n",
  807. " <th></th>\n",
  808. " <th>onsets</th>\n",
  809. " <th>log2</th>\n",
  810. " <th>log3</th>\n",
  811. " <th>run</th>\n",
  812. " <th>subject</th>\n",
  813. " <th>trigger_time</th>\n",
  814. " </tr>\n",
  815. " </thead>\n",
  816. " <tbody>\n",
  817. " <tr>\n",
  818. " <th>217 </th>\n",
  819. " <td> 253.6934</td>\n",
  820. " <td> EXP</td>\n",
  821. " <td> New trial (rep=0, index=27): {'stim': 'probe2'}</td>\n",
  822. " <td> 4</td>\n",
  823. " <td> p3</td>\n",
  824. " <td>NaN</td>\n",
  825. " </tr>\n",
  826. " <tr>\n",
  827. " <th>291 </th>\n",
  828. " <td> 279.1104</td>\n",
  829. " <td> EXP</td>\n",
  830. " <td> New trial (rep=0, index=36): {'stim': 'probe2'}</td>\n",
  831. " <td> 4</td>\n",
  832. " <td> p3</td>\n",
  833. " <td>NaN</td>\n",
  834. " </tr>\n",
  835. " <tr>\n",
  836. " <th>488 </th>\n",
  837. " <td> 336.5476</td>\n",
  838. " <td> EXP</td>\n",
  839. " <td> New trial (rep=0, index=61): {'stim': 'probe2'}</td>\n",
  840. " <td> 4</td>\n",
  841. " <td> p3</td>\n",
  842. " <td>NaN</td>\n",
  843. " </tr>\n",
  844. " <tr>\n",
  845. " <th>630 </th>\n",
  846. " <td> 379.9758</td>\n",
  847. " <td> EXP</td>\n",
  848. " <td> New trial (rep=0, index=79): {'stim': 'probe2'}</td>\n",
  849. " <td> 4</td>\n",
  850. " <td> p3</td>\n",
  851. " <td>NaN</td>\n",
  852. " </tr>\n",
  853. " <tr>\n",
  854. " <th>765 </th>\n",
  855. " <td> 421.4029</td>\n",
  856. " <td> EXP</td>\n",
  857. " <td> New trial (rep=0, index=96): {'stim': 'probe2'}</td>\n",
  858. " <td> 4</td>\n",
  859. " <td> p3</td>\n",
  860. " <td>NaN</td>\n",
  861. " </tr>\n",
  862. " <tr>\n",
  863. " <th>854 </th>\n",
  864. " <td> 450.8385</td>\n",
  865. " <td> EXP</td>\n",
  866. " <td> New trial (rep=0, index=107): {'stim': 'probe2'}</td>\n",
  867. " <td> 4</td>\n",
  868. " <td> p3</td>\n",
  869. " <td>NaN</td>\n",
  870. " </tr>\n",
  871. " <tr>\n",
  872. " <th>982 </th>\n",
  873. " <td> 490.2656</td>\n",
  874. " <td> EXP</td>\n",
  875. " <td> New trial (rep=0, index=123): {'stim': 'probe2'}</td>\n",
  876. " <td> 4</td>\n",
  877. " <td> p3</td>\n",
  878. " <td>NaN</td>\n",
  879. " </tr>\n",
  880. " <tr>\n",
  881. " <th>1118</th>\n",
  882. " <td> 531.6913</td>\n",
  883. " <td> EXP</td>\n",
  884. " <td> New trial (rep=0, index=140): {'stim': 'probe2'}</td>\n",
  885. " <td> 4</td>\n",
  886. " <td> p3</td>\n",
  887. " <td>NaN</td>\n",
  888. " </tr>\n",
  889. " <tr>\n",
  890. " <th>1377</th>\n",
  891. " <td> 605.1392</td>\n",
  892. " <td> EXP</td>\n",
  893. " <td> New trial (rep=0, index=173): {'stim': 'probe2'}</td>\n",
  894. " <td> 4</td>\n",
  895. " <td> p3</td>\n",
  896. " <td>NaN</td>\n",
  897. " </tr>\n",
  898. " <tr>\n",
  899. " <th>1850</th>\n",
  900. " <td> 734.6236</td>\n",
  901. " <td> EXP</td>\n",
  902. " <td> New trial (rep=0, index=234): {'stim': 'probe2'}</td>\n",
  903. " <td> 4</td>\n",
  904. " <td> p3</td>\n",
  905. " <td>NaN</td>\n",
  906. " </tr>\n",
  907. " <tr>\n",
  908. " <th>2001</th>\n",
  909. " <td> 780.0533</td>\n",
  910. " <td> EXP</td>\n",
  911. " <td> New trial (rep=0, index=253): {'stim': 'probe2'}</td>\n",
  912. " <td> 4</td>\n",
  913. " <td> p3</td>\n",
  914. " <td>NaN</td>\n",
  915. " </tr>\n",
  916. " <tr>\n",
  917. " <th>2113</th>\n",
  918. " <td> 815.4764</td>\n",
  919. " <td> EXP</td>\n",
  920. " <td> New trial (rep=0, index=267): {'stim': 'probe2'}</td>\n",
  921. " <td> 4</td>\n",
  922. " <td> p3</td>\n",
  923. " <td>NaN</td>\n",
  924. " </tr>\n",
  925. " <tr>\n",
  926. " <th>2171</th>\n",
  927. " <td> 836.8906</td>\n",
  928. " <td> EXP</td>\n",
  929. " <td> New trial (rep=0, index=274): {'stim': 'probe2'}</td>\n",
  930. " <td> 4</td>\n",
  931. " <td> p3</td>\n",
  932. " <td>NaN</td>\n",
  933. " </tr>\n",
  934. " <tr>\n",
  935. " <th>2329</th>\n",
  936. " <td> 884.3214</td>\n",
  937. " <td> EXP</td>\n",
  938. " <td> New trial (rep=0, index=294): {'stim': 'probe2'}</td>\n",
  939. " <td> 4</td>\n",
  940. " <td> p3</td>\n",
  941. " <td>NaN</td>\n",
  942. " </tr>\n",
  943. " <tr>\n",
  944. " <th>2596</th>\n",
  945. " <td> 959.7704</td>\n",
  946. " <td> EXP</td>\n",
  947. " <td> New trial (rep=0, index=328): {'stim': 'probe2'}</td>\n",
  948. " <td> 4</td>\n",
  949. " <td> p3</td>\n",
  950. " <td>NaN</td>\n",
  951. " </tr>\n",
  952. " <tr>\n",
  953. " <th>2754</th>\n",
  954. " <td> 1007.2010</td>\n",
  955. " <td> EXP</td>\n",
  956. " <td> New trial (rep=0, index=348): {'stim': 'probe2'}</td>\n",
  957. " <td> 4</td>\n",
  958. " <td> p3</td>\n",
  959. " <td>NaN</td>\n",
  960. " </tr>\n",
  961. " </tbody>\n",
  962. "</table>\n",
  963. "</div>"
  964. ],
  965. "metadata": {},
  966. "output_type": "pyout",
  967. "prompt_number": 7,
  968. "text": [
  969. " onsets log2 log3 run \\\n",
  970. "217 253.6934 EXP New trial (rep=0, index=27): {'stim': 'probe2'} 4 \n",
  971. "291 279.1104 EXP New trial (rep=0, index=36): {'stim': 'probe2'} 4 \n",
  972. "488 336.5476 EXP New trial (rep=0, index=61): {'stim': 'probe2'} 4 \n",
  973. "630 379.9758 EXP New trial (rep=0, index=79): {'stim': 'probe2'} 4 \n",
  974. "765 421.4029 EXP New trial (rep=0, index=96): {'stim': 'probe2'} 4 \n",
  975. "854 450.8385 EXP New trial (rep=0, index=107): {'stim': 'probe2'} 4 \n",
  976. "982 490.2656 EXP New trial (rep=0, index=123): {'stim': 'probe2'} 4 \n",
  977. "1118 531.6913 EXP New trial (rep=0, index=140): {'stim': 'probe2'} 4 \n",
  978. "1377 605.1392 EXP New trial (rep=0, index=173): {'stim': 'probe2'} 4 \n",
  979. "1850 734.6236 EXP New trial (rep=0, index=234): {'stim': 'probe2'} 4 \n",
  980. "2001 780.0533 EXP New trial (rep=0, index=253): {'stim': 'probe2'} 4 \n",
  981. "2113 815.4764 EXP New trial (rep=0, index=267): {'stim': 'probe2'} 4 \n",
  982. "2171 836.8906 EXP New trial (rep=0, index=274): {'stim': 'probe2'} 4 \n",
  983. "2329 884.3214 EXP New trial (rep=0, index=294): {'stim': 'probe2'} 4 \n",
  984. "2596 959.7704 EXP New trial (rep=0, index=328): {'stim': 'probe2'} 4 \n",
  985. "2754 1007.2010 EXP New trial (rep=0, index=348): {'stim': 'probe2'} 4 \n",
  986. "\n",
  987. " subject trigger_time \n",
  988. "217 p3 NaN \n",
  989. "291 p3 NaN \n",
  990. "488 p3 NaN \n",
  991. "630 p3 NaN \n",
  992. "765 p3 NaN \n",
  993. "854 p3 NaN \n",
  994. "982 p3 NaN \n",
  995. "1118 p3 NaN \n",
  996. "1377 p3 NaN \n",
  997. "1850 p3 NaN \n",
  998. "2001 p3 NaN \n",
  999. "2113 p3 NaN \n",
  1000. "2171 p3 NaN \n",
  1001. "2329 p3 NaN \n",
  1002. "2596 p3 NaN \n",
  1003. "2754 p3 NaN "
  1004. ]
  1005. }
  1006. ],
  1007. "prompt_number": 7
  1008. },
  1009. {
  1010. "cell_type": "code",
  1011. "collapsed": false,
  1012. "input": [
  1013. "#Now, I want to add it to my forloop. I want to add a column that says the condition name for each partial string: But I get an error:\n",
  1014. "runs = [1,2,3,4]\n",
  1015. "subjects = ['p3'] #, 'p3']\n",
  1016. "names = ['on', 'off','aware', 'unaware'] \n",
  1017. "\n",
  1018. " \n",
  1019. "for run in runs:\n",
  1020. " for sub in subjects:\n",
  1021. " df = pd.DataFrame()\n",
  1022. " \n",
  1023. " df = df.append(pd.read_csv('/home/jminas/Dropbox/SART/fMRI/data/%s_schedule%d.log' % (sub, run), delimiter='\\t', header=None), ignore_index=True)\n",
  1024. " df.columns = ['onsets', 'log2', 'log3']\n",
  1025. " df['run'] = run\n",
  1026. " df['subject'] = sub\n",
  1027. " df['trigger_time'] = df.apply(lambda row:( row['onsets'] if (row['log3']=='Keypress: num_add') else None), axis=1)\n",
  1028. " df['condition'] = df.apply(lambda row: ('probe2' if row[row['log3'].str.contains(\"'probe2'\")==True] \n",
  1029. " else 'probe2' if (row[row['log3'].str.contains(\"'probe2'\")]) \n",
  1030. " else 'target' if (row[row['log3'].str.contains(\"'stim': 3\")]) \n",
  1031. " else 'nontarget'), axis=1)"
  1032. ],
  1033. "language": "python",
  1034. "metadata": {},
  1035. "outputs": [
  1036. {
  1037. "ename": "AttributeError",
  1038. "evalue": "(\"'str' object has no attribute 'str'\", u'occurred at index 0')",
  1039. "output_type": "pyerr",
  1040. "traceback": [
  1041. "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m\n\u001b[1;31mAttributeError\u001b[0m Traceback (most recent call last)",
  1042. "\u001b[1;32m<ipython-input-9-113932e3650f>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m()\u001b[0m\n\u001b[0;32m 17\u001b[0m \u001b[1;32melse\u001b[0m \u001b[1;34m'probe2'\u001b[0m \u001b[1;32mif\u001b[0m \u001b[1;33m(\u001b[0m\u001b[0mrow\u001b[0m\u001b[1;33m[\u001b[0m\u001b[0mrow\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;34m'log3'\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mstr\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mcontains\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m\"'probe2'\"\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m 18\u001b[0m \u001b[1;32melse\u001b[0m \u001b[1;34m'target'\u001b[0m \u001b[1;32mif\u001b[0m \u001b[1;33m(\u001b[0m\u001b[0mrow\u001b[0m\u001b[1;33m[\u001b[0m\u001b[0mrow\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;34m'log3'\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mstr\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mcontains\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m\"'stim': 3\"\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m---> 19\u001b[1;33m else 'nontarget'), axis=1)\n\u001b[0m",
  1043. "\u001b[1;32m/home/jminas/Enthought/Canopy_64bit/User/lib/python2.7/site-packages/pandas/core/frame.pyc\u001b[0m in \u001b[0;36mapply\u001b[1;34m(self, func, axis, broadcast, raw, reduce, args, **kwds)\u001b[0m\n\u001b[0;32m 3469\u001b[0m \u001b[1;32mif\u001b[0m \u001b[0mreduce\u001b[0m \u001b[1;32mis\u001b[0m \u001b[0mNone\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m 3470\u001b[0m \u001b[0mreduce\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mTrue\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m-> 3471\u001b[1;33m \u001b[1;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_apply_standard\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mf\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0maxis\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mreduce\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mreduce\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m 3472\u001b[0m \u001b[1;32melse\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m 3473\u001b[0m \u001b[1;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_apply_broadcast\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mf\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0maxis\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
  1044. "\u001b[1;32m/home/jminas/Enthought/Canopy_64bit/User/lib/python2.7/site-packages/pandas/core/frame.pyc\u001b[0m in \u001b[0;36m_apply_standard\u001b[1;34m(self, func, axis, ignore_failures, reduce)\u001b[0m\n\u001b[0;32m 3558\u001b[0m \u001b[1;32mtry\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m 3559\u001b[0m \u001b[1;32mfor\u001b[0m \u001b[0mi\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mv\u001b[0m \u001b[1;32min\u001b[0m \u001b[0menumerate\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mseries_gen\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m-> 3560\u001b[1;33m \u001b[0mresults\u001b[0m\u001b[1;33m[\u001b[0m\u001b[0mi\u001b[0m\u001b[1;33m]\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mfunc\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mv\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m 3561\u001b[0m \u001b[0mkeys\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mappend\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mv\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mname\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m 3562\u001b[0m \u001b[1;32mexcept\u001b[0m \u001b[0mException\u001b[0m \u001b[1;32mas\u001b[0m \u001b[0me\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
  1045. "\u001b[1;32m<ipython-input-9-113932e3650f>\u001b[0m in \u001b[0;36m<lambda>\u001b[1;34m(row)\u001b[0m\n\u001b[0;32m 14\u001b[0m \u001b[0mdf\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;34m'subject'\u001b[0m\u001b[1;33m]\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0msub\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m 15\u001b[0m \u001b[0mdf\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;34m'trigger_time'\u001b[0m\u001b[1;33m]\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mdf\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mapply\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;32mlambda\u001b[0m \u001b[0mrow\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m(\u001b[0m \u001b[0mrow\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;34m'onsets'\u001b[0m\u001b[1;33m]\u001b[0m \u001b[1;32mif\u001b[0m \u001b[1;33m(\u001b[0m\u001b[0mrow\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;34m'log3'\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m==\u001b[0m\u001b[1;34m'Keypress: num_add'\u001b[0m\u001b[1;33m)\u001b[0m \u001b[1;32melse\u001b[0m \u001b[0mNone\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0maxis\u001b[0m\u001b[1;33m=\u001b[0m\u001b[1;36m1\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m---> 16\u001b[1;33m df['condition'] = df.apply(lambda row: ('probe2' if row[row['log3'].str.contains(\"'probe2'\")==True] \n\u001b[0m\u001b[0;32m 17\u001b[0m \u001b[1;32melse\u001b[0m \u001b[1;34m'probe2'\u001b[0m \u001b[1;32mif\u001b[0m \u001b[1;33m(\u001b[0m\u001b[0mrow\u001b[0m\u001b[1;33m[\u001b[0m\u001b[0mrow\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;34m'log3'\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mstr\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mcontains\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m\"'probe2'\"\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m 18\u001b[0m \u001b[1;32melse\u001b[0m \u001b[1;34m'target'\u001b[0m \u001b[1;32mif\u001b[0m \u001b[1;33m(\u001b[0m\u001b[0mrow\u001b[0m\u001b[1;33m[\u001b[0m\u001b[0mrow\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;34m'log3'\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mstr\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mcontains\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m\"'stim': 3\"\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
  1046. "\u001b[1;31mAttributeError\u001b[0m: (\"'str' object has no attribute 'str'\", u'occurred at index 0')"
  1047. ]
  1048. }
  1049. ],
  1050. "prompt_number": 9
  1051. },
  1052. {
  1053. "cell_type": "code",
  1054. "collapsed": false,
  1055. "input": [],
  1056. "language": "python",
  1057. "metadata": {},
  1058. "outputs": []
  1059. }
  1060. ],
  1061. "metadata": {}
  1062. }
  1063. ]
  1064. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!