Skip to content

Instantly share code, notes, and snippets.

@adyork

adyork/test-field-name-validation.ipynb Secret

Created August 17, 2020 16:11
Show Gist options
  • Save adyork/9ae791ebee7b0b651be034ec1b033c18 to your computer and use it in GitHub Desktop.
Save adyork/9ae791ebee7b0b651be034ec1b033c18 to your computer and use it in GitHub Desktop.
Download ZIP
test-field-name-validation.ipynb
Display the source blob
Display the rendered blob
Raw
test-field-name-validation.ipynb
{
"nbformat": 4,
"nbformat_minor": 0,
"metadata": {
"colab": {
"name": "test-field-name-validation.ipynb",
"provenance": [],
"collapsed_sections": [],
"authorship_tag": "ABX9TyPgQhjEFcaOA62N21Ee8SyA",
"include_colab_link": true
},
"kernelspec": {
"name": "python3",
"display_name": "Python 3"
}
},
"cells": [
{
"cell_type": "markdown",
"metadata": {
"id": "view-in-github",
"colab_type": "text"
},
"source": [
"<a href=\"https://colab.research.google.com/gist/adyork/9ae791ebee7b0b651be034ec1b033c18/test-field-name-validation.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
]
},
{
"cell_type": "markdown",
"metadata": {
"id": "sAlxpVpsLTyF",
"colab_type": "text"
},
"source": [
"Setup for testing a commit for validate_metadata in dataflows\n",
"\n",
"See https://github.com/BCODMO/laminar_web/issues/801\n",
"\n",
"\n",
"Goal: checking field names for requirement [A-Za-z0-9_]. In test data loaded here sigma-é00, c1S/m, etc violate this."
]
},
{
"cell_type": "code",
"metadata": {
"id": "jGgBG2LU0NY5",
"colab_type": "code",
"colab": {
"base_uri": "https://localhost:8080/",
"height": 989
},
"outputId": "49a8dd02-775c-4672-ebcd-475534b40031"
},
"source": [
"#!pip install dataflows\n",
"\n",
"#!pip install https://github.com/roll/dataflows/archive/validate-metadata.zip\n",
"!pip install https://github.com/datahq/dataflows/archive/982c9f7ca0ed2ee4dd67983acf11c9d92b02bff4.zip"
],
"execution_count": 53,
"outputs": [
{
"output_type": "stream",
"text": [
"Collecting https://github.com/datahq/dataflows/archive/982c9f7ca0ed2ee4dd67983acf11c9d92b02bff4.zip\n",
" Using cached https://github.com/datahq/dataflows/archive/982c9f7ca0ed2ee4dd67983acf11c9d92b02bff4.zip\n",
"Requirement already satisfied (use --upgrade to upgrade): dataflows==0.1.5 from https://github.com/datahq/dataflows/archive/982c9f7ca0ed2ee4dd67983acf11c9d92b02bff4.zip in /usr/local/lib/python3.6/dist-packages\n",
"Requirement already satisfied: tabulator>=1.38.4 in /usr/local/lib/python3.6/dist-packages (from dataflows==0.1.5) (1.52.3)\n",
"Requirement already satisfied: datapackage>=1.5.0 in /usr/local/lib/python3.6/dist-packages (from dataflows==0.1.5) (1.15.0)\n",
"Requirement already satisfied: tableschema>=1.5 in /usr/local/lib/python3.6/dist-packages (from dataflows==0.1.5) (1.19.3)\n",
"Requirement already satisfied: kvfile>=0.0.8 in /usr/local/lib/python3.6/dist-packages (from dataflows==0.1.5) (0.0.8)\n",
"Requirement already satisfied: click in /usr/local/lib/python3.6/dist-packages (from dataflows==0.1.5) (7.1.2)\n",
"Requirement already satisfied: jinja2 in /usr/local/lib/python3.6/dist-packages (from dataflows==0.1.5) (2.11.2)\n",
"Requirement already satisfied: awesome-slugify in /usr/local/lib/python3.6/dist-packages (from dataflows==0.1.5) (1.6.5)\n",
"Requirement already satisfied: inquirer in /usr/local/lib/python3.6/dist-packages (from dataflows==0.1.5) (2.7.0)\n",
"Requirement already satisfied: tabulate in /usr/local/lib/python3.6/dist-packages (from dataflows==0.1.5) (0.8.7)\n",
"Requirement already satisfied: tableschema-sql in /usr/local/lib/python3.6/dist-packages (from dataflows==0.1.5) (1.3.1)\n",
"Requirement already satisfied: xmljson in /usr/local/lib/python3.6/dist-packages (from dataflows==0.1.5) (0.2.1)\n",
"Requirement already satisfied: bitstring>=3 in /usr/local/lib/python3.6/dist-packages (from dataflows==0.1.5) (3.1.7)\n",
"Requirement already satisfied: boto3>=1.9 in /usr/local/lib/python3.6/dist-packages (from tabulator>=1.38.4->dataflows==0.1.5) (1.14.37)\n",
"Requirement already satisfied: xlrd>=1.0 in /usr/local/lib/python3.6/dist-packages (from tabulator>=1.38.4->dataflows==0.1.5) (1.1.0)\n",
"Requirement already satisfied: openpyxl>=2.6 in /usr/local/lib/python3.6/dist-packages (from tabulator>=1.38.4->dataflows==0.1.5) (3.0.4)\n",
"Requirement already satisfied: unicodecsv>=0.14 in /usr/local/lib/python3.6/dist-packages (from tabulator>=1.38.4->dataflows==0.1.5) (0.14.1)\n",
"Requirement already satisfied: chardet>=3.0 in /usr/local/lib/python3.6/dist-packages (from tabulator>=1.38.4->dataflows==0.1.5) (3.0.4)\n",
"Requirement already satisfied: six>=1.9 in /usr/local/lib/python3.6/dist-packages (from tabulator>=1.38.4->dataflows==0.1.5) (1.15.0)\n",
"Requirement already satisfied: sqlalchemy>=0.9.6 in /usr/local/lib/python3.6/dist-packages (from tabulator>=1.38.4->dataflows==0.1.5) (1.3.18)\n",
"Requirement already satisfied: ijson>=3.0.3 in /usr/local/lib/python3.6/dist-packages (from tabulator>=1.38.4->dataflows==0.1.5) (3.1.1)\n",
"Requirement already satisfied: linear-tsv>=1.0 in /usr/local/lib/python3.6/dist-packages (from tabulator>=1.38.4->dataflows==0.1.5) (1.1.0)\n",
"Requirement already satisfied: requests>=2.8 in /usr/local/lib/python3.6/dist-packages (from tabulator>=1.38.4->dataflows==0.1.5) (2.23.0)\n",
"Requirement already satisfied: jsonlines>=1.1 in /usr/local/lib/python3.6/dist-packages (from tabulator>=1.38.4->dataflows==0.1.5) (1.2.0)\n",
"Requirement already satisfied: jsonpointer>=1.10 in /usr/local/lib/python3.6/dist-packages (from datapackage>=1.5.0->dataflows==0.1.5) (2.0)\n",
"Requirement already satisfied: jsonschema>=2.5 in /usr/local/lib/python3.6/dist-packages (from datapackage>=1.5.0->dataflows==0.1.5) (2.6.0)\n",
"Requirement already satisfied: rfc3986>=1.1.0 in /usr/local/lib/python3.6/dist-packages (from tableschema>=1.5->dataflows==0.1.5) (1.4.0)\n",
"Requirement already satisfied: python-dateutil>=2.4 in /usr/local/lib/python3.6/dist-packages (from tableschema>=1.5->dataflows==0.1.5) (2.8.1)\n",
"Requirement already satisfied: cached-property>=1.5 in /usr/local/lib/python3.6/dist-packages (from tableschema>=1.5->dataflows==0.1.5) (1.5.1)\n",
"Requirement already satisfied: isodate>=0.5.4 in /usr/local/lib/python3.6/dist-packages (from tableschema>=1.5->dataflows==0.1.5) (0.6.0)\n",
"Requirement already satisfied: cachetools in /usr/local/lib/python3.6/dist-packages (from kvfile>=0.0.8->dataflows==0.1.5) (4.1.1)\n",
"Requirement already satisfied: MarkupSafe>=0.23 in /usr/local/lib/python3.6/dist-packages (from jinja2->dataflows==0.1.5) (1.1.1)\n",
"Requirement already satisfied: Unidecode<0.05,>=0.04.14 in /usr/local/lib/python3.6/dist-packages (from awesome-slugify->dataflows==0.1.5) (0.4.21)\n",
"Requirement already satisfied: regex in /usr/local/lib/python3.6/dist-packages (from awesome-slugify->dataflows==0.1.5) (2019.12.20)\n",
"Requirement already satisfied: python-editor==1.0.4 in /usr/local/lib/python3.6/dist-packages (from inquirer->dataflows==0.1.5) (1.0.4)\n",
"Requirement already satisfied: readchar==2.0.1 in /usr/local/lib/python3.6/dist-packages (from inquirer->dataflows==0.1.5) (2.0.1)\n",
"Requirement already satisfied: blessed==1.17.6 in /usr/local/lib/python3.6/dist-packages (from inquirer->dataflows==0.1.5) (1.17.6)\n",
"Requirement already satisfied: pybloom-live>=2.2 in /usr/local/lib/python3.6/dist-packages (from tableschema-sql->dataflows==0.1.5) (3.0.0)\n",
"Requirement already satisfied: jmespath<1.0.0,>=0.7.1 in /usr/local/lib/python3.6/dist-packages (from boto3>=1.9->tabulator>=1.38.4->dataflows==0.1.5) (0.10.0)\n",
"Requirement already satisfied: s3transfer<0.4.0,>=0.3.0 in /usr/local/lib/python3.6/dist-packages (from boto3>=1.9->tabulator>=1.38.4->dataflows==0.1.5) (0.3.3)\n",
"Requirement already satisfied: botocore<1.18.0,>=1.17.37 in /usr/local/lib/python3.6/dist-packages (from boto3>=1.9->tabulator>=1.38.4->dataflows==0.1.5) (1.17.37)\n",
"Requirement already satisfied: jdcal in /usr/local/lib/python3.6/dist-packages (from openpyxl>=2.6->tabulator>=1.38.4->dataflows==0.1.5) (1.4.1)\n",
"Requirement already satisfied: et-xmlfile in /usr/local/lib/python3.6/dist-packages (from openpyxl>=2.6->tabulator>=1.38.4->dataflows==0.1.5) (1.0.1)\n",
"Requirement already satisfied: certifi>=2017.4.17 in /usr/local/lib/python3.6/dist-packages (from requests>=2.8->tabulator>=1.38.4->dataflows==0.1.5) (2020.6.20)\n",
"Requirement already satisfied: idna<3,>=2.5 in /usr/local/lib/python3.6/dist-packages (from requests>=2.8->tabulator>=1.38.4->dataflows==0.1.5) (2.10)\n",
"Requirement already satisfied: urllib3!=1.25.0,!=1.25.1,<1.26,>=1.21.1 in /usr/local/lib/python3.6/dist-packages (from requests>=2.8->tabulator>=1.38.4->dataflows==0.1.5) (1.24.3)\n",
"Requirement already satisfied: wcwidth>=0.1.4 in /usr/local/lib/python3.6/dist-packages (from blessed==1.17.6->inquirer->dataflows==0.1.5) (0.2.5)\n",
"Requirement already satisfied: bitarray>=0.3.4 in /usr/local/lib/python3.6/dist-packages (from pybloom-live>=2.2->tableschema-sql->dataflows==0.1.5) (1.5.2)\n",
"Requirement already satisfied: docutils<0.16,>=0.10 in /usr/local/lib/python3.6/dist-packages (from botocore<1.18.0,>=1.17.37->boto3>=1.9->tabulator>=1.38.4->dataflows==0.1.5) (0.15.2)\n",
"Building wheels for collected packages: dataflows\n",
" Building wheel for dataflows (setup.py) ... \u001b[?25l\u001b[?25hdone\n",
" Created wheel for dataflows: filename=dataflows-0.1.5-py2.py3-none-any.whl size=49542 sha256=82531db88469ffe0af97ef7b09dc863733da6bd326e51d4925b1adc942dc4d33\n",
" Stored in directory: /tmp/pip-ephem-wheel-cache-crumebly/wheels/f4/9b/ce/b78c1e4e29f52de738a7031f53d9c1d08cb20dd429f8b50e20\n",
"Successfully built dataflows\n"
],
"name": "stdout"
}
]
},
{
"cell_type": "code",
"metadata": {
"id": "2B9zvb4C_Jfq",
"colab_type": "code",
"colab": {
"base_uri": "https://localhost:8080/",
"height": 836
},
"outputId": "d56612db-54f7-4a75-c106-45ff87653eac"
},
"source": [
"\n",
"\n",
"#!dataflows init https://github.com/BCODMO/frictionless-usecases/raw/master/usecases/818993_seabirdCTD/orig/head/FK190211_CTD004_01032019.csv\n",
"#\n",
"#Flow(\n",
" # validate(extra_checks=['baseline', 'integrity', ('blacklisted-value', {'fieldName': 'name'}), ...]\n",
"#)\n",
"\n",
"from dataflows import Flow, load, dump_to_path, dump_to_zip, printer, add_metadata\n",
"from dataflows import sort_rows, filter_rows, find_replace, delete_fields, set_type, validate, unpivot\n",
"\n",
"def FK190211_CTD004_01032019_csv():\n",
" flow = Flow(\n",
" # Load inputs\n",
" load('https://github.com/BCODMO/frictionless-usecases/raw/master/usecases/818993_seabirdCTD/orig/head/FK190211_CTD004_01032019.csv', format='csv', ),\n",
" # Process them (if necessary)\n",
" # Save the results\n",
" add_metadata(name='FK190211_CTD004_01032019_csv', title='''FK190211_CTD004_01032019.csv'''),\n",
" printer(),\n",
" dump_to_path('FK190211_CTD004_01032019_csv'),\n",
" )\n",
" flow.process()\n",
"\n",
"\n",
"if __name__ == '__main__':\n",
" FK190211_CTD004_01032019_csv()"
],
"execution_count": 52,
"outputs": [
{
"output_type": "stream",
"text": [
"FK190211_CTD004_01032019:\n",
"# scan timeY prDM t090C t190C c0S/m c1S/m V0 V1 V2 V3 V4 V5 sbeox0V sbeox1V CStarAt0 CStarTr0 flECO-AFL turbWETntu0 par latitude longitude depSM potemp090C potemp190C sal00 sal11 sigma-é00 sigma-é11 sbeox0Mg/L sbeox0Mm/L sbeox1Mg/L sbeox1Mm/L oxsolMg/L oxsatMg/L dm sva T2-T190C secS-priS flag\n",
" (integer) (integer) (number) (number) (number) (number) (number) (number) (number) (number) (integer) (number) (number) (number) (number) (number) (number) (number) (number) (number) (number) (number) (number) (number) (number) (number) (number) (number) (number) (number) (number) (number) (number) (number) (number) (number) (number) (number) (number) (number)\n",
"--- ----------- ----------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ----------- ---------- ---------- ---------- ---------- ---------- ---------- ----------- ------------- ---------- ---------- ----------- ---------- ------------ ------------ ---------- ---------- ----------- ----------- ------------ ------------ ------------ ------------ ----------- ----------- ---------- ---------- ---------- ----------- ----------\n",
"1 1 1551416593 13.129 17.9078 17.9066 4.61216 4.61253 2.7009 4.4811 2.9609 0 0.2051 0.0806 4.4811 -1.23e-07 2.2181 57.4346 1.5414 0.1179 1e-12 27.0149 -111.411 13.042 17.9056 17.9044 35.2655 35.2697 25.4988 25.5023 11.9951 374.852 -1.9915 -62.235 7.67684 7.66553 0 247.805 -0.0012 0.0042 0\n",
"2 2 1551416593 13.13 17.9079 17.9069 4.6122 4.6125 2.7009 4.4811 2.9609 0 0.2051 0.0806 4.4811 -1.25e-07 2.2181 57.4346 1.5414 0.1179 1e-12 27.0149 -111.411 13.043 17.9057 17.9047 35.2658 35.2692 25.4989 25.5018 11.9951 374.851 -1.9915 -62.235 7.67681 7.6655 0 247.791 -0.001 0.0034 0\n",
"3 3 1551416593 13.13 17.9083 17.9067 4.61225 4.61245 2.7009 4.4811 2.9499 0 0.2051 0.0806 4.4811 -1.26e-07 2.2181 57.4346 1.5414 0.1179 1e-12 27.0149 -111.411 13.043 17.9061 17.9045 35.2659 35.269 25.4989 25.5017 11.995 374.848 -1.9915 -62.235 7.67675 7.66544 0 247.792 -0.0016 0.0031 0\n",
"4 4 1551416593 13.13 17.9085 17.9071 4.61227 4.6125 2.6996 4.4811 2.9499 0 0.2051 0.0806 4.4811 -1.27e-07 2.2199 57.4086 1.5414 0.1179 1e-12 27.0149 -111.411 13.043 17.9063 17.9049 35.2658 35.269 25.4988 25.5016 11.9949 374.847 -1.9915 -62.235 7.67672 7.66541 0 247.8 -0.0014 0.0032 0\n",
"5 5 1551416593 13.131 17.9083 17.9069 4.6122 4.6125 2.7009 4.4811 2.9499 0 0.2051 0.0806 4.4811 -1.29e-07 2.2181 57.4346 1.5414 0.1179 1e-12 27.0149 -111.411 13.044 17.9061 17.9047 35.2654 35.2692 25.4986 25.5018 11.995 374.849 -1.9915 -62.235 7.67677 7.66546 0 247.825 -0.0014 0.0037 0\n",
"6 6 1551416593 13.133 17.9083 17.9069 4.6122 4.6125 2.7009 4.4811 2.9499 0 0.2051 0.0806 4.4811 -1.3e-07 2.2181 57.4346 1.5414 0.1179 1e-12 27.0149 -111.411 13.046 17.9061 17.9047 35.2654 35.2692 25.4986 25.5018 11.995 374.849 -1.9915 -62.235 7.67677 7.66546 0 247.825 -0.0014 0.0037 0\n",
"7 7 1551416593 13.135 17.9083 17.9071 4.6122 4.61251 2.7009 4.4811 2.9499 0 0.2051 0.0806 4.4811 -1.31e-07 2.2181 57.4346 1.5414 0.1179 1e-12 27.0149 -111.411 13.048 17.9061 17.9049 35.2654 35.2691 25.4986 25.5017 11.995 374.849 -1.9915 -62.235 7.67677 7.66546 0 247.825 -0.0012 0.0037 0\n",
"8 8 1551416593 13.137 17.9083 17.9071 4.61219 4.61251 2.6996 4.4811 2.9621 0 0.2051 0.0806 4.4811 -1.32e-07 2.2199 57.4086 1.5414 0.1179 1e-12 27.0149 -111.411 13.05 17.9061 17.9049 35.2654 35.2691 25.4985 25.5017 11.995 374.849 -1.9915 -62.235 7.67677 7.66546 0 247.829 -0.0012 0.0038 0\n",
"9 9 1551416593 13.141 17.9082 17.9071 4.61219 4.61251 2.7009 4.4811 2.9731 0 0.2051 0.0806 4.4811 -1.34e-07 2.2181 57.4346 1.5414 0.1179 1e-12 27.0149 -111.411 13.054 17.906 17.9049 35.2655 35.2691 25.4986 25.5017 11.995 374.85 -1.9915 -62.235 7.67678 7.66547 0 247.821 -0.0011 0.0037 0\n",
"10 10 1551416593 13.144 17.9082 17.9071 4.61219 4.61251 2.6996 4.4811 2.9731 0 0.2051 0.0806 4.4811 -1.35e-07 2.2199 57.4086 1.5414 0.1179 1e-12 27.0149 -111.411 13.057 17.906 17.9049 35.2655 35.2691 25.4986 25.5017 11.995 374.85 -1.9915 -62.235 7.67678 7.66547 0 247.821 -0.0011 0.0037 0\n",
"11 11 1551416593 13.147 17.9083 17.9071 4.61219 4.61251 2.7009 4.4811 2.9731 0 0.2051 0.0806 4.4811 -1.36e-07 2.2181 57.4346 1.5414 0.1179 1e-12 27.0149 -111.411 13.06 17.9061 17.9049 35.2654 35.2691 25.4985 25.5017 11.995 374.85 -1.9915 -62.235 7.67677 7.66546 0 247.83 -0.0012 0.0038 0\n",
"12 12 1551416593 13.151 17.9083 17.9071 4.61219 4.61251 2.7009 4.4811 2.9731 0 0.2051 0.0806 4.4811 -1.38e-07 2.2181 57.4346 1.5414 0.1179 1e-12 27.0149 -111.411 13.064 17.9061 17.9049 35.2654 35.2691 25.4985 25.5017 11.995 374.85 -1.9915 -62.235 7.67677 7.66546 0.0001 247.83 -0.0012 0.0038 0\n",
"13 13 1551416593 13.154 17.9083 17.9071 4.61219 4.6125 2.6996 4.4799 2.9731 0 0.2051 0.0806 4.4799 -1.39e-07 2.2199 57.4086 1.5414 0.1179 1e-12 27.0149 -111.411 13.067 17.9061 17.9049 35.2654 35.2691 25.4985 25.5016 11.9914 374.738 -1.9915 -62.235 7.67677 7.66546 0.0001 247.831 -0.0012 0.0037 0\n",
"14 14 1551416593 13.157 17.9083 17.9071 4.61219 4.6125 2.6996 4.475 2.967 0 0.2051 0.0806 4.475 -1.4e-07 2.2199 57.4086 1.5414 0.1179 1e-12 27.0149 -111.411 13.07 17.9061 17.9049 35.2654 35.2691 25.4985 25.5016 11.9767 374.278 -1.9915 -62.235 7.67677 7.66546 0.0001 247.831 -0.0012 0.0037 0\n",
"15 15 1551416593 13.16 17.9083 17.907 4.61219 4.6125 2.6996 4.4737 2.967 0 0.2051 0.0806 4.4737 -1.41e-07 2.2199 57.4086 1.5414 0.1179 1e-12 27.0149 -111.411 13.073 17.9061 17.9048 35.2654 35.2692 25.4985 25.5017 11.9728 374.156 -1.9915 -62.235 7.67677 7.66546 0.0001 247.831 -0.0013 0.0038 0\n",
"16 16 1551416593 13.163 17.9083 17.907 4.61219 4.6125 2.6996 4.4737 2.967 0 0.2051 0.0806 4.4737 -1.43e-07 2.2199 57.4086 1.5414 0.1179 1e-12 27.0149 -111.411 13.076 17.9061 17.9048 35.2654 35.2691 25.4985 25.5017 11.9728 374.156 -1.9915 -62.235 7.67677 7.66546 0.0001 247.831 -0.0013 0.0037 0\n",
"17 17 1551416593 13.166 17.9083 17.907 4.61219 4.61249 2.7009 4.4737 2.967 0 0.2051 0.0806 4.4737 -1.44e-07 2.2181 57.4346 1.5414 0.1179 1e-12 27.0149 -111.411 13.079 17.9061 17.9048 35.2654 35.269 25.4985 25.5016 11.9728 374.156 -1.9915 -62.235 7.67677 7.66546 0.0001 247.831 -0.0013 0.0037 0\n",
"18 18 1551416593 13.168 17.9083 17.907 4.61219 4.6125 2.7009 4.4737 2.967 0 0.2051 0.0806 4.4737 -1.45e-07 2.2181 57.4346 1.5414 0.1179 1e-12 27.0149 -111.411 13.081 17.9061 17.9048 35.2654 35.2691 25.4985 25.5017 11.9728 374.156 -1.9915 -62.235 7.67677 7.66546 0.0001 247.831 -0.0013 0.0037 0\n",
"19 19 1551416593 13.171 17.9083 17.907 4.61219 4.6125 2.7009 4.4737 2.9866 0 0.2051 0.0806 4.4737 -1.47e-07 2.2181 57.4346 1.5414 0.1179 1e-12 27.0149 -111.411 13.084 17.9061 17.9048 35.2654 35.2691 25.4985 25.5017 11.9728 374.156 -1.9915 -62.235 7.67677 7.66546 0.0001 247.832 -0.0013 0.0038 0\n",
"20 20 1551416593 13.173 17.9083 17.907 4.61219 4.61252 2.7009 4.4737 3.0061 0 0.2051 0.0806 4.4737 -1.48e-07 2.2181 57.4346 1.5414 0.1179 1e-12 27.0149 -111.411 13.086 17.9061 17.9048 35.2654 35.2693 25.4985 25.5018 11.9728 374.156 -1.9915 -62.235 7.67677 7.66546 0.0001 247.832 -0.0013 0.0039 0\n",
"...\n",
"100 100 1551416597 13.18 17.9073 17.9064 4.61213 4.61242 2.7033 4.4835 3.1355 0 0.2063 0.0781 4.4835 -2.51e-07 2.2145 57.4865 1.5548 0.1057 1e-12 27.0149 -111.411 13.093 17.9051 17.9042 35.2657 35.269 25.499 25.5017 12.0112 375.355 -1.9915 -62.236 7.67691 7.66559 0.0002 247.785 -0.0009 0.0033 0\n",
"101 101 1551416597 13.182 17.9073 17.9064 4.61213 4.61242 2.7033 4.4835 3.1416 0 0.2063 0.0781 4.4835 -2.53e-07 2.2145 57.4865 1.5548 0.1057 1e-12 27.0149 -111.411 13.095 17.905 17.9041 35.2657 35.269 25.499 25.5017 12.0099 375.316 -1.9915 -62.236 7.67691 7.66559 0.0003 247.785 -0.0009 0.0033 0\n",
"102 102 1551416597 13.183 17.9071 17.9064 4.61213 4.61242 2.7033 4.4835 3.1416 0 0.2027 0.0769 4.4835 -2.54e-07 2.2145 57.4865 1.5145 0.0996 1e-12 27.0149 -111.411 13.096 17.9048 17.9041 35.2659 35.269 25.4992 25.5017 12.0087 375.277 -1.9915 -62.236 7.67693 7.66561 0.0003 247.768 -0.0007 0.0031 0\n",
"103 103 1551416597 13.185 17.9071 17.9064 4.61213 4.61242 2.7033 4.4835 3.1416 0 0.2015 0.0769 4.4835 -2.55e-07 2.2145 57.4865 1.5011 0.0996 1e-12 27.0149 -111.411 13.098 17.9048 17.9041 35.2659 35.269 25.4992 25.5017 12.0074 375.237 -1.9915 -62.236 7.67693 7.66561 0.0003 247.768 -0.0007 0.0031 0\n",
"104 104 1551416597 13.187 17.9071 17.9064 4.61212 4.61243 2.7033 4.4835 3.1416 0 0.2015 0.0769 4.4835 -2.56e-07 2.2145 57.4865 1.5011 0.0996 1e-12 27.0149 -111.411 13.1 17.9048 17.9041 35.2657 35.269 25.4991 25.5018 12.0061 375.197 -1.9915 -62.236 7.67693 7.66562 0.0003 247.777 -0.0007 0.0033 0\n",
"105 105 1551416597 13.19 17.9071 17.9064 4.61212 4.61243 2.7033 4.4835 3.1416 0 0.2015 0.0769 4.4835 -2.58e-07 2.2145 57.4865 1.5011 0.0996 1e-12 27.0149 -111.411 13.103 17.9048 17.9041 35.2657 35.269 25.4991 25.5018 12.0048 375.156 -1.9915 -62.236 7.67693 7.66562 0.0003 247.778 -0.0007 0.0033 0\n",
"106 106 1551416597 13.194 17.9071 17.9064 4.61212 4.61243 2.7033 4.4835 3.1343 0 0.2015 0.0769 4.4835 -2.59e-07 2.2145 57.4865 1.5011 0.0996 1e-12 27.0149 -111.411 13.107 17.9048 17.9041 35.2657 35.269 25.4991 25.5018 12.0035 375.115 -1.9915 -62.236 7.67693 7.66562 0.0003 247.778 -0.0007 0.0033 0\n",
"107 107 1551416597 13.198 17.9071 17.9064 4.61213 4.61243 2.7045 4.4835 3.1184 0 0.2015 0.0769 4.4835 -2.6e-07 2.2127 57.5125 1.5011 0.0996 1e-12 27.0149 -111.411 13.111 17.9048 17.9041 35.2659 35.269 25.4992 25.5018 12.0022 375.073 -1.9915 -62.236 7.67693 7.66561 0.0003 247.769 -0.0007 0.0032 0\n",
"108 108 1551416597 13.202 17.9071 17.9064 4.61213 4.61243 2.7045 4.4835 3.1148 0 0.2015 0.0769 4.4835 -2.62e-07 2.2127 57.5125 1.5011 0.0996 1e-12 27.0149 -111.411 13.115 17.9048 17.9041 35.2659 35.269 25.4992 25.5018 12.0008 375.032 -1.9915 -62.236 7.67693 7.66561 0.0003 247.769 -0.0007 0.0032 0\n",
"109 109 1551416597 13.206 17.9073 17.9064 4.61213 4.61243 2.7045 4.4835 3.1123 0 0.2015 0.0769 4.4835 -2.63e-07 2.2127 57.5125 1.5011 0.0996 1e-12 27.0149 -111.411 13.119 17.905 17.9041 35.2657 35.269 25.499 25.5018 11.9995 374.988 -1.9915 -62.236 7.67691 7.66559 0.0003 247.786 -0.0009 0.0033 0\n",
"110 110 1551416597 13.209 17.9073 17.9064 4.61213 4.61243 2.7045 4.4835 3.1074 0 0.2015 0.0769 4.4835 -2.64e-07 2.2127 57.5125 1.5011 0.0996 1e-12 27.0149 -111.411 13.122 17.905 17.9041 35.2657 35.269 25.499 25.5018 11.9978 374.937 -1.9915 -62.236 7.67691 7.66559 0.0003 247.786 -0.0009 0.0033 0\n",
"...\n",
"790 790 1551416625 13.381 17.9075 17.9061 4.61212 4.61239 2.7057 4.4811 2.7668 0 0.2039 0.0769 4.4811 0 2.2109 57.5385 1.528 0.0996 1e-12 27.0149 -111.411 13.293 17.9052 17.9038 35.2654 35.2689 25.4987 25.5017 12.0131 375.415 -1.9916 -62.238 7.67689 7.66558 0.0022 247.821 -0.0014 0.0035 0\n",
"791 791 1551416626 13.377 17.9075 17.9061 4.61212 4.61239 2.7057 4.4811 2.7558 0 0.2002 0.0781 4.4811 0 2.2109 57.5385 1.4877 0.1057 1e-12 27.0149 -111.411 13.289 17.9052 17.9038 35.2654 35.2689 25.4987 25.5017 12.0113 375.36 -1.9916 -62.238 7.67689 7.66558 0.0022 247.82 -0.0014 0.0035 0\n",
"792 792 1551416626 13.373 17.9075 17.9061 4.61213 4.61239 2.7045 4.4811 2.7411 0 0.199 0.0794 4.4811 0 2.2127 57.5125 1.4743 0.1118 1e-12 27.0149 -111.411 13.285 17.9052 17.9038 35.2654 35.2689 25.4988 25.5017 12.0095 375.303 -1.9916 -62.238 7.67689 7.66558 0.0022 247.815 -0.0014 0.0034 0\n",
"793 793 1551416626 13.369 17.9075 17.9061 4.61212 4.61238 2.7045 4.4811 2.7265 0 0.199 0.0794 4.4811 0 2.2127 57.5125 1.4743 0.1118 1e-12 27.0149 -111.411 13.281 17.9052 17.9038 35.2654 35.2688 25.4987 25.5017 12.0077 375.245 -1.9916 -62.238 7.67689 7.66558 0.0022 247.82 -0.0014 0.0035 0\n",
"794 794 1551416626 13.367 17.9075 17.9061 4.61214 4.61237 2.7045 4.4811 2.7106 0 0.199 0.0794 4.4811 0 2.2127 57.5125 1.4743 0.1118 1e-12 27.0149 -111.411 13.279 17.9052 17.9038 35.2655 35.2687 25.4988 25.5016 12.0057 375.184 -1.9916 -62.238 7.67689 7.66557 0.0022 247.81 -0.0014 0.0032 0\n",
"795 795 1551416626 13.365 17.9076 17.9061 4.61213 4.61238 2.7045 4.4811 2.7106 0 0.199 0.0794 4.4811 0 2.2127 57.5125 1.4743 0.1118 1e-12 27.0149 -111.411 13.277 17.9053 17.9038 35.2653 35.2688 25.4987 25.5017 12.0037 375.121 -1.9916 -62.238 7.67688 7.66556 0.0022 247.823 -0.0015 0.0035 0\n",
"796 796 1551416626 13.364 17.9078 17.9061 4.61214 4.61238 2.7045 4.4811 2.7106 0 0.199 0.0794 4.4811 0 2.2127 57.5125 1.4743 0.1118 1e-12 27.0149 -111.411 13.276 17.9055 17.9038 35.2652 35.2688 25.4985 25.5017 12.0016 375.056 -1.9916 -62.238 7.67685 7.66554 0.0022 247.836 -0.0017 0.0036 0\n",
"797 797 1551416626 13.362 17.9078 17.9061 4.61215 4.61238 2.7045 4.4811 2.7106 0 0.199 0.0794 4.4811 0 2.2127 57.5125 1.4743 0.1118 1e-12 27.0149 -111.411 13.274 17.9055 17.9038 35.2654 35.2688 25.4986 25.5017 11.9992 374.981 -1.9916 -62.238 7.67685 7.66553 0.0022 247.826 -0.0017 0.0035 0\n",
"798 798 1551416626 13.361 17.9079 17.9061 4.61215 4.61238 2.7045 4.4811 2.7106 0 0.199 0.0794 4.4811 0 2.2127 57.5125 1.4743 0.1118 1e-12 27.0149 -111.411 13.273 17.9056 17.9038 35.2653 35.2688 25.4985 25.5017 11.9942 374.824 -1.9916 -62.238 7.67684 7.66552 0.0022 247.835 -0.0018 0.0035 0\n",
"799 799 1551416626 13.36 17.908 17.9061 4.61215 4.61238 2.7045 4.4811 2.7192 0 0.199 0.0794 4.4811 0 2.2127 57.5125 1.4743 0.1118 1e-12 27.0149 -111.411 13.272 17.9057 17.9038 35.2652 35.2688 25.4985 25.5017 11.9878 374.624 -1.9916 -62.238 7.67683 7.66551 0.0022 247.843 -0.0019 0.0036 0\n"
],
"name": "stdout"
}
]
},
{
"cell_type": "code",
"metadata": {
"id": "qltqbaRtK0FD",
"colab_type": "code",
"colab": {}
},
"source": [
""
],
"execution_count": null,
"outputs": []
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment