{ "metadata": { "name": "Open data from marinexplore.org" }, "nbformat": 3, "nbformat_minor": 0, "worksheets": [ { "cells": [ { "cell_type": "code", "collapsed": false, "input": [ "%pylab inline" ], "language": "python", "metadata": {}, "outputs": [ { "output_type": "stream", "stream": "stdout", "text": [ "\n", "Welcome to pylab, a matplotlib-based Python environment [backend: module://IPython.kernel.zmq.pylab.backend_inline].\n", "For more information, type 'help(pylab)'.\n" ] } ], "prompt_number": 2 }, { "cell_type": "code", "collapsed": false, "input": [ "import pandas as pd" ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 4 }, { "cell_type": "code", "collapsed": false, "input": [ "df = pd.read_csv('data.csv', index_col=['date_time'], parse_dates=True, na_values=['-99999.9'])" ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 19 }, { "cell_type": "code", "collapsed": false, "input": [ "df.head()" ], "language": "python", "metadata": {}, "outputs": [ { "html": [ "
\n", " | station_id | \n", "latitude (degrees north) | \n", "longitude (degrees east) | \n", "depth (meters) | \n", "ocean_temperature (C\u00b0) | \n", "sea_level_pressure (hPa) | \n", "wind_direction_drift (degT) | \n", "
---|---|---|---|---|---|---|---|
date_time | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
2013-04-15 00:00:00 | \n", "3757812 | \n", "65.638 | \n", "-11.094 | \n", "0 | \n", "2.4 | \n", "NaN | \n", "-1000000 | \n", "
2013-04-15 01:00:00 | \n", "3757812 | \n", "65.638 | \n", "-11.094 | \n", "0 | \n", "2.4 | \n", "NaN | \n", "-1000000 | \n", "
2013-04-15 02:00:00 | \n", "3757812 | \n", "65.638 | \n", "-11.094 | \n", "0 | \n", "2.4 | \n", "NaN | \n", "-1000000 | \n", "
2013-04-15 03:00:00 | \n", "3757812 | \n", "65.633 | \n", "-11.100 | \n", "0 | \n", "2.4 | \n", "NaN | \n", "-1000000 | \n", "
2013-04-15 04:00:00 | \n", "3757812 | \n", "65.633 | \n", "-11.100 | \n", "0 | \n", "2.4 | \n", "NaN | \n", "-1000000 | \n", "