{
"cells": [
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# The `Excel_plan()` -- batch scans using a spreadsheet\n",
"\n",
"Use a spreadsheet as a multi-sample batch scan tool. \n",
"We'll need a spreadsheet with some things to be done \n",
"and a plan that will read that spreadsheet and act on it. \n",
"\n",
"This plan will:\n",
"\n",
"* [x] use an Excel spreadsheet (for starters)\n",
"* [x] read a table from the spreadsheet file\n",
"* [x] take a single action from each row in the table\n",
"* [x] decide action based on a specific named column in the table\n",
"* [x] report all columns as metadata for the action\n",
"* [x] ignore empty rows\n",
"* [ ] ignore any data outside of the table boundaries\n",
"\n",
"Since the actions and parameters (args & kwargs) will be \n",
"different in every implementation, this may prove difficult \n",
"to generalize.given a spreadsheet (named ``sample_example.xlsx``)\n",
"with content as shown in the next figure:\n",
"\n",
"![sample_example.xlsx](../resources/sample_example.jpg)\n",
"\n",
"**Tip**: Place the column labels on the fourth row of the spreadsheet, starting\n",
"in the first column. The actions start on the next row. The first blank row\n",
"indicates the end of the command table within the spreadsheet. Use as many\n",
"columns as you need, one column per argument.\n",
"\n",
"Here's the demo, starting with the bluesky setup."
]
},
{
"cell_type": "code",
"execution_count": 1,
"metadata": {},
"outputs": [],
"source": [
"# Import matplotlib and put it in interactive mode.\n",
"%matplotlib notebook\n",
"import matplotlib.pyplot as plt\n",
"plt.ion()\n",
"\n",
"import pathlib\n",
"\n",
"import databroker\n",
"cat = databroker.temp()\n",
"\n",
"from bluesky import RunEngine\n",
"import bluesky.plans as bp\n",
"import bluesky.plan_stubs as bps\n",
"from bluesky.callbacks.best_effort import BestEffortCallback\n",
"from bluesky import SupplementalData\n",
"from bluesky.simulators import summarize_plan\n",
"from bluesky.suspenders import SuspendFloor\n",
"\n",
"from ophyd.sim import motor1, motor2, motor3, SynGauss\n",
"\n",
"import apstools.devices as APS_devices\n",
"import apstools.utils as APS_utils\n",
"\n",
"RE = RunEngine({})\n",
"RE.subscribe(cat.v1.insert)\n",
"RE.subscribe(BestEffortCallback())\n",
"RE.preprocessors.append(SupplementalData())\n",
"\n",
"shutter = APS_devices.SimulatedApsPssShutterWithStatus(name=\"shutter\")\n",
"watch_for_shutter_close = SuspendFloor(shutter.pss_state, 1)\n",
"\n",
"noisy_det = SynGauss('noisy_det', motor1, 'motor1', center=0, Imax=1,\n",
" noise='uniform', sigma=0.9, noise_multiplier=0.1, labels={'detectors'})\n",
"noisy_det.kind = \"hinted\""
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"----\n",
"\n",
"## Excel plan and infrastructure"
]
},
{
"cell_type": "code",
"execution_count": 2,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"shutter -> open\n",
"motor2 -> 5.07\n",
"motor3 -> 8.3\n",
"Scan_Type: step_scan\n",
"sx: 5.07\n",
"sy: 8.3\n",
"Thickness: 0\n",
"Sample_Name: Water Blank\n",
"remarks: deionized\n",
"code_number: None\n",
"table_row: 1\n",
"Excel_file: sample_example.xlsx\n",
"xl_file: sample_example.xlsx\n",
"original_keys: {'Scan_Type': 'Scan Type', 'sx': 'sx', 'sy': 'sy', 'Thickness': 'Thickness', 'Sample_Name': 'Sample Name', 'remarks': 'remarks', 'code_number': 'code number'}\n",
"motor2: 0\n",
"motor3: 0\n",
"shutter: close\n",
"=================================== Open Run ===================================\n",
"motor1 -> -5.0\n",
" Read ['noisy_det', 'motor1']\n",
"motor1 -> -3.571428571428571\n",
" Read ['noisy_det', 'motor1']\n",
"motor1 -> -2.142857142857143\n",
" Read ['noisy_det', 'motor1']\n",
"motor1 -> -0.7142857142857144\n",
" Read ['noisy_det', 'motor1']\n",
"motor1 -> 0.7142857142857144\n",
" Read ['noisy_det', 'motor1']\n",
"motor1 -> 2.1428571428571432\n",
" Read ['noisy_det', 'motor1']\n",
"motor1 -> 3.571428571428571\n",
" Read ['noisy_det', 'motor1']\n",
"motor1 -> 5.0\n",
" Read ['noisy_det', 'motor1']\n",
"================================== Close Run ===================================\n",
"no handling for table row 2: OrderedDict([('Scan Type', 'other_scan'), ('sx', 5.07), ('sy', 8.3), ('Thickness', 0), ('Sample Name', 'Water Blank'), ('remarks', 'deionized'), ('code number', None)])\n",
"no handling for table row 3: OrderedDict([('Scan Type', 'this will be ignored (and also the next blank row will be ignored)'), ('sx', None), ('sy', None), ('Thickness', None), ('Sample Name', None), ('remarks', None), ('code number', None)])\n",
"shutter -> close\n",
"motor1 -> 0\n",
"motor2 -> 0\n",
"motor3 -> 0\n"
]
}
],
"source": [
"def beforeExcelPlan():\n",
" \"\"\"things to be done at the start of every Excel plan\"\"\"\n",
" yield from bps.mv(\n",
" shutter, \"open\", # for example\n",
" )\n",
"\n",
" \n",
"def afterExcelPlan():\n",
" \"\"\"things to be done at the end of every Excel plan\"\"\"\n",
" yield from bps.mv(\n",
" shutter, \"close\", # for example\n",
" motor1, 0, # park the motors\n",
" motor2, 0,\n",
" motor3, 0,\n",
" )\n",
"\n",
"\n",
"def common_step_scan(pos_X, pos_Y, thickness, scan_title, md={}):\n",
" \"\"\"\n",
" run a step scan over a common range at given sample position\n",
" \"\"\"\n",
" yield from bps.mv(\n",
" motor2, pos_X,\n",
" motor3, pos_Y,\n",
" )\n",
" md[motor2.name] = motor2.position\n",
" md[motor3.name] = motor3.position\n",
" md[\"shutter\"] = shutter.state\n",
" for k, v in md.items():\n",
" print(f\"{k}: {v}\")\n",
"\n",
" yield from bps.install_suspender(watch_for_shutter_close)\n",
" yield from bp.scan([noisy_det], motor1, -5, 5, 8, md=md)\n",
" yield from bps.remove_suspender(watch_for_shutter_close)\n",
"\n",
"\n",
"def Excel_plan(xl_file, md={}):\n",
" \"\"\"\n",
" example of reading a list of samples from Excel spreadsheet\n",
" \n",
" USAGE::\n",
" \n",
" summarize_plan(run_Excel_file(\"sample_example.xlsx\"))\n",
" RE(run_Excel_file(\"sample_example.xlsx\"))\n",
" \"\"\"\n",
" excel_file = pathlib.Path(xl_file)\n",
" assert excel_file.exists()\n",
" xl = APS_utils.ExcelDatabaseFileGeneric(str(excel_file))\n",
"\n",
" yield from beforeExcelPlan()\n",
" for i, row in enumerate(xl.db.values()):\n",
" # print(f\"row={row}\")\n",
" \n",
" # metadata\n",
" # all parameters from this row go into the metadata\n",
" # columns names are the keys in the metadata dictionary\n",
" # make sure md keys are \"clean\"\n",
" # also provide crossreference to original column names\n",
" _md = {APS_utils.cleanupText(k): v for k, v in row.items()}\n",
" _md[\"table_row\"] = i+1\n",
" _md[\"Excel_file\"] = str(excel_file)\n",
" _md[\"xl_file\"] = xl_file\n",
" _md[\"original_keys\"] = {APS_utils.cleanupText(k): k for k in row.keys()}\n",
" _md.update(md) # overlay with user-supplied metadata\n",
"\n",
" scan_command = (row[\"Scan Type\"] or \"\").lower()\n",
" if scan_command == \"step_scan\":\n",
" yield from common_step_scan(\n",
" row[\"sx\"], # label must match cell string EXACTLY\n",
" row[\"sy\"], \n",
" row[\"Thickness\"], \n",
" row[\"Sample Name\"],\n",
" # add all input as scan metadata, ensure the keys are clean\n",
" md=_md,\n",
" )\n",
" elif scan_command == \"some_other_action\":\n",
" pass # TODO: suggestion\n",
" else:\n",
" print(f\"no handling for table row {i+1}: {row}\")\n",
" yield from afterExcelPlan()\n",
"\n",
"\n",
"summarize_plan(Excel_plan(\"sample_example.xlsx\"))"
]
},