Skip to content
Snippets Groups Projects
pybis demo.ipynb 260 KiB
Newer Older
  • Learn to ignore specific revisions
  • Swen Vermeul's avatar
    Swen Vermeul committed
    5001 5002 5003 5004 5005 5006 5007 5008 5009 5010 5011 5012 5013 5014 5015 5016 5017 5018 5019 5020 5021 5022 5023 5024 5025 5026 5027 5028 5029 5030 5031 5032 5033 5034 5035 5036 5037 5038 5039 5040 5041 5042 5043 5044 5045 5046 5047 5048 5049 5050 5051 5052 5053 5054 5055 5056 5057 5058 5059 5060 5061 5062 5063 5064 5065 5066 5067 5068 5069 5070 5071 5072 5073 5074 5075 5076 5077 5078 5079 5080 5081 5082 5083 5084 5085 5086 5087 5088 5089 5090 5091 5092 5093 5094 5095 5096 5097 5098 5099 5100 5101 5102 5103 5104 5105 5106 5107 5108 5109 5110 5111 5112 5113 5114 5115 5116 5117 5118 5119 5120 5121 5122 5123 5124 5125 5126 5127 5128 5129 5130 5131 5132 5133 5134 5135 5136 5137 5138 5139 5140 5141 5142 5143 5144 5145 5146 5147 5148 5149 5150 5151 5152 5153 5154 5155 5156 5157 5158 5159 5160 5161 5162 5163 5164 5165 5166 5167 5168 5169 5170 5171 5172 5173 5174 5175 5176 5177 5178 5179 5180 5181 5182 5183 5184 5185 5186 5187 5188 5189 5190 5191 5192 5193 5194 5195 5196 5197 5198 5199 5200 5201 5202 5203 5204 5205 5206 5207 5208 5209 5210 5211 5212 5213 5214 5215 5216 5217 5218 5219 5220 5221 5222 5223 5224 5225 5226 5227 5228 5229 5230 5231 5232 5233 5234 5235 5236 5237 5238 5239 5240 5241 5242 5243 5244 5245 5246 5247 5248 5249 5250 5251 5252 5253 5254 5255 5256 5257 5258 5259 5260 5261 5262 5263 5264 5265 5266 5267 5268 5269 5270 5271 5272 5273 5274 5275 5276 5277 5278 5279 5280 5281 5282 5283 5284 5285 5286 5287 5288 5289 5290 5291 5292 5293 5294 5295 5296 5297 5298 5299 5300 5301 5302 5303 5304 5305 5306 5307 5308 5309 5310 5311 5312 5313 5314 5315 5316 5317 5318 5319 5320 5321 5322 5323 5324 5325 5326 5327 5328 5329 5330 5331 5332 5333 5334 5335 5336 5337 5338 5339 5340 5341 5342 5343 5344 5345 5346 5347 5348 5349 5350 5351 5352 5353 5354 5355 5356 5357 5358 5359 5360 5361 5362 5363 5364 5365 5366 5367 5368 5369 5370 5371 5372 5373 5374 5375 5376 5377 5378 5379 5380 5381 5382 5383 5384 5385 5386 5387 5388 5389 5390 5391 5392 5393 5394 5395 5396 5397 5398 5399 5400 5401 5402 5403 5404 5405 5406 5407 5408 5409 5410 5411 5412 5413 5414 5415 5416 5417 5418 5419 5420 5421 5422 5423 5424 5425 5426 5427 5428 5429 5430 5431 5432 5433 5434 5435 5436 5437 5438 5439 5440 5441 5442 5443 5444 5445 5446 5447 5448 5449 5450 5451 5452 5453 5454 5455
           "      <td>2016-07-22 11:20:03</td>\n",
           "    </tr>\n",
           "    <tr>\n",
           "      <th>29</th>\n",
           "      <td>/VERMEUL/HOW_WONDERFUL3</td>\n",
           "      <td>20160630105402002-83</td>\n",
           "      <td>None</td>\n",
           "      <td>UNKNOWN</td>\n",
           "      <td>vermeul</td>\n",
           "      <td>2016-06-30 16:54:02</td>\n",
           "      <td>vermeul</td>\n",
           "      <td>2016-06-30 16:54:02</td>\n",
           "    </tr>\n",
           "    <tr>\n",
           "      <th>...</th>\n",
           "      <td>...</td>\n",
           "      <td>...</td>\n",
           "      <td>...</td>\n",
           "      <td>...</td>\n",
           "      <td>...</td>\n",
           "      <td>...</td>\n",
           "      <td>...</td>\n",
           "      <td>...</td>\n",
           "    </tr>\n",
           "    <tr>\n",
           "      <th>63</th>\n",
           "      <td>/DEFAULT/TEST_GET_BY_PERMID_WED_171004_000946</td>\n",
           "      <td>20171004000946100-531</td>\n",
           "      <td>None</td>\n",
           "      <td>UNKNOWN</td>\n",
           "      <td>admin</td>\n",
           "      <td>2017-10-04 00:09:46</td>\n",
           "      <td>admin</td>\n",
           "      <td>2017-10-04 00:09:46</td>\n",
           "    </tr>\n",
           "    <tr>\n",
           "      <th>64</th>\n",
           "      <td>/DEFAULT/TEST_GET_BY_PERMID_WED_171004_001010</td>\n",
           "      <td>20171004001010530-534</td>\n",
           "      <td>None</td>\n",
           "      <td>UNKNOWN</td>\n",
           "      <td>admin</td>\n",
           "      <td>2017-10-04 00:10:11</td>\n",
           "      <td>admin</td>\n",
           "      <td>2017-10-04 00:10:11</td>\n",
           "    </tr>\n",
           "    <tr>\n",
           "      <th>65</th>\n",
           "      <td>/DEFAULT/TEST_GET_BY_PERMID_WED_171004_001021</td>\n",
           "      <td>20171004001020929-537</td>\n",
           "      <td>None</td>\n",
           "      <td>UNKNOWN</td>\n",
           "      <td>admin</td>\n",
           "      <td>2017-10-04 00:10:21</td>\n",
           "      <td>admin</td>\n",
           "      <td>2017-10-04 00:10:21</td>\n",
           "    </tr>\n",
           "    <tr>\n",
           "      <th>66</th>\n",
           "      <td>/DEFAULT/TEST_SAMPLE_FRI_171208_174600</td>\n",
           "      <td>20171208174559963-591</td>\n",
           "      <td>None</td>\n",
           "      <td>UNKNOWN</td>\n",
           "      <td>admin</td>\n",
           "      <td>2017-12-08 17:46:00</td>\n",
           "      <td>admin</td>\n",
           "      <td>2017-12-08 17:46:00</td>\n",
           "    </tr>\n",
           "    <tr>\n",
           "      <th>67</th>\n",
           "      <td>/DEFAULT/TEST_SAMPLE_MON_171211_105927</td>\n",
           "      <td>20171211105946839-592</td>\n",
           "      <td>None</td>\n",
           "      <td>UNKNOWN</td>\n",
           "      <td>admin</td>\n",
           "      <td>2017-12-11 10:59:47</td>\n",
           "      <td>admin</td>\n",
           "      <td>2017-12-11 10:59:47</td>\n",
           "    </tr>\n",
           "    <tr>\n",
           "      <th>68</th>\n",
           "      <td>/DEFAULT/TEST_SAMPLE_MON_171211_110318</td>\n",
           "      <td>20171211110357956-594</td>\n",
           "      <td>None</td>\n",
           "      <td>UNKNOWN</td>\n",
           "      <td>admin</td>\n",
           "      <td>2017-12-11 11:03:58</td>\n",
           "      <td>admin</td>\n",
           "      <td>2017-12-11 11:03:58</td>\n",
           "    </tr>\n",
           "    <tr>\n",
           "      <th>69</th>\n",
           "      <td>/DEFAULT/TEST_SAMPLE_TUE_180227_223409</td>\n",
           "      <td>20180227223406110-677</td>\n",
           "      <td>None</td>\n",
           "      <td>UNKNOWN</td>\n",
           "      <td>vermeul</td>\n",
           "      <td>2018-02-27 22:34:06</td>\n",
           "      <td>vermeul</td>\n",
           "      <td>2018-02-27 22:34:06</td>\n",
           "    </tr>\n",
           "    <tr>\n",
           "      <th>70</th>\n",
           "      <td>/DEFAULT/TEST_SAMPLE_TUE_180227_223428</td>\n",
           "      <td>20180227223424887-681</td>\n",
           "      <td>None</td>\n",
           "      <td>UNKNOWN</td>\n",
           "      <td>vermeul</td>\n",
           "      <td>2018-02-27 22:34:25</td>\n",
           "      <td>vermeul</td>\n",
           "      <td>2018-02-27 22:34:25</td>\n",
           "    </tr>\n",
           "    <tr>\n",
           "      <th>71</th>\n",
           "      <td>/MY_NEW_SPACE/YEA21</td>\n",
           "      <td>20161025010638912-382</td>\n",
           "      <td>/MY_NEW_SPACE/VERMEUL_PROJECT/MY_SPECIAL_EXPER...</td>\n",
           "      <td>YEAST</td>\n",
           "      <td>vermeul</td>\n",
           "      <td>2016-10-25 01:06:39</td>\n",
           "      <td>vermeul</td>\n",
           "      <td>2017-01-19 00:02:53</td>\n",
           "    </tr>\n",
           "    <tr>\n",
           "      <th>72</th>\n",
           "      <td>/MY_NEW_SPACE/YEA34</td>\n",
           "      <td>20161108230958839-384</td>\n",
           "      <td>/MY_NEW_SPACE/VERMEUL_PROJECT/MY_SPECIAL_EXPER...</td>\n",
           "      <td>YEAST</td>\n",
           "      <td>vermeul</td>\n",
           "      <td>2016-11-08 23:09:59</td>\n",
           "      <td>vermeul</td>\n",
           "      <td>2017-01-25 23:48:14</td>\n",
           "    </tr>\n",
           "    <tr>\n",
           "      <th>73</th>\n",
           "      <td>/VERMEUL/YEA35</td>\n",
           "      <td>20161108231507755-385</td>\n",
           "      <td>None</td>\n",
           "      <td>YEAST</td>\n",
           "      <td>vermeul</td>\n",
           "      <td>2016-11-08 23:15:08</td>\n",
           "      <td>vermeul</td>\n",
           "      <td>2016-11-08 23:15:08</td>\n",
           "    </tr>\n",
           "    <tr>\n",
           "      <th>74</th>\n",
           "      <td>/VERMEUL/YEA36</td>\n",
           "      <td>20161108231536195-386</td>\n",
           "      <td>None</td>\n",
           "      <td>YEAST</td>\n",
           "      <td>vermeul</td>\n",
           "      <td>2016-11-08 23:15:36</td>\n",
           "      <td>vermeul</td>\n",
           "      <td>2016-11-08 23:15:36</td>\n",
           "    </tr>\n",
           "    <tr>\n",
           "      <th>75</th>\n",
           "      <td>/VERMEUL/YEA37</td>\n",
           "      <td>20161108231604599-387</td>\n",
           "      <td>None</td>\n",
           "      <td>YEAST</td>\n",
           "      <td>vermeul</td>\n",
           "      <td>2016-11-08 23:16:05</td>\n",
           "      <td>vermeul</td>\n",
           "      <td>2016-11-08 23:16:05</td>\n",
           "    </tr>\n",
           "    <tr>\n",
           "      <th>76</th>\n",
           "      <td>/MY_NEW_SPACE/YEA38</td>\n",
           "      <td>20161108232203635-388</td>\n",
           "      <td>None</td>\n",
           "      <td>YEAST</td>\n",
           "      <td>vermeul</td>\n",
           "      <td>2016-11-08 23:22:04</td>\n",
           "      <td>vermeul</td>\n",
           "      <td>2017-01-18 17:16:50</td>\n",
           "    </tr>\n",
           "    <tr>\n",
           "      <th>77</th>\n",
           "      <td>/VERMEUL/YEA39</td>\n",
           "      <td>20161108232240159-389</td>\n",
           "      <td>None</td>\n",
           "      <td>YEAST</td>\n",
           "      <td>vermeul</td>\n",
           "      <td>2016-11-08 23:22:40</td>\n",
           "      <td>vermeul</td>\n",
           "      <td>2016-11-08 23:22:40</td>\n",
           "    </tr>\n",
           "    <tr>\n",
           "      <th>78</th>\n",
           "      <td>/VERMEUL/YEA40</td>\n",
           "      <td>20161108233530315-390</td>\n",
           "      <td>None</td>\n",
           "      <td>YEAST</td>\n",
           "      <td>vermeul</td>\n",
           "      <td>2016-11-08 23:35:30</td>\n",
           "      <td>vermeul</td>\n",
           "      <td>2016-11-08 23:35:30</td>\n",
           "    </tr>\n",
           "    <tr>\n",
           "      <th>79</th>\n",
           "      <td>/VERMEUL/YEA41</td>\n",
           "      <td>20161109142859057-391</td>\n",
           "      <td>None</td>\n",
           "      <td>YEAST</td>\n",
           "      <td>vermeul</td>\n",
           "      <td>2016-11-09 14:28:59</td>\n",
           "      <td>vermeul</td>\n",
           "      <td>2016-11-09 14:28:59</td>\n",
           "    </tr>\n",
           "    <tr>\n",
           "      <th>80</th>\n",
           "      <td>/VERMEUL/YEA63</td>\n",
           "      <td>20170227104527381-434</td>\n",
           "      <td>None</td>\n",
           "      <td>YEAST</td>\n",
           "      <td>vermeul</td>\n",
           "      <td>2017-02-27 10:45:27</td>\n",
           "      <td>vermeul</td>\n",
           "      <td>2017-02-27 10:45:27</td>\n",
           "    </tr>\n",
           "    <tr>\n",
           "      <th>81</th>\n",
           "      <td>/VERMEUL/YEA64</td>\n",
           "      <td>20170227104651646-435</td>\n",
           "      <td>None</td>\n",
           "      <td>YEAST</td>\n",
           "      <td>vermeul</td>\n",
           "      <td>2017-02-27 10:46:52</td>\n",
           "      <td>vermeul</td>\n",
           "      <td>2017-02-27 15:51:34</td>\n",
           "    </tr>\n",
           "    <tr>\n",
           "      <th>82</th>\n",
           "      <td>/VERMEUL/YEA65</td>\n",
           "      <td>20170227154403209-436</td>\n",
           "      <td>None</td>\n",
           "      <td>YEAST</td>\n",
           "      <td>vermeul</td>\n",
           "      <td>2017-02-27 15:44:03</td>\n",
           "      <td>vermeul</td>\n",
           "      <td>2017-03-27 12:21:05</td>\n",
           "    </tr>\n",
           "    <tr>\n",
           "      <th>83</th>\n",
           "      <td>/VERMEUL/YEA66</td>\n",
           "      <td>20170323101102451-441</td>\n",
           "      <td>None</td>\n",
           "      <td>YEAST</td>\n",
           "      <td>vermeul</td>\n",
           "      <td>2017-03-23 10:11:02</td>\n",
           "      <td>vermeul</td>\n",
           "      <td>2017-03-27 12:21:05</td>\n",
           "    </tr>\n",
           "    <tr>\n",
           "      <th>84</th>\n",
           "      <td>/VERMEUL/YEA67</td>\n",
           "      <td>20170327113258723-442</td>\n",
           "      <td>None</td>\n",
           "      <td>YEAST</td>\n",
           "      <td>vermeul</td>\n",
           "      <td>2017-03-27 11:32:59</td>\n",
           "      <td>vermeul</td>\n",
           "      <td>2017-03-27 12:03:46</td>\n",
           "    </tr>\n",
           "    <tr>\n",
           "      <th>85</th>\n",
           "      <td>/VERMEUL/YEA68</td>\n",
           "      <td>20170327122105199-443</td>\n",
           "      <td>None</td>\n",
           "      <td>YEAST</td>\n",
           "      <td>vermeul</td>\n",
           "      <td>2017-03-27 12:21:05</td>\n",
           "      <td>vermeul</td>\n",
           "      <td>2017-03-27 12:25:41</td>\n",
           "    </tr>\n",
           "    <tr>\n",
           "      <th>86</th>\n",
           "      <td>/VERMEUL/YEA71</td>\n",
           "      <td>20170518112158124-516</td>\n",
           "      <td>None</td>\n",
           "      <td>YEAST</td>\n",
           "      <td>vermeul</td>\n",
           "      <td>2017-05-18 11:21:58</td>\n",
           "      <td>vermeul</td>\n",
           "      <td>2017-05-18 11:21:58</td>\n",
           "    </tr>\n",
           "    <tr>\n",
           "      <th>87</th>\n",
           "      <td>/VERMEUL/YEA72</td>\n",
           "      <td>20170518112248330-517</td>\n",
           "      <td>None</td>\n",
           "      <td>YEAST</td>\n",
           "      <td>vermeul</td>\n",
           "      <td>2017-05-18 11:22:48</td>\n",
           "      <td>vermeul</td>\n",
           "      <td>2017-05-18 11:22:48</td>\n",
           "    </tr>\n",
           "    <tr>\n",
           "      <th>88</th>\n",
           "      <td>/VERMEUL/YEA73</td>\n",
           "      <td>20170518112726306-519</td>\n",
           "      <td>None</td>\n",
           "      <td>YEAST</td>\n",
           "      <td>vermeul</td>\n",
           "      <td>2017-05-18 11:27:26</td>\n",
           "      <td>vermeul</td>\n",
           "      <td>2017-05-18 11:27:26</td>\n",
           "    </tr>\n",
           "    <tr>\n",
           "      <th>89</th>\n",
           "      <td>/VERMEUL/YEA74</td>\n",
           "      <td>20170518112739712-520</td>\n",
           "      <td>None</td>\n",
           "      <td>YEAST</td>\n",
           "      <td>vermeul</td>\n",
           "      <td>2017-05-18 11:27:40</td>\n",
           "      <td>vermeul</td>\n",
           "      <td>2017-05-18 11:27:40</td>\n",
           "    </tr>\n",
           "    <tr>\n",
           "      <th>90</th>\n",
           "      <td>/VERMEUL/YEA75</td>\n",
           "      <td>20170518112808649-521</td>\n",
           "      <td>None</td>\n",
           "      <td>YEAST</td>\n",
           "      <td>vermeul</td>\n",
           "      <td>2017-05-18 11:28:09</td>\n",
           "      <td>vermeul</td>\n",
           "      <td>2017-05-18 11:28:12</td>\n",
           "    </tr>\n",
           "    <tr>\n",
           "      <th>91</th>\n",
           "      <td>/VERMEUL/YEA76</td>\n",
           "      <td>20171215141946133-620</td>\n",
           "      <td>None</td>\n",
           "      <td>YEAST</td>\n",
           "      <td>admin</td>\n",
           "      <td>2017-12-15 14:19:46</td>\n",
           "      <td>admin</td>\n",
           "      <td>2017-12-15 14:19:46</td>\n",
           "    </tr>\n",
           "    <tr>\n",
           "      <th>92</th>\n",
           "      <td>/VERMEUL/YET_ANOTHER_SAMPLE1</td>\n",
           "      <td>20160706002555747-209</td>\n",
           "      <td>None</td>\n",
           "      <td>UNKNOWN</td>\n",
           "      <td>vermeul</td>\n",
           "      <td>2016-07-06 00:25:56</td>\n",
           "      <td>vermeul</td>\n",
           "      <td>2017-06-22 10:56:33</td>\n",
           "    </tr>\n",
           "  </tbody>\n",
           "</table>\n",
           "<p>93 rows × 8 columns</p>\n",
           "</div>"
          ],
          "text/plain": [
           "    identifier                                     permId                 experiment                                           sample_type           registrator    registrationDate     modifier    modificationDate\n",
           "--  ---------------------------------------------  ---------------------  ---------------------------------------------------  --------------------  -------------  -------------------  ----------  -------------------\n",
           " 0  /VERMEUL/ANOTHER_SAMPLE1                       20160706001644827-208  None                                                 UNKNOWN               vermeul        2016-07-06 00:16:45  vermeul     2017-11-02 18:27:37\n",
           " 1  /ELN_SETTINGS/BENCH                            20171208173222809-574  /ELN_SETTINGS/STORAGES/STORAGES_COLLECTION           STORAGE               admin          2017-12-08 17:32:23  admin       2017-12-08 17:32:23\n",
           " 2  /VERMEUL/BLAJLSD                               20160630111949369-89   None                                                 UNKNOWN               vermeul        2016-06-30 17:19:49  vermeul     2017-06-22 02:40:01\n",
           " 3  /MY_NEW_SPACE/CHILD_OF_SAMPLE1                 20160705234504004-206  None                                                 UNKNOWN               vermeul        2016-07-05 23:45:04  vermeul     2017-09-20 14:12:03\n",
           " 4  /DEFAULT/CHILD_SAMPLE_MON_171211_112532        20171211112551150-600  None                                                 UNKNOWN               admin          2017-12-11 11:25:51  admin       2017-12-11 11:25:51\n",
           " 5  /DEFAULT/CHILD_SAMPLE_MON_171211_112859        20171211112918769-603  None                                                 UNKNOWN               admin          2017-12-11 11:29:19  admin       2017-12-11 11:29:19\n",
           " 6  /DEFAULT/CHILD_SAMPLE_MON_171211_123501        20171211123518060-606  None                                                 UNKNOWN               admin          2017-12-11 12:35:18  admin       2017-12-11 12:35:18\n",
           " 7  /DEFAULT/CHILD_SAMPLE_MON_171211_123653        20171211123710443-609  None                                                 UNKNOWN               admin          2017-12-11 12:37:10  admin       2017-12-11 12:37:10\n",
           " 8  /DEFAULT/CHILD_SAMPLE_MON_171211_123736        20171211123753331-612  None                                                 UNKNOWN               admin          2017-12-11 12:37:53  admin       2017-12-11 12:37:53\n",
           " 9  /DEFAULT/CHILD_SAMPLE_MON_171211_123757        20171211123813756-615  None                                                 UNKNOWN               admin          2017-12-11 12:38:14  admin       2017-12-11 12:38:14\n",
           "10  /DEFAULT/CHILD_SAMPLE_MON_171211_134640        20171211134641170-618  None                                                 UNKNOWN               admin          2017-12-11 13:46:41  admin       2017-12-11 13:46:41\n",
           "11  /DEFAULT/CHILD_SAMPLE_MON_171218_164249        20171218164250384-644  None                                                 UNKNOWN               admin          2017-12-18 16:42:50  admin       2017-12-18 16:42:50\n",
           "12  /DEFAULT/CHILD_SAMPLE_TUE_171219_110150        20171219110155327-649  None                                                 UNKNOWN               admin          2017-12-19 11:01:55  admin       2017-12-19 11:01:55\n",
           "13  /DEFAULT/CHILD_SAMPLE_TUE_180227_223411        20180227223408486-680  None                                                 UNKNOWN               vermeul        2018-02-27 22:34:08  vermeul     2018-02-27 22:34:08\n",
           "14  /DEFAULT/CHILD_SAMPLE_TUE_180227_223429        20180227223426765-684  None                                                 UNKNOWN               vermeul        2018-02-27 22:34:27  vermeul     2018-02-27 22:34:27\n",
           "15  /DEFAULT/CHILD_SAMPLE_TUE_180227_223705        20180227223703438-688  None                                                 UNKNOWN               vermeul        2018-02-27 22:37:03  vermeul     2018-02-27 22:37:03\n",
           "16  /DEFAULT/CHILD_SAMPLE_WED_180228_102753        20180228102751116-695  None                                                 UNKNOWN               vermeul        2018-02-28 10:27:51  vermeul     2018-02-28 10:27:51\n",
           "17  /DEFAULT/CHILD_SAMPLE_WED_180228_102803        20180228102800818-697  None                                                 UNKNOWN               vermeul        2018-02-28 10:28:01  vermeul     2018-02-28 10:28:01\n",
           "18  /DEFAULT/CHILD_SAMPLE_WED_180228_103709        20180228103707200-701  None                                                 UNKNOWN               vermeul        2018-02-28 10:37:07  vermeul     2018-02-28 10:37:07\n",
           "19  /DEFAULT/CHILD_SAMPLE_WED_180228_171049        20180228171050238-715  None                                                 UNKNOWN               vermeul        2018-02-28 17:10:50  vermeul     2018-02-28 17:10:50\n",
           "20  /ELN_SETTINGS/DEFAULT_STORAGE                  20171208173222809-575  /ELN_SETTINGS/STORAGES/STORAGES_COLLECTION           STORAGE               admin          2017-12-08 17:32:23  admin       2017-12-08 17:32:23\n",
           "21  /VERMEUL/EXP1                                  20170124170850531-422  /VERMEUL/PROJECT_ONE/PROJECT_ONE_EXP_1               EXPERIMENTAL_STEP     vermeul        2017-01-24 17:08:51  vermeul     2017-01-25 17:26:25\n",
           "22  /MATERIALS/FLY43                               20170104000802333-404  /MATERIALS/YEASTS/MY_EXPERIMENT007                   FLY                   vermeul        2017-01-04 00:08:02  vermeul     2017-02-27 10:04:19\n",
           "23  /MATERIALS/FLY45                               20170104000847172-405  /MATERIALS/YEASTS/MY_EXPERIMENT007                   FLY                   vermeul        2017-01-04 00:08:47  vermeul     2017-01-04 00:36:09\n",
           "24  /MY_NEW_SPACE/FLY51                            20170120010813349-416  /MY_NEW_SPACE/VERMEUL_PROJECT/MY_EXPERIMENT4         FLY                   vermeul        2017-01-20 01:08:13  vermeul     2017-05-15 14:41:20\n",
           "25  /VERMEUL/FLY84                                 20180831174909928-725  None                                                 FLY                   vermeul        2018-08-31 17:49:10  vermeul     2018-08-31 17:49:10\n",
           "26  /ELN_SETTINGS/GENERAL_ELN_SETTINGS             20171208173222969-576  None                                                 GENERAL_ELN_SETTINGS  admin          2017-12-08 17:32:23  admin       2017-12-08 17:32:23\n",
           "27  /MY_NEW_SPACE/HOW_WONDERFUL                    20160630105304285-81   /MY_NEW_SPACE/VERMEUL_PROJECT/MY_EXPERIMENT4         UNKNOWN               vermeul        2016-06-30 16:53:04  vermeul     2017-05-18 11:22:52\n",
           "28  /VERMEUL/HOW_WONDERFUL2                        20160630105337180-82   None                                                 UNKNOWN               vermeul        2016-06-30 16:53:37  vermeul     2016-07-22 11:20:03\n",
           "29  /VERMEUL/HOW_WONDERFUL3                        20160630105402002-83   None                                                 UNKNOWN               vermeul        2016-06-30 16:54:02  vermeul     2016-06-30 16:54:02\n",
           "30  /VERMEUL/HOW_WONDERFUL4                        20160630105953557-85   None                                                 UNKNOWN               vermeul        2016-06-30 16:59:54  vermeul     2016-06-30 16:59:54\n",
           "31  /VERMEUL/MON_160718_181552                     20160718181615356-214  None                                                 UNKNOWN               vermeul        2016-07-18 18:16:15  vermeul     2016-07-18 18:16:15\n",
           "32  /VERMEUL/MON_160718_181654                     20160718181656980-215  None                                                 UNKNOWN               vermeul        2016-07-18 18:16:57  vermeul     2016-08-17 17:52:35\n",
           "33  /ANOTHER_SPACE_NAME/MY_WONDERFUL_SAMPLE_NAME   20160720225637704-262  None                                                 UNKNOWN               vermeul        2016-07-20 22:56:38  vermeul     2016-12-01 22:56:28\n",
           "34  /VERMEUL/OH_WIE_SCHOEN_IST_PANAMA              20160630110733527-86   None                                                 UNKNOWN               vermeul        2016-06-30 17:07:34  vermeul     2016-07-06 00:11:45\n",
           "35  /VERMEUL/OH_WIE_SCHOEN_IST_PANAMA3             20160630112720553-90   None                                                 UNKNOWN               vermeul        2016-06-30 17:27:21  vermeul     2016-06-30 17:27:21\n",
           "36  /VERMEUL/OH_WIE_SCHOEN_IST_PANAMA5             20160706231053756-211  None                                                 UNKNOWN               vermeul        2016-07-06 23:10:54  vermeul     2016-07-06 23:10:54\n",
           "37  /DEFAULT/PARENT_SAMPLE_MON_171211_105928       20171211105947734-593  None                                                 UNKNOWN               admin          2017-12-11 10:59:48  admin       2017-12-11 10:59:48\n",
           "38  /DEFAULT/PARENT_SAMPLE_MON_171211_110500       20171211110519861-595  None                                                 UNKNOWN               admin          2017-12-11 11:05:20  admin       2017-12-11 11:05:20\n",
           "39  /DEFAULT/PARENT_SAMPLE_MON_171211_111846       20171211111905097-597  None                                                 UNKNOWN               admin          2017-12-11 11:19:05  admin       2017-12-11 11:19:05\n",
           "40  /DEFAULT/PARENT_SAMPLE_MON_171211_112532       20171211112550661-599  None                                                 UNKNOWN               admin          2017-12-11 11:25:51  admin       2017-12-11 11:25:51\n",
           "41  /DEFAULT/PARENT_SAMPLE_MON_171211_112859       20171211112918064-602  None                                                 UNKNOWN               admin          2017-12-11 11:29:18  admin       2017-12-11 11:29:19\n",
           "42  /DEFAULT/PARENT_SAMPLE_MON_171211_123501       20171211123517714-605  None                                                 UNKNOWN               admin          2017-12-11 12:35:18  admin       2017-12-11 12:35:18\n",
           "43  /DEFAULT/PARENT_SAMPLE_MON_171211_123653       20171211123710077-608  None                                                 UNKNOWN               admin          2017-12-11 12:37:10  admin       2017-12-11 12:37:10\n",
           "44  /DEFAULT/PARENT_SAMPLE_MON_171211_123736       20171211123753140-611  None                                                 UNKNOWN               admin          2017-12-11 12:37:53  admin       2017-12-11 12:37:53\n",
           "45  /DEFAULT/PARENT_SAMPLE_MON_171211_123757       20171211123813577-614  None                                                 UNKNOWN               admin          2017-12-11 12:38:14  admin       2017-12-11 12:38:14\n",
           "46  /DEFAULT/PARENT_SAMPLE_MON_171211_134640       20171211134641028-617  None                                                 UNKNOWN               admin          2017-12-11 13:46:41  admin       2017-12-11 13:46:41\n",
           "47  /DEFAULT/PARENT_SAMPLE_MON_171218_164249       20171218164249790-643  None                                                 UNKNOWN               admin          2017-12-18 16:42:50  admin       2017-12-18 16:42:50\n",
           "48  /DEFAULT/PARENT_SAMPLE_TUE_171219_110150       20171219110154568-648  None                                                 UNKNOWN               admin          2017-12-19 11:01:55  admin       2017-12-19 11:01:55\n",
           "49  /DEFAULT/PARENT_SAMPLE_TUE_180227_223411       20180227223407864-679  None                                                 UNKNOWN               vermeul        2018-02-27 22:34:08  vermeul     2018-02-27 22:34:08\n",
           "50  /DEFAULT/PARENT_SAMPLE_TUE_180227_223429       20180227223425882-683  None                                                 UNKNOWN               vermeul        2018-02-27 22:34:26  vermeul     2018-02-27 22:34:26\n",
           "51  /DEFAULT/PARENT_SAMPLE_TUE_180227_223705       20180227223702468-687  None                                                 UNKNOWN               vermeul        2018-02-27 22:37:02  vermeul     2018-02-27 22:37:02\n",
           "52  /DEFAULT/PARENT_SAMPLE_WED_180228_102753       20180228102750593-694  None                                                 UNKNOWN               vermeul        2018-02-28 10:27:51  vermeul     2018-02-28 10:27:51\n",
           "53  /DEFAULT/PARENT_SAMPLE_WED_180228_102803       20180228102800550-696  None                                                 UNKNOWN               vermeul        2018-02-28 10:28:01  vermeul     2018-02-28 10:28:01\n",
           "54  /DEFAULT/PARENT_SAMPLE_WED_180228_103709       20180228103706793-700  None                                                 UNKNOWN               vermeul        2018-02-28 10:37:07  vermeul     2018-02-28 10:37:07\n",
           "55  /DEFAULT/PARENT_SAMPLE_WED_180228_171049       20180228171049534-714  None                                                 UNKNOWN               vermeul        2018-02-28 17:10:50  vermeul     2018-02-28 17:10:50\n",
           "56  /VERMEUL/PROJ1_EXP2_SAMPLE_ONE                 20170115220351496-413  /VERMEUL/PROJECT_ONE/PROJECT_ONE_EXP_2               EXPERIMENTAL_STEP     vermeul        2017-01-15 22:03:52  vermeul     2017-01-15 22:04:54\n",
           "57  /VERMEUL/RNA47                                 20170108022244150-408  None                                                 RNA                   vermeul        2017-01-08 02:22:44  vermeul     2017-01-08 02:22:44\n",
           "58  /VERMEUL/S42                                   20161118132053585-392  None                                                 UNKNOWN               vermeul        2016-11-18 13:20:54  vermeul     2016-11-18 13:20:54\n",
           "59  /VERMEUL/TEST001                               20171215142200853-621  None                                                 UNKNOWN               admin          2017-12-15 14:22:01  admin       2017-12-15 14:22:01\n",
           "60  /DEFAULT/TEST_GET_BY_ID_WED_171004_000944      20171004000944680-530  None                                                 UNKNOWN               admin          2017-10-04 00:09:45  admin       2017-10-04 00:09:45\n",
           "61  /DEFAULT/TEST_GET_BY_ID_WED_171004_001010      20171004001009668-533  None                                                 UNKNOWN               admin          2017-10-04 00:10:10  admin       2017-10-04 00:10:10\n",
           "62  /DEFAULT/TEST_GET_BY_ID_WED_171004_001020      20171004001020119-536  None                                                 UNKNOWN               admin          2017-10-04 00:10:20  admin       2017-10-04 00:10:20\n",
           "63  /DEFAULT/TEST_GET_BY_PERMID_WED_171004_000946  20171004000946100-531  None                                                 UNKNOWN               admin          2017-10-04 00:09:46  admin       2017-10-04 00:09:46\n",
           "64  /DEFAULT/TEST_GET_BY_PERMID_WED_171004_001010  20171004001010530-534  None                                                 UNKNOWN               admin          2017-10-04 00:10:11  admin       2017-10-04 00:10:11\n",
           "65  /DEFAULT/TEST_GET_BY_PERMID_WED_171004_001021  20171004001020929-537  None                                                 UNKNOWN               admin          2017-10-04 00:10:21  admin       2017-10-04 00:10:21\n",
           "66  /DEFAULT/TEST_SAMPLE_FRI_171208_174600         20171208174559963-591  None                                                 UNKNOWN               admin          2017-12-08 17:46:00  admin       2017-12-08 17:46:00\n",
           "67  /DEFAULT/TEST_SAMPLE_MON_171211_105927         20171211105946839-592  None                                                 UNKNOWN               admin          2017-12-11 10:59:47  admin       2017-12-11 10:59:47\n",
           "68  /DEFAULT/TEST_SAMPLE_MON_171211_110318         20171211110357956-594  None                                                 UNKNOWN               admin          2017-12-11 11:03:58  admin       2017-12-11 11:03:58\n",
           "69  /DEFAULT/TEST_SAMPLE_TUE_180227_223409         20180227223406110-677  None                                                 UNKNOWN               vermeul        2018-02-27 22:34:06  vermeul     2018-02-27 22:34:06\n",
           "70  /DEFAULT/TEST_SAMPLE_TUE_180227_223428         20180227223424887-681  None                                                 UNKNOWN               vermeul        2018-02-27 22:34:25  vermeul     2018-02-27 22:34:25\n",
           "71  /MY_NEW_SPACE/YEA21                            20161025010638912-382  /MY_NEW_SPACE/VERMEUL_PROJECT/MY_SPECIAL_EXPERIMENT  YEAST                 vermeul        2016-10-25 01:06:39  vermeul     2017-01-19 00:02:53\n",
           "72  /MY_NEW_SPACE/YEA34                            20161108230958839-384  /MY_NEW_SPACE/VERMEUL_PROJECT/MY_SPECIAL_EXPERIMENT  YEAST                 vermeul        2016-11-08 23:09:59  vermeul     2017-01-25 23:48:14\n",
           "73  /VERMEUL/YEA35                                 20161108231507755-385  None                                                 YEAST                 vermeul        2016-11-08 23:15:08  vermeul     2016-11-08 23:15:08\n",
           "74  /VERMEUL/YEA36                                 20161108231536195-386  None                                                 YEAST                 vermeul        2016-11-08 23:15:36  vermeul     2016-11-08 23:15:36\n",
           "75  /VERMEUL/YEA37                                 20161108231604599-387  None                                                 YEAST                 vermeul        2016-11-08 23:16:05  vermeul     2016-11-08 23:16:05\n",
           "76  /MY_NEW_SPACE/YEA38                            20161108232203635-388  None                                                 YEAST                 vermeul        2016-11-08 23:22:04  vermeul     2017-01-18 17:16:50\n",
           "77  /VERMEUL/YEA39                                 20161108232240159-389  None                                                 YEAST                 vermeul        2016-11-08 23:22:40  vermeul     2016-11-08 23:22:40\n",
           "78  /VERMEUL/YEA40                                 20161108233530315-390  None                                                 YEAST                 vermeul        2016-11-08 23:35:30  vermeul     2016-11-08 23:35:30\n",
           "79  /VERMEUL/YEA41                                 20161109142859057-391  None                                                 YEAST                 vermeul        2016-11-09 14:28:59  vermeul     2016-11-09 14:28:59\n",
           "80  /VERMEUL/YEA63                                 20170227104527381-434  None                                                 YEAST                 vermeul        2017-02-27 10:45:27  vermeul     2017-02-27 10:45:27\n",
           "81  /VERMEUL/YEA64                                 20170227104651646-435  None                                                 YEAST                 vermeul        2017-02-27 10:46:52  vermeul     2017-02-27 15:51:34\n",
           "82  /VERMEUL/YEA65                                 20170227154403209-436  None                                                 YEAST                 vermeul        2017-02-27 15:44:03  vermeul     2017-03-27 12:21:05\n",
           "83  /VERMEUL/YEA66                                 20170323101102451-441  None                                                 YEAST                 vermeul        2017-03-23 10:11:02  vermeul     2017-03-27 12:21:05\n",
           "84  /VERMEUL/YEA67                                 20170327113258723-442  None                                                 YEAST                 vermeul        2017-03-27 11:32:59  vermeul     2017-03-27 12:03:46\n",
           "85  /VERMEUL/YEA68                                 20170327122105199-443  None                                                 YEAST                 vermeul        2017-03-27 12:21:05  vermeul     2017-03-27 12:25:41\n",
           "86  /VERMEUL/YEA71                                 20170518112158124-516  None                                                 YEAST                 vermeul        2017-05-18 11:21:58  vermeul     2017-05-18 11:21:58\n",
           "87  /VERMEUL/YEA72                                 20170518112248330-517  None                                                 YEAST                 vermeul        2017-05-18 11:22:48  vermeul     2017-05-18 11:22:48\n",
           "88  /VERMEUL/YEA73                                 20170518112726306-519  None                                                 YEAST                 vermeul        2017-05-18 11:27:26  vermeul     2017-05-18 11:27:26\n",
           "89  /VERMEUL/YEA74                                 20170518112739712-520  None                                                 YEAST                 vermeul        2017-05-18 11:27:40  vermeul     2017-05-18 11:27:40\n",
           "90  /VERMEUL/YEA75                                 20170518112808649-521  None                                                 YEAST                 vermeul        2017-05-18 11:28:09  vermeul     2017-05-18 11:28:12\n",
           "91  /VERMEUL/YEA76                                 20171215141946133-620  None                                                 YEAST                 admin          2017-12-15 14:19:46  admin       2017-12-15 14:19:46\n",
           "92  /VERMEUL/YET_ANOTHER_SAMPLE1                   20160706002555747-209  None                                                 UNKNOWN               vermeul        2016-07-06 00:25:56  vermeul     2017-06-22 10:56:33"
    
    Swen Vermeul's avatar
    Swen Vermeul committed
         "execution_count": 3,
    
         "metadata": {},
         "output_type": "execute_result"
        }
       ],
       "source": [
    
    Swen Vermeul's avatar
    Swen Vermeul committed
        "o.get_samples()"
    
       ]
      },
      {
       "cell_type": "code",
       "execution_count": 8,
    
    Swen Vermeul's avatar
    Swen Vermeul committed
       "metadata": {},
    
       "outputs": [
        {
         "data": {
          "text/html": [
           "\n",
           "            <table border=\"1\" class=\"dataframe\">\n",
           "            <thead>\n",
           "                <tr style=\"text-align: right;\">\n",
           "                <th>attribute</th>\n",
           "                <th>value</th>\n",
           "                </tr>\n",
           "            </thead>\n",
           "            <tbody>\n",
           "        <tr> <td>code</td> <td>MY_EXPERIMENT4</td> </tr><tr> <td>permId</td> <td>20160924020719018-358</td> </tr><tr> <td>identifier</td> <td>/MY_NEW_SPACE/VERMEUL_PROJECT/MY_EXPERIMENT4</td> </tr><tr> <td>type</td> <td>DEFAULT_EXPERIMENT</td> </tr><tr> <td>space</td> <td></td> </tr><tr> <td>project</td> <td>/MY_NEW_SPACE/VERMEUL_PROJECT</td> </tr><tr> <td>tags</td> <td>['A_tag', 'another_tag', 'too_late', 'tre']</td> </tr><tr><td>attachments</td><td></td></tr>\n",
           "            </tbody>\n",
           "            </table>\n",
           "        "
          ],
          "text/plain": [
           "<pybis.pybis.Experiment at 0x7f10ecdadd30>"
          ]
         },
         "execution_count": 8,
         "metadata": {},
         "output_type": "execute_result"
        }
       ],
       "source": [
        "e = o.get_experiment('/MY_NEW_SPACE/VERMEUL_PROJECT/MY_EXPERIMENT4')\n",
        "e"
       ]
      },
      {
       "cell_type": "markdown",
       "metadata": {},
       "source": [
        "controlled vocabulary: find out which terms are allowed by adding an underscore to the property."
       ]
      },
      {
       "cell_type": "code",
       "execution_count": 10,
    
    Swen Vermeul's avatar
    Swen Vermeul committed
       "metadata": {},
    
       "outputs": [
        {
         "data": {
          "text/html": [
           "\n",
           "            <table border=\"1\" class=\"dataframe\">\n",
           "            <thead>\n",
           "                <tr style=\"text-align: right;\">\n",
           "                <th>vocabulary term</th>\n",
           "                <th>label</th>\n",
           "                <th>description</th>\n",
           "                <th>vocabulary</th>\n",
           "                </tr>\n",
           "            </thead>\n",
           "            <tbody>\n",
           "        <tr> <td>CROSS</td> <td>cross</td> <td>The strain was produced by crossing two parent strains</td> <td>ORIGIN</td> </tr><tr> <td>TRANSFORMATION</td> <td>transformation</td> <td>The strain/ cell line was obtained by transformation</td> <td>ORIGIN</td> </tr><tr> <td>SPORULATION</td> <td>transformation sporulation</td> <td>The strain was obtained by sporulating a parent diploid strain</td> <td>ORIGIN</td> </tr><tr> <td>NEGATIVE_SELECTION</td> <td>negative selection</td> <td>The strain/cell line was obtained by negative selection</td> <td>ORIGIN</td> </tr><tr> <td>TRANSFECTION</td> <td>transfection</td> <td>The strain/cell line was obtained by transfection</td> <td>ORIGIN</td> </tr>\n",
           "            </tbody>\n",
           "            </table>\n",
           "        "
          ],
          "text/plain": [
           "<pybis.pybis.Vocabulary at 0x7fbfcacd5a58>"
          ]
         },
         "execution_count": 10,
         "metadata": {},
         "output_type": "execute_result"
        }
       ],
       "source": [
        "s_new.p.origin_"
       ]
      },
      {
       "cell_type": "markdown",
       "metadata": {},
       "source": [
        "assigning a wrong value to a property will lead to an error:"
       ]
      },
      {
       "cell_type": "code",
       "execution_count": 12,
    
    Swen Vermeul's avatar
    Swen Vermeul committed
       "metadata": {},
    
       "outputs": [
        {
         "ename": "ValueError",
         "evalue": "Value must be one of these terms: CROSS, TRANSFORMATION, SPORULATION, NEGATIVE_SELECTION, TRANSFECTION",
         "output_type": "error",
         "traceback": [
          "\u001b[1;31m\u001b[0m",
          "\u001b[1;31mValueError\u001b[0mTraceback (most recent call last)",
          "\u001b[1;32m<ipython-input-12-d9539d489991>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m()\u001b[0m\n\u001b[1;32m----> 1\u001b[1;33m \u001b[0ms_new\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mp\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0morigin\u001b[0m \u001b[1;33m=\u001b[0m \u001b[1;34m'crozz'\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m",
          "\u001b[1;32m/vagrant_python/PyBis/pybis/pybis.py\u001b[0m in \u001b[0;36m__setattr__\u001b[1;34m(self, name, value)\u001b[0m\n\u001b[0;32m   2099\u001b[0m             \u001b[0mvoc\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_openbis\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mget_terms\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   2100\u001b[0m             \u001b[1;32mif\u001b[0m \u001b[0mvalue\u001b[0m \u001b[1;32mnot\u001b[0m \u001b[1;32min\u001b[0m \u001b[0mvoc\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mterms\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m-> 2101\u001b[1;33m                 \u001b[1;32mraise\u001b[0m \u001b[0mValueError\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m\"Value must be one of these terms: \"\u001b[0m \u001b[1;33m+\u001b[0m \u001b[1;34m\", \"\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mjoin\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mvoc\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mterms\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m   2102\u001b[0m         \u001b[1;32melif\u001b[0m \u001b[0mdata_type\u001b[0m \u001b[1;32min\u001b[0m \u001b[1;33m(\u001b[0m\u001b[1;34m'INTEGER'\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;34m'BOOLEAN'\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;34m'VARCHAR'\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m   2103\u001b[0m             \u001b[1;32mif\u001b[0m \u001b[1;32mnot\u001b[0m \u001b[0mcheck_datatype\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mdata_type\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mvalue\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
          "\u001b[1;31mValueError\u001b[0m: Value must be one of these terms: CROSS, TRANSFORMATION, SPORULATION, NEGATIVE_SELECTION, TRANSFECTION"
         ]
        }
       ],
       "source": [
        "s_new.p.origin = 'crozz'"
       ]
      },
      {
       "cell_type": "markdown",
       "metadata": {},
       "source": [
        "s_new.p. + TAB autocompletes all available properties for that given sample type. To show the current attributes of our new sample just use this:"
       ]
      },
      {
       "cell_type": "code",
       "execution_count": 10,
    
    Swen Vermeul's avatar
    Swen Vermeul committed
       "metadata": {},
    
       "outputs": [],
       "source": [
        "s_new.p.mating_type = 'ALPHA'"
       ]
      },
      {
       "cell_type": "markdown",
       "metadata": {},
       "source": [
        "## working with datasets"
       ]
      },
      {
       "cell_type": "code",
    
       "execution_count": 1,
    
    Swen Vermeul's avatar
    Swen Vermeul committed
       "metadata": {},
    
       "outputs": [
        {
         "data": {
          "text/plain": [
           "'vermeul-170213105629815x0CF2F2467FF08E65E79A1E25E0334BC3'"
          ]
         },
         "execution_count": 1,
         "metadata": {},
         "output_type": "execute_result"
        }
       ],
       "source": [
        "from pybis import Openbis\n",
        "o = Openbis(url='https://localhost:8443', verify_certificates=False)\n",
        "o.token"
       ]
      },
      {
       "cell_type": "code",
       "execution_count": 5,
    
       "metadata": {
        "collapsed": true
       },
       "outputs": [],
       "source": [
    
        "ds = o.get_dataset('20160929145446460-367') # has no physical data, because it's a container"
       ]
      },
      {
       "cell_type": "code",
       "execution_count": 2,
       "metadata": {
        "collapsed": true
       },
       "outputs": [],
       "source": [
        "ds = o.get_dataset('20160719143426517-259')"
    
       "execution_count": 3,
    
    Swen Vermeul's avatar
    Swen Vermeul committed
       "metadata": {},
    
       "outputs": [
        {
         "data": {
          "text/html": [
           "\n",
           "            <table border=\"1\" class=\"dataframe\">\n",
           "            <thead>\n",
           "                <tr style=\"text-align: right;\">\n",
           "                <th>attribute</th>\n",
           "                <th>value</th>\n",
           "                </tr>\n",
           "            </thead>\n",
           "            <tbody>\n",
    
           "        <tr> <td>code</td> <td>20160719143426517-259</td> </tr><tr> <td>permId</td> <td>20160719143426517-259</td> </tr><tr> <td>type</td> <td>JUPYTER_RESULT</td> </tr><tr> <td>experiment</td> <td></td> </tr><tr> <td>sample</td> <td>/VERMEUL/MON_160718_181654</td> </tr><tr> <td>parents</td> <td>[]</td> </tr><tr> <td>children</td> <td>[]</td> </tr><tr> <td>container</td> <td></td> </tr><tr> <td>components</td> <td></td> </tr><tr> <td>tags</td> <td>[]</td> </tr><tr> <td>accessDate</td> <td>2016-08-18 13:43:54</td> </tr><tr> <td>dataProducer</td> <td></td> </tr><tr> <td>dataProductionDate</td> <td></td> </tr><tr> <td>registrator</td> <td></td> </tr><tr> <td>registrationDate</td> <td>2016-07-19 14:34:33</td> </tr><tr> <td>modifier</td> <td></td> </tr><tr> <td>modificationDate</td> <td>2016-07-19 14:34:33</td> </tr><tr> <td>dataStore</td> <td>DSS1</td> </tr><tr> <td>measured</td> <td>True</td> </tr>\n",
    
           "            </tbody>\n",
           "            </table>\n",
           "        "
          ],
          "text/plain": [
    
           "property            value\n",
           "------------------  --------------------------\n",
           "code                20160719143426517-259\n",
           "permId              20160719143426517-259\n",
           "type                JUPYTER_RESULT\n",
           "experiment\n",
           "sample              /VERMEUL/MON_160718_181654\n",
           "parents             []\n",
           "children            []\n",
           "container\n",
           "components\n",
           "tags                []\n",
           "accessDate          2016-08-18 13:43:54\n",
           "dataProducer\n",
           "dataProductionDate\n",
           "registrator\n",
           "registrationDate    2016-07-19 14:34:33\n",
           "modifier\n",
           "modificationDate    2016-07-19 14:34:33\n",
           "dataStore           DSS1\n",
           "measured            True"
    
         "execution_count": 3,
    
         "metadata": {},
         "output_type": "execute_result"
        }
       ],
       "source": [
    
       "execution_count": 26,
    
    Swen Vermeul's avatar
    Swen Vermeul committed
       "metadata": {},
    
       "outputs": [],
       "source": [
        "ds.status  # always fetches the current status from the server, no caching"
       ]
      },
      {
       "cell_type": "code",
       "execution_count": 4,
    
    Swen Vermeul's avatar
    Swen Vermeul committed
       "metadata": {},
    
       "outputs": [
        {
         "data": {
          "text/html": [
           "\n",
           "            <table border=\"1\" class=\"dataframe\">\n",
           "            <thead>\n",
           "                <tr style=\"text-align: right;\">\n",
           "                <th>attribute</th>\n",
           "                <th>value</th>\n",
           "                </tr>\n",
           "            </thead>\n",
           "            <tbody>\n",
    
           "        <tr> <td>speedHint</td> <td>-50</td> </tr><tr> <td>complete</td> <td>UNKNOWN</td> </tr><tr> <td>shareId</td> <td>1</td> </tr><tr> <td>size</td> <td>None</td> </tr><tr> <td>fileFormatType</td> <td>None</td> </tr><tr> <td>storageFormat</td> <td>None</td> </tr><tr> <td>location</td> <td>68D4E291-7D2C-413C-B318-895E139D29D1/7c/3b/03/20160719143426517-259</td> </tr><tr> <td>presentInArchive</td> <td>False</td> </tr><tr> <td>storageConfirmation</td> <td>True</td> </tr><tr> <td>locatorType</td> <td>None</td> </tr><tr> <td>status</td> <td>AVAILABLE</td> </tr>\n",
    
           "            </tbody>\n",
           "            </table>\n",
           "        "
          ],
          "text/plain": [
    
           "attribute            value\n",
           "-------------------  -------------------------------------------------------------------\n",
           "speedHint            -50\n",
           "complete             UNKNOWN\n",
           "shareId              1\n",
           "size\n",
           "fileFormatType\n",
           "storageFormat\n",
           "location             68D4E291-7D2C-413C-B318-895E139D29D1/7c/3b/03/20160719143426517-259\n",
           "presentInArchive     False\n",
           "storageConfirmation  True\n",
           "locatorType\n",
           "status               AVAILABLE"
    
         "execution_count": 4,
    
         "metadata": {},
         "output_type": "execute_result"
        }
       ],
       "source": [
    
       "execution_count": 8,
    
    Swen Vermeul's avatar
    Swen Vermeul committed
       "metadata": {},
    
       "outputs": [
        {
         "data": {
          "text/html": [
           "\n",
           "            <table border=\"1\" class=\"dataframe\">\n",
           "            <thead>\n",
           "                <tr style=\"text-align: right;\">\n",
           "                <th>attribute</th>\n",
           "                <th>value</th>\n",
           "                </tr>\n",
           "            </thead>\n",
           "            <tbody>\n",
    
           "        <tr> <td>code</td> <td>CHILD_OF_SAMPLE1</td> </tr><tr> <td>permId</td> <td>20160705234504004-206</td> </tr><tr> <td>identifier</td> <td>/MY_NEW_SPACE/CHILD_OF_SAMPLE1</td> </tr><tr> <td>type</td> <td>UNKNOWN</td> </tr><tr> <td>space</td> <td>MY_NEW_SPACE</td> </tr><tr> <td>project</td> <td></td> </tr><tr> <td>experiment</td> <td>/MY_NEW_SPACE/VERMEUL_PROJECT/MY_EXPERIMENT4</td> </tr><tr> <td>tags</td> <td>['A_tag', 'due']</td> </tr><tr><td>attachments</td><td></td></tr>\n",
    
           "            </tbody>\n",
           "            </table>\n",
           "        "
          ],
          "text/plain": [
    
           "property    value\n",
           "----------  --------------------------------------------\n",
           "code        CHILD_OF_SAMPLE1\n",
           "permId      20160705234504004-206\n",
           "identifier  /MY_NEW_SPACE/CHILD_OF_SAMPLE1\n",
           "type        UNKNOWN\n",
           "space       MY_NEW_SPACE\n",
           "project\n",
           "experiment  /MY_NEW_SPACE/VERMEUL_PROJECT/MY_EXPERIMENT4\n",
           "tags        ['A_tag', 'due']"
    
         "execution_count": 8,
    
         "metadata": {},
         "output_type": "execute_result"
        }
       ],
       "source": [
    
        "s = o.get_sample('/MY_NEW_SPACE/CHILD_OF_SAMPLE1')\n",
    
       "execution_count": 9,
    
    Swen Vermeul's avatar
    Swen Vermeul committed
       "metadata": {},
    
       "outputs": [
        {
         "data": {
          "text/html": [
           "\n",
           "            <table border=\"1\" class=\"dataframe\">\n",
           "            <thead>\n",
           "                <tr style=\"text-align: right;\">\n",
           "                <th>attribute</th>\n",
           "                <th>value</th>\n",
           "                </tr>\n",
           "            </thead>\n",
           "            <tbody>\n",
           "        <tr> <td>code</td> <td>MY_EXPERIMENT4</td> </tr><tr> <td>permId</td> <td>20160924020719018-358</td> </tr><tr> <td>identifier</td> <td>/MY_NEW_SPACE/VERMEUL_PROJECT/MY_EXPERIMENT4</td> </tr><tr> <td>type</td> <td>DEFAULT_EXPERIMENT</td> </tr><tr> <td>project</td> <td>/MY_NEW_SPACE/VERMEUL_PROJECT</td> </tr><tr> <td>tags</td> <td>['A_tag', 'another_tag', 'too_late', 'tre']</td> </tr><tr><td>attachments</td><td></td></tr>\n",
           "            </tbody>\n",
           "            </table>\n",
           "        "
          ],
          "text/plain": [
           "property    value\n",
           "----------  --------------------------------------------\n",
           "code        MY_EXPERIMENT4\n",
           "permId      20160924020719018-358\n",
           "identifier  /MY_NEW_SPACE/VERMEUL_PROJECT/MY_EXPERIMENT4\n",
           "type        DEFAULT_EXPERIMENT\n",
           "project     /MY_NEW_SPACE/VERMEUL_PROJECT\n",
           "tags        ['A_tag', 'another_tag', 'too_late', 'tre']"
          ]
         },
         "execution_count": 9,
         "metadata": {},
         "output_type": "execute_result"
        }
       ],
       "source": [
        "s.get_experiment()"
       ]
      },
      {
       "cell_type": "code",
       "execution_count": 5,
       "metadata": {
        "scrolled": true
       },
       "outputs": [],
       "source": [
        "s = o.get_sample('/MY_NEW_SPACE/HOW_WONDERFUL')"
       ]
      },
      {
       "cell_type": "code",
       "execution_count": 6,
    
    Swen Vermeul's avatar
    Swen Vermeul committed
       "metadata": {},
    
       "outputs": [
        {
         "data": {
          "text/html": [
           "<div>\n",
           "<table border=\"1\" class=\"dataframe\">\n",
           "  <thead>\n",
           "    <tr style=\"text-align: right;\">\n",
           "      <th></th>\n",
    
           "      <th>permId</th>\n",
    
           "      <th>properties</th>\n",
           "      <th>type</th>\n",
    
           "      <th>experiment</th>\n",
    
           "      <th>sample</th>\n",
           "      <th>registrationDate</th>\n",
           "      <th>modificationDate</th>\n",
           "    </tr>\n",
           "  </thead>\n",
           "  <tbody>\n",
           "    <tr>\n",
           "      <th>0</th>\n",
           "      <td>20160721002154012-269</td>\n",
           "      <td>{}</td>\n",
           "      <td>JUPYTER_NOTEBOOK</td>\n",
    
           "      <td>/MY_NEW_SPACE/VERMEUL_PROJECT/MY_EXPERIMENT4</td>\n",
    
           "      <td>/MY_NEW_SPACE/HOW_WONDERFUL</td>\n",
           "      <td>2016-07-21 00:22:11</td>\n",
           "      <td>2016-11-06 22:59:21</td>\n",
           "    </tr>\n",
           "    <tr>\n",
           "      <th>1</th>\n",
           "      <td>20160721002157457-270</td>\n",
           "      <td>{}</td>\n",
           "      <td>JUPYTER_RESULT</td>\n",
    
           "      <td>/MY_NEW_SPACE/VERMEUL_PROJECT/MY_EXPERIMENT4</td>\n",
    
           "      <td>/MY_NEW_SPACE/HOW_WONDERFUL</td>\n",
           "      <td>2016-07-21 00:22:11</td>\n",
           "      <td>2016-11-06 22:59:21</td>\n",
           "    </tr>\n",
           "    <tr>\n",
           "      <th>2</th>\n",
           "      <td>20160721002157457-271</td>\n",
           "      <td>{'NAME': 'my_delightful_analysis', 'DESCRIPTIO...</td>\n",
           "      <td>JUPYTER_CONTAINER</td>\n",
    
           "      <td>/MY_NEW_SPACE/VERMEUL_PROJECT/MY_EXPERIMENT4</td>\n",
    
           "      <td>/MY_NEW_SPACE/HOW_WONDERFUL</td>\n",
           "      <td>2016-07-21 00:22:11</td>\n",
    
           "      <td>2017-01-20 23:41:42</td>\n",
    
           "    </tr>\n",
           "    <tr>\n",
           "      <th>3</th>\n",
           "      <td>20160721005440169-272</td>\n",
           "      <td>{}</td>\n",
           "      <td>JUPYTER_NOTEBOOK</td>\n",
    
           "      <td>/MY_NEW_SPACE/VERMEUL_PROJECT/MY_EXPERIMENT4</td>\n",
    
           "      <td>/MY_NEW_SPACE/HOW_WONDERFUL</td>\n",
           "      <td>2016-07-21 00:54:51</td>\n",
           "      <td>2016-11-06 22:59:21</td>\n",
           "    </tr>\n",
           "    <tr>\n",
           "      <th>4</th>\n",
           "      <td>20160721005441238-273</td>\n",
           "      <td>{}</td>\n",
           "      <td>JUPYTER_RESULT</td>\n",
    
           "      <td>/MY_NEW_SPACE/VERMEUL_PROJECT/MY_EXPERIMENT4</td>\n",
    
           "      <td>/MY_NEW_SPACE/HOW_WONDERFUL</td>\n",
           "      <td>2016-07-21 00:54:51</td>\n",
           "      <td>2016-11-06 22:59:21</td>\n",
           "    </tr>\n",
           "    <tr>\n",
           "      <th>5</th>\n",
           "      <td>20160818092513667-332</td>\n",
           "      <td>{}</td>\n",
           "      <td>JUPYTER_NOTEBOOK</td>\n",
    
           "      <td>/MY_NEW_SPACE/VERMEUL_PROJECT/MY_EXPERIMENT4</td>\n",
    
           "      <td>/MY_NEW_SPACE/HOW_WONDERFUL</td>\n",
           "      <td>2016-08-18 09:25:15</td>\n",
           "      <td>2016-11-06 22:59:21</td>\n",
           "    </tr>\n",
           "    <tr>\n",
           "      <th>6</th>\n",
           "      <td>20160818092513706-333</td>\n",
           "      <td>{}</td>\n",
           "      <td>JUPYTER_RESULT</td>\n",
    
           "      <td>/MY_NEW_SPACE/VERMEUL_PROJECT/MY_EXPERIMENT4</td>\n",
    
           "      <td>/MY_NEW_SPACE/HOW_WONDERFUL</td>\n",
           "      <td>2016-08-18 09:25:15</td>\n",
           "      <td>2016-11-06 22:59:21</td>\n",
           "    </tr>\n",
           "    <tr>\n",
           "      <th>7</th>\n",
           "      <td>20160826103944978-335</td>\n",
           "      <td>{}</td>\n",
           "      <td>JUPYTER_NOTEBOOK</td>\n",
    
           "      <td>/MY_NEW_SPACE/VERMEUL_PROJECT/MY_EXPERIMENT4</td>\n",
    
           "      <td>/MY_NEW_SPACE/HOW_WONDERFUL</td>\n",
           "      <td>2016-08-26 10:39:46</td>\n",
           "      <td>2016-11-06 22:59:21</td>\n",
           "    </tr>\n",
           "    <tr>\n",
           "      <th>8</th>\n",
           "      <td>20160826103945007-336</td>\n",
           "      <td>{}</td>\n",
           "      <td>JUPYTER_RESULT</td>\n",
    
           "      <td>/MY_NEW_SPACE/VERMEUL_PROJECT/MY_EXPERIMENT4</td>\n",
    
           "      <td>/MY_NEW_SPACE/HOW_WONDERFUL</td>\n",
           "      <td>2016-08-26 10:39:46</td>\n",
           "      <td>2016-11-06 22:59:21</td>\n",
           "    </tr>\n",
           "    <tr>\n",
           "      <th>9</th>\n",
           "      <td>20160929145446441-365</td>\n",
           "      <td>{}</td>\n",
           "      <td>JUPYTER_NOTEBOOK</td>\n",
    
           "      <td>/MY_NEW_SPACE/VERMEUL_PROJECT/MY_EXPERIMENT4</td>\n",
    
           "      <td>/MY_NEW_SPACE/HOW_WONDERFUL</td>\n",
           "      <td>2016-09-29 14:54:47</td>\n",
           "      <td>2016-11-06 22:59:21</td>\n",
           "    </tr>\n",
           "    <tr>\n",
           "      <th>10</th>\n",
           "      <td>20160929145446460-366</td>\n",
           "      <td>{}</td>\n",
           "      <td>JUPYTER_RESULT</td>\n",
    
           "      <td>/MY_NEW_SPACE/VERMEUL_PROJECT/MY_EXPERIMENT4</td>\n",
    
           "      <td>/MY_NEW_SPACE/HOW_WONDERFUL</td>\n",
           "      <td>2016-09-29 14:54:47</td>\n",
           "      <td>2016-11-06 22:59:21</td>\n",
           "    </tr>\n",
           "    <tr>\n",
           "      <th>11</th>\n",
           "      <td>20160929145446460-367</td>\n",
           "      <td>{'NAME': 'crc32 check', 'DESCRIPTION': 'should...</td>\n",
           "      <td>JUPYTER_CONTAINER</td>\n",
    
           "      <td>/MY_NEW_SPACE/VERMEUL_PROJECT/MY_EXPERIMENT4</td>\n",
    
           "      <td>/MY_NEW_SPACE/HOW_WONDERFUL</td>\n",
           "      <td>2016-09-29 14:54:47</td>\n",
           "      <td>2016-11-06 22:59:21</td>\n",
           "    </tr>\n",
           "    <tr>\n",
           "      <th>12</th>\n",
           "      <td>20161121005146312-396</td>\n",
           "      <td>{}</td>\n",
           "      <td>JUPYTER_NOTEBOOK</td>\n",
    
           "      <td>/MY_NEW_SPACE/VERMEUL_PROJECT/MY_EXPERIMENT4</td>\n",