{ "cells": [ { "cell_type": "code", "execution_count": 7, "metadata": { "collapsed": false }, "outputs": [], "source": [ "%matplotlib inline\n", "\n", "import pandas as pd\n", "import matplotlib.pyplot as plt\n", "import numpy as np\n", "\n", "pd.set_option('display.mpl_style', 'default')\n", "plt.rcParams['figure.figsize'] = (15, 3)\n", "plt.rcParams['font.family'] = 'sans-serif'" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "We saw earlier that pandas is really good at dealing with dates. It is also amazing with strings! We're going to go back to our weather data from Chapter 5, here." ] }, { "cell_type": "code", "execution_count": 8, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "
\n", " | Temp (C) | \n", "Dew Point Temp (C) | \n", "Rel Hum (%) | \n", "Wind Spd (km/h) | \n", "Visibility (km) | \n", "Stn Press (kPa) | \n", "Weather | \n", "
---|---|---|---|---|---|---|---|
Date/Time | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
2012-01-01 00:00:00 | \n", "-1.8 | \n", "-3.9 | \n", "86 | \n", "4 | \n", "8.0 | \n", "101.24 | \n", "Fog | \n", "
2012-01-01 01:00:00 | \n", "-1.8 | \n", "-3.7 | \n", "87 | \n", "4 | \n", "8.0 | \n", "101.24 | \n", "Fog | \n", "
2012-01-01 02:00:00 | \n", "-1.8 | \n", "-3.4 | \n", "89 | \n", "7 | \n", "4.0 | \n", "101.26 | \n", "Freezing Drizzle,Fog | \n", "
2012-01-01 03:00:00 | \n", "-1.5 | \n", "-3.2 | \n", "88 | \n", "6 | \n", "4.0 | \n", "101.27 | \n", "Freezing Drizzle,Fog | \n", "
2012-01-01 04:00:00 | \n", "-1.5 | \n", "-3.3 | \n", "88 | \n", "7 | \n", "4.8 | \n", "101.23 | \n", "Fog | \n", "
5 rows × 7 columns
\n", "\n", " | Temperature | \n", "Snowiness | \n", "
---|---|---|
2012-01-31 | \n", "-7.05 | \n", "0.240591 | \n", "
2012-02-29 | \n", "-4.10 | \n", "0.162356 | \n", "
2012-03-31 | \n", "2.60 | \n", "0.087366 | \n", "
2012-04-30 | \n", "6.30 | \n", "0.015278 | \n", "
2012-05-31 | \n", "16.05 | \n", "0.000000 | \n", "
2012-06-30 | \n", "19.60 | \n", "0.000000 | \n", "
2012-07-31 | \n", "22.90 | \n", "0.000000 | \n", "
2012-08-31 | \n", "22.20 | \n", "0.000000 | \n", "
2012-09-30 | \n", "16.10 | \n", "0.000000 | \n", "
2012-10-31 | \n", "11.30 | \n", "0.000000 | \n", "
2012-11-30 | \n", "1.05 | \n", "0.038889 | \n", "
2012-12-31 | \n", "-2.85 | \n", "0.251344 | \n", "
12 rows × 2 columns
\n", "