
{
"cell_type": "code",
"execution_count": 3,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"Scan_Type: step_scan\n",
"sx: 5.07\n",
"sy: 8.3\n",
"Thickness: 0\n",
"Sample_Name: Water Blank\n",
"remarks: deionized\n",
"code_number: None\n",
"table_row: 1\n",
"Excel_file: sample_example.xlsx\n",
"xl_file: sample_example.xlsx\n",
"original_keys: {'Scan_Type': 'Scan Type', 'sx': 'sx', 'sy': 'sy', 'Thickness': 'Thickness', 'Sample_Name': 'Sample Name', 'remarks': 'remarks', 'code_number': 'code number'}\n",
"motor2: 5.07\n",
"motor3: 8.3\n",
"shutter: open\n",
"\n",
"\n",
"Transient Scan ID: 1 Time: 2022-07-06 00:27:29\n",
"Persistent Unique Scan ID: 'a6ea8a82-aff2-4621-a197-1a3bca524e51'\n",
"New stream: 'primary'\n"
]
},
{
"data": {
"application/javascript": "/* Put everything inside the global mpl namespace */\n/* global mpl */\nwindow.mpl = {};\n\nmpl.get_websocket_type = function () {\n if (typeof WebSocket !== 'undefined') {\n return WebSocket;\n } else if (typeof MozWebSocket !== 'undefined') {\n return MozWebSocket;\n } else {\n alert(\n 'Your browser does not have WebSocket support. ' +\n 'Please try Chrome, Safari or Firefox ≥ 6. ' +\n 'Firefox 4 and 5 are also supported but you ' +\n 'have to enable WebSockets in about:config.'\n );\n }\n};\n\nmpl.figure = function (figure_id, websocket, ondownload, parent_element) {\n this.id = figure_id;\n\n this.ws = websocket;\n\n this.supports_binary = this.ws.binaryType !== undefined;\n\n if (!this.supports_binary) {\n var warnings = document.getElementById('mpl-warnings');\n if (warnings) {\n warnings.style.display = 'block';\n warnings.textContent =\n 'This browser does not support binary websocket messages. ' +\n 'Performance may be slow.';\n }\n }\n\n this.imageObj = new Image();\n\n this.context = undefined;\n this.message = undefined;\n this.canvas = undefined;\n this.rubberband_canvas = undefined;\n this.rubberband_context = undefined;\n this.format_dropdown = undefined;\n\n this.image_mode = 'full';\n\n this.root = document.createElement('div');\n this.root.setAttribute('style', 'display: inline-block');\n this._root_extra_style(this.root);\n\n parent_element.appendChild(this.root);\n\n this._init_header(this);\n this._init_canvas(this);\n this._init_toolbar(this);\n\n var fig = this;\n\n this.waiting = false;\n\n this.ws.onopen = function () {\n fig.send_message('supports_binary', { value: fig.supports_binary });\n fig.send_message('send_image_mode', {});\n if (fig.ratio !== 1) {\n fig.send_message('set_device_pixel_ratio', {\n device_pixel_ratio: fig.ratio,\n });\n }\n fig.send_message('refresh', {});\n };\n\n this.imageObj.onload = function () {\n if (fig.image_mode === 'full') {\n // Full images could contain transparency (where diff images\n // almost always do), so we need to clear the canvas so that\n // there is no ghosting.\n fig.context.clearRect(0, 0, fig.canvas.width, fig.canvas.height);\n }\n fig.context.drawImage(fig.imageObj, 0, 0);\n };\n\n this.imageObj.onunload = function () {\n fig.ws.close();\n };\n\n this.ws.onmessage = this._make_on_message_function(this);\n\n this.ondownload = ondownload;\n};\n\nmpl.figure.prototype._init_header = function () {\n var titlebar = document.createElement('div');\n titlebar.classList =\n 'ui-dialog-titlebar ui-widget-header ui-corner-all ui-helper-clearfix';\n var titletext = document.createElement('div');\n titletext.classList = 'ui-dialog-title';\n titletext.setAttribute(\n 'style',\n 'width: 100%; text-align: center; padding: 3px;'\n );\n titlebar.appendChild(titletext);\n this.root.appendChild(titlebar);\n this.header = titletext;\n};\n\nmpl.figure.prototype._canvas_extra_style = function (_canvas_div) {};\n\nmpl.figure.prototype._root_extra_style = function (_canvas_div) {};\n\nmpl.figure.prototype._init_canvas = function () {\n var fig = this;\n\n var canvas_div = (this.canvas_div = document.createElement('div'));\n canvas_div.setAttribute(\n 'style',\n 'border: 1px solid #ddd;' +\n 'box-sizing: content-box;' +\n 'clear: both;' +\n 'min-height: 1px;' +\n 'min-width: 1px;' +\n 'outline: 0;' +\n 'overflow: hidden;' +\n 'position: relative;' +\n 'resize: both;'\n );\n\n function on_keyboard_event_closure(name) {\n return function (event) {\n return fig.key_event(event, name);\n };\n }\n\n canvas_div.addEventListener(\n 'keydown',\n on_keyboard_event_closure('key_press')\n );\n canvas_div.addEventListener(\n 'keyup',\n on_keyboard_event_closure('key_release')\n );\n\n this._canvas_extra_style(canvas_div);\n this.root.appendChild(canvas_div);\n\n var canvas = (this.canvas = document.createElement('canvas'));\n canvas.classList.add('mpl-canvas');\n canvas.setAttribute('style', 'box-sizing: content-box;');\n\n this.context = canvas.getContext('2d');\n\n var backingStore =\n this.context.backingStorePixelRatio ||\n this.context.webkitBackingStorePixelRatio ||\n this.context.mozBackingStorePixelRatio ||\n this.context.msBackingStorePixelRatio ||\n this.context.oBackingStorePixelRatio ||\n this.context.backingStorePixelRatio ||\n 1;\n\n this.ratio = (window.devicePixelRatio || 1) / backingStore;\n\n var rubberband_canvas = (this.rubberband_canvas = document.createElement(\n 'canvas'\n ));\n rubberband_canvas.setAttribute(\n 'style',\n 'box-sizing: content-box; position: absolute; left: 0; top: 0; z-index: 1;'\n );\n\n // Apply a ponyfill if ResizeObserver is not implemented by browser.\n if (this.ResizeObserver === undefined) {\n if (window.ResizeObserver !== undefined) {\n this.ResizeObserver = window.ResizeObserver;\n } else {\n var obs = _JSXTOOLS_RESIZE_OBSERVER({});\n this.ResizeObserver = obs.ResizeObserver;\n }\n }\n\n this.resizeObserverInstance = new this.ResizeObserver(function (entries) {\n var nentries = entries.length;\n for (var i = 0; i < nentries; i++) {\n var entry = entries[i];\n var width, height;\n if (entry.contentBoxSize) {\n if (entry.contentBoxSize instanceof Array) {\n // Chrome 84 implements new version of spec.\n width = entry.contentBoxSize[0].inlineSize;\n height = entry.contentBoxSize[0].blockSize;\n } else {\n // Firefox implements old version of spec.\n width = entry.contentBoxSize.inlineSize;\n height = entry.contentBoxSize.blockSize;\n }\n } else {\n // Chrome <84 implements even older version of spec.\n width = entry.contentRect.width;\n height = entry.contentRect.height;\n }\n\n // Keep the size of the canvas and rubber band canvas in sync with\n // the canvas container.\n if (entry.devicePixelContentBoxSize) {\n // Chrome 84 implements new version of spec.\n canvas.setAttribute(\n 'width',\n entry.devicePixelContentBoxSize[0].inlineSize\n );\n canvas.setAttribute(\n 'height',\n entry.devicePixelContentBoxSize[0].blockSize\n );\n } else {\n canvas.setAttribute('width', width * fig.ratio);\n canvas.setAttribute('height', height * fig.ratio);\n }\n canvas.setAttribute(\n 'style',\n 'width: ' + width + 'px; height: ' + height + 'px;'\n );\n\n rubberband_canvas.setAttribute('width', width);\n rubberband_canvas.setAttribute('height', height);\n\n // And update the size in Python. We ignore the initial 0/0 size\n // that occurs as the element is placed into the DOM, which should\n // otherwise not happen due to the minimum size styling.\n if (fig.ws.readyState == 1 && width != 0 && height != 0) {\n fig.request_resize(width, height);\n }\n }\n });\n this.resizeObserverInstance.observe(canvas_div);\n\n function on_mouse_event_closure(name) {\n return function (event) {\n return fig.mouse_event(event, name);\n };\n }\n\n rubberband_canvas.addEventListener(\n 'mousedown',\n on_mouse_event_closure('button_press')\n );\n rubberband_canvas.addEventListener(\n 'mouseup',\n on_mouse_event_closure('button_release')\n );\n rubberband_canvas.addEventListener(\n 'dblclick',\n on_mouse_event_closure('dblclick')\n );\n // Throttle sequential mouse events to 1 every 20ms.\n rubberband_canvas.addEventListener(\n 'mousemove',\n on_mouse_event_closure('motion_notify')\n );\n\n rubberband_canvas.addEventListener(\n 'mouseenter',\n on_mouse_event_closure('figure_enter')\n );\n rubberband_canvas.addEventListener(\n 'mouseleave',\n on_mouse_event_closure('figure_leave')\n );\n\n canvas_div.addEventListener('wheel', function (event) {\n if (event.deltaY < 0) {\n event.step = 1;\n } else {\n event.step = -1;\n }\n on_mouse_event_closure('scroll')(event);\n });\n\n canvas_div.appendChild(canvas);\n canvas_div.appendChild(rubberband_canvas);\n\n this.rubberband_context = rubberband_canvas.getContext('2d');\n this.rubberband_context.strokeStyle = '#000000';\n\n this._resize_canvas = function (width, height, forward) {\n if (forward) {\n canvas_div.style.width = width + 'px';\n canvas_div.style.height = height + 'px';\n }\n };\n\n // Disable right mouse context menu.\n this.rubberband_canvas.addEventListener('contextmenu', function (_e) {\n event.preventDefault();\n return false;\n });\n\n function set_focus() {\n canvas.focus();\n canvas_div.focus();\n }\n\n window.setTimeout(set_focus, 100);\n};\n\nmpl.figure.prototype._init_toolbar = function () {\n var fig = this;\n\n var toolbar = document.createElement('div');\n toolbar.classList = 'mpl-toolbar';\n this.root.appendChild(toolbar);\n\n function on_click_closure(name) {\n return function (_event) {\n return fig.toolbar_button_onclick(name);\n };\n }\n\n function on_mouseover_closure(tooltip) {\n return function (event) {\n if (!event.currentTarget.disabled) {\n return fig.toolbar_button_onmouseover(tooltip);\n }\n };\n }\n\n fig.buttons = {};\n var buttonGroup = document.createElement('div');\n buttonGroup.classList = 'mpl-button-group';\n for (var toolbar_ind in mpl.toolbar_items) {\n var name = mpl.toolbar_items[toolbar_ind][0];\n var tooltip = mpl.toolbar_items[toolbar_ind][1];\n var image = mpl.toolbar_items[toolbar_ind][2];\n var method_name = mpl.toolbar_items[toolbar_ind][3];\n\n if (!name) {\n /* Instead of a spacer, we start a new button group. */\n if (buttonGroup.hasChildNodes()) {\n toolbar.appendChild(buttonGroup);\n }\n buttonGroup = document.createElement('div');\n buttonGroup.classList = 'mpl-button-group';\n continue;\n }\n\n var button = (fig.buttons[name] = document.createElement('button'));\n button.classList = 'mpl-widget';\n button.setAttribute('role', 'button');\n button.setAttribute('aria-disabled', 'false');\n button.addEventListener('click', on_click_closure(method_name));\n button.addEventListener('mouseover', on_mouseover_closure(tooltip));\n\n var icon_img = document.createElement('img');\n icon_img.src = '_images/' + image + '.png';\n icon_img.srcset = '_images/' + image + '_large.png 2x';\n icon_img.alt = tooltip;\n button.appendChild(icon_img);\n\n buttonGroup.appendChild(button);\n }\n\n if (buttonGroup.hasChildNodes()) {\n toolbar.appendChild(buttonGroup);\n }\n\n var fmt_picker = document.createElement('select');\n fmt_picker.classList = 'mpl-widget';\n toolbar.appendChild(fmt_picker);\n this.format_dropdown = fmt_picker;\n\n for (var ind in mpl.extensions) {\n var fmt = mpl.extensions[ind];\n var option = document.createElement('option');\n option.selected = fmt === mpl.default_extension;\n option.innerHTML = fmt;\n fmt_picker.appendChild(option);\n }\n\n var status_bar = document.createElement('span');\n status_bar.classList = 'mpl-message';\n toolbar.appendChild(status_bar);\n this.message = status_bar;\n};\n\nmpl.figure.prototype.request_resize = function (x_pixels, y_pixels) {\n // Request matplotlib to resize the figure. Matplotlib will then trigger a resize in the client,\n // which will in turn request a refresh of the image.\n this.send_message('resize', { width: x_pixels, height: y_pixels });\n};\n\nmpl.figure.prototype.send_message = function (type, properties) {\n properties['type'] = type;\n properties['figure_id'] = this.id;\n this.ws.send(JSON.stringify(properties));\n};\n\nmpl.figure.prototype.send_draw_message = function () {\n if (!this.waiting) {\n this.waiting = true;\n this.ws.send(JSON.stringify({ type: 'draw', figure_id: this.id }));\n }\n};\n\nmpl.figure.prototype.handle_save = function (fig, _msg) {\n var format_dropdown = fig.format_dropdown;\n var format = format_dropdown.options[format_dropdown.selectedIndex].value;\n fig.ondownload(fig, format);\n};\n\nmpl.figure.prototype.handle_resize = function (fig, msg) {\n var size = msg['size'];\n if (size[0] !== fig.canvas.width || size[1] !== fig.canvas.height) {\n fig._resize_canvas(size[0], size[1], msg['forward']);\n fig.send_message('refresh', {});\n }\n};\n\nmpl.figure.prototype.handle_rubberband = function (fig, msg) {\n var x0 = msg['x0'] / fig.ratio;\n var y0 = (fig.canvas.height - msg['y0']) / fig.ratio;\n var x1 = msg['x1'] / fig.ratio;\n var y1 = (fig.canvas.height - msg['y1']) / fig.ratio;\n x0 = Math.floor(x0) + 0.5;\n y0 = Math.floor(y0) + 0.5;\n x1 = Math.floor(x1) + 0.5;\n y1 = Math.floor(y1) + 0.5;\n var min_x = Math.min(x0, x1);\n var min_y = Math.min(y0, y1);\n var width = Math.abs(x1 - x0);\n var height = Math.abs(y1 - y0);\n\n fig.rubberband_context.clearRect(\n 0,\n 0,\n fig.canvas.width / fig.ratio,\n fig.canvas.height / fig.ratio\n );\n\n fig.rubberband_context.strokeRect(min_x, min_y, width, height);\n};\n\nmpl.figure.prototype.handle_figure_label = function (fig, msg) {\n // Updates the figure title.\n fig.header.textContent = msg['label'];\n};\n\nmpl.figure.prototype.handle_cursor = function (fig, msg) {\n fig.rubberband_canvas.style.cursor = msg['cursor'];\n};\n\nmpl.figure.prototype.handle_message = function (fig, msg) {\n fig.message.textContent = msg['message'];\n};\n\nmpl.figure.prototype.handle_draw = function (fig, _msg) {\n // Request the server to send over a new figure.\n fig.send_draw_message();\n};\n\nmpl.figure.prototype.handle_image_mode = function (fig, msg) {\n fig.image_mode = msg['mode'];\n};\n\nmpl.figure.prototype.handle_history_buttons = function (fig, msg) {\n for (var key in msg) {\n if (!(key in fig.buttons)) {\n continue;\n }\n fig.buttons[key].disabled = !msg[key];\n fig.buttons[key].setAttribute('aria-disabled', !msg[key]);\n }\n};\n\nmpl.figure.prototype.handle_navigate_mode = function (fig, msg) {\n if (msg['mode'] === 'PAN') {\n fig.buttons['Pan'].classList.add('active');\n fig.buttons['Zoom'].classList.remove('active');\n } else if (msg['mode'] === 'ZOOM') {\n fig.buttons['Pan'].classList.remove('active');\n fig.buttons['Zoom'].classList.add('active');\n } else {\n fig.buttons['Pan'].classList.remove('active');\n fig.buttons['Zoom'].classList.remove('active');\n }\n};\n\nmpl.figure.prototype.updated_canvas_event = function () {\n // Called whenever the canvas gets updated.\n this.send_message('ack', {});\n};\n\n// A function to construct a web socket function for onmessage handling.\n// Called in the figure constructor.\nmpl.figure.prototype._make_on_message_function = function (fig) {\n return function socket_on_message(evt) {\n if (evt.data instanceof Blob) {\n var img = evt.data;\n if (img.type !== 'image/png') {\n /* FIXME: We get \"Resource interpreted as Image but\n * transferred with MIME type text/plain:\" errors on\n * Chrome. But how to set the MIME type? It doesn't seem\n * to be part of the websocket stream */\n img.type = 'image/png';\n }\n\n /* Free the memory for the previous frames */\n if (fig.imageObj.src) {\n (window.URL || window.webkitURL).revokeObjectURL(\n fig.imageObj.src\n );\n }\n\n fig.imageObj.src = (window.URL || window.webkitURL).createObjectURL(\n img\n );\n fig.updated_canvas_event();\n fig.waiting = false;\n return;\n } else if (\n typeof evt.data === 'string' &&\n evt.data.slice(0, 21) === 'data:image/png;base64'\n ) {\n fig.imageObj.src = evt.data;\n fig.updated_canvas_event();\n fig.waiting = false;\n return;\n }\n\n var msg = JSON.parse(evt.data);\n var msg_type = msg['type'];\n\n // Call the \"handle_{type}\" callback, which takes\n // the figure and JSON message as its only arguments.\n try {\n var callback = fig['handle_' + msg_type];\n } catch (e) {\n console.log(\n \"No handler for the '\" + msg_type + \"' message type: \",\n msg\n );\n return;\n }\n\n if (callback) {\n try {\n // console.log(\"Handling '\" + msg_type + \"' message: \", msg);\n callback(fig, msg);\n } catch (e) {\n console.log(\n \"Exception inside the 'handler_\" + msg_type + \"' callback:\",\n e,\n e.stack,\n msg\n );\n }\n }\n };\n};\n\n// from https://stackoverflow.com/questions/1114465/getting-mouse-location-in-canvas\nmpl.findpos = function (e) {\n //this section is from http://www.quirksmode.org/js/events_properties.html\n var targ;\n if (!e) {\n e = window.event;\n }\n if (e.target) {\n targ = e.target;\n } else if (e.srcElement) {\n targ = e.srcElement;\n }\n if (targ.nodeType === 3) {\n // defeat Safari bug\n targ = targ.parentNode;\n }\n\n // pageX,Y are the mouse positions relative to the document\n var boundingRect = targ.getBoundingClientRect();\n var x = e.pageX - (boundingRect.left + document.body.scrollLeft);\n var y = e.pageY - (boundingRect.top + document.body.scrollTop);\n\n return { x: x, y: y };\n};\n\n/*\n * return a copy of an object with only non-object keys\n * we need this to avoid circular references\n * https://stackoverflow.com/a/24161582/3208463\n */\nfunction simpleKeys(original) {\n return Object.keys(original).reduce(function (obj, key) {\n if (typeof original[key] !== 'object') {\n obj[key] = original[key];\n }\n return obj;\n }, {});\n}\n\nmpl.figure.prototype.mouse_event = function (event, name) {\n var canvas_pos = mpl.findpos(event);\n\n if (name === 'button_press') {\n this.canvas.focus();\n this.canvas_div.focus();\n }\n\n var x = canvas_pos.x * this.ratio;\n var y = canvas_pos.y * this.ratio;\n\n this.send_message(name, {\n x: x,\n y: y,\n button: event.button,\n step: event.step,\n guiEvent: simpleKeys(event),\n });\n\n /* This prevents the web browser from automatically changing to\n * the text insertion cursor when the button is pressed. We want\n * to control all of the cursor setting manually through the\n * 'cursor' event from matplotlib */\n event.preventDefault();\n return false;\n};\n\nmpl.figure.prototype._key_event_extra = function (_event, _name) {\n // Handle any extra behaviour associated with a key event\n};\n\nmpl.figure.prototype.key_event = function (event, name) {\n // Prevent repeat events\n if (name === 'key_press') {\n if (event.key === this._key) {\n return;\n } else {\n this._key = event.key;\n }\n }\n if (name === 'key_release') {\n this._key = null;\n }\n\n var value = '';\n if (event.ctrlKey && event.key !== 'Control') {\n value += 'ctrl+';\n }\n else if (event.altKey && event.key !== 'Alt') {\n value += 'alt+';\n }\n else if (event.shiftKey && event.key !== 'Shift') {\n value += 'shift+';\n }\n\n value += 'k' + event.key;\n\n this._key_event_extra(event, name);\n\n this.send_message(name, { key: value, guiEvent: simpleKeys(event) });\n return false;\n};\n\nmpl.figure.prototype.toolbar_button_onclick = function (name) {\n if (name === 'download') {\n this.handle_save(this, null);\n } else {\n this.send_message('toolbar_button', { name: name });\n }\n};\n\nmpl.figure.prototype.toolbar_button_onmouseover = function (tooltip) {\n this.message.textContent = tooltip;\n};\n\n///////////////// REMAINING CONTENT GENERATED BY embed_js.py /////////////////\n// prettier-ignore\nvar _JSXTOOLS_RESIZE_OBSERVER=function(A){var t,i=new WeakMap,n=new WeakMap,a=new WeakMap,r=new WeakMap,o=new Set;function s(e){if(!(this instanceof s))throw new TypeError(\"Constructor requires 'new' operator\");i.set(this,e)}function h(){throw new TypeError(\"Function is not a constructor\")}function c(e,t,i,n){e=0 in arguments?Number(arguments[0]):0,t=1 in arguments?Number(arguments[1]):0,i=2 in arguments?Number(arguments[2]):0,n=3 in arguments?Number(arguments[3]):0,this.right=(this.x=this.left=e)+(this.width=i),this.bottom=(this.y=this.top=t)+(this.height=n),Object.freeze(this)}function d(){t=requestAnimationFrame(d);var s=new WeakMap,p=new Set;o.forEach((function(t){r.get(t).forEach((function(i){var r=t instanceof window.SVGElement,o=a.get(t),d=r?0:parseFloat(o.paddingTop),f=r?0:parseFloat(o.paddingRight),l=r?0:parseFloat(o.paddingBottom),u=r?0:parseFloat(o.paddingLeft),g=r?0:parseFloat(o.borderTopWidth),m=r?0:parseFloat(o.borderRightWidth),w=r?0:parseFloat(o.borderBottomWidth),b=u+f,F=d+l,v=(r?0:parseFloat(o.borderLeftWidth))+m,W=g+w,y=r?0:t.offsetHeight-W-t.clientHeight,E=r?0:t.offsetWidth-v-t.clientWidth,R=b+v,z=F+W,M=r?t.width:parseFloat(o.width)-R-E,O=r?t.height:parseFloat(o.height)-z-y;if(n.has(t)){var k=n.get(t);if(k[0]===M&&k[1]===O)return}n.set(t,[M,O]);var S=Object.create(h.prototype);S.target=t,S.contentRect=new c(u,d,M,O),s.has(i)||(s.set(i,[]),p.add(i)),s.get(i).push(S)}))})),p.forEach((function(e){i.get(e).call(e,s.get(e),e)}))}return s.prototype.observe=function(i){if(i instanceof window.Element){r.has(i)||(r.set(i,new Set),o.add(i),a.set(i,window.getComputedStyle(i)));var n=r.get(i);n.has(this)||n.add(this),cancelAnimationFrame(t),t=requestAnimationFrame(d)}},s.prototype.unobserve=function(i){if(i instanceof window.Element&&r.has(i)){var n=r.get(i);n.has(this)&&(n.delete(this),n.size||(r.delete(i),o.delete(i))),n.size||r.delete(i),o.size||cancelAnimationFrame(t)}},A.DOMRectReadOnly=c,A.ResizeObserver=s,A.ResizeObserverEntry=h,A}; // eslint-disable-line\nmpl.toolbar_items = [[\"Home\", \"Reset original view\", \"fa fa-home icon-home\", \"home\"], [\"Back\", \"Back to previous view\", \"fa fa-arrow-left icon-arrow-left\", \"back\"], [\"Forward\", \"Forward to next view\", \"fa fa-arrow-right icon-arrow-right\", \"forward\"], [\"\", \"\", \"\", \"\"], [\"Pan\", \"Left button pans, Right button zooms\\nx/y fixes axis, CTRL fixes aspect\", \"fa fa-arrows icon-move\", \"pan\"], [\"Zoom\", \"Zoom to rectangle\\nx/y fixes axis\", \"fa fa-square-o icon-check-empty\", \"zoom\"], [\"\", \"\", \"\", \"\"], [\"Download\", \"Download plot\", \"fa fa-floppy-o icon-save\", \"download\"]];\n\nmpl.extensions = [\"eps\", \"jpeg\", \"pgf\", \"pdf\", \"png\", \"ps\", \"raw\", \"svg\", \"tif\"];\n\nmpl.default_extension = \"png\";/* global mpl */\n\nvar comm_websocket_adapter = function (comm) {\n // Create a \"websocket\"-like object which calls the given IPython comm\n // object with the appropriate methods. Currently this is a non binary\n // socket, so there is still some room for performance tuning.\n var ws = {};\n\n ws.binaryType = comm.kernel.ws.binaryType;\n ws.readyState = comm.kernel.ws.readyState;\n function updateReadyState(_event) {\n if (comm.kernel.ws) {\n ws.readyState = comm.kernel.ws.readyState;\n } else {\n ws.readyState = 3; // Closed state.\n }\n }\n comm.kernel.ws.addEventListener('open', updateReadyState);\n comm.kernel.ws.addEventListener('close', updateReadyState);\n comm.kernel.ws.addEventListener('error', updateReadyState);\n\n ws.close = function () {\n comm.close();\n };\n ws.send = function (m) {\n //console.log('sending', m);\n comm.send(m);\n };\n // Register the callback with on_msg.\n comm.on_msg(function (msg) {\n //console.log('receiving', msg['content']['data'], msg);\n var data = msg['content']['data'];\n if (data['blob'] !== undefined) {\n data = {\n data: new Blob(msg['buffers'], { type: data['blob'] }),\n };\n }\n // Pass the mpl event to the overridden (by mpl) onmessage function.\n ws.onmessage(data);\n });\n return ws;\n};\n\nmpl.mpl_figure_comm = function (comm, msg) {\n // This is the function which gets called when the mpl process\n // starts-up an IPython Comm through the \"matplotlib\" channel.\n\n var id = msg.content.data.id;\n // Get hold of the div created by the display call when the Comm\n // socket was opened in Python.\n var element = document.getElementById(id);\n var ws_proxy = comm_websocket_adapter(comm);\n\n function ondownload(figure, _format) {\n window.open(figure.canvas.toDataURL());\n }\n\n var fig = new mpl.figure(id, ws_proxy, ondownload, element);\n\n // Call onopen now - mpl needs it, as it is assuming we've passed it a real\n // web socket which is closed, not our websocket->open comm proxy.\n ws_proxy.onopen();\n\n fig.parent_element = element;\n fig.cell_info = mpl.find_output_cell(\"
\");\n if (!fig.cell_info) {\n console.error('Failed to find cell for figure', id, fig);\n return;\n }\n fig.cell_info[0].output_area.element.on(\n 'cleared',\n { fig: fig },\n fig._remove_fig_handler\n );\n};\n\nmpl.figure.prototype.handle_close = function (fig, msg) {\n var width = fig.canvas.width / fig.ratio;\n fig.cell_info[0].output_area.element.off(\n 'cleared',\n fig._remove_fig_handler\n );\n fig.resizeObserverInstance.unobserve(fig.canvas_div);\n\n // Update the output cell to use the data from the current canvas.\n fig.push_to_output();\n var dataURL = fig.canvas.toDataURL();\n // Re-enable the keyboard manager in IPython - without this line, in FF,\n // the notebook keyboard shortcuts fail.\n IPython.keyboard_manager.enable();\n fig.parent_element.innerHTML =\n '';\n fig.close_ws(fig, msg);\n};\n\nmpl.figure.prototype.close_ws = function (fig, msg) {\n fig.send_message('closing', msg);\n // fig.ws.close()\n};\n\nmpl.figure.prototype.push_to_output = function (_remove_interactive) {\n // Turn the data on the canvas into data in the output cell.\n var width = this.canvas.width / this.ratio;\n var dataURL = this.canvas.toDataURL();\n this.cell_info[1]['text/html'] =\n '';\n};\n\nmpl.figure.prototype.updated_canvas_event = function () {\n // Tell IPython that the notebook contents must change.\n IPython.notebook.set_dirty(true);\n this.send_message('ack', {});\n var fig = this;\n // Wait a second, then push the new image to the DOM so\n // that it is saved nicely (might be nice to debounce this).\n setTimeout(function () {\n fig.push_to_output();\n }, 1000);\n};\n\nmpl.figure.prototype._init_toolbar = function () {\n var fig = this;\n\n var toolbar = document.createElement('div');\n toolbar.classList = 'btn-toolbar';\n this.root.appendChild(toolbar);\n\n function on_click_closure(name) {\n return function (_event) {\n return fig.toolbar_button_onclick(name);\n };\n }\n\n function on_mouseover_closure(tooltip) {\n return function (event) {\n if (!event.currentTarget.disabled) {\n return fig.toolbar_button_onmouseover(tooltip);\n }\n };\n }\n\n fig.buttons = {};\n var buttonGroup = document.createElement('div');\n buttonGroup.classList = 'btn-group';\n var button;\n for (var toolbar_ind in mpl.toolbar_items) {\n var name = mpl.toolbar_items[toolbar_ind][0];\n var tooltip = mpl.toolbar_items[toolbar_ind][1];\n var image = mpl.toolbar_items[toolbar_ind][2];\n var method_name = mpl.toolbar_items[toolbar_ind][3];\n\n if (!name) {\n /* Instead of a spacer, we start a new button group. */\n if (buttonGroup.hasChildNodes()) {\n toolbar.appendChild(buttonGroup);\n }\n buttonGroup = document.createElement('div');\n buttonGroup.classList = 'btn-group';\n continue;\n }\n\n button = fig.buttons[name] = document.createElement('button');\n button.classList = 'btn btn-default';\n button.href = '#';\n button.title = name;\n button.innerHTML = '';\n button.addEventListener('click', on_click_closure(method_name));\n button.addEventListener('mouseover', on_mouseover_closure(tooltip));\n buttonGroup.appendChild(button);\n }\n\n if (buttonGroup.hasChildNodes()) {\n toolbar.appendChild(buttonGroup);\n }\n\n // Add the status bar.\n var status_bar = document.createElement('span');\n status_bar.classList = 'mpl-message pull-right';\n toolbar.appendChild(status_bar);\n this.message = status_bar;\n\n // Add the close button to the window.\n var buttongrp = document.createElement('div');\n buttongrp.classList = 'btn-group inline pull-right';\n button = document.createElement('button');\n button.classList = 'btn btn-mini btn-primary';\n button.href = '#';\n button.title = 'Stop Interaction';\n button.innerHTML = '';\n button.addEventListener('click', function (_evt) {\n fig.handle_close(fig, {});\n });\n button.addEventListener(\n 'mouseover',\n on_mouseover_closure('Stop Interaction')\n );\n buttongrp.appendChild(button);\n var titlebar = this.root.querySelector('.ui-dialog-titlebar');\n titlebar.insertBefore(buttongrp, titlebar.firstChild);\n};\n\nmpl.figure.prototype._remove_fig_handler = function (event) {\n var fig = event.data.fig;\n if (event.target !== this) {\n // Ignore bubbled events from children.\n return;\n }\n fig.close_ws(fig, {});\n};\n\nmpl.figure.prototype._root_extra_style = function (el) {\n el.style.boxSizing = 'content-box'; // override notebook setting of border-box.\n};\n\nmpl.figure.prototype._canvas_extra_style = function (el) {\n // this is important to make the div 'focusable\n el.setAttribute('tabindex', 0);\n // reach out to IPython and tell the keyboard manager to turn it's self\n // off when our div gets focus\n\n // location in version 3\n if (IPython.notebook.keyboard_manager) {\n IPython.notebook.keyboard_manager.register_events(el);\n } else {\n // location in version 2\n IPython.keyboard_manager.register_events(el);\n }\n};\n\nmpl.figure.prototype._key_event_extra = function (event, _name) {\n // Check for shift+enter\n if (event.shiftKey && event.which === 13) {\n this.canvas_div.blur();\n // select the cell after this one\n var index = IPython.notebook.find_cell_index(this.cell_info[0]);\n IPython.notebook.select(index + 1);\n }\n};\n\nmpl.figure.prototype.handle_save = function (fig, _msg) {\n fig.ondownload(fig, null);\n};\n\nmpl.find_output_cell = function (html_output) {\n // Return the cell and output element which can be found *uniquely* in the notebook.\n // Note - this is a bit hacky, but it is done because the \"notebook_saving.Notebook\"\n // IPython event is triggered only after the cells have been serialised, which for\n // our purposes (turning an active figure into a static one), is too late.\n var cells = IPython.notebook.get_cells();\n var ncells = cells.length;\n for (var i = 0; i < ncells; i++) {\n var cell = cells[i];\n if (cell.cell_type === 'code') {\n for (var j = 0; j < cell.output_area.outputs.length; j++) {\n var data = cell.output_area.outputs[j];\n if (data.data) {\n // IPython >= 3 moved mimebundle to data attribute of output\n data = data.data;\n }\n if (data['text/html'] === html_output) {\n return [cell, data, j];\n }\n }\n }\n }\n};\n\n// Register the function which deals with the matplotlib target/channel.\n// The kernel may be null if the page has been refreshed.\nif (IPython.notebook.kernel !== null) {\n IPython.notebook.kernel.comm_manager.register_target(\n 'matplotlib',\n mpl.mpl_figure_comm\n );\n}\n",
"text/plain": [
""
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
""
],
"text/plain": [
""
]
},
"metadata": {},
"output_type": "display_data"
},
{
"name": "stdout",
"output_type": "stream",
"text": [
"+-----------+------------+------------+------------+\n",
"| seq_num | time | motor1 | noisy_det |\n",
"+-----------+------------+------------+------------+\n",
"| 1 | 00:27:29.7 | -5.000 | 0.017 |\n",
"| 2 | 00:27:29.7 | -3.571 | 0.021 |\n",
"| 3 | 00:27:29.7 | -2.143 | 0.115 |\n",
"| 4 | 00:27:29.7 | -0.714 | 0.658 |\n",
"| 5 | 00:27:29.7 | 0.714 | 0.697 |\n",
"| 6 | 00:27:29.7 | 2.143 | 0.155 |\n",
"| 7 | 00:27:29.7 | 3.571 | -0.086 |\n",
"| 8 | 00:27:29.7 | 5.000 | 0.089 |\n",
"+-----------+------------+------------+------------+\n",
"generator scan ['a6ea8a82'] (scan num: 1)\n",
"\n",
"\n",
"\n",
"no handling for table row 2: OrderedDict([('Scan Type', 'other_scan'), ('sx', 5.07), ('sy', 8.3), ('Thickness', 0), ('Sample Name', 'Water Blank'), ('remarks', 'deionized'), ('code number', None)])\n",
"no handling for table row 3: OrderedDict([('Scan Type', 'this will be ignored (and also the next blank row will be ignored)'), ('sx', None), ('sy', None), ('Thickness', None), ('Sample Name', None), ('remarks', None), ('code number', None)])\n"
]
},
{
"data": {
"text/plain": [
"('a6ea8a82-aff2-4621-a197-1a3bca524e51',)"
]
},
"execution_count": 3,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"RE(Excel_plan(\"sample_example.xlsx\"))"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Show what was collected by accessing the most recent run from the catalog."
]
},