{ "cells": [ { "cell_type": "markdown", "metadata": { "application/vnd.databricks.v1+cell": { "cellMetadata": {}, "inputWidgets": {}, "nuid": "28589033-9516-4f79-ab21-4149964e7e23", "showTitle": false, "title": "" } }, "source": [ "**ConnectToDeltaOnADLS**\n", "\n", "Connect to the Delta Table created in ADF using Azure Databricks to connect to ADLS with a Service Principal" ] }, { "cell_type": "code", "execution_count": 0, "metadata": { "application/vnd.databricks.v1+cell": { "cellMetadata": { "byteLimit": 2048000, "rowLimit": 10000 }, "inputWidgets": {}, "nuid": "3e3f6d25-ad28-41d2-a440-67b22c239410", "showTitle": false, "title": "" } }, "outputs": [], "source": [ "adlsAccountName = \"\"\n", "sourceAdlsContainerName = \"bronze\"\n", "sinkAdlsContainerName = \"silver\"\n", "sourceAdlsFolderName = \"diabetes\"\n", "sinkAdlsFolderName = \"diabetes\"" ] }, { "cell_type": "code", "execution_count": 0, "metadata": { "application/vnd.databricks.v1+cell": { "cellMetadata": { "byteLimit": 2048000, "rowLimit": 10000 }, "inputWidgets": {}, "nuid": "d7dea54f-4e09-4289-a350-13a4c0a627a9", "showTitle": false, "title": "" } }, "outputs": [], "source": [ "spark.conf.set(\n", " \"fs.azure.account.key.\" + adlsAccountName + \".dfs.core.windows.net\",\n", " dbutils.secrets.get(scope=\"\",key=\"Adls2-KeySecret\"))" ] }, { "cell_type": "code", "execution_count": 0, "metadata": { "application/vnd.databricks.v1+cell": { "cellMetadata": { "byteLimit": 2048000, "rowLimit": 10000 }, "inputWidgets": {}, "nuid": "a6724215-30b1-4ac7-a106-a257a5a0f9ea", "showTitle": false, "title": "" } }, "outputs": [ { "output_type": "stream", "name": "stdout", "output_type": "stream", "text": [ "Out[3]: [FileInfo(path='abfss://bronze@cdcacceleredfkdd3zynq6k.dfs.core.windows.net/SalesLT.Customer.txt', name='SalesLT.Customer.txt', size=217829, modificationTime=1679577529000),\n FileInfo(path='abfss://bronze@cdcacceleredfkdd3zynq6k.dfs.core.windows.net/SalesLTAddress.csv', name='SalesLTAddress.csv', size=62625, modificationTime=1679577890000),\n FileInfo(path='abfss://bronze@cdcacceleredfkdd3zynq6k.dfs.core.windows.net/SalesLTProduct.csv', name='SalesLTProduct.csv', size=1358154, modificationTime=1679577891000),\n FileInfo(path='abfss://bronze@cdcacceleredfkdd3zynq6k.dfs.core.windows.net/diabetes/', name='diabetes/', size=0, modificationTime=1679700073000)]" ] } ], "source": [ "dbutils.fs.ls(\"abfss://\" + sourceAdlsContainerName + \"@\" + adlsAccountName + \".dfs.core.windows.net/\")" ] }, { "cell_type": "code", "execution_count": 0, "metadata": { "application/vnd.databricks.v1+cell": { "cellMetadata": { "byteLimit": 2048000, "rowLimit": 10000 }, "inputWidgets": {}, "nuid": "592a81ea-cf47-4963-9185-415391b8ea93", "showTitle": false, "title": "" } }, "outputs": [], "source": [ "SubscriptionID = dbutils.secrets.get(\"\",\"SubscriptionID\")\n", "DirectoryID = dbutils.secrets.get(\"\",\"DirectoryID\")\n", "ServicePrincipalAppID = dbutils.secrets.get(\"\",\"ServicePrincipalAppID\")\n", "ServicePrincipalSecret = dbutils.secrets.get(\"\",\"AppSecret\")\n", "ResourceGroup = dbutils.secrets.get(\"\",\"ResourceGroup\")\n", "BlobConnectionKey = dbutils.secrets.get(\"\",\"Adls2-KeySecret\")" ] }, { "cell_type": "code", "execution_count": 0, "metadata": { "application/vnd.databricks.v1+cell": { "cellMetadata": { "byteLimit": 2048000, "rowLimit": 10000 }, "inputWidgets": {}, "nuid": "d2985e25-c7bb-4bcb-9285-b9b5705dd07b", "showTitle": false, "title": "" } }, "outputs": [], "source": [ "configs = {\"fs.azure.account.auth.type\": \"OAuth\",\n", " \"fs.azure.account.oauth.provider.type\": \"org.apache.hadoop.fs.azurebfs.oauth2.ClientCredsTokenProvider\",\n", " \"fs.azure.account.oauth2.client.id\": ServicePrincipalAppID,\n", " \"fs.azure.account.oauth2.client.secret\": ServicePrincipalSecret,\n", " \"fs.azure.account.oauth2.client.endpoint\": \"https://login.microsoftonline.com/\"+DirectoryID+\"/oauth2/token\"}" ] }, { "cell_type": "code", "execution_count": 0, "metadata": { "application/vnd.databricks.v1+cell": { "cellMetadata": { "byteLimit": 2048000, "rowLimit": 10000 }, "inputWidgets": {}, "nuid": "f978e2e8-2639-4273-a812-755decae2d40", "showTitle": false, "title": "" } }, "outputs": [ { "output_type": "display_data", "data": { "text/plain": [ "\u001B[0;31m---------------------------------------------------------------------------\u001B[0m\n\u001B[0;31mExecutionError\u001B[0m Traceback (most recent call last)\n\u001B[0;32m\u001B[0m in \u001B[0;36m\u001B[0;34m()\u001B[0m\n\u001B[0;32m----> 1\u001B[0;31m \u001B[0mdbutils\u001B[0m\u001B[0;34m.\u001B[0m\u001B[0mfs\u001B[0m\u001B[0;34m.\u001B[0m\u001B[0munmount\u001B[0m\u001B[0;34m(\u001B[0m\u001B[0;34m\"/mnt/source\"\u001B[0m\u001B[0;34m)\u001B[0m\u001B[0;34m\u001B[0m\u001B[0;34m\u001B[0m\u001B[0m\n\u001B[0m\u001B[1;32m 2\u001B[0m \u001B[0mdbutils\u001B[0m\u001B[0;34m.\u001B[0m\u001B[0mfs\u001B[0m\u001B[0;34m.\u001B[0m\u001B[0munmount\u001B[0m\u001B[0;34m(\u001B[0m\u001B[0;34m\"/mnt/sink\"\u001B[0m\u001B[0;34m)\u001B[0m\u001B[0;34m\u001B[0m\u001B[0;34m\u001B[0m\u001B[0m\n\n\u001B[0;32m/databricks/python_shell/dbruntime/dbutils.py\u001B[0m in \u001B[0;36mf_with_exception_handling\u001B[0;34m(*args, **kwargs)\u001B[0m\n\u001B[1;32m 360\u001B[0m \u001B[0mexc\u001B[0m\u001B[0;34m.\u001B[0m\u001B[0m__context__\u001B[0m \u001B[0;34m=\u001B[0m \u001B[0;32mNone\u001B[0m\u001B[0;34m\u001B[0m\u001B[0;34m\u001B[0m\u001B[0m\n\u001B[1;32m 361\u001B[0m \u001B[0mexc\u001B[0m\u001B[0;34m.\u001B[0m\u001B[0m__cause__\u001B[0m \u001B[0;34m=\u001B[0m \u001B[0;32mNone\u001B[0m\u001B[0;34m\u001B[0m\u001B[0;34m\u001B[0m\u001B[0m\n\u001B[0;32m--> 362\u001B[0;31m \u001B[0;32mraise\u001B[0m \u001B[0mexc\u001B[0m\u001B[0;34m\u001B[0m\u001B[0;34m\u001B[0m\u001B[0m\n\u001B[0m\u001B[1;32m 363\u001B[0m \u001B[0;34m\u001B[0m\u001B[0m\n\u001B[1;32m 364\u001B[0m \u001B[0;32mreturn\u001B[0m \u001B[0mf_with_exception_handling\u001B[0m\u001B[0;34m\u001B[0m\u001B[0;34m\u001B[0m\u001B[0m\n\n\u001B[0;31mExecutionError\u001B[0m: An error occurred while calling o433.unmount.\n: java.rmi.RemoteException: java.lang.IllegalArgumentException: requirement failed: Directory not mounted: /mnt/source; nested exception is: \n\tjava.lang.IllegalArgumentException: requirement failed: Directory not mounted: /mnt/source\n\tat com.databricks.backend.daemon.data.client.DbfsClient.send0(DbfsClient.scala:135)\n\tat com.databricks.backend.daemon.data.client.DbfsClient.sendIdempotent(DbfsClient.scala:69)\n\tat com.databricks.backend.daemon.dbutils.DBUtilsCore.unmount(DBUtilsCore.scala:1202)\n\tat com.databricks.backend.daemon.dbutils.DBUtilsCore.$anonfun$unmount$1(DBUtilsCore.scala:1218)\n\tat com.databricks.logging.UsageLogging.$anonfun$recordOperation$1(UsageLogging.scala:541)\n\tat com.databricks.logging.UsageLogging.executeThunkAndCaptureResultTags$1(UsageLogging.scala:636)\n\tat com.databricks.logging.UsageLogging.$anonfun$recordOperationWithResultTags$4(UsageLogging.scala:657)\n\tat com.databricks.logging.UsageLogging.$anonfun$withAttributionContext$1(UsageLogging.scala:398)\n\tat scala.util.DynamicVariable.withValue(DynamicVariable.scala:62)\n\tat com.databricks.logging.AttributionContext$.withValue(AttributionContext.scala:147)\n\tat com.databricks.logging.UsageLogging.withAttributionContext(UsageLogging.scala:396)\n\tat com.databricks.logging.UsageLogging.withAttributionContext$(UsageLogging.scala:393)\n\tat com.databricks.backend.daemon.dbutils.FSUtils.withAttributionContext(DBUtilsCore.scala:66)\n\tat com.databricks.logging.UsageLogging.withAttributionTags(UsageLogging.scala:441)\n\tat com.databricks.logging.UsageLogging.withAttributionTags$(UsageLogging.scala:426)\n\tat com.databricks.backend.daemon.dbutils.FSUtils.withAttributionTags(DBUtilsCore.scala:66)\n\tat com.databricks.logging.UsageLogging.recordOperationWithResultTags(UsageLogging.scala:631)\n\tat com.databricks.logging.UsageLogging.recordOperationWithResultTags$(UsageLogging.scala:550)\n\tat com.databricks.backend.daemon.dbutils.FSUtils.recordOperationWithResultTags(DBUtilsCore.scala:66)\n\tat com.databricks.logging.UsageLogging.recordOperation(UsageLogging.scala:541)\n\tat com.databricks.logging.UsageLogging.recordOperation$(UsageLogging.scala:511)\n\tat com.databricks.backend.daemon.dbutils.FSUtils.recordOperation(DBUtilsCore.scala:66)\n\tat com.databricks.backend.daemon.dbutils.FSUtils.recordDbutilsFsOp(DBUtilsCore.scala:130)\n\tat com.databricks.backend.daemon.dbutils.DBUtilsCore.unmount(DBUtilsCore.scala:1218)\n\tat sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\n\tat sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n\tat java.lang.reflect.Method.invoke(Method.java:498)\n\tat py4j.reflection.MethodInvoker.invoke(MethodInvoker.java:244)\n\tat py4j.reflection.ReflectionEngine.invoke(ReflectionEngine.java:380)\n\tat py4j.Gateway.invoke(Gateway.java:306)\n\tat py4j.commands.AbstractCommand.invokeMethod(AbstractCommand.java:132)\n\tat py4j.commands.CallCommand.execute(CallCommand.java:79)\n\tat py4j.ClientServerConnection.waitForCommands(ClientServerConnection.java:195)\n\tat py4j.ClientServerConnection.run(ClientServerConnection.java:115)\n\tat java.lang.Thread.run(Thread.java:750)\nCaused by: java.lang.IllegalArgumentException: requirement failed: Directory not mounted: /mnt/source\n\tat scala.Predef$.require(Predef.scala:281)\n\tat com.databricks.backend.daemon.data.server.DefaultMetadataManager.$anonfun$deleteMount$1(MetadataManager.scala:604)\n\tat com.databricks.backend.daemon.data.server.DefaultMetadataManager.$anonfun$modifyAndVerify$1(MetadataManager.scala:873)\n\tat scala.runtime.java8.JFunction0$mcV$sp.apply(JFunction0$mcV$sp.java:23)\n\tat com.databricks.backend.daemon.data.server.DefaultMetadataManager.withRetries(MetadataManager.scala:654)\n\tat com.databricks.backend.daemon.data.server.DefaultMetadataManager.modifyAndVerify(MetadataManager.scala:862)\n\tat com.databricks.backend.daemon.data.server.DefaultMetadataManager.deleteMount(MetadataManager.scala:608)\n\tat com.databricks.backend.daemon.data.server.handler.MountHandler.receive(MountHandler.scala:141)\n\tat com.databricks.backend.daemon.data.server.session.SessionContext.$anonfun$queryHandlers$1(SessionContext.scala:54)\n\tat com.databricks.backend.daemon.data.server.session.SessionContext.$anonfun$queryHandlers$1$adapted(SessionContext.scala:53)\n\tat scala.collection.immutable.List.foreach(List.scala:431)\n\tat com.databricks.backend.daemon.data.server.session.SessionContext.queryHandlers(SessionContext.scala:53)\n\tat com.databricks.backend.daemon.data.server.DbfsServerBackend$$anonfun$receive$4.$anonfun$applyOrElse$5(DbfsServerBackend.scala:370)\n\tat com.databricks.logging.UsageLogging.$anonfun$withAttributionContext$1(UsageLogging.scala:415)\n\tat scala.util.DynamicVariable.withValue(DynamicVariable.scala:62)\n\tat com.databricks.logging.AttributionContext$.withValue(AttributionContext.scala:196)\n\tat com.databricks.logging.UsageLogging.withAttributionContext(UsageLogging.scala:413)\n\tat com.databricks.logging.UsageLogging.withAttributionContext$(UsageLogging.scala:407)\n\tat com.databricks.rpc.ServerBackend.withAttributionContext(ServerBackend.scala:22)\n\tat com.databricks.logging.UsageLogging.withAttributionTags(UsageLogging.scala:459)\n\tat com.databricks.logging.UsageLogging.withAttributionTags$(UsageLogging.scala:444)\n\tat com.databricks.rpc.ServerBackend.withAttributionTags(ServerBackend.scala:22)\n\tat com.databricks.backend.daemon.data.server.DbfsServerBackend$$anonfun$receive$4.applyOrElse(DbfsServerBackend.scala:370)\n\tat com.databricks.backend.daemon.data.server.DbfsServerBackend$$anonfun$receive$4.applyOrElse(DbfsServerBackend.scala:326)\n\tat com.databricks.rpc.ServerBackend.$anonfun$internalReceive$2(ServerBackend.scala:117)\n\tat com.databricks.rpc.ServerBackend$$anonfun$commonReceive$1.applyOrElse(ServerBackend.scala:144)\n\tat com.databricks.rpc.ServerBackend$$anonfun$commonReceive$1.applyOrElse(ServerBackend.scala:144)\n\tat com.databricks.rpc.ServerBackend.$anonfun$internalReceive$1(ServerBackend.scala:114)\n\tat com.databricks.logging.UsageLogging.$anonfun$recordOperation$1(UsageLogging.scala:559)\n\tat com.databricks.logging.UsageLogging.executeThunkAndCaptureResultTags$1(UsageLogging.scala:654)\n\tat com.databricks.logging.UsageLogging.$anonfun$recordOperationWithResultTags$4(UsageLogging.scala:675)\n\tat com.databricks.logging.UsageLogging.$anonfun$withAttributionContext$1(UsageLogging.scala:415)\n\tat scala.util.DynamicVariable.withValue(DynamicVariable.scala:62)\n\tat com.databricks.logging.AttributionContext$.withValue(AttributionContext.scala:196)\n\tat com.databricks.logging.UsageLogging.withAttributionContext(UsageLogging.scala:413)\n\tat com.databricks.logging.UsageLogging.withAttributionContext$(UsageLogging.scala:407)\n\tat com.databricks.rpc.ServerBackend.withAttributionContext(ServerBackend.scala:22)\n\tat com.databricks.logging.UsageLogging.withAttributionTags(UsageLogging.scala:459)\n\tat com.databricks.logging.UsageLogging.withAttributionTags$(UsageLogging.scala:444)\n\tat com.databricks.rpc.ServerBackend.withAttributionTags(ServerBackend.scala:22)\n\tat com.databricks.logging.UsageLogging.recordOperationWithResultTags(UsageLogging.scala:649)\n\tat com.databricks.logging.UsageLogging.recordOperationWithResultTags$(UsageLogging.scala:568)\n\tat com.databricks.rpc.ServerBackend.recordOperationWithResultTags(ServerBackend.scala:22)\n\tat com.databricks.logging.UsageLogging.recordOperation(UsageLogging.scala:559)\n\tat com.databricks.logging.UsageLogging.recordOperation$(UsageLogging.scala:529)\n\tat com.databricks.rpc.ServerBackend.recordOperation(ServerBackend.scala:22)\n\tat com.databricks.rpc.ServerBackend.internalReceive(ServerBackend.scala:113)\n\tat com.databricks.rpc.JettyServer$RequestManager.handleRPC(JettyServer.scala:950)\n\tat com.databricks.rpc.JettyServer$RequestManager.handleRequestAndRespond(JettyServer.scala:861)\n\tat com.databricks.rpc.JettyServer$RequestManager.$anonfun$handleHttp$2(JettyServer.scala:499)\n\tat com.databricks.rpc.JettyServer$RequestManager.$anonfun$handleHttp$2$adapted(JettyServer.scala:474)\n\tat com.databricks.logging.activity.ActivityContextFactory$.$anonfun$withActivityInternal$3(ActivityContextFactory.scala:388)\n\tat com.databricks.logging.UsageLogging.$anonfun$withAttributionContext$1(UsageLogging.scala:415)\n\tat scala.util.DynamicVariable.withValue(DynamicVariable.scala:62)\n\tat com.databricks.logging.AttributionContext$.withValue(AttributionContext.scala:196)\n\tat com.databricks.logging.UsageLogging.withAttributionContext(UsageLogging.scala:413)\n\tat com.databricks.logging.UsageLogging.withAttributionContext$(UsageLogging.scala:407)\n\tat com.databricks.logging.activity.ActivityContextFactory$.withAttributionContext(ActivityContextFactory.scala:53)\n\tat com.databricks.logging.activity.ActivityContextFactory$.withActivityInternal(ActivityContextFactory.scala:388)\n\tat com.databricks.logging.activity.ActivityContextFactory$.withServiceRequestActivity(ActivityContextFactory.scala:162)\n\tat com.databricks.rpc.JettyServer$RequestManager.handleHttp(JettyServer.scala:474)\n\tat com.databricks.rpc.JettyServer$RequestManager.doPost(JettyServer.scala:375)\n\tat javax.servlet.http.HttpServlet.service(HttpServlet.java:707)\n\tat com.databricks.rpc.HttpServletWithPatch.service(HttpServletWithPatch.scala:33)\n\tat javax.servlet.http.HttpServlet.service(HttpServlet.java:790)\n\tat org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:848)\n\tat org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:585)\n\tat org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)\n\tat org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)\n\tat org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:134)\n\tat org.eclipse.jetty.server.Server.handle(Server.java:539)\n\tat org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:333)\n\tat org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:251)\n\tat org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:283)\n\tat org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:108)\n\tat org.eclipse.jetty.io.SelectChannelEndPoint$2.run(SelectChannelEndPoint.java:93)\n\tat org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.executeProduceConsume(ExecuteProduceConsume.java:303)\n\tat org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.produceConsume(ExecuteProduceConsume.java:148)\n\tat org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.run(ExecuteProduceConsume.java:136)\n\tat com.databricks.rpc.InstrumentedQueuedThreadPool$$anon$1.run(InstrumentedQueuedThreadPool.scala:80)\n\tat org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:671)\n\tat org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:589)\n\t... 1 more\n" ] }, "metadata": { "application/vnd.databricks.v1+output": { "arguments": {}, "data": "\u001B[0;31m---------------------------------------------------------------------------\u001B[0m\n\u001B[0;31mExecutionError\u001B[0m Traceback (most recent call last)\n\u001B[0;32m\u001B[0m in \u001B[0;36m\u001B[0;34m()\u001B[0m\n\u001B[0;32m----> 1\u001B[0;31m \u001B[0mdbutils\u001B[0m\u001B[0;34m.\u001B[0m\u001B[0mfs\u001B[0m\u001B[0;34m.\u001B[0m\u001B[0munmount\u001B[0m\u001B[0;34m(\u001B[0m\u001B[0;34m\"/mnt/source\"\u001B[0m\u001B[0;34m)\u001B[0m\u001B[0;34m\u001B[0m\u001B[0;34m\u001B[0m\u001B[0m\n\u001B[0m\u001B[1;32m 2\u001B[0m \u001B[0mdbutils\u001B[0m\u001B[0;34m.\u001B[0m\u001B[0mfs\u001B[0m\u001B[0;34m.\u001B[0m\u001B[0munmount\u001B[0m\u001B[0;34m(\u001B[0m\u001B[0;34m\"/mnt/sink\"\u001B[0m\u001B[0;34m)\u001B[0m\u001B[0;34m\u001B[0m\u001B[0;34m\u001B[0m\u001B[0m\n\n\u001B[0;32m/databricks/python_shell/dbruntime/dbutils.py\u001B[0m in \u001B[0;36mf_with_exception_handling\u001B[0;34m(*args, **kwargs)\u001B[0m\n\u001B[1;32m 360\u001B[0m \u001B[0mexc\u001B[0m\u001B[0;34m.\u001B[0m\u001B[0m__context__\u001B[0m \u001B[0;34m=\u001B[0m \u001B[0;32mNone\u001B[0m\u001B[0;34m\u001B[0m\u001B[0;34m\u001B[0m\u001B[0m\n\u001B[1;32m 361\u001B[0m \u001B[0mexc\u001B[0m\u001B[0;34m.\u001B[0m\u001B[0m__cause__\u001B[0m \u001B[0;34m=\u001B[0m \u001B[0;32mNone\u001B[0m\u001B[0;34m\u001B[0m\u001B[0;34m\u001B[0m\u001B[0m\n\u001B[0;32m--> 362\u001B[0;31m \u001B[0;32mraise\u001B[0m \u001B[0mexc\u001B[0m\u001B[0;34m\u001B[0m\u001B[0;34m\u001B[0m\u001B[0m\n\u001B[0m\u001B[1;32m 363\u001B[0m \u001B[0;34m\u001B[0m\u001B[0m\n\u001B[1;32m 364\u001B[0m \u001B[0;32mreturn\u001B[0m \u001B[0mf_with_exception_handling\u001B[0m\u001B[0;34m\u001B[0m\u001B[0;34m\u001B[0m\u001B[0m\n\n\u001B[0;31mExecutionError\u001B[0m: An error occurred while calling o433.unmount.\n: java.rmi.RemoteException: java.lang.IllegalArgumentException: requirement failed: Directory not mounted: /mnt/source; nested exception is: \n\tjava.lang.IllegalArgumentException: requirement failed: Directory not mounted: /mnt/source\n\tat com.databricks.backend.daemon.data.client.DbfsClient.send0(DbfsClient.scala:135)\n\tat com.databricks.backend.daemon.data.client.DbfsClient.sendIdempotent(DbfsClient.scala:69)\n\tat com.databricks.backend.daemon.dbutils.DBUtilsCore.unmount(DBUtilsCore.scala:1202)\n\tat com.databricks.backend.daemon.dbutils.DBUtilsCore.$anonfun$unmount$1(DBUtilsCore.scala:1218)\n\tat com.databricks.logging.UsageLogging.$anonfun$recordOperation$1(UsageLogging.scala:541)\n\tat com.databricks.logging.UsageLogging.executeThunkAndCaptureResultTags$1(UsageLogging.scala:636)\n\tat com.databricks.logging.UsageLogging.$anonfun$recordOperationWithResultTags$4(UsageLogging.scala:657)\n\tat com.databricks.logging.UsageLogging.$anonfun$withAttributionContext$1(UsageLogging.scala:398)\n\tat scala.util.DynamicVariable.withValue(DynamicVariable.scala:62)\n\tat com.databricks.logging.AttributionContext$.withValue(AttributionContext.scala:147)\n\tat com.databricks.logging.UsageLogging.withAttributionContext(UsageLogging.scala:396)\n\tat com.databricks.logging.UsageLogging.withAttributionContext$(UsageLogging.scala:393)\n\tat com.databricks.backend.daemon.dbutils.FSUtils.withAttributionContext(DBUtilsCore.scala:66)\n\tat com.databricks.logging.UsageLogging.withAttributionTags(UsageLogging.scala:441)\n\tat com.databricks.logging.UsageLogging.withAttributionTags$(UsageLogging.scala:426)\n\tat com.databricks.backend.daemon.dbutils.FSUtils.withAttributionTags(DBUtilsCore.scala:66)\n\tat com.databricks.logging.UsageLogging.recordOperationWithResultTags(UsageLogging.scala:631)\n\tat com.databricks.logging.UsageLogging.recordOperationWithResultTags$(UsageLogging.scala:550)\n\tat com.databricks.backend.daemon.dbutils.FSUtils.recordOperationWithResultTags(DBUtilsCore.scala:66)\n\tat com.databricks.logging.UsageLogging.recordOperation(UsageLogging.scala:541)\n\tat com.databricks.logging.UsageLogging.recordOperation$(UsageLogging.scala:511)\n\tat com.databricks.backend.daemon.dbutils.FSUtils.recordOperation(DBUtilsCore.scala:66)\n\tat com.databricks.backend.daemon.dbutils.FSUtils.recordDbutilsFsOp(DBUtilsCore.scala:130)\n\tat com.databricks.backend.daemon.dbutils.DBUtilsCore.unmount(DBUtilsCore.scala:1218)\n\tat sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\n\tat sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n\tat java.lang.reflect.Method.invoke(Method.java:498)\n\tat py4j.reflection.MethodInvoker.invoke(MethodInvoker.java:244)\n\tat py4j.reflection.ReflectionEngine.invoke(ReflectionEngine.java:380)\n\tat py4j.Gateway.invoke(Gateway.java:306)\n\tat py4j.commands.AbstractCommand.invokeMethod(AbstractCommand.java:132)\n\tat py4j.commands.CallCommand.execute(CallCommand.java:79)\n\tat py4j.ClientServerConnection.waitForCommands(ClientServerConnection.java:195)\n\tat py4j.ClientServerConnection.run(ClientServerConnection.java:115)\n\tat java.lang.Thread.run(Thread.java:750)\nCaused by: java.lang.IllegalArgumentException: requirement failed: Directory not mounted: /mnt/source\n\tat scala.Predef$.require(Predef.scala:281)\n\tat com.databricks.backend.daemon.data.server.DefaultMetadataManager.$anonfun$deleteMount$1(MetadataManager.scala:604)\n\tat com.databricks.backend.daemon.data.server.DefaultMetadataManager.$anonfun$modifyAndVerify$1(MetadataManager.scala:873)\n\tat scala.runtime.java8.JFunction0$mcV$sp.apply(JFunction0$mcV$sp.java:23)\n\tat com.databricks.backend.daemon.data.server.DefaultMetadataManager.withRetries(MetadataManager.scala:654)\n\tat com.databricks.backend.daemon.data.server.DefaultMetadataManager.modifyAndVerify(MetadataManager.scala:862)\n\tat com.databricks.backend.daemon.data.server.DefaultMetadataManager.deleteMount(MetadataManager.scala:608)\n\tat com.databricks.backend.daemon.data.server.handler.MountHandler.receive(MountHandler.scala:141)\n\tat com.databricks.backend.daemon.data.server.session.SessionContext.$anonfun$queryHandlers$1(SessionContext.scala:54)\n\tat com.databricks.backend.daemon.data.server.session.SessionContext.$anonfun$queryHandlers$1$adapted(SessionContext.scala:53)\n\tat scala.collection.immutable.List.foreach(List.scala:431)\n\tat com.databricks.backend.daemon.data.server.session.SessionContext.queryHandlers(SessionContext.scala:53)\n\tat com.databricks.backend.daemon.data.server.DbfsServerBackend$$anonfun$receive$4.$anonfun$applyOrElse$5(DbfsServerBackend.scala:370)\n\tat com.databricks.logging.UsageLogging.$anonfun$withAttributionContext$1(UsageLogging.scala:415)\n\tat scala.util.DynamicVariable.withValue(DynamicVariable.scala:62)\n\tat com.databricks.logging.AttributionContext$.withValue(AttributionContext.scala:196)\n\tat com.databricks.logging.UsageLogging.withAttributionContext(UsageLogging.scala:413)\n\tat com.databricks.logging.UsageLogging.withAttributionContext$(UsageLogging.scala:407)\n\tat com.databricks.rpc.ServerBackend.withAttributionContext(ServerBackend.scala:22)\n\tat com.databricks.logging.UsageLogging.withAttributionTags(UsageLogging.scala:459)\n\tat com.databricks.logging.UsageLogging.withAttributionTags$(UsageLogging.scala:444)\n\tat com.databricks.rpc.ServerBackend.withAttributionTags(ServerBackend.scala:22)\n\tat com.databricks.backend.daemon.data.server.DbfsServerBackend$$anonfun$receive$4.applyOrElse(DbfsServerBackend.scala:370)\n\tat com.databricks.backend.daemon.data.server.DbfsServerBackend$$anonfun$receive$4.applyOrElse(DbfsServerBackend.scala:326)\n\tat com.databricks.rpc.ServerBackend.$anonfun$internalReceive$2(ServerBackend.scala:117)\n\tat com.databricks.rpc.ServerBackend$$anonfun$commonReceive$1.applyOrElse(ServerBackend.scala:144)\n\tat com.databricks.rpc.ServerBackend$$anonfun$commonReceive$1.applyOrElse(ServerBackend.scala:144)\n\tat com.databricks.rpc.ServerBackend.$anonfun$internalReceive$1(ServerBackend.scala:114)\n\tat com.databricks.logging.UsageLogging.$anonfun$recordOperation$1(UsageLogging.scala:559)\n\tat com.databricks.logging.UsageLogging.executeThunkAndCaptureResultTags$1(UsageLogging.scala:654)\n\tat com.databricks.logging.UsageLogging.$anonfun$recordOperationWithResultTags$4(UsageLogging.scala:675)\n\tat com.databricks.logging.UsageLogging.$anonfun$withAttributionContext$1(UsageLogging.scala:415)\n\tat scala.util.DynamicVariable.withValue(DynamicVariable.scala:62)\n\tat com.databricks.logging.AttributionContext$.withValue(AttributionContext.scala:196)\n\tat com.databricks.logging.UsageLogging.withAttributionContext(UsageLogging.scala:413)\n\tat com.databricks.logging.UsageLogging.withAttributionContext$(UsageLogging.scala:407)\n\tat com.databricks.rpc.ServerBackend.withAttributionContext(ServerBackend.scala:22)\n\tat com.databricks.logging.UsageLogging.withAttributionTags(UsageLogging.scala:459)\n\tat com.databricks.logging.UsageLogging.withAttributionTags$(UsageLogging.scala:444)\n\tat com.databricks.rpc.ServerBackend.withAttributionTags(ServerBackend.scala:22)\n\tat com.databricks.logging.UsageLogging.recordOperationWithResultTags(UsageLogging.scala:649)\n\tat com.databricks.logging.UsageLogging.recordOperationWithResultTags$(UsageLogging.scala:568)\n\tat com.databricks.rpc.ServerBackend.recordOperationWithResultTags(ServerBackend.scala:22)\n\tat com.databricks.logging.UsageLogging.recordOperation(UsageLogging.scala:559)\n\tat com.databricks.logging.UsageLogging.recordOperation$(UsageLogging.scala:529)\n\tat com.databricks.rpc.ServerBackend.recordOperation(ServerBackend.scala:22)\n\tat com.databricks.rpc.ServerBackend.internalReceive(ServerBackend.scala:113)\n\tat com.databricks.rpc.JettyServer$RequestManager.handleRPC(JettyServer.scala:950)\n\tat com.databricks.rpc.JettyServer$RequestManager.handleRequestAndRespond(JettyServer.scala:861)\n\tat com.databricks.rpc.JettyServer$RequestManager.$anonfun$handleHttp$2(JettyServer.scala:499)\n\tat com.databricks.rpc.JettyServer$RequestManager.$anonfun$handleHttp$2$adapted(JettyServer.scala:474)\n\tat com.databricks.logging.activity.ActivityContextFactory$.$anonfun$withActivityInternal$3(ActivityContextFactory.scala:388)\n\tat com.databricks.logging.UsageLogging.$anonfun$withAttributionContext$1(UsageLogging.scala:415)\n\tat scala.util.DynamicVariable.withValue(DynamicVariable.scala:62)\n\tat com.databricks.logging.AttributionContext$.withValue(AttributionContext.scala:196)\n\tat com.databricks.logging.UsageLogging.withAttributionContext(UsageLogging.scala:413)\n\tat com.databricks.logging.UsageLogging.withAttributionContext$(UsageLogging.scala:407)\n\tat com.databricks.logging.activity.ActivityContextFactory$.withAttributionContext(ActivityContextFactory.scala:53)\n\tat com.databricks.logging.activity.ActivityContextFactory$.withActivityInternal(ActivityContextFactory.scala:388)\n\tat com.databricks.logging.activity.ActivityContextFactory$.withServiceRequestActivity(ActivityContextFactory.scala:162)\n\tat com.databricks.rpc.JettyServer$RequestManager.handleHttp(JettyServer.scala:474)\n\tat com.databricks.rpc.JettyServer$RequestManager.doPost(JettyServer.scala:375)\n\tat javax.servlet.http.HttpServlet.service(HttpServlet.java:707)\n\tat com.databricks.rpc.HttpServletWithPatch.service(HttpServletWithPatch.scala:33)\n\tat javax.servlet.http.HttpServlet.service(HttpServlet.java:790)\n\tat org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:848)\n\tat org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:585)\n\tat org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)\n\tat org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)\n\tat org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:134)\n\tat org.eclipse.jetty.server.Server.handle(Server.java:539)\n\tat org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:333)\n\tat org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:251)\n\tat org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:283)\n\tat org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:108)\n\tat org.eclipse.jetty.io.SelectChannelEndPoint$2.run(SelectChannelEndPoint.java:93)\n\tat org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.executeProduceConsume(ExecuteProduceConsume.java:303)\n\tat org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.produceConsume(ExecuteProduceConsume.java:148)\n\tat org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.run(ExecuteProduceConsume.java:136)\n\tat com.databricks.rpc.InstrumentedQueuedThreadPool$$anon$1.run(InstrumentedQueuedThreadPool.scala:80)\n\tat org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:671)\n\tat org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:589)\n\t... 1 more\n", "errorSummary": "java.rmi.RemoteException: java.lang.IllegalArgumentException: requirement failed: Directory not mounted: /mnt/source; nested exception is: ", "errorTraceType": "ansi", "metadata": {}, "type": "ipynbError" } }, "output_type": "display_data" } ], "source": [ "dbutils.fs.unmount(\"/mnt/source\")\n", "dbutils.fs.unmount(\"/mnt/sink\") " ] }, { "cell_type": "code", "execution_count": 0, "metadata": { "application/vnd.databricks.v1+cell": { "cellMetadata": { "byteLimit": 2048000, "rowLimit": 10000 }, "inputWidgets": {}, "nuid": "980864bc-b300-4368-8dfb-323bd6ad902a", "showTitle": false, "title": "" } }, "outputs": [ { "output_type": "stream", "name": "stdout", "output_type": "stream", "text": [ "Out[7]: True" ] } ], "source": [ "dbutils.fs.mount(\n", " source = \"abfss://\"+sourceAdlsContainerName+\"@\"+adlsAccountName+\".dfs.core.windows.net/\",\n", " mount_point = \"/mnt/source\",\n", " extra_configs = configs)\n", "\n", "\n", "dbutils.fs.mount(\n", " source = \"abfss://\"+sinkAdlsContainerName+\"@\"+adlsAccountName+\".dfs.core.windows.net/\",\n", " mount_point = \"/mnt/sink\",\n", " extra_configs = configs)" ] }, { "cell_type": "code", "execution_count": 0, "metadata": { "application/vnd.databricks.v1+cell": { "cellMetadata": { "byteLimit": 2048000, "rowLimit": 10000 }, "inputWidgets": {}, "nuid": "f5640595-d24b-4ce9-b35e-e6358a48f498", "showTitle": false, "title": "" } }, "outputs": [ { "output_type": "stream", "name": "stdout", "output_type": "stream", "text": [ "Out[8]: [FileInfo(path='dbfs:/mnt/sink/', name='sink/', size=0, modificationTime=0),\n FileInfo(path='dbfs:/mnt/source/', name='source/', size=0, modificationTime=0)]" ] } ], "source": [ "dbutils.fs.ls (\"/mnt/\")" ] }, { "cell_type": "code", "execution_count": 0, "metadata": { "application/vnd.databricks.v1+cell": { "cellMetadata": { "byteLimit": 2048000, "rowLimit": 10000 }, "inputWidgets": {}, "nuid": "4db133e0-2d88-453a-80e3-d508f4567624", "showTitle": false, "title": "" } }, "outputs": [ { "output_type": "stream", "name": "stdout", "output_type": "stream", "text": [ "Out[10]: DataFrame[]" ] } ], "source": [ "spark.sql(\"CREATE DATABASE IF NOT EXISTS diabetes\")\n", "spark.sql(\"CREATE TABLE IF NOT EXISTS diabetes.diabetesage USING DELTA LOCATION '/mnt/sink/\"+sinkAdlsFolderName+\"/adfdelta/'\")\n" ] }, { "cell_type": "code", "execution_count": 0, "metadata": { "application/vnd.databricks.v1+cell": { "cellMetadata": { "byteLimit": 2048000, "implicitDf": true, "rowLimit": 10000 }, "inputWidgets": {}, "nuid": "601690f0-e2e7-426e-98a1-26917002ae6f", "showTitle": false, "title": "" } }, "outputs": [ { "output_type": "display_data", "data": { "text/html": [ "
AGESEXBMIBPS1S2S3S4S5S6YGenderageband
59232.1101.015793.238.04.04.859887151FemaleRetiredAdult
48121.687.0183103.270.03.03.89186975MaleAdult
72230.593.015693.641.04.04.672885141FemaleRetiredAdult
24125.384.0198131.440.05.04.890389206MaleAdult
50123.0101.0192125.452.04.04.290580135MaleAdult
23122.689.013964.861.02.04.18976897MaleAdult
36222.090.016099.650.03.03.951282138FemaleAdult
66226.2114.0255185.056.04.554.24859263FemaleRetiredAdult
60232.183.0179119.442.04.04.477394110FemaleRetiredAdult
29130.085.018093.443.04.05.384588310MaleAdult
22118.697.011457.646.02.03.951283101MaleAdult
56228.085.0184144.832.06.03.58357769FemaleRetiredAdult
53123.792.0186109.262.03.04.304181179MaleAdult
50226.297.0186105.449.04.05.062688185FemaleAdult
61124.091.0202115.472.03.04.290573118MaleRetiredAdult
34224.7118.0254184.239.07.05.03781171FemaleAdult
47130.3109.0207100.270.03.05.214998166MaleAdult
68227.5111.0214147.039.05.04.941691144FemaleRetiredAdult
38125.484.0162103.042.04.04.44278797MaleAdult
41124.783.0187108.260.03.04.543378168MaleAdult
35121.182.015687.850.03.04.51099568MaleAdult
25224.395.016298.654.03.03.85018749FemaleAdult
25126.092.0187120.456.03.03.97038868MaleAdult
61232.0103.6721085.235.06.06.107124245FemaleRetiredAdult
31129.788.0167103.448.04.04.356778184MaleAdult
30225.283.0178118.434.05.04.85283202FemaleAdult
19119.287.012454.057.02.04.174490137MaleYoungAdult
42131.983.015887.653.03.04.465910185MaleAdult
63124.473.016091.448.03.04.634778131MaleRetiredAdult
67225.8113.015854.264.02.05.2933104283FemaleRetiredAdult
32130.589.0182110.656.03.04.343889129MaleAdult
42120.371.016181.266.02.04.23418159MaleAdult
58238.0103.0150107.222.07.04.644498341FemaleRetiredAdult
57121.794.015758.082.02.04.44279287MaleRetiredAdult
53120.578.014784.252.03.03.9897565MaleAdult
62223.580.33225112.886.02.624.875296102FemaleRetiredAdult
52128.5110.019597.260.03.05.241785265MaleAdult
46127.478.017188.058.03.04.828390276MaleAdult
48233.0123.0253163.644.06.05.42597252FemaleAdult
48227.773.0191119.446.04.04.8529290FemaleAdult
50225.6101.0229162.243.05.04.7791114100FemaleAdult
21120.163.013569.054.03.04.09438955MaleAdult
32225.490.33153100.434.04.54.53268361FemaleAdult
54124.274.0204109.082.02.04.174410992MaleAdult
61232.797.0177118.429.06.04.997287259FemaleRetiredAdult
56223.1104.0181116.447.04.04.47737953FemaleRetiredAdult
33125.385.015585.051.03.04.553970190MaleAdult
27119.678.012868.043.03.04.442771142MaleAdult
67222.598.0191119.261.03.03.9898675FemaleRetiredAdult
37227.793.0180119.430.06.05.030488142FemaleAdult
58125.799.015791.649.03.04.406793155MaleRetiredAdult
65227.9103.015996.842.04.04.615186225FemaleRetiredAdult
34125.593.0218144.057.04.04.44278859MaleAdult
46124.9115.0198129.654.04.04.2767103104MaleAdult
35128.797.0204126.864.03.04.189793182MaleAdult
37121.884.0184101.073.03.03.91293128MaleAdult
37130.287.016696.040.04.155.01068752MaleAdult
41120.580.012448.864.02.04.02547537MaleAdult
60120.4105.019878.499.02.04.634779170MaleRetiredAdult
66224.098.0236146.458.04.05.062696170FemaleRetiredAdult
29126.083.014165.264.02.04.07758361MaleAdult
37226.879.015798.028.06.05.043496144FemaleAdult
41225.783.0181106.666.03.03.73778552FemaleAdult
39122.977.0204143.246.04.04.304174128MaleAdult
67224.083.014377.249.03.04.43089471FemaleRetiredAdult
36224.1112.0193125.035.06.05.105995163FemaleAdult
46224.785.0174123.230.06.04.644496150FemaleAdult
60225.089.67185120.846.04.024.51099297FemaleRetiredAdult
59223.683.0165100.047.04.04.499892160FemaleRetiredAdult
53122.193.013476.246.03.04.077596178MaleAdult
48119.991.0189109.669.03.03.951210148MaleAdult
48129.5131.0207132.247.04.04.9345106270MaleAdult
66226.091.0264146.665.04.05.568387202FemaleRetiredAdult
52224.594.0217149.448.05.04.58589111FemaleAdult
52226.6111.0209126.461.03.04.682110985FemaleAdult
46223.587.0181114.844.04.04.70959842FemaleAdult
40229.0115.09747.235.02.774.304195170FemaleAdult
22123.073.016197.854.03.03.828691200MaleAdult
50121.088.014071.835.04.05.11271252MaleAdult
20122.987.0191128.253.04.03.891885113MaleYoungAdult
68127.5107.0241149.664.04.04.9290143MaleRetiredAdult
52224.386.0197133.644.05.04.57479151FemaleAdult
44123.187.0213126.477.03.03.87127252MaleAdult
38127.381.014681.647.03.04.465981210MaleAdult
49122.765.3316896.262.02.713.89186065MaleAdult
61133.095.0182114.854.03.04.189774141MaleRetiredAdult
29219.483.0152105.839.04.03.58358355FemaleAdult
61125.898.0235125.876.03.05.11282134MaleRetiredAdult
34222.675.016691.860.03.04.262710842FemaleAdult
36121.989.0189105.268.03.04.369496111MaleAdult
52124.083.016786.671.02.03.85019498MaleAdult
61131.279.0235156.847.05.05.049996164MaleRetiredAdult
43126.8123.0193102.267.03.04.77919448MaleAdult
35120.465.0187105.667.02.794.27677896MaleAdult
27124.891.0189106.869.03.04.18976990MaleAdult
29121.071.015697.038.04.04.65490162MaleAdult
64227.3109.0186107.638.05.05.308399150FemaleRetiredAdult
41134.687.33205142.641.05.04.6728110279MaleAdult
49225.991.0178106.652.03.04.57477592FemaleAdult
48120.498.0209139.446.05.04.77077883MaleAdult
53128.088.0233143.858.04.05.049991128MaleAdult
53222.2113.0197115.267.03.04.3041100102FemaleAdult
23129.090.0216131.465.03.04.58591302MaleAdult
65230.298.0219160.640.05.04.521884198FemaleRetiredAdult
41132.494.0171104.456.03.03.97037695MaleAdult
55223.483.0166101.646.04.04.52189653FemaleRetiredAdult
22119.382.015693.252.03.03.98971134MaleAdult
56131.078.67187141.434.05.54.060490144MaleRetiredAdult
54230.6103.3314479.830.04.85.1417101232FemaleAdult
59225.595.33190139.435.05.434.356711781FemaleRetiredAdult
60223.488.015389.858.03.03.258195104FemaleRetiredAdult
54126.887.0206122.068.03.04.3828059MaleAdult
25128.387.0193128.049.04.04.38292246MaleAdult
54227.7113.0200128.437.05.05.1533113297FemaleAdult
55136.6113.019994.443.04.635.730197258MaleRetiredAdult
40226.593.0236147.037.07.05.560792229FemaleAdult
62231.8115.0199128.644.05.04.882898275FemaleRetiredAdult
65124.4120.0222135.637.06.05.5094124281MaleRetiredAdult
33225.4102.0206141.039.05.04.8675105179FemaleAdult
53122.094.017588.059.03.04.941698200MaleAdult
35126.898.0162103.645.04.04.204786200MaleAdult
66128.0101.0195129.240.05.04.859894173MaleRetiredAdult
62233.9101.0221156.435.06.04.9972103180FemaleRetiredAdult
50229.694.33300242.433.09.094.812210984FemaleAdult
47128.697.016490.656.03.04.465988121MaleAdult
47225.694.016574.840.04.05.525593161FemaleAdult
24120.787.014980.661.02.03.61097899MaleAdult
58226.291.0217124.271.03.04.691368109FemaleRetiredAdult
34120.687.0185112.258.03.04.304174115MaleAdult
51127.996.0196122.242.05.05.0689120268MaleAdult
31235.3125.0187112.448.04.04.8903109274FemaleAdult
22119.975.0175108.654.03.04.127172158MaleAdult
53224.492.0214146.050.04.04.499897107FemaleAdult
37221.483.012869.649.03.03.85018483FemaleAdult
28130.485.0198115.667.03.04.343880103MaleAdult
47131.684.015488.030.05.15.1985105272MaleAdult
23118.878.014572.063.02.03.9128685MaleAdult
50131.0123.0178105.048.04.04.828388280MaleAdult
58236.7117.016693.844.04.04.9488109336FemaleRetiredAdult
55132.1110.016484.242.04.05.241790281MaleRetiredAdult
60227.7107.0167114.638.04.04.276795118FemaleRetiredAdult
41130.881.0214152.028.07.65.1358123317MaleAdult
60227.5106.0229143.851.04.05.141791235FemaleRetiredAdult
40126.992.0203119.870.03.04.18978160MaleAdult
57230.790.0204147.834.06.04.709593174FemaleRetiredAdult
37138.3113.016594.653.03.04.465979259MaleAdult
40231.995.0198135.638.05.04.80493178FemaleAdult
33135.089.0200130.442.04.764.9273101128MaleAdult
32227.889.0216146.255.04.04.30419196FemaleAdult
35225.981.0174102.431.06.05.313282126FemaleAdult
55132.9102.0164106.241.04.04.430889288MaleRetiredAdult
49126.093.0183100.264.03.04.54338888MaleAdult
39226.3115.0218158.232.07.04.9345109292FemaleAdult
60222.3113.0186125.846.04.04.26279471FemaleRetiredAdult
67228.393.0204132.249.04.04.736292197FemaleRetiredAdult
41232.0109.0251170.649.05.05.0562103186FemaleAdult
44125.495.016292.653.03.04.40678325MaleAdult
48223.389.33212142.846.04.614.75369884FemaleAdult
45120.374.33190126.249.03.884.30417996MaleAdult
47130.4120.0199120.046.04.05.105987195MaleAdult
46120.673.0172107.051.03.04.24858053MaleAdult
36232.3115.0286199.439.07.05.4723112217FemaleAdult
34129.273.0172108.249.04.04.304191172MaleAdult
53233.1117.0183119.048.04.04.382106131FemaleAdult
61124.6101.0209106.877.03.04.836388214MaleRetiredAdult
37120.281.016287.863.03.04.02548859MaleAdult
33220.884.012570.246.03.03.78426670FemaleAdult
68132.8105.67205116.440.05.135.4931117220MaleRetiredAdult
49231.994.0234155.834.07.05.3982122268FemaleAdult
48123.9109.0232105.237.06.06.10796152MaleAdult
55224.584.0179105.866.03.03.58358747FemaleRetiredAdult
43122.166.013477.245.03.04.07758074MaleAdult
60233.097.0217125.645.05.05.4467112295FemaleRetiredAdult
31219.093.013773.047.03.04.442778101FemaleAdult
53227.382.011955.039.03.04.828393151FemaleAdult
67122.887.016698.652.03.04.343892127MaleRetiredAdult
61228.2106.0204132.052.04.04.605296237FemaleRetiredAdult
62128.987.33206127.233.06.245.433799225MaleRetiredAdult
60125.687.0207125.869.03.04.11098481MaleRetiredAdult
42124.991.0204141.838.05.04.795889151MaleAdult
38226.8105.0181119.237.05.04.820391107FemaleAdult
62122.479.0222147.459.04.04.35677664MaleRetiredAdult
61226.9111.0236172.439.06.04.812289138FemaleRetiredAdult
61223.1113.0186114.447.04.04.8122105185FemaleRetiredAdult
53128.688.017198.841.04.05.049999265MaleAdult
28224.797.017599.632.05.05.379987101FemaleAdult
26230.389.0218152.231.07.05.159182137FemaleAdult
30121.387.013463.063.02.03.688966143MaleAdult
50126.1109.0243160.662.04.04.62589141MaleAdult
48120.295.0187117.453.04.04.41888579MaleAdult
51125.2103.0176112.237.05.04.897890292MaleAdult
47222.582.013166.841.03.04.753689178FemaleAdult
64223.597.0203129.059.03.04.31757791FemaleRetiredAdult
51225.976.0240169.039.06.05.075296116FemaleAdult
30120.9104.015283.847.03.04.66349786MaleAdult
56228.799.0208146.439.05.04.727497122FemaleRetiredAdult
42122.185.0213138.660.04.04.27679472MaleAdult
62226.7115.0183124.035.05.04.7875100129FemaleRetiredAdult
34131.487.014993.846.03.03.828677142MaleAdult
60122.2104.67221105.460.03.685.62769390MaleRetiredAdult
64121.092.33227146.865.03.494.3307102158MaleRetiredAdult
39221.290.0182110.460.03.04.06049839FemaleAdult
71226.5105.0281173.655.05.05.568384196FemaleRetiredAdult
48229.2110.0218151.639.06.04.9298222FemaleAdult
79227.0103.0169110.837.05.04.6634110277FemaleRetiredAdult
40130.799.017785.450.04.05.33758599MaleAdult
49228.892.0207140.044.05.04.744992196FemaleAdult
51130.6103.0198106.657.03.05.1475100202MaleAdult
57130.1117.0202139.642.05.04.625120155MaleRetiredAdult
59224.7114.0152104.829.05.04.51098877FemaleRetiredAdult
51127.799.0229145.669.03.04.276777191MaleAdult
74129.8101.0171104.850.03.04.39448670MaleRetiredAdult
67126.7105.0225135.469.03.04.63479673MaleRetiredAdult
49119.888.0188114.857.03.04.39449349MaleAdult
57123.388.015563.678.02.04.20477865MaleRetiredAdult
56235.1123.016495.038.04.05.0434117263FemaleRetiredAdult
52229.7109.0228162.831.08.05.1417103248FemaleAdult
69129.3124.0223139.054.04.05.0106102296MaleRetiredAdult
37120.383.0185124.638.05.04.718588214MaleAdult
24122.589.014168.052.03.04.65484185MaleAdult
55222.793.015494.253.03.03.52647578FemaleRetiredAdult
36122.887.0178116.041.04.04.6548293MaleAdult
42224.0107.015085.044.03.04.65496252FemaleAdult
21124.276.014777.053.03.04.442779150MaleAdult
41120.262.015389.050.03.04.24858977MaleAdult
57229.4109.016087.631.05.05.332792208FemaleRetiredAdult
20222.187.017199.658.03.04.20477877FemaleYoungAdult
67223.6111.33189105.470.02.74.219593108FemaleRetiredAdult
34125.277.0189120.653.04.04.343879160MaleAdult
41224.986.0192115.061.03.04.3829453FemaleAdult
38233.078.0301215.050.06.025.193108220FemaleAdult
51123.5101.0195121.051.04.04.744994154MaleAdult
52226.491.33218152.039.05.594.905399259FemaleAdult
67129.880.017293.463.03.04.35678290MaleRetiredAdult
61130.0108.0194100.052.03.735.3471105246MaleRetiredAdult
67225.0111.6714693.433.04.424.585103124FemaleRetiredAdult
56127.0105.0247160.654.05.05.08769467MaleRetiredAdult
64120.074.67189114.862.03.054.11099172MaleRetiredAdult
58225.5112.0163110.629.06.04.762286257FemaleRetiredAdult
55128.291.0250140.267.04.05.366103262MaleRetiredAdult
62233.3114.0182114.038.05.05.010696275FemaleRetiredAdult
57225.696.0200133.052.03.854.3175105177FemaleRetiredAdult
20224.288.012672.245.03.03.78427471FemaleYoungAdult
53222.198.0165105.247.04.04.15898147FemaleAdult
32231.489.015384.256.03.04.158990187FemaleAdult
41123.186.014878.058.03.04.094360125MaleAdult
60123.476.67247148.065.03.85.13587778MaleRetiredAdult
26118.883.0191103.669.03.04.52186951MaleAdult
37130.8112.0282197.243.07.05.3423101258MaleAdult
45132.0110.0224134.245.05.05.411693215MaleAdult
67131.6116.017990.441.04.05.4723100303MaleRetiredAdult
34235.5120.0233146.634.07.05.5683101243FemaleAdult
50131.978.33207149.238.05.454.59518491MaleAdult
71129.597.0227151.645.05.05.0239108150MaleRetiredAdult
57231.6117.0225107.640.06.05.9584113310FemaleRetiredAdult
49120.393.0184103.061.03.04.605293153MaleAdult
35141.381.0168102.837.05.04.948894346MaleAdult
41221.2102.0184100.464.03.04.5857963FemaleAdult
70224.182.33194149.231.06.264.234110589FemaleRetiredAdult
52123.0107.0179123.742.54.214.15899350MaleAdult
60125.678.019595.491.02.03.76128739MaleRetiredAdult
62122.5125.021599.098.02.04.499895103MaleRetiredAdult
44238.2123.0201126.644.05.05.023992308FemaleAdult
28219.281.015594.651.03.03.850187116FemaleAdult
58229.085.0156109.236.04.03.98986145FemaleRetiredAdult
39224.089.67190113.652.03.654.80410174FemaleAdult
34220.698.018392.083.02.03.68899245FemaleAdult
65126.370.0244166.251.05.04.897898115MaleRetiredAdult
66234.6115.0204139.436.06.04.9628109264FemaleRetiredAdult
51123.487.0220108.893.02.04.51098287MaleAdult
50229.2119.016285.254.03.04.736295202FemaleAdult
59227.2107.0158102.039.04.04.442793127FemaleRetiredAdult
52127.078.3313473.044.03.054.442769182MaleAdult
69224.5108.0243136.440.06.05.8081100241FemaleRetiredAdult
53124.1105.0184113.446.04.04.81229566MaleAdult
47225.398.0173105.644.04.04.762210894FemaleAdult
52128.8113.0280174.067.04.05.27386283MaleAdult
39120.995.015065.668.02.04.40679564MaleAdult
67223.070.0184128.035.05.04.65499102FemaleRetiredAdult
59224.196.017098.654.03.04.465985200FemaleRetiredAdult
51228.1106.0202122.255.04.04.820387265FemaleAdult
23218.078.017196.048.04.04.90539294FemaleAdult
68125.993.0253181.253.05.04.543398230MaleRetiredAdult
44121.585.015792.255.03.03.891884181MaleAdult
60224.3103.014186.633.04.04.672878156FemaleRetiredAdult
52124.590.0198129.029.07.05.298386233MaleAdult
38121.372.016560.288.02.04.43089060MaleAdult
61125.890.0280195.455.05.04.997290219MaleRetiredAdult
68224.8101.0221151.460.04.03.87128780FemaleRetiredAdult
28231.583.0228149.438.06.05.31328368FemaleAdult
65233.5102.0190126.235.05.04.9698102332FemaleRetiredAdult
69128.1113.0234142.852.04.05.278177248MaleRetiredAdult
51124.385.3315371.671.02.153.95128284MaleAdult
29135.098.33204142.650.04.084.043191200MaleAdult
55223.593.0177126.841.04.03.82868355FemaleRetiredAdult
34230.083.0185107.253.03.04.82039285FemaleAdult
67120.783.017099.859.03.04.02547789MaleRetiredAdult
49125.676.016199.851.03.03.93187831MaleAdult
55222.981.012367.241.03.04.304188129FemaleRetiredAdult
59225.190.0163101.446.04.04.35679183FemaleRetiredAdult
53133.282.67186106.846.04.045.112102275MaleAdult
48224.1110.0209134.658.04.04.406710065FemaleAdult
52129.5104.33211132.849.04.314.983698198MaleAdult
69129.6122.0231128.456.04.05.45186236MaleRetiredAdult
60222.8110.0245189.839.06.04.394488253FemaleRetiredAdult
46222.783.0183125.832.06.04.836375124FemaleAdult
51226.2101.016199.648.03.04.20478844FemaleAdult
67223.596.0207138.242.05.04.8978111172FemaleRetiredAdult
49122.185.013663.462.02.193.970372114MaleAdult
46226.594.0247160.259.04.04.9345111142FemaleAdult
47132.4105.0188125.046.04.094.442799109MaleAdult
75130.178.0222154.244.05.054.779197180MaleRetiredAdult
28124.293.0174106.454.03.04.219584144MaleAdult
65231.3110.0213128.047.05.05.24791163FemaleRetiredAdult
42130.191.0182114.849.04.04.510982147MaleAdult
51124.579.0212128.665.03.04.52189197MaleAdult
53227.795.0190101.841.05.05.4638101220FemaleAdult
54123.2110.67238162.848.04.964.9127108190MaleAdult
73127.0102.0211121.067.03.04.744999109MaleRetiredAdult
54126.8108.017680.667.03.04.9558106191MaleAdult
42129.293.0249174.245.06.05.003992122MaleAdult
75131.2117.67229138.829.07.95.7236106230MaleRetiredAdult
55232.1112.6720792.425.08.286.1048111242FemaleRetiredAdult
68225.7109.0233112.635.07.06.0568105248FemaleRetiredAdult
57126.998.0246165.238.07.05.36696249MaleRetiredAdult
48131.475.33242151.638.06.375.5683103192MaleAdult
61225.685.0184116.239.05.04.969898131FemaleRetiredAdult
69137.0103.0207131.455.04.04.634790237MaleRetiredAdult
38132.677.0168100.647.04.04.6259678MaleAdult
45221.294.016996.855.03.04.4543102135FemaleAdult
51229.2107.0187139.032.06.04.38295244FemaleAdult
71224.084.013885.839.04.04.189790199FemaleRetiredAdult
57136.1117.0181108.234.05.05.2679100270MaleRetiredAdult
56225.8103.0177114.434.05.04.962899164FemaleRetiredAdult
32222.088.013778.648.03.03.95127872FemaleAdult
50121.991.0190111.267.03.04.07757796MaleAdult
43134.384.0256172.633.08.05.5294104306MaleAdult
54225.2115.0181120.039.05.04.70059291FemaleAdult
31123.385.0190130.843.04.04.394477214MaleAdult
56125.780.0244151.659.04.05.1189595MaleRetiredAdult
44125.1133.0182113.055.03.04.248584216MaleAdult
57231.9111.0173116.241.04.04.369487263FemaleRetiredAdult
64228.4111.0184127.041.04.04.38297178FemaleRetiredAdult
43128.1121.0192121.060.03.04.007393113MaleAdult
19125.383.0225156.646.05.04.718584200MaleYoungAdult
71226.185.0220152.447.05.04.634791139FemaleRetiredAdult
50228.0104.0282196.844.06.05.327995139FemaleAdult
59223.673.0180107.451.04.04.68218488FemaleRetiredAdult
57124.593.018696.671.03.04.521891148MaleRetiredAdult
49221.082.011985.423.05.03.97037488FemaleAdult
41232.0126.0198104.249.04.05.4116124243FemaleAdult
25222.685.013071.048.03.04.00738171FemaleAdult
52219.781.015253.482.02.04.41888277FemaleAdult
34121.284.0254113.452.05.06.093692109MaleAdult
42230.6101.0269172.250.05.05.4553106272FemaleAdult
28225.599.0162101.646.04.04.27679460FemaleAdult
47223.390.0195125.854.04.04.33077354FemaleAdult
32231.0100.017796.245.04.05.187477221FemaleAdult
43118.587.016393.661.02.673.73778090MaleAdult
59226.9104.0194126.643.05.04.804106311FemaleRetiredAdult
53128.3101.0179107.048.04.04.7875101281MaleAdult
60125.7103.015884.664.02.03.850197182MaleRetiredAdult
54236.1115.016398.443.04.04.6821101321FemaleAdult
35224.194.6715597.432.04.844.8529458FemaleAdult
49225.889.0182118.639.05.04.804115262FemaleAdult
58122.891.0196118.848.04.04.9836115206MaleRetiredAdult
36239.190.0219135.838.06.05.4205103233FemaleAdult
46242.299.0211137.044.05.05.010699242FemaleAdult
44226.699.0205109.043.05.05.5797111123FemaleAdult
46129.983.0171113.038.04.54.58598167MaleAdult
54121.078.0188107.470.03.03.97037363MaleAdult
63225.5109.0226103.246.05.05.950687197FemaleRetiredAdult
41224.290.0199123.657.04.04.52188671FemaleAdult
28125.493.014179.049.03.04.174491168MaleAdult
19123.275.014370.452.03.04.634772140MaleYoungAdult
61226.1126.0215129.857.04.04.948896217FemaleRetiredAdult
48132.793.0276198.643.06.425.147591121MaleAdult
54227.3100.0200144.033.06.04.744976235FemaleAdult
53226.693.0185122.436.05.04.890382245FemaleAdult
48122.8101.011041.656.02.04.12719740MaleAdult
53128.8111.6714587.246.03.154.07758552MaleAdult
29218.173.015899.041.04.04.499878104FemaleAdult
62132.088.017269.038.04.05.7838100132MaleRetiredAdult
50223.792.016697.052.03.04.44279388FemaleAdult
58223.696.0257171.059.04.04.90538269FemaleRetiredAdult
55224.6109.014376.451.03.04.356788219FemaleRetiredAdult
54122.690.0183104.264.03.04.30419272MaleAdult
36127.873.0153104.442.04.03.496573201MaleAdult
63224.1111.0184112.244.04.04.934582110FemaleRetiredAdult
47226.570.0181104.863.03.04.18977051FemaleAdult
51232.8112.0202100.637.05.05.7746109277FemaleAdult
42119.976.014683.255.03.03.66367963MaleAdult
37223.694.0205138.853.04.04.1897107118FemaleAdult
28122.182.0168100.654.03.04.20478669MaleAdult
58128.1111.019880.631.06.06.068493273MaleRetiredAdult
32126.586.0184101.653.04.04.990478258MaleAdult
25223.588.014380.855.03.03.58358343FemaleAdult
63126.085.6715578.246.03.375.03797198MaleRetiredAdult
52127.885.0219136.049.04.05.135875242MaleAdult
65228.5109.0201123.046.04.05.075296232FemaleRetiredAdult
42130.6121.017692.869.03.04.262789175MaleAdult
53122.278.016481.070.02.04.174410193MaleAdult
79223.388.0186128.433.06.04.8122102168FemaleRetiredAdult
43135.493.0185100.244.04.05.3181101275MaleAdult
44131.4115.016597.652.03.04.343889293MaleAdult
62237.8119.011351.031.04.05.043484281FemaleRetiredAdult
33118.970.016291.859.03.04.02545872MaleAdult
56135.079.33195140.842.04.644.110996140MaleRetiredAdult
66121.7126.0212127.845.04.715.2781101189MaleRetiredAdult
34225.3111.0230162.039.06.04.976790181FemaleAdult
46223.897.0224139.242.05.05.36681209FemaleAdult
50131.882.013669.255.02.04.077585136MaleAdult
69134.3113.0200123.854.04.04.7095112261MaleRetiredAdult
34126.387.0197120.063.03.04.248596113MaleAdult
71227.093.33269190.241.06.565.241793131FemaleRetiredAdult
47127.280.0208145.638.06.04.80492174MaleAdult
41133.8123.33187127.045.04.164.3175100257MaleAdult
34133.073.0178114.651.03.494.12719255MaleAdult
51124.187.0261175.669.04.04.40679384MaleAdult
43121.379.014178.853.03.03.82869042MaleAdult
55123.094.67190137.638.05.04.2767106146MaleRetiredAdult
59227.9101.0218144.238.06.05.187495212FemaleRetiredAdult
27233.6110.0246156.657.04.05.087689233FemaleAdult
51222.7103.0217162.430.07.04.81228091FemaleAdult
49227.489.0177113.037.05.04.905397111FemaleAdult
27122.671.011643.456.02.04.418879152MaleAdult
57223.2107.33231159.441.05.635.0304112120FemaleRetiredAdult
39226.993.013675.448.03.04.14319967FemaleAdult
62234.6120.0215129.243.05.05.366123310FemaleRetiredAdult
37123.388.0223142.065.03.44.35678294MaleAdult
46121.180.0205144.442.05.04.532687183MaleAdult
68223.5101.016285.459.03.04.47739166FemaleRetiredAdult
51131.593.0231144.049.04.75.2523117173MaleAdult
41120.886.0223128.283.03.04.07758972MaleAdult
53126.597.0193122.458.03.04.14319949MaleAdult
45124.283.0177118.445.04.04.21958264MaleAdult
33119.580.017185.475.02.03.97038048MaleAdult
60228.2112.0185113.842.04.04.983693178FemaleRetiredAdult
47224.975.0225166.042.05.04.4427102104FemaleAdult
60224.999.67162106.643.03.774.127195132FemaleRetiredAdult
36130.095.0201125.242.04.795.129985220MaleAdult
36119.671.0250133.297.03.04.59519257MaleAdult
" ] }, "metadata": { "application/vnd.databricks.v1+output": { "addedWidgets": {}, "aggData": [], "aggError": "", "aggOverflow": false, "aggSchema": [], "aggSeriesLimitReached": false, "aggType": "", "arguments": {}, "columnCustomDisplayInfos": {}, "data": [ [ 59, 2, 32.1, 101.0, 157, 93.2, 38.0, 4.0, 4.8598, 87, 151, "Female", "RetiredAdult" ], [ 48, 1, 21.6, 87.0, 183, 103.2, 70.0, 3.0, 3.8918, 69, 75, "Male", "Adult" ], [ 72, 2, 30.5, 93.0, 156, 93.6, 41.0, 4.0, 4.6728, 85, 141, "Female", "RetiredAdult" ], [ 24, 1, 25.3, 84.0, 198, 131.4, 40.0, 5.0, 4.8903, 89, 206, "Male", "Adult" ], [ 50, 1, 23.0, 101.0, 192, 125.4, 52.0, 4.0, 4.2905, 80, 135, "Male", "Adult" ], [ 23, 1, 22.6, 89.0, 139, 64.8, 61.0, 2.0, 4.1897, 68, 97, "Male", "Adult" ], [ 36, 2, 22.0, 90.0, 160, 99.6, 50.0, 3.0, 3.9512, 82, 138, "Female", "Adult" ], [ 66, 2, 26.2, 114.0, 255, 185.0, 56.0, 4.55, 4.2485, 92, 63, "Female", "RetiredAdult" ], [ 60, 2, 32.1, 83.0, 179, 119.4, 42.0, 4.0, 4.4773, 94, 110, "Female", "RetiredAdult" ], [ 29, 1, 30.0, 85.0, 180, 93.4, 43.0, 4.0, 5.3845, 88, 310, "Male", "Adult" ], [ 22, 1, 18.6, 97.0, 114, 57.6, 46.0, 2.0, 3.9512, 83, 101, "Male", "Adult" ], [ 56, 2, 28.0, 85.0, 184, 144.8, 32.0, 6.0, 3.5835, 77, 69, "Female", "RetiredAdult" ], [ 53, 1, 23.7, 92.0, 186, 109.2, 62.0, 3.0, 4.3041, 81, 179, "Male", "Adult" ], [ 50, 2, 26.2, 97.0, 186, 105.4, 49.0, 4.0, 5.0626, 88, 185, "Female", "Adult" ], [ 61, 1, 24.0, 91.0, 202, 115.4, 72.0, 3.0, 4.2905, 73, 118, "Male", "RetiredAdult" ], [ 34, 2, 24.7, 118.0, 254, 184.2, 39.0, 7.0, 5.037, 81, 171, "Female", "Adult" ], [ 47, 1, 30.3, 109.0, 207, 100.2, 70.0, 3.0, 5.2149, 98, 166, "Male", "Adult" ], [ 68, 2, 27.5, 111.0, 214, 147.0, 39.0, 5.0, 4.9416, 91, 144, "Female", "RetiredAdult" ], [ 38, 1, 25.4, 84.0, 162, 103.0, 42.0, 4.0, 4.4427, 87, 97, "Male", "Adult" ], [ 41, 1, 24.7, 83.0, 187, 108.2, 60.0, 3.0, 4.5433, 78, 168, "Male", "Adult" ], [ 35, 1, 21.1, 82.0, 156, 87.8, 50.0, 3.0, 4.5109, 95, 68, "Male", "Adult" ], [ 25, 2, 24.3, 95.0, 162, 98.6, 54.0, 3.0, 3.8501, 87, 49, "Female", "Adult" ], [ 25, 1, 26.0, 92.0, 187, 120.4, 56.0, 3.0, 3.9703, 88, 68, "Male", "Adult" ], [ 61, 2, 32.0, 103.67, 210, 85.2, 35.0, 6.0, 6.107, 124, 245, "Female", "RetiredAdult" ], [ 31, 1, 29.7, 88.0, 167, 103.4, 48.0, 4.0, 4.3567, 78, 184, "Male", "Adult" ], [ 30, 2, 25.2, 83.0, 178, 118.4, 34.0, 5.0, 4.852, 83, 202, "Female", "Adult" ], [ 19, 1, 19.2, 87.0, 124, 54.0, 57.0, 2.0, 4.1744, 90, 137, "Male", "YoungAdult" ], [ 42, 1, 31.9, 83.0, 158, 87.6, 53.0, 3.0, 4.4659, 101, 85, "Male", "Adult" ], [ 63, 1, 24.4, 73.0, 160, 91.4, 48.0, 3.0, 4.6347, 78, 131, "Male", "RetiredAdult" ], [ 67, 2, 25.8, 113.0, 158, 54.2, 64.0, 2.0, 5.2933, 104, 283, "Female", "RetiredAdult" ], [ 32, 1, 30.5, 89.0, 182, 110.6, 56.0, 3.0, 4.3438, 89, 129, "Male", "Adult" ], [ 42, 1, 20.3, 71.0, 161, 81.2, 66.0, 2.0, 4.2341, 81, 59, "Male", "Adult" ], [ 58, 2, 38.0, 103.0, 150, 107.2, 22.0, 7.0, 4.6444, 98, 341, "Female", "RetiredAdult" ], [ 57, 1, 21.7, 94.0, 157, 58.0, 82.0, 2.0, 4.4427, 92, 87, "Male", "RetiredAdult" ], [ 53, 1, 20.5, 78.0, 147, 84.2, 52.0, 3.0, 3.989, 75, 65, "Male", "Adult" ], [ 62, 2, 23.5, 80.33, 225, 112.8, 86.0, 2.62, 4.8752, 96, 102, "Female", "RetiredAdult" ], [ 52, 1, 28.5, 110.0, 195, 97.2, 60.0, 3.0, 5.2417, 85, 265, "Male", "Adult" ], [ 46, 1, 27.4, 78.0, 171, 88.0, 58.0, 3.0, 4.8283, 90, 276, "Male", "Adult" ], [ 48, 2, 33.0, 123.0, 253, 163.6, 44.0, 6.0, 5.425, 97, 252, "Female", "Adult" ], [ 48, 2, 27.7, 73.0, 191, 119.4, 46.0, 4.0, 4.852, 92, 90, "Female", "Adult" ], [ 50, 2, 25.6, 101.0, 229, 162.2, 43.0, 5.0, 4.7791, 114, 100, "Female", "Adult" ], [ 21, 1, 20.1, 63.0, 135, 69.0, 54.0, 3.0, 4.0943, 89, 55, "Male", "Adult" ], [ 32, 2, 25.4, 90.33, 153, 100.4, 34.0, 4.5, 4.5326, 83, 61, "Female", "Adult" ], [ 54, 1, 24.2, 74.0, 204, 109.0, 82.0, 2.0, 4.1744, 109, 92, "Male", "Adult" ], [ 61, 2, 32.7, 97.0, 177, 118.4, 29.0, 6.0, 4.9972, 87, 259, "Female", "RetiredAdult" ], [ 56, 2, 23.1, 104.0, 181, 116.4, 47.0, 4.0, 4.4773, 79, 53, "Female", "RetiredAdult" ], [ 33, 1, 25.3, 85.0, 155, 85.0, 51.0, 3.0, 4.5539, 70, 190, "Male", "Adult" ], [ 27, 1, 19.6, 78.0, 128, 68.0, 43.0, 3.0, 4.4427, 71, 142, "Male", "Adult" ], [ 67, 2, 22.5, 98.0, 191, 119.2, 61.0, 3.0, 3.989, 86, 75, "Female", "RetiredAdult" ], [ 37, 2, 27.7, 93.0, 180, 119.4, 30.0, 6.0, 5.0304, 88, 142, "Female", "Adult" ], [ 58, 1, 25.7, 99.0, 157, 91.6, 49.0, 3.0, 4.4067, 93, 155, "Male", "RetiredAdult" ], [ 65, 2, 27.9, 103.0, 159, 96.8, 42.0, 4.0, 4.6151, 86, 225, "Female", "RetiredAdult" ], [ 34, 1, 25.5, 93.0, 218, 144.0, 57.0, 4.0, 4.4427, 88, 59, "Male", "Adult" ], [ 46, 1, 24.9, 115.0, 198, 129.6, 54.0, 4.0, 4.2767, 103, 104, "Male", "Adult" ], [ 35, 1, 28.7, 97.0, 204, 126.8, 64.0, 3.0, 4.1897, 93, 182, "Male", "Adult" ], [ 37, 1, 21.8, 84.0, 184, 101.0, 73.0, 3.0, 3.912, 93, 128, "Male", "Adult" ], [ 37, 1, 30.2, 87.0, 166, 96.0, 40.0, 4.15, 5.0106, 87, 52, "Male", "Adult" ], [ 41, 1, 20.5, 80.0, 124, 48.8, 64.0, 2.0, 4.0254, 75, 37, "Male", "Adult" ], [ 60, 1, 20.4, 105.0, 198, 78.4, 99.0, 2.0, 4.6347, 79, 170, "Male", "RetiredAdult" ], [ 66, 2, 24.0, 98.0, 236, 146.4, 58.0, 4.0, 5.0626, 96, 170, "Female", "RetiredAdult" ], [ 29, 1, 26.0, 83.0, 141, 65.2, 64.0, 2.0, 4.0775, 83, 61, "Male", "Adult" ], [ 37, 2, 26.8, 79.0, 157, 98.0, 28.0, 6.0, 5.0434, 96, 144, "Female", "Adult" ], [ 41, 2, 25.7, 83.0, 181, 106.6, 66.0, 3.0, 3.7377, 85, 52, "Female", "Adult" ], [ 39, 1, 22.9, 77.0, 204, 143.2, 46.0, 4.0, 4.3041, 74, 128, "Male", "Adult" ], [ 67, 2, 24.0, 83.0, 143, 77.2, 49.0, 3.0, 4.4308, 94, 71, "Female", "RetiredAdult" ], [ 36, 2, 24.1, 112.0, 193, 125.0, 35.0, 6.0, 5.1059, 95, 163, "Female", "Adult" ], [ 46, 2, 24.7, 85.0, 174, 123.2, 30.0, 6.0, 4.6444, 96, 150, "Female", "Adult" ], [ 60, 2, 25.0, 89.67, 185, 120.8, 46.0, 4.02, 4.5109, 92, 97, "Female", "RetiredAdult" ], [ 59, 2, 23.6, 83.0, 165, 100.0, 47.0, 4.0, 4.4998, 92, 160, "Female", "RetiredAdult" ], [ 53, 1, 22.1, 93.0, 134, 76.2, 46.0, 3.0, 4.0775, 96, 178, "Male", "Adult" ], [ 48, 1, 19.9, 91.0, 189, 109.6, 69.0, 3.0, 3.9512, 101, 48, "Male", "Adult" ], [ 48, 1, 29.5, 131.0, 207, 132.2, 47.0, 4.0, 4.9345, 106, 270, "Male", "Adult" ], [ 66, 2, 26.0, 91.0, 264, 146.6, 65.0, 4.0, 5.5683, 87, 202, "Female", "RetiredAdult" ], [ 52, 2, 24.5, 94.0, 217, 149.4, 48.0, 5.0, 4.585, 89, 111, "Female", "Adult" ], [ 52, 2, 26.6, 111.0, 209, 126.4, 61.0, 3.0, 4.6821, 109, 85, "Female", "Adult" ], [ 46, 2, 23.5, 87.0, 181, 114.8, 44.0, 4.0, 4.7095, 98, 42, "Female", "Adult" ], [ 40, 2, 29.0, 115.0, 97, 47.2, 35.0, 2.77, 4.3041, 95, 170, "Female", "Adult" ], [ 22, 1, 23.0, 73.0, 161, 97.8, 54.0, 3.0, 3.8286, 91, 200, "Male", "Adult" ], [ 50, 1, 21.0, 88.0, 140, 71.8, 35.0, 4.0, 5.112, 71, 252, "Male", "Adult" ], [ 20, 1, 22.9, 87.0, 191, 128.2, 53.0, 4.0, 3.8918, 85, 113, "Male", "YoungAdult" ], [ 68, 1, 27.5, 107.0, 241, 149.6, 64.0, 4.0, 4.92, 90, 143, "Male", "RetiredAdult" ], [ 52, 2, 24.3, 86.0, 197, 133.6, 44.0, 5.0, 4.5747, 91, 51, "Female", "Adult" ], [ 44, 1, 23.1, 87.0, 213, 126.4, 77.0, 3.0, 3.8712, 72, 52, "Male", "Adult" ], [ 38, 1, 27.3, 81.0, 146, 81.6, 47.0, 3.0, 4.4659, 81, 210, "Male", "Adult" ], [ 49, 1, 22.7, 65.33, 168, 96.2, 62.0, 2.71, 3.8918, 60, 65, "Male", "Adult" ], [ 61, 1, 33.0, 95.0, 182, 114.8, 54.0, 3.0, 4.1897, 74, 141, "Male", "RetiredAdult" ], [ 29, 2, 19.4, 83.0, 152, 105.8, 39.0, 4.0, 3.5835, 83, 55, "Female", "Adult" ], [ 61, 1, 25.8, 98.0, 235, 125.8, 76.0, 3.0, 5.112, 82, 134, "Male", "RetiredAdult" ], [ 34, 2, 22.6, 75.0, 166, 91.8, 60.0, 3.0, 4.2627, 108, 42, "Female", "Adult" ], [ 36, 1, 21.9, 89.0, 189, 105.2, 68.0, 3.0, 4.3694, 96, 111, "Male", "Adult" ], [ 52, 1, 24.0, 83.0, 167, 86.6, 71.0, 2.0, 3.8501, 94, 98, "Male", "Adult" ], [ 61, 1, 31.2, 79.0, 235, 156.8, 47.0, 5.0, 5.0499, 96, 164, "Male", "RetiredAdult" ], [ 43, 1, 26.8, 123.0, 193, 102.2, 67.0, 3.0, 4.7791, 94, 48, "Male", "Adult" ], [ 35, 1, 20.4, 65.0, 187, 105.6, 67.0, 2.79, 4.2767, 78, 96, "Male", "Adult" ], [ 27, 1, 24.8, 91.0, 189, 106.8, 69.0, 3.0, 4.1897, 69, 90, "Male", "Adult" ], [ 29, 1, 21.0, 71.0, 156, 97.0, 38.0, 4.0, 4.654, 90, 162, "Male", "Adult" ], [ 64, 2, 27.3, 109.0, 186, 107.6, 38.0, 5.0, 5.3083, 99, 150, "Female", "RetiredAdult" ], [ 41, 1, 34.6, 87.33, 205, 142.6, 41.0, 5.0, 4.6728, 110, 279, "Male", "Adult" ], [ 49, 2, 25.9, 91.0, 178, 106.6, 52.0, 3.0, 4.5747, 75, 92, "Female", "Adult" ], [ 48, 1, 20.4, 98.0, 209, 139.4, 46.0, 5.0, 4.7707, 78, 83, "Male", "Adult" ], [ 53, 1, 28.0, 88.0, 233, 143.8, 58.0, 4.0, 5.0499, 91, 128, "Male", "Adult" ], [ 53, 2, 22.2, 113.0, 197, 115.2, 67.0, 3.0, 4.3041, 100, 102, "Female", "Adult" ], [ 23, 1, 29.0, 90.0, 216, 131.4, 65.0, 3.0, 4.585, 91, 302, "Male", "Adult" ], [ 65, 2, 30.2, 98.0, 219, 160.6, 40.0, 5.0, 4.5218, 84, 198, "Female", "RetiredAdult" ], [ 41, 1, 32.4, 94.0, 171, 104.4, 56.0, 3.0, 3.9703, 76, 95, "Male", "Adult" ], [ 55, 2, 23.4, 83.0, 166, 101.6, 46.0, 4.0, 4.5218, 96, 53, "Female", "RetiredAdult" ], [ 22, 1, 19.3, 82.0, 156, 93.2, 52.0, 3.0, 3.989, 71, 134, "Male", "Adult" ], [ 56, 1, 31.0, 78.67, 187, 141.4, 34.0, 5.5, 4.0604, 90, 144, "Male", "RetiredAdult" ], [ 54, 2, 30.6, 103.33, 144, 79.8, 30.0, 4.8, 5.1417, 101, 232, "Female", "Adult" ], [ 59, 2, 25.5, 95.33, 190, 139.4, 35.0, 5.43, 4.3567, 117, 81, "Female", "RetiredAdult" ], [ 60, 2, 23.4, 88.0, 153, 89.8, 58.0, 3.0, 3.2581, 95, 104, "Female", "RetiredAdult" ], [ 54, 1, 26.8, 87.0, 206, 122.0, 68.0, 3.0, 4.382, 80, 59, "Male", "Adult" ], [ 25, 1, 28.3, 87.0, 193, 128.0, 49.0, 4.0, 4.382, 92, 246, "Male", "Adult" ], [ 54, 2, 27.7, 113.0, 200, 128.4, 37.0, 5.0, 5.1533, 113, 297, "Female", "Adult" ], [ 55, 1, 36.6, 113.0, 199, 94.4, 43.0, 4.63, 5.7301, 97, 258, "Male", "RetiredAdult" ], [ 40, 2, 26.5, 93.0, 236, 147.0, 37.0, 7.0, 5.5607, 92, 229, "Female", "Adult" ], [ 62, 2, 31.8, 115.0, 199, 128.6, 44.0, 5.0, 4.8828, 98, 275, "Female", "RetiredAdult" ], [ 65, 1, 24.4, 120.0, 222, 135.6, 37.0, 6.0, 5.5094, 124, 281, "Male", "RetiredAdult" ], [ 33, 2, 25.4, 102.0, 206, 141.0, 39.0, 5.0, 4.8675, 105, 179, "Female", "Adult" ], [ 53, 1, 22.0, 94.0, 175, 88.0, 59.0, 3.0, 4.9416, 98, 200, "Male", "Adult" ], [ 35, 1, 26.8, 98.0, 162, 103.6, 45.0, 4.0, 4.2047, 86, 200, "Male", "Adult" ], [ 66, 1, 28.0, 101.0, 195, 129.2, 40.0, 5.0, 4.8598, 94, 173, "Male", "RetiredAdult" ], [ 62, 2, 33.9, 101.0, 221, 156.4, 35.0, 6.0, 4.9972, 103, 180, "Female", "RetiredAdult" ], [ 50, 2, 29.6, 94.33, 300, 242.4, 33.0, 9.09, 4.8122, 109, 84, "Female", "Adult" ], [ 47, 1, 28.6, 97.0, 164, 90.6, 56.0, 3.0, 4.4659, 88, 121, "Male", "Adult" ], [ 47, 2, 25.6, 94.0, 165, 74.8, 40.0, 4.0, 5.5255, 93, 161, "Female", "Adult" ], [ 24, 1, 20.7, 87.0, 149, 80.6, 61.0, 2.0, 3.6109, 78, 99, "Male", "Adult" ], [ 58, 2, 26.2, 91.0, 217, 124.2, 71.0, 3.0, 4.6913, 68, 109, "Female", "RetiredAdult" ], [ 34, 1, 20.6, 87.0, 185, 112.2, 58.0, 3.0, 4.3041, 74, 115, "Male", "Adult" ], [ 51, 1, 27.9, 96.0, 196, 122.2, 42.0, 5.0, 5.0689, 120, 268, "Male", "Adult" ], [ 31, 2, 35.3, 125.0, 187, 112.4, 48.0, 4.0, 4.8903, 109, 274, "Female", "Adult" ], [ 22, 1, 19.9, 75.0, 175, 108.6, 54.0, 3.0, 4.1271, 72, 158, "Male", "Adult" ], [ 53, 2, 24.4, 92.0, 214, 146.0, 50.0, 4.0, 4.4998, 97, 107, "Female", "Adult" ], [ 37, 2, 21.4, 83.0, 128, 69.6, 49.0, 3.0, 3.8501, 84, 83, "Female", "Adult" ], [ 28, 1, 30.4, 85.0, 198, 115.6, 67.0, 3.0, 4.3438, 80, 103, "Male", "Adult" ], [ 47, 1, 31.6, 84.0, 154, 88.0, 30.0, 5.1, 5.1985, 105, 272, "Male", "Adult" ], [ 23, 1, 18.8, 78.0, 145, 72.0, 63.0, 2.0, 3.912, 86, 85, "Male", "Adult" ], [ 50, 1, 31.0, 123.0, 178, 105.0, 48.0, 4.0, 4.8283, 88, 280, "Male", "Adult" ], [ 58, 2, 36.7, 117.0, 166, 93.8, 44.0, 4.0, 4.9488, 109, 336, "Female", "RetiredAdult" ], [ 55, 1, 32.1, 110.0, 164, 84.2, 42.0, 4.0, 5.2417, 90, 281, "Male", "RetiredAdult" ], [ 60, 2, 27.7, 107.0, 167, 114.6, 38.0, 4.0, 4.2767, 95, 118, "Female", "RetiredAdult" ], [ 41, 1, 30.8, 81.0, 214, 152.0, 28.0, 7.6, 5.1358, 123, 317, "Male", "Adult" ], [ 60, 2, 27.5, 106.0, 229, 143.8, 51.0, 4.0, 5.1417, 91, 235, "Female", "RetiredAdult" ], [ 40, 1, 26.9, 92.0, 203, 119.8, 70.0, 3.0, 4.1897, 81, 60, "Male", "Adult" ], [ 57, 2, 30.7, 90.0, 204, 147.8, 34.0, 6.0, 4.7095, 93, 174, "Female", "RetiredAdult" ], [ 37, 1, 38.3, 113.0, 165, 94.6, 53.0, 3.0, 4.4659, 79, 259, "Male", "Adult" ], [ 40, 2, 31.9, 95.0, 198, 135.6, 38.0, 5.0, 4.804, 93, 178, "Female", "Adult" ], [ 33, 1, 35.0, 89.0, 200, 130.4, 42.0, 4.76, 4.9273, 101, 128, "Male", "Adult" ], [ 32, 2, 27.8, 89.0, 216, 146.2, 55.0, 4.0, 4.3041, 91, 96, "Female", "Adult" ], [ 35, 2, 25.9, 81.0, 174, 102.4, 31.0, 6.0, 5.3132, 82, 126, "Female", "Adult" ], [ 55, 1, 32.9, 102.0, 164, 106.2, 41.0, 4.0, 4.4308, 89, 288, "Male", "RetiredAdult" ], [ 49, 1, 26.0, 93.0, 183, 100.2, 64.0, 3.0, 4.5433, 88, 88, "Male", "Adult" ], [ 39, 2, 26.3, 115.0, 218, 158.2, 32.0, 7.0, 4.9345, 109, 292, "Female", "Adult" ], [ 60, 2, 22.3, 113.0, 186, 125.8, 46.0, 4.0, 4.2627, 94, 71, "Female", "RetiredAdult" ], [ 67, 2, 28.3, 93.0, 204, 132.2, 49.0, 4.0, 4.7362, 92, 197, "Female", "RetiredAdult" ], [ 41, 2, 32.0, 109.0, 251, 170.6, 49.0, 5.0, 5.0562, 103, 186, "Female", "Adult" ], [ 44, 1, 25.4, 95.0, 162, 92.6, 53.0, 3.0, 4.4067, 83, 25, "Male", "Adult" ], [ 48, 2, 23.3, 89.33, 212, 142.8, 46.0, 4.61, 4.7536, 98, 84, "Female", "Adult" ], [ 45, 1, 20.3, 74.33, 190, 126.2, 49.0, 3.88, 4.3041, 79, 96, "Male", "Adult" ], [ 47, 1, 30.4, 120.0, 199, 120.0, 46.0, 4.0, 5.1059, 87, 195, "Male", "Adult" ], [ 46, 1, 20.6, 73.0, 172, 107.0, 51.0, 3.0, 4.2485, 80, 53, "Male", "Adult" ], [ 36, 2, 32.3, 115.0, 286, 199.4, 39.0, 7.0, 5.4723, 112, 217, "Female", "Adult" ], [ 34, 1, 29.2, 73.0, 172, 108.2, 49.0, 4.0, 4.3041, 91, 172, "Male", "Adult" ], [ 53, 2, 33.1, 117.0, 183, 119.0, 48.0, 4.0, 4.382, 106, 131, "Female", "Adult" ], [ 61, 1, 24.6, 101.0, 209, 106.8, 77.0, 3.0, 4.8363, 88, 214, "Male", "RetiredAdult" ], [ 37, 1, 20.2, 81.0, 162, 87.8, 63.0, 3.0, 4.0254, 88, 59, "Male", "Adult" ], [ 33, 2, 20.8, 84.0, 125, 70.2, 46.0, 3.0, 3.7842, 66, 70, "Female", "Adult" ], [ 68, 1, 32.8, 105.67, 205, 116.4, 40.0, 5.13, 5.4931, 117, 220, "Male", "RetiredAdult" ], [ 49, 2, 31.9, 94.0, 234, 155.8, 34.0, 7.0, 5.3982, 122, 268, "Female", "Adult" ], [ 48, 1, 23.9, 109.0, 232, 105.2, 37.0, 6.0, 6.107, 96, 152, "Male", "Adult" ], [ 55, 2, 24.5, 84.0, 179, 105.8, 66.0, 3.0, 3.5835, 87, 47, "Female", "RetiredAdult" ], [ 43, 1, 22.1, 66.0, 134, 77.2, 45.0, 3.0, 4.0775, 80, 74, "Male", "Adult" ], [ 60, 2, 33.0, 97.0, 217, 125.6, 45.0, 5.0, 5.4467, 112, 295, "Female", "RetiredAdult" ], [ 31, 2, 19.0, 93.0, 137, 73.0, 47.0, 3.0, 4.4427, 78, 101, "Female", "Adult" ], [ 53, 2, 27.3, 82.0, 119, 55.0, 39.0, 3.0, 4.8283, 93, 151, "Female", "Adult" ], [ 67, 1, 22.8, 87.0, 166, 98.6, 52.0, 3.0, 4.3438, 92, 127, "Male", "RetiredAdult" ], [ 61, 2, 28.2, 106.0, 204, 132.0, 52.0, 4.0, 4.6052, 96, 237, "Female", "RetiredAdult" ], [ 62, 1, 28.9, 87.33, 206, 127.2, 33.0, 6.24, 5.4337, 99, 225, "Male", "RetiredAdult" ], [ 60, 1, 25.6, 87.0, 207, 125.8, 69.0, 3.0, 4.1109, 84, 81, "Male", "RetiredAdult" ], [ 42, 1, 24.9, 91.0, 204, 141.8, 38.0, 5.0, 4.7958, 89, 151, "Male", "Adult" ], [ 38, 2, 26.8, 105.0, 181, 119.2, 37.0, 5.0, 4.8203, 91, 107, "Female", "Adult" ], [ 62, 1, 22.4, 79.0, 222, 147.4, 59.0, 4.0, 4.3567, 76, 64, "Male", "RetiredAdult" ], [ 61, 2, 26.9, 111.0, 236, 172.4, 39.0, 6.0, 4.8122, 89, 138, "Female", "RetiredAdult" ], [ 61, 2, 23.1, 113.0, 186, 114.4, 47.0, 4.0, 4.8122, 105, 185, "Female", "RetiredAdult" ], [ 53, 1, 28.6, 88.0, 171, 98.8, 41.0, 4.0, 5.0499, 99, 265, "Male", "Adult" ], [ 28, 2, 24.7, 97.0, 175, 99.6, 32.0, 5.0, 5.3799, 87, 101, "Female", "Adult" ], [ 26, 2, 30.3, 89.0, 218, 152.2, 31.0, 7.0, 5.1591, 82, 137, "Female", "Adult" ], [ 30, 1, 21.3, 87.0, 134, 63.0, 63.0, 2.0, 3.6889, 66, 143, "Male", "Adult" ], [ 50, 1, 26.1, 109.0, 243, 160.6, 62.0, 4.0, 4.625, 89, 141, "Male", "Adult" ], [ 48, 1, 20.2, 95.0, 187, 117.4, 53.0, 4.0, 4.4188, 85, 79, "Male", "Adult" ], [ 51, 1, 25.2, 103.0, 176, 112.2, 37.0, 5.0, 4.8978, 90, 292, "Male", "Adult" ], [ 47, 2, 22.5, 82.0, 131, 66.8, 41.0, 3.0, 4.7536, 89, 178, "Female", "Adult" ], [ 64, 2, 23.5, 97.0, 203, 129.0, 59.0, 3.0, 4.3175, 77, 91, "Female", "RetiredAdult" ], [ 51, 2, 25.9, 76.0, 240, 169.0, 39.0, 6.0, 5.0752, 96, 116, "Female", "Adult" ], [ 30, 1, 20.9, 104.0, 152, 83.8, 47.0, 3.0, 4.6634, 97, 86, "Male", "Adult" ], [ 56, 2, 28.7, 99.0, 208, 146.4, 39.0, 5.0, 4.7274, 97, 122, "Female", "RetiredAdult" ], [ 42, 1, 22.1, 85.0, 213, 138.6, 60.0, 4.0, 4.2767, 94, 72, "Male", "Adult" ], [ 62, 2, 26.7, 115.0, 183, 124.0, 35.0, 5.0, 4.7875, 100, 129, "Female", "RetiredAdult" ], [ 34, 1, 31.4, 87.0, 149, 93.8, 46.0, 3.0, 3.8286, 77, 142, "Male", "Adult" ], [ 60, 1, 22.2, 104.67, 221, 105.4, 60.0, 3.68, 5.6276, 93, 90, "Male", "RetiredAdult" ], [ 64, 1, 21.0, 92.33, 227, 146.8, 65.0, 3.49, 4.3307, 102, 158, "Male", "RetiredAdult" ], [ 39, 2, 21.2, 90.0, 182, 110.4, 60.0, 3.0, 4.0604, 98, 39, "Female", "Adult" ], [ 71, 2, 26.5, 105.0, 281, 173.6, 55.0, 5.0, 5.5683, 84, 196, "Female", "RetiredAdult" ], [ 48, 2, 29.2, 110.0, 218, 151.6, 39.0, 6.0, 4.92, 98, 222, "Female", "Adult" ], [ 79, 2, 27.0, 103.0, 169, 110.8, 37.0, 5.0, 4.6634, 110, 277, "Female", "RetiredAdult" ], [ 40, 1, 30.7, 99.0, 177, 85.4, 50.0, 4.0, 5.3375, 85, 99, "Male", "Adult" ], [ 49, 2, 28.8, 92.0, 207, 140.0, 44.0, 5.0, 4.7449, 92, 196, "Female", "Adult" ], [ 51, 1, 30.6, 103.0, 198, 106.6, 57.0, 3.0, 5.1475, 100, 202, "Male", "Adult" ], [ 57, 1, 30.1, 117.0, 202, 139.6, 42.0, 5.0, 4.625, 120, 155, "Male", "RetiredAdult" ], [ 59, 2, 24.7, 114.0, 152, 104.8, 29.0, 5.0, 4.5109, 88, 77, "Female", "RetiredAdult" ], [ 51, 1, 27.7, 99.0, 229, 145.6, 69.0, 3.0, 4.2767, 77, 191, "Male", "Adult" ], [ 74, 1, 29.8, 101.0, 171, 104.8, 50.0, 3.0, 4.3944, 86, 70, "Male", "RetiredAdult" ], [ 67, 1, 26.7, 105.0, 225, 135.4, 69.0, 3.0, 4.6347, 96, 73, "Male", "RetiredAdult" ], [ 49, 1, 19.8, 88.0, 188, 114.8, 57.0, 3.0, 4.3944, 93, 49, "Male", "Adult" ], [ 57, 1, 23.3, 88.0, 155, 63.6, 78.0, 2.0, 4.2047, 78, 65, "Male", "RetiredAdult" ], [ 56, 2, 35.1, 123.0, 164, 95.0, 38.0, 4.0, 5.0434, 117, 263, "Female", "RetiredAdult" ], [ 52, 2, 29.7, 109.0, 228, 162.8, 31.0, 8.0, 5.1417, 103, 248, "Female", "Adult" ], [ 69, 1, 29.3, 124.0, 223, 139.0, 54.0, 4.0, 5.0106, 102, 296, "Male", "RetiredAdult" ], [ 37, 1, 20.3, 83.0, 185, 124.6, 38.0, 5.0, 4.7185, 88, 214, "Male", "Adult" ], [ 24, 1, 22.5, 89.0, 141, 68.0, 52.0, 3.0, 4.654, 84, 185, "Male", "Adult" ], [ 55, 2, 22.7, 93.0, 154, 94.2, 53.0, 3.0, 3.5264, 75, 78, "Female", "RetiredAdult" ], [ 36, 1, 22.8, 87.0, 178, 116.0, 41.0, 4.0, 4.654, 82, 93, "Male", "Adult" ], [ 42, 2, 24.0, 107.0, 150, 85.0, 44.0, 3.0, 4.654, 96, 252, "Female", "Adult" ], [ 21, 1, 24.2, 76.0, 147, 77.0, 53.0, 3.0, 4.4427, 79, 150, "Male", "Adult" ], [ 41, 1, 20.2, 62.0, 153, 89.0, 50.0, 3.0, 4.2485, 89, 77, "Male", "Adult" ], [ 57, 2, 29.4, 109.0, 160, 87.6, 31.0, 5.0, 5.3327, 92, 208, "Female", "RetiredAdult" ], [ 20, 2, 22.1, 87.0, 171, 99.6, 58.0, 3.0, 4.2047, 78, 77, "Female", "YoungAdult" ], [ 67, 2, 23.6, 111.33, 189, 105.4, 70.0, 2.7, 4.2195, 93, 108, "Female", "RetiredAdult" ], [ 34, 1, 25.2, 77.0, 189, 120.6, 53.0, 4.0, 4.3438, 79, 160, "Male", "Adult" ], [ 41, 2, 24.9, 86.0, 192, 115.0, 61.0, 3.0, 4.382, 94, 53, "Female", "Adult" ], [ 38, 2, 33.0, 78.0, 301, 215.0, 50.0, 6.02, 5.193, 108, 220, "Female", "Adult" ], [ 51, 1, 23.5, 101.0, 195, 121.0, 51.0, 4.0, 4.7449, 94, 154, "Male", "Adult" ], [ 52, 2, 26.4, 91.33, 218, 152.0, 39.0, 5.59, 4.9053, 99, 259, "Female", "Adult" ], [ 67, 1, 29.8, 80.0, 172, 93.4, 63.0, 3.0, 4.3567, 82, 90, "Male", "RetiredAdult" ], [ 61, 1, 30.0, 108.0, 194, 100.0, 52.0, 3.73, 5.3471, 105, 246, "Male", "RetiredAdult" ], [ 67, 2, 25.0, 111.67, 146, 93.4, 33.0, 4.42, 4.585, 103, 124, "Female", "RetiredAdult" ], [ 56, 1, 27.0, 105.0, 247, 160.6, 54.0, 5.0, 5.0876, 94, 67, "Male", "RetiredAdult" ], [ 64, 1, 20.0, 74.67, 189, 114.8, 62.0, 3.05, 4.1109, 91, 72, "Male", "RetiredAdult" ], [ 58, 2, 25.5, 112.0, 163, 110.6, 29.0, 6.0, 4.7622, 86, 257, "Female", "RetiredAdult" ], [ 55, 1, 28.2, 91.0, 250, 140.2, 67.0, 4.0, 5.366, 103, 262, "Male", "RetiredAdult" ], [ 62, 2, 33.3, 114.0, 182, 114.0, 38.0, 5.0, 5.0106, 96, 275, "Female", "RetiredAdult" ], [ 57, 2, 25.6, 96.0, 200, 133.0, 52.0, 3.85, 4.3175, 105, 177, "Female", "RetiredAdult" ], [ 20, 2, 24.2, 88.0, 126, 72.2, 45.0, 3.0, 3.7842, 74, 71, "Female", "YoungAdult" ], [ 53, 2, 22.1, 98.0, 165, 105.2, 47.0, 4.0, 4.1589, 81, 47, "Female", "Adult" ], [ 32, 2, 31.4, 89.0, 153, 84.2, 56.0, 3.0, 4.1589, 90, 187, "Female", "Adult" ], [ 41, 1, 23.1, 86.0, 148, 78.0, 58.0, 3.0, 4.0943, 60, 125, "Male", "Adult" ], [ 60, 1, 23.4, 76.67, 247, 148.0, 65.0, 3.8, 5.1358, 77, 78, "Male", "RetiredAdult" ], [ 26, 1, 18.8, 83.0, 191, 103.6, 69.0, 3.0, 4.5218, 69, 51, "Male", "Adult" ], [ 37, 1, 30.8, 112.0, 282, 197.2, 43.0, 7.0, 5.3423, 101, 258, "Male", "Adult" ], [ 45, 1, 32.0, 110.0, 224, 134.2, 45.0, 5.0, 5.4116, 93, 215, "Male", "Adult" ], [ 67, 1, 31.6, 116.0, 179, 90.4, 41.0, 4.0, 5.4723, 100, 303, "Male", "RetiredAdult" ], [ 34, 2, 35.5, 120.0, 233, 146.6, 34.0, 7.0, 5.5683, 101, 243, "Female", "Adult" ], [ 50, 1, 31.9, 78.33, 207, 149.2, 38.0, 5.45, 4.5951, 84, 91, "Male", "Adult" ], [ 71, 1, 29.5, 97.0, 227, 151.6, 45.0, 5.0, 5.0239, 108, 150, "Male", "RetiredAdult" ], [ 57, 2, 31.6, 117.0, 225, 107.6, 40.0, 6.0, 5.9584, 113, 310, "Female", "RetiredAdult" ], [ 49, 1, 20.3, 93.0, 184, 103.0, 61.0, 3.0, 4.6052, 93, 153, "Male", "Adult" ], [ 35, 1, 41.3, 81.0, 168, 102.8, 37.0, 5.0, 4.9488, 94, 346, "Male", "Adult" ], [ 41, 2, 21.2, 102.0, 184, 100.4, 64.0, 3.0, 4.585, 79, 63, "Female", "Adult" ], [ 70, 2, 24.1, 82.33, 194, 149.2, 31.0, 6.26, 4.2341, 105, 89, "Female", "RetiredAdult" ], [ 52, 1, 23.0, 107.0, 179, 123.7, 42.5, 4.21, 4.1589, 93, 50, "Male", "Adult" ], [ 60, 1, 25.6, 78.0, 195, 95.4, 91.0, 2.0, 3.7612, 87, 39, "Male", "RetiredAdult" ], [ 62, 1, 22.5, 125.0, 215, 99.0, 98.0, 2.0, 4.4998, 95, 103, "Male", "RetiredAdult" ], [ 44, 2, 38.2, 123.0, 201, 126.6, 44.0, 5.0, 5.0239, 92, 308, "Female", "Adult" ], [ 28, 2, 19.2, 81.0, 155, 94.6, 51.0, 3.0, 3.8501, 87, 116, "Female", "Adult" ], [ 58, 2, 29.0, 85.0, 156, 109.2, 36.0, 4.0, 3.989, 86, 145, "Female", "RetiredAdult" ], [ 39, 2, 24.0, 89.67, 190, 113.6, 52.0, 3.65, 4.804, 101, 74, "Female", "Adult" ], [ 34, 2, 20.6, 98.0, 183, 92.0, 83.0, 2.0, 3.6889, 92, 45, "Female", "Adult" ], [ 65, 1, 26.3, 70.0, 244, 166.2, 51.0, 5.0, 4.8978, 98, 115, "Male", "RetiredAdult" ], [ 66, 2, 34.6, 115.0, 204, 139.4, 36.0, 6.0, 4.9628, 109, 264, "Female", "RetiredAdult" ], [ 51, 1, 23.4, 87.0, 220, 108.8, 93.0, 2.0, 4.5109, 82, 87, "Male", "Adult" ], [ 50, 2, 29.2, 119.0, 162, 85.2, 54.0, 3.0, 4.7362, 95, 202, "Female", "Adult" ], [ 59, 2, 27.2, 107.0, 158, 102.0, 39.0, 4.0, 4.4427, 93, 127, "Female", "RetiredAdult" ], [ 52, 1, 27.0, 78.33, 134, 73.0, 44.0, 3.05, 4.4427, 69, 182, "Male", "Adult" ], [ 69, 2, 24.5, 108.0, 243, 136.4, 40.0, 6.0, 5.8081, 100, 241, "Female", "RetiredAdult" ], [ 53, 1, 24.1, 105.0, 184, 113.4, 46.0, 4.0, 4.8122, 95, 66, "Male", "Adult" ], [ 47, 2, 25.3, 98.0, 173, 105.6, 44.0, 4.0, 4.7622, 108, 94, "Female", "Adult" ], [ 52, 1, 28.8, 113.0, 280, 174.0, 67.0, 4.0, 5.273, 86, 283, "Male", "Adult" ], [ 39, 1, 20.9, 95.0, 150, 65.6, 68.0, 2.0, 4.4067, 95, 64, "Male", "Adult" ], [ 67, 2, 23.0, 70.0, 184, 128.0, 35.0, 5.0, 4.654, 99, 102, "Female", "RetiredAdult" ], [ 59, 2, 24.1, 96.0, 170, 98.6, 54.0, 3.0, 4.4659, 85, 200, "Female", "RetiredAdult" ], [ 51, 2, 28.1, 106.0, 202, 122.2, 55.0, 4.0, 4.8203, 87, 265, "Female", "Adult" ], [ 23, 2, 18.0, 78.0, 171, 96.0, 48.0, 4.0, 4.9053, 92, 94, "Female", "Adult" ], [ 68, 1, 25.9, 93.0, 253, 181.2, 53.0, 5.0, 4.5433, 98, 230, "Male", "RetiredAdult" ], [ 44, 1, 21.5, 85.0, 157, 92.2, 55.0, 3.0, 3.8918, 84, 181, "Male", "Adult" ], [ 60, 2, 24.3, 103.0, 141, 86.6, 33.0, 4.0, 4.6728, 78, 156, "Female", "RetiredAdult" ], [ 52, 1, 24.5, 90.0, 198, 129.0, 29.0, 7.0, 5.2983, 86, 233, "Male", "Adult" ], [ 38, 1, 21.3, 72.0, 165, 60.2, 88.0, 2.0, 4.4308, 90, 60, "Male", "Adult" ], [ 61, 1, 25.8, 90.0, 280, 195.4, 55.0, 5.0, 4.9972, 90, 219, "Male", "RetiredAdult" ], [ 68, 2, 24.8, 101.0, 221, 151.4, 60.0, 4.0, 3.8712, 87, 80, "Female", "RetiredAdult" ], [ 28, 2, 31.5, 83.0, 228, 149.4, 38.0, 6.0, 5.3132, 83, 68, "Female", "Adult" ], [ 65, 2, 33.5, 102.0, 190, 126.2, 35.0, 5.0, 4.9698, 102, 332, "Female", "RetiredAdult" ], [ 69, 1, 28.1, 113.0, 234, 142.8, 52.0, 4.0, 5.2781, 77, 248, "Male", "RetiredAdult" ], [ 51, 1, 24.3, 85.33, 153, 71.6, 71.0, 2.15, 3.9512, 82, 84, "Male", "Adult" ], [ 29, 1, 35.0, 98.33, 204, 142.6, 50.0, 4.08, 4.0431, 91, 200, "Male", "Adult" ], [ 55, 2, 23.5, 93.0, 177, 126.8, 41.0, 4.0, 3.8286, 83, 55, "Female", "RetiredAdult" ], [ 34, 2, 30.0, 83.0, 185, 107.2, 53.0, 3.0, 4.8203, 92, 85, "Female", "Adult" ], [ 67, 1, 20.7, 83.0, 170, 99.8, 59.0, 3.0, 4.0254, 77, 89, "Male", "RetiredAdult" ], [ 49, 1, 25.6, 76.0, 161, 99.8, 51.0, 3.0, 3.9318, 78, 31, "Male", "Adult" ], [ 55, 2, 22.9, 81.0, 123, 67.2, 41.0, 3.0, 4.3041, 88, 129, "Female", "RetiredAdult" ], [ 59, 2, 25.1, 90.0, 163, 101.4, 46.0, 4.0, 4.3567, 91, 83, "Female", "RetiredAdult" ], [ 53, 1, 33.2, 82.67, 186, 106.8, 46.0, 4.04, 5.112, 102, 275, "Male", "Adult" ], [ 48, 2, 24.1, 110.0, 209, 134.6, 58.0, 4.0, 4.4067, 100, 65, "Female", "Adult" ], [ 52, 1, 29.5, 104.33, 211, 132.8, 49.0, 4.31, 4.9836, 98, 198, "Male", "Adult" ], [ 69, 1, 29.6, 122.0, 231, 128.4, 56.0, 4.0, 5.451, 86, 236, "Male", "RetiredAdult" ], [ 60, 2, 22.8, 110.0, 245, 189.8, 39.0, 6.0, 4.3944, 88, 253, "Female", "RetiredAdult" ], [ 46, 2, 22.7, 83.0, 183, 125.8, 32.0, 6.0, 4.8363, 75, 124, "Female", "Adult" ], [ 51, 2, 26.2, 101.0, 161, 99.6, 48.0, 3.0, 4.2047, 88, 44, "Female", "Adult" ], [ 67, 2, 23.5, 96.0, 207, 138.2, 42.0, 5.0, 4.8978, 111, 172, "Female", "RetiredAdult" ], [ 49, 1, 22.1, 85.0, 136, 63.4, 62.0, 2.19, 3.9703, 72, 114, "Male", "Adult" ], [ 46, 2, 26.5, 94.0, 247, 160.2, 59.0, 4.0, 4.9345, 111, 142, "Female", "Adult" ], [ 47, 1, 32.4, 105.0, 188, 125.0, 46.0, 4.09, 4.4427, 99, 109, "Male", "Adult" ], [ 75, 1, 30.1, 78.0, 222, 154.2, 44.0, 5.05, 4.7791, 97, 180, "Male", "RetiredAdult" ], [ 28, 1, 24.2, 93.0, 174, 106.4, 54.0, 3.0, 4.2195, 84, 144, "Male", "Adult" ], [ 65, 2, 31.3, 110.0, 213, 128.0, 47.0, 5.0, 5.247, 91, 163, "Female", "RetiredAdult" ], [ 42, 1, 30.1, 91.0, 182, 114.8, 49.0, 4.0, 4.5109, 82, 147, "Male", "Adult" ], [ 51, 1, 24.5, 79.0, 212, 128.6, 65.0, 3.0, 4.5218, 91, 97, "Male", "Adult" ], [ 53, 2, 27.7, 95.0, 190, 101.8, 41.0, 5.0, 5.4638, 101, 220, "Female", "Adult" ], [ 54, 1, 23.2, 110.67, 238, 162.8, 48.0, 4.96, 4.9127, 108, 190, "Male", "Adult" ], [ 73, 1, 27.0, 102.0, 211, 121.0, 67.0, 3.0, 4.7449, 99, 109, "Male", "RetiredAdult" ], [ 54, 1, 26.8, 108.0, 176, 80.6, 67.0, 3.0, 4.9558, 106, 191, "Male", "Adult" ], [ 42, 1, 29.2, 93.0, 249, 174.2, 45.0, 6.0, 5.0039, 92, 122, "Male", "Adult" ], [ 75, 1, 31.2, 117.67, 229, 138.8, 29.0, 7.9, 5.7236, 106, 230, "Male", "RetiredAdult" ], [ 55, 2, 32.1, 112.67, 207, 92.4, 25.0, 8.28, 6.1048, 111, 242, "Female", "RetiredAdult" ], [ 68, 2, 25.7, 109.0, 233, 112.6, 35.0, 7.0, 6.0568, 105, 248, "Female", "RetiredAdult" ], [ 57, 1, 26.9, 98.0, 246, 165.2, 38.0, 7.0, 5.366, 96, 249, "Male", "RetiredAdult" ], [ 48, 1, 31.4, 75.33, 242, 151.6, 38.0, 6.37, 5.5683, 103, 192, "Male", "Adult" ], [ 61, 2, 25.6, 85.0, 184, 116.2, 39.0, 5.0, 4.9698, 98, 131, "Female", "RetiredAdult" ], [ 69, 1, 37.0, 103.0, 207, 131.4, 55.0, 4.0, 4.6347, 90, 237, "Male", "RetiredAdult" ], [ 38, 1, 32.6, 77.0, 168, 100.6, 47.0, 4.0, 4.625, 96, 78, "Male", "Adult" ], [ 45, 2, 21.2, 94.0, 169, 96.8, 55.0, 3.0, 4.4543, 102, 135, "Female", "Adult" ], [ 51, 2, 29.2, 107.0, 187, 139.0, 32.0, 6.0, 4.382, 95, 244, "Female", "Adult" ], [ 71, 2, 24.0, 84.0, 138, 85.8, 39.0, 4.0, 4.1897, 90, 199, "Female", "RetiredAdult" ], [ 57, 1, 36.1, 117.0, 181, 108.2, 34.0, 5.0, 5.2679, 100, 270, "Male", "RetiredAdult" ], [ 56, 2, 25.8, 103.0, 177, 114.4, 34.0, 5.0, 4.9628, 99, 164, "Female", "RetiredAdult" ], [ 32, 2, 22.0, 88.0, 137, 78.6, 48.0, 3.0, 3.9512, 78, 72, "Female", "Adult" ], [ 50, 1, 21.9, 91.0, 190, 111.2, 67.0, 3.0, 4.0775, 77, 96, "Male", "Adult" ], [ 43, 1, 34.3, 84.0, 256, 172.6, 33.0, 8.0, 5.5294, 104, 306, "Male", "Adult" ], [ 54, 2, 25.2, 115.0, 181, 120.0, 39.0, 5.0, 4.7005, 92, 91, "Female", "Adult" ], [ 31, 1, 23.3, 85.0, 190, 130.8, 43.0, 4.0, 4.3944, 77, 214, "Male", "Adult" ], [ 56, 1, 25.7, 80.0, 244, 151.6, 59.0, 4.0, 5.118, 95, 95, "Male", "RetiredAdult" ], [ 44, 1, 25.1, 133.0, 182, 113.0, 55.0, 3.0, 4.2485, 84, 216, "Male", "Adult" ], [ 57, 2, 31.9, 111.0, 173, 116.2, 41.0, 4.0, 4.3694, 87, 263, "Female", "RetiredAdult" ], [ 64, 2, 28.4, 111.0, 184, 127.0, 41.0, 4.0, 4.382, 97, 178, "Female", "RetiredAdult" ], [ 43, 1, 28.1, 121.0, 192, 121.0, 60.0, 3.0, 4.0073, 93, 113, "Male", "Adult" ], [ 19, 1, 25.3, 83.0, 225, 156.6, 46.0, 5.0, 4.7185, 84, 200, "Male", "YoungAdult" ], [ 71, 2, 26.1, 85.0, 220, 152.4, 47.0, 5.0, 4.6347, 91, 139, "Female", "RetiredAdult" ], [ 50, 2, 28.0, 104.0, 282, 196.8, 44.0, 6.0, 5.3279, 95, 139, "Female", "Adult" ], [ 59, 2, 23.6, 73.0, 180, 107.4, 51.0, 4.0, 4.6821, 84, 88, "Female", "RetiredAdult" ], [ 57, 1, 24.5, 93.0, 186, 96.6, 71.0, 3.0, 4.5218, 91, 148, "Male", "RetiredAdult" ], [ 49, 2, 21.0, 82.0, 119, 85.4, 23.0, 5.0, 3.9703, 74, 88, "Female", "Adult" ], [ 41, 2, 32.0, 126.0, 198, 104.2, 49.0, 4.0, 5.4116, 124, 243, "Female", "Adult" ], [ 25, 2, 22.6, 85.0, 130, 71.0, 48.0, 3.0, 4.0073, 81, 71, "Female", "Adult" ], [ 52, 2, 19.7, 81.0, 152, 53.4, 82.0, 2.0, 4.4188, 82, 77, "Female", "Adult" ], [ 34, 1, 21.2, 84.0, 254, 113.4, 52.0, 5.0, 6.0936, 92, 109, "Male", "Adult" ], [ 42, 2, 30.6, 101.0, 269, 172.2, 50.0, 5.0, 5.4553, 106, 272, "Female", "Adult" ], [ 28, 2, 25.5, 99.0, 162, 101.6, 46.0, 4.0, 4.2767, 94, 60, "Female", "Adult" ], [ 47, 2, 23.3, 90.0, 195, 125.8, 54.0, 4.0, 4.3307, 73, 54, "Female", "Adult" ], [ 32, 2, 31.0, 100.0, 177, 96.2, 45.0, 4.0, 5.1874, 77, 221, "Female", "Adult" ], [ 43, 1, 18.5, 87.0, 163, 93.6, 61.0, 2.67, 3.7377, 80, 90, "Male", "Adult" ], [ 59, 2, 26.9, 104.0, 194, 126.6, 43.0, 5.0, 4.804, 106, 311, "Female", "RetiredAdult" ], [ 53, 1, 28.3, 101.0, 179, 107.0, 48.0, 4.0, 4.7875, 101, 281, "Male", "Adult" ], [ 60, 1, 25.7, 103.0, 158, 84.6, 64.0, 2.0, 3.8501, 97, 182, "Male", "RetiredAdult" ], [ 54, 2, 36.1, 115.0, 163, 98.4, 43.0, 4.0, 4.6821, 101, 321, "Female", "Adult" ], [ 35, 2, 24.1, 94.67, 155, 97.4, 32.0, 4.84, 4.852, 94, 58, "Female", "Adult" ], [ 49, 2, 25.8, 89.0, 182, 118.6, 39.0, 5.0, 4.804, 115, 262, "Female", "Adult" ], [ 58, 1, 22.8, 91.0, 196, 118.8, 48.0, 4.0, 4.9836, 115, 206, "Male", "RetiredAdult" ], [ 36, 2, 39.1, 90.0, 219, 135.8, 38.0, 6.0, 5.4205, 103, 233, "Female", "Adult" ], [ 46, 2, 42.2, 99.0, 211, 137.0, 44.0, 5.0, 5.0106, 99, 242, "Female", "Adult" ], [ 44, 2, 26.6, 99.0, 205, 109.0, 43.0, 5.0, 5.5797, 111, 123, "Female", "Adult" ], [ 46, 1, 29.9, 83.0, 171, 113.0, 38.0, 4.5, 4.585, 98, 167, "Male", "Adult" ], [ 54, 1, 21.0, 78.0, 188, 107.4, 70.0, 3.0, 3.9703, 73, 63, "Male", "Adult" ], [ 63, 2, 25.5, 109.0, 226, 103.2, 46.0, 5.0, 5.9506, 87, 197, "Female", "RetiredAdult" ], [ 41, 2, 24.2, 90.0, 199, 123.6, 57.0, 4.0, 4.5218, 86, 71, "Female", "Adult" ], [ 28, 1, 25.4, 93.0, 141, 79.0, 49.0, 3.0, 4.1744, 91, 168, "Male", "Adult" ], [ 19, 1, 23.2, 75.0, 143, 70.4, 52.0, 3.0, 4.6347, 72, 140, "Male", "YoungAdult" ], [ 61, 2, 26.1, 126.0, 215, 129.8, 57.0, 4.0, 4.9488, 96, 217, "Female", "RetiredAdult" ], [ 48, 1, 32.7, 93.0, 276, 198.6, 43.0, 6.42, 5.1475, 91, 121, "Male", "Adult" ], [ 54, 2, 27.3, 100.0, 200, 144.0, 33.0, 6.0, 4.7449, 76, 235, "Female", "Adult" ], [ 53, 2, 26.6, 93.0, 185, 122.4, 36.0, 5.0, 4.8903, 82, 245, "Female", "Adult" ], [ 48, 1, 22.8, 101.0, 110, 41.6, 56.0, 2.0, 4.1271, 97, 40, "Male", "Adult" ], [ 53, 1, 28.8, 111.67, 145, 87.2, 46.0, 3.15, 4.0775, 85, 52, "Male", "Adult" ], [ 29, 2, 18.1, 73.0, 158, 99.0, 41.0, 4.0, 4.4998, 78, 104, "Female", "Adult" ], [ 62, 1, 32.0, 88.0, 172, 69.0, 38.0, 4.0, 5.7838, 100, 132, "Male", "RetiredAdult" ], [ 50, 2, 23.7, 92.0, 166, 97.0, 52.0, 3.0, 4.4427, 93, 88, "Female", "Adult" ], [ 58, 2, 23.6, 96.0, 257, 171.0, 59.0, 4.0, 4.9053, 82, 69, "Female", "RetiredAdult" ], [ 55, 2, 24.6, 109.0, 143, 76.4, 51.0, 3.0, 4.3567, 88, 219, "Female", "RetiredAdult" ], [ 54, 1, 22.6, 90.0, 183, 104.2, 64.0, 3.0, 4.3041, 92, 72, "Male", "Adult" ], [ 36, 1, 27.8, 73.0, 153, 104.4, 42.0, 4.0, 3.4965, 73, 201, "Male", "Adult" ], [ 63, 2, 24.1, 111.0, 184, 112.2, 44.0, 4.0, 4.9345, 82, 110, "Female", "RetiredAdult" ], [ 47, 2, 26.5, 70.0, 181, 104.8, 63.0, 3.0, 4.1897, 70, 51, "Female", "Adult" ], [ 51, 2, 32.8, 112.0, 202, 100.6, 37.0, 5.0, 5.7746, 109, 277, "Female", "Adult" ], [ 42, 1, 19.9, 76.0, 146, 83.2, 55.0, 3.0, 3.6636, 79, 63, "Male", "Adult" ], [ 37, 2, 23.6, 94.0, 205, 138.8, 53.0, 4.0, 4.1897, 107, 118, "Female", "Adult" ], [ 28, 1, 22.1, 82.0, 168, 100.6, 54.0, 3.0, 4.2047, 86, 69, "Male", "Adult" ], [ 58, 1, 28.1, 111.0, 198, 80.6, 31.0, 6.0, 6.0684, 93, 273, "Male", "RetiredAdult" ], [ 32, 1, 26.5, 86.0, 184, 101.6, 53.0, 4.0, 4.9904, 78, 258, "Male", "Adult" ], [ 25, 2, 23.5, 88.0, 143, 80.8, 55.0, 3.0, 3.5835, 83, 43, "Female", "Adult" ], [ 63, 1, 26.0, 85.67, 155, 78.2, 46.0, 3.37, 5.037, 97, 198, "Male", "RetiredAdult" ], [ 52, 1, 27.8, 85.0, 219, 136.0, 49.0, 4.0, 5.1358, 75, 242, "Male", "Adult" ], [ 65, 2, 28.5, 109.0, 201, 123.0, 46.0, 4.0, 5.0752, 96, 232, "Female", "RetiredAdult" ], [ 42, 1, 30.6, 121.0, 176, 92.8, 69.0, 3.0, 4.2627, 89, 175, "Male", "Adult" ], [ 53, 1, 22.2, 78.0, 164, 81.0, 70.0, 2.0, 4.1744, 101, 93, "Male", "Adult" ], [ 79, 2, 23.3, 88.0, 186, 128.4, 33.0, 6.0, 4.8122, 102, 168, "Female", "RetiredAdult" ], [ 43, 1, 35.4, 93.0, 185, 100.2, 44.0, 4.0, 5.3181, 101, 275, "Male", "Adult" ], [ 44, 1, 31.4, 115.0, 165, 97.6, 52.0, 3.0, 4.3438, 89, 293, "Male", "Adult" ], [ 62, 2, 37.8, 119.0, 113, 51.0, 31.0, 4.0, 5.0434, 84, 281, "Female", "RetiredAdult" ], [ 33, 1, 18.9, 70.0, 162, 91.8, 59.0, 3.0, 4.0254, 58, 72, "Male", "Adult" ], [ 56, 1, 35.0, 79.33, 195, 140.8, 42.0, 4.64, 4.1109, 96, 140, "Male", "RetiredAdult" ], [ 66, 1, 21.7, 126.0, 212, 127.8, 45.0, 4.71, 5.2781, 101, 189, "Male", "RetiredAdult" ], [ 34, 2, 25.3, 111.0, 230, 162.0, 39.0, 6.0, 4.9767, 90, 181, "Female", "Adult" ], [ 46, 2, 23.8, 97.0, 224, 139.2, 42.0, 5.0, 5.366, 81, 209, "Female", "Adult" ], [ 50, 1, 31.8, 82.0, 136, 69.2, 55.0, 2.0, 4.0775, 85, 136, "Male", "Adult" ], [ 69, 1, 34.3, 113.0, 200, 123.8, 54.0, 4.0, 4.7095, 112, 261, "Male", "RetiredAdult" ], [ 34, 1, 26.3, 87.0, 197, 120.0, 63.0, 3.0, 4.2485, 96, 113, "Male", "Adult" ], [ 71, 2, 27.0, 93.33, 269, 190.2, 41.0, 6.56, 5.2417, 93, 131, "Female", "RetiredAdult" ], [ 47, 1, 27.2, 80.0, 208, 145.6, 38.0, 6.0, 4.804, 92, 174, "Male", "Adult" ], [ 41, 1, 33.8, 123.33, 187, 127.0, 45.0, 4.16, 4.3175, 100, 257, "Male", "Adult" ], [ 34, 1, 33.0, 73.0, 178, 114.6, 51.0, 3.49, 4.1271, 92, 55, "Male", "Adult" ], [ 51, 1, 24.1, 87.0, 261, 175.6, 69.0, 4.0, 4.4067, 93, 84, "Male", "Adult" ], [ 43, 1, 21.3, 79.0, 141, 78.8, 53.0, 3.0, 3.8286, 90, 42, "Male", "Adult" ], [ 55, 1, 23.0, 94.67, 190, 137.6, 38.0, 5.0, 4.2767, 106, 146, "Male", "RetiredAdult" ], [ 59, 2, 27.9, 101.0, 218, 144.2, 38.0, 6.0, 5.1874, 95, 212, "Female", "RetiredAdult" ], [ 27, 2, 33.6, 110.0, 246, 156.6, 57.0, 4.0, 5.0876, 89, 233, "Female", "Adult" ], [ 51, 2, 22.7, 103.0, 217, 162.4, 30.0, 7.0, 4.8122, 80, 91, "Female", "Adult" ], [ 49, 2, 27.4, 89.0, 177, 113.0, 37.0, 5.0, 4.9053, 97, 111, "Female", "Adult" ], [ 27, 1, 22.6, 71.0, 116, 43.4, 56.0, 2.0, 4.4188, 79, 152, "Male", "Adult" ], [ 57, 2, 23.2, 107.33, 231, 159.4, 41.0, 5.63, 5.0304, 112, 120, "Female", "RetiredAdult" ], [ 39, 2, 26.9, 93.0, 136, 75.4, 48.0, 3.0, 4.1431, 99, 67, "Female", "Adult" ], [ 62, 2, 34.6, 120.0, 215, 129.2, 43.0, 5.0, 5.366, 123, 310, "Female", "RetiredAdult" ], [ 37, 1, 23.3, 88.0, 223, 142.0, 65.0, 3.4, 4.3567, 82, 94, "Male", "Adult" ], [ 46, 1, 21.1, 80.0, 205, 144.4, 42.0, 5.0, 4.5326, 87, 183, "Male", "Adult" ], [ 68, 2, 23.5, 101.0, 162, 85.4, 59.0, 3.0, 4.4773, 91, 66, "Female", "RetiredAdult" ], [ 51, 1, 31.5, 93.0, 231, 144.0, 49.0, 4.7, 5.2523, 117, 173, "Male", "Adult" ], [ 41, 1, 20.8, 86.0, 223, 128.2, 83.0, 3.0, 4.0775, 89, 72, "Male", "Adult" ], [ 53, 1, 26.5, 97.0, 193, 122.4, 58.0, 3.0, 4.1431, 99, 49, "Male", "Adult" ], [ 45, 1, 24.2, 83.0, 177, 118.4, 45.0, 4.0, 4.2195, 82, 64, "Male", "Adult" ], [ 33, 1, 19.5, 80.0, 171, 85.4, 75.0, 2.0, 3.9703, 80, 48, "Male", "Adult" ], [ 60, 2, 28.2, 112.0, 185, 113.8, 42.0, 4.0, 4.9836, 93, 178, "Female", "RetiredAdult" ], [ 47, 2, 24.9, 75.0, 225, 166.0, 42.0, 5.0, 4.4427, 102, 104, "Female", "Adult" ], [ 60, 2, 24.9, 99.67, 162, 106.6, 43.0, 3.77, 4.1271, 95, 132, "Female", "RetiredAdult" ], [ 36, 1, 30.0, 95.0, 201, 125.2, 42.0, 4.79, 5.1299, 85, 220, "Male", "Adult" ], [ 36, 1, 19.6, 71.0, 250, 133.2, 97.0, 3.0, 4.5951, 92, 57, "Male", "Adult" ] ], "datasetInfos": [], "dbfsResultPath": null, "isJsonSchema": true, "metadata": {}, "overflow": false, "plotOptions": { "customPlotOptions": {}, "displayType": "table", "pivotAggregation": null, "pivotColumns": null, "xColumns": null, "yColumns": null }, "removedWidgets": [], "schema": [ { "metadata": "{}", "name": "AGE", "type": "\"short\"" }, { "metadata": "{}", "name": "SEX", "type": "\"short\"" }, { "metadata": "{}", "name": "BMI", "type": "\"double\"" }, { "metadata": "{}", "name": "BP", "type": "\"double\"" }, { "metadata": "{}", "name": "S1", "type": "\"short\"" }, { "metadata": "{}", "name": "S2", "type": "\"double\"" }, { "metadata": "{}", "name": "S3", "type": "\"double\"" }, { "metadata": "{}", "name": "S4", "type": "\"double\"" }, { "metadata": "{}", "name": "S5", "type": "\"double\"" }, { "metadata": "{}", "name": "S6", "type": "\"short\"" }, { "metadata": "{}", "name": "Y", "type": "\"short\"" }, { "metadata": "{}", "name": "Gender", "type": "\"string\"" }, { "metadata": "{}", "name": "ageband", "type": "\"string\"" } ], "type": "table" } }, "output_type": "display_data" } ], "source": [ "\n", "%sql\n", "\n", "SELECT * FROM diabetes.diabetesage\n", " " ] } ], "metadata": { "application/vnd.databricks.v1+notebook": { "dashboards": [], "language": "python", "notebookMetadata": { "mostRecentlyExecutedCommandWithImplicitDF": { "commandId": 847672408742511, "dataframes": [ "_sqldf" ] }, "pythonIndentUnit": 4 }, "notebookName": "ConnectToDeltaOnADLS", "notebookOrigID": 847672408742512, "widgets": {} } }, "nbformat": 4, "nbformat_minor": 0 }