
{
"cell_type": "code",
"execution_count": 4,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"\n",
"\n",
" \n",
" \n",
" Start \n",
" code_number | \n",
" None | \n",
" \n",
" detectors | \n",
" | \n",
" \n",
" Excel_file | \n",
" sample_example.xlsx | \n",
" \n",
" hints | \n",
" \n",
" \n",
" dimensions | \n",
" | \n",
" \n",
" | \n",
" \n",
" motor2 | \n",
" 5.07 | \n",
" \n",
" motor3 | \n",
" 8.3 | \n",
" \n",
" motors | \n",
" | \n",
" \n",
" num_intervals | \n",
" 7 | \n",
" \n",
" num_points | \n",
" 8 | \n",
" \n",
" original_keys | \n",
" \n",
" \n",
" code_number | \n",
" code number | \n",
" \n",
" remarks | \n",
" remarks | \n",
" \n",
" Sample_Name | \n",
" Sample Name | \n",
" \n",
" Scan_Type | \n",
" Scan Type | \n",
" \n",
" sx | \n",
" sx | \n",
" \n",
" sy | \n",
" sy | \n",
" \n",
" Thickness | \n",
" Thickness | \n",
" \n",
" | \n",
" \n",
" plan_args | \n",
" \n",
" \n",
" args | \n",
" SynAxis(prefix='', name='motor1', read_attrs=['readback', 'setpoint'], configuration_attrs=['velocity', 'acceleration']) | -5 | 5 |
| \n",
" \n",
" detectors | \n",
" SynGauss(prefix='', name='noisy_det', read_attrs=['val'], configuration_attrs=['Imax', 'center', 'sigma', 'noise', 'noise_multiplier']) |
| \n",
" \n",
" num | \n",
" 8 | \n",
" \n",
" per_step | \n",
" None | \n",
" \n",
" | \n",
" \n",
" plan_name | \n",
" scan | \n",
" \n",
" plan_pattern | \n",
" inner_product | \n",
" \n",
" plan_pattern_args | \n",
" \n",
" \n",
" args | \n",
" SynAxis(prefix='', name='motor1', read_attrs=['readback', 'setpoint'], configuration_attrs=['velocity', 'acceleration']) | -5 | 5 |
| \n",
" \n",
" num | \n",
" 8 | \n",
" \n",
" | \n",
" \n",
" plan_pattern_module | \n",
" bluesky.plan_patterns | \n",
" \n",
" plan_type | \n",
" generator | \n",
" \n",
" remarks | \n",
" deionized | \n",
" \n",
" Sample_Name | \n",
" Water Blank | \n",
" \n",
" scan_id | \n",
" 1 | \n",
" \n",
" Scan_Type | \n",
" step_scan | \n",
" \n",
" shutter | \n",
" open | \n",
" \n",
" sx | \n",
" 5.07 | \n",
" \n",
" sy | \n",
" 8.3 | \n",
" \n",
" table_row | \n",
" 1 | \n",
" \n",
" Thickness | \n",
" 0 | \n",
" \n",
" time | \n",
" a second ago (2022-07-06T00:27:29.644067) | \n",
" \n",
" uid | \n",
" a6ea8a82-aff2-4621-a197-1a3bca524e51 | \n",
" \n",
" versions | \n",
" \n",
" \n",
" bluesky | \n",
" 1.8.3 | \n",
" \n",
" ophyd | \n",
" 1.6.4 | \n",
" \n",
" | \n",
" \n",
" xl_file | \n",
" sample_example.xlsx | \n",
" | \n",
"
\n",
" \n",
" Stop \n",
" exit_status | \n",
" success | \n",
" \n",
" num_events | \n",
" \n",
" \n",
" primary | \n",
" 8 | \n",
" \n",
" | \n",
" \n",
" reason | \n",
" | \n",
" \n",
" run_start | \n",
" a6ea8a82-aff2-4621-a197-1a3bca524e51 | \n",
" \n",
" time | \n",
" a second ago (2022-07-06T00:27:29.781108) | \n",
" \n",
" uid | \n",
" 128c5ecf-2c21-497e-b7f1-6b74614bfb45 | \n",
" | \n",
" \n",
" \n",
" \n",
" \n",
" Descriptors\n",
" \n",
" primary \n",
" configuration | \n",
" \n",
" \n",
" motor1 | \n",
" \n",
" \n",
" data | \n",
" \n",
" \n",
" motor1_acceleration | \n",
" 1 | \n",
" \n",
" motor1_velocity | \n",
" 1 | \n",
" \n",
" | \n",
" \n",
" data_keys | \n",
" \n",
" \n",
" motor1_acceleration | \n",
" \n",
" \n",
" dtype | \n",
" integer | \n",
" \n",
" shape | \n",
" | \n",
" \n",
" source | \n",
" SIM:motor1_acceleration | \n",
" \n",
" | \n",
" \n",
" motor1_velocity | \n",
" \n",
" \n",
" dtype | \n",
" integer | \n",
" \n",
" shape | \n",
" | \n",
" \n",
" source | \n",
" SIM:motor1_velocity | \n",
" \n",
" | \n",
" \n",
" | \n",
" \n",
" timestamps | \n",
" \n",
" \n",
" motor1_acceleration | \n",
" 1657085249.0746343 | \n",
" \n",
" motor1_velocity | \n",
" 1657085249.0746002 | \n",
" \n",
" | \n",
" \n",
" | \n",
" \n",
" noisy_det | \n",
" \n",
" \n",
" data | \n",
" \n",
" \n",
" noisy_det_center | \n",
" 0 | \n",
" \n",
" noisy_det_Imax | \n",
" 1 | \n",
" \n",
" noisy_det_noise | \n",
" uniform | \n",
" \n",
" noisy_det_noise_multiplier | \n",
" 0.1 | \n",
" \n",
" noisy_det_sigma | \n",
" 0.9 | \n",
" \n",
" | \n",
" \n",
" data_keys | \n",
" \n",
" \n",
" noisy_det_center | \n",
" \n",
" \n",
" dtype | \n",
" integer | \n",
" \n",
" shape | \n",
" | \n",
" \n",
" source | \n",
" SIM:noisy_det_center | \n",
" \n",
" | \n",
" \n",
" noisy_det_Imax | \n",
" \n",
" \n",
" dtype | \n",
" integer | \n",
" \n",
" shape | \n",
" | \n",
" \n",
" source | \n",
" SIM:noisy_det_Imax | \n",
" \n",
" | \n",
" \n",
" noisy_det_noise | \n",
" \n",
" \n",
" dtype | \n",
" integer | \n",
" \n",
" enum_strs | \n",
" | \n",
" \n",
" shape | \n",
" | \n",
" \n",
" source | \n",
" SIM:noisy_det_noise | \n",
" \n",
" | \n",
" \n",
" noisy_det_noise_multiplier | \n",
" \n",
" \n",
" dtype | \n",
" number | \n",
" \n",
" shape | \n",
" | \n",
" \n",
" source | \n",
" SIM:noisy_det_noise_multiplier | \n",
" \n",
" | \n",
" \n",
" noisy_det_sigma | \n",
" \n",
" \n",
" dtype | \n",
" number | \n",
" \n",
" shape | \n",
" | \n",
" \n",
" source | \n",
" SIM:noisy_det_sigma | \n",
" \n",
" | \n",
" \n",
" | \n",
" \n",
" timestamps | \n",
" \n",
" \n",
" noisy_det_center | \n",
" 1657085249.298179 | \n",
" \n",
" noisy_det_Imax | \n",
" 1657085249.2981858 | \n",
" \n",
" noisy_det_noise | \n",
" 1657085249.298202 | \n",
" \n",
" noisy_det_noise_multiplier | \n",
" 1657085249.2982059 | \n",
" \n",
" noisy_det_sigma | \n",
" 1657085249.2981968 | \n",
" \n",
" | \n",
" \n",
" | \n",
" \n",
" | \n",
" \n",
" data_keys | \n",
" \n",
" \n",
" motor1 | \n",
" \n",
" \n",
" dtype | \n",
" number | \n",
" \n",
" object_name | \n",
" motor1 | \n",
" \n",
" precision | \n",
" 3 | \n",
" \n",
" shape | \n",
" | \n",
" \n",
" source | \n",
" SIM:motor1 | \n",
" \n",
" | \n",
" \n",
" motor1_setpoint | \n",
" \n",
" \n",
" dtype | \n",
" number | \n",
" \n",
" object_name | \n",
" motor1 | \n",
" \n",
" precision | \n",
" 3 | \n",
" \n",
" shape | \n",
" | \n",
" \n",
" source | \n",
" SIM:motor1_setpoint | \n",
" \n",
" | \n",
" \n",
" noisy_det | \n",
" \n",
" \n",
" dtype | \n",
" number | \n",
" \n",
" object_name | \n",
" noisy_det | \n",
" \n",
" precision | \n",
" 3 | \n",
" \n",
" shape | \n",
" | \n",
" \n",
" source | \n",
" SIM:noisy_det | \n",
" \n",
" | \n",
" \n",
" | \n",
" \n",
" hints | \n",
" \n",
" \n",
" motor1 | \n",
" \n",
" \n",
" fields | \n",
" | \n",
" \n",
" | \n",
" \n",
" noisy_det | \n",
" \n",
" \n",
" fields | \n",
" | \n",
" \n",
" | \n",
" \n",
" | \n",
" \n",
" name | \n",
" primary | \n",
" \n",
" object_keys | \n",
" \n",
" \n",
" motor1 | \n",
" | \n",
" \n",
" noisy_det | \n",
" | \n",
" \n",
" | \n",
" \n",
" run_start | \n",
" a6ea8a82-aff2-4621-a197-1a3bca524e51 | \n",
" \n",
" time | \n",
" a second ago (2022-07-06T00:27:29.654973) | \n",
" \n",
" uid | \n",
" 9fc2e538-dfde-48a0-a70a-b6ad3ac3c493 | \n",
" | \n",
" \n",
" | \n",
"
\n",
"
"
],
"text/plain": [
""
]
},
"execution_count": 4,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"run = cat[-1]\n",
"run"
]
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 3.9.13 ('base')",
"language": "python",
"name": "python3"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 3
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython3",
"version": "3.9.13"
},
"vscode": {
"interpreter": {
"hash": "f38aef175fb08dfc130a7d9bb9234f0792dc9ad861f95b6c05aedd1b380356e2"
}
}
},
"nbformat": 4,
"nbformat_minor": 4
}