{ "metadata": { "name": "", "signature": "sha256:97bfc8cd2186b905845a200ee3ca9a08693982349943b78df611359d0519a232" }, "nbformat": 3, "nbformat_minor": 0, "worksheets": [ { "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# Pandas Time Series Basics\n", "\n", "- **Author:** [Chris Albon](http://www.chrisalbon.com/), [@ChrisAlbon](https://twitter.com/chrisalbon)\n", "- **Date:** -\n", "- **Repo:** [Python 3 code snippets for data science](https://github.com/chrisalbon/code_py)\n", "- **Note:**" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Import modules" ] }, { "cell_type": "code", "collapsed": false, "input": [ "from datetime import datetime\n", "import pandas as pd\n", "%matplotlib inline\n", "import matplotlib.pyplot as pyplot" ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 113 }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Create a dataframe" ] }, { "cell_type": "code", "collapsed": false, "input": [ "data = {'date': ['2014-05-01 18:47:05.069722', '2014-05-01 18:47:05.119994', '2014-05-02 18:47:05.178768', '2014-05-02 18:47:05.230071', '2014-05-02 18:47:05.230071', '2014-05-02 18:47:05.280592', '2014-05-03 18:47:05.332662', '2014-05-03 18:47:05.385109', '2014-05-04 18:47:05.436523', '2014-05-04 18:47:05.486877'], \n", " 'battle_deaths': [34, 25, 26, 15, 15, 14, 26, 25, 62, 41]}\n", "df = pd.DataFrame(data, columns = ['date', 'battle_deaths'])\n", "print(df)" ], "language": "python", "metadata": {}, "outputs": [ { "output_type": "stream", "stream": "stdout", "text": [ " date battle_deaths\n", "0 2014-05-01 18:47:05.069722 34\n", "1 2014-05-01 18:47:05.119994 25\n", "2 2014-05-02 18:47:05.178768 26\n", "3 2014-05-02 18:47:05.230071 15\n", "4 2014-05-02 18:47:05.230071 15\n", "5 2014-05-02 18:47:05.280592 14\n", "6 2014-05-03 18:47:05.332662 26\n", "7 2014-05-03 18:47:05.385109 25\n", "8 2014-05-04 18:47:05.436523 62\n", "9 2014-05-04 18:47:05.486877 41\n", "\n", "[10 rows x 2 columns]\n" ] } ], "prompt_number": 114 }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Convert df['date'] from string to datetime" ] }, { "cell_type": "code", "collapsed": false, "input": [ "df['date'] = pd.to_datetime(df['date'])" ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 115 }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Set df['date'] as the index and delete the column" ] }, { "cell_type": "code", "collapsed": false, "input": [ "df.index = df['date']\n", "del df['date']\n", "df" ], "language": "python", "metadata": {}, "outputs": [ { "html": [ "
\n", " | battle_deaths | \n", "
---|---|
date | \n", "\n", " |
2014-05-01 18:47:05.069722 | \n", "34 | \n", "
2014-05-01 18:47:05.119994 | \n", "25 | \n", "
2014-05-02 18:47:05.178768 | \n", "26 | \n", "
2014-05-02 18:47:05.230071 | \n", "15 | \n", "
2014-05-02 18:47:05.230071 | \n", "15 | \n", "
2014-05-02 18:47:05.280592 | \n", "14 | \n", "
2014-05-03 18:47:05.332662 | \n", "26 | \n", "
2014-05-03 18:47:05.385109 | \n", "25 | \n", "
2014-05-04 18:47:05.436523 | \n", "62 | \n", "
2014-05-04 18:47:05.486877 | \n", "41 | \n", "
10 rows \u00d7 1 columns
\n", "\n", " | battle_deaths | \n", "
---|---|
date | \n", "\n", " |
2014-05-01 18:47:05.069722 | \n", "34 | \n", "
2014-05-01 18:47:05.119994 | \n", "25 | \n", "
2014-05-02 18:47:05.178768 | \n", "26 | \n", "
2014-05-02 18:47:05.230071 | \n", "15 | \n", "
2014-05-02 18:47:05.230071 | \n", "15 | \n", "
2014-05-02 18:47:05.280592 | \n", "14 | \n", "
2014-05-03 18:47:05.332662 | \n", "26 | \n", "
2014-05-03 18:47:05.385109 | \n", "25 | \n", "
2014-05-04 18:47:05.436523 | \n", "62 | \n", "
2014-05-04 18:47:05.486877 | \n", "41 | \n", "
10 rows \u00d7 1 columns
\n", "\n", " | battle_deaths | \n", "
---|---|
date | \n", "\n", " |
2014-05-01 18:47:05.069722 | \n", "34 | \n", "
2014-05-01 18:47:05.119994 | \n", "25 | \n", "
2014-05-02 18:47:05.178768 | \n", "26 | \n", "
2014-05-02 18:47:05.230071 | \n", "15 | \n", "
2014-05-02 18:47:05.230071 | \n", "15 | \n", "
2014-05-02 18:47:05.280592 | \n", "14 | \n", "
2014-05-03 18:47:05.332662 | \n", "26 | \n", "
2014-05-03 18:47:05.385109 | \n", "25 | \n", "
2014-05-04 18:47:05.436523 | \n", "62 | \n", "
2014-05-04 18:47:05.486877 | \n", "41 | \n", "
10 rows \u00d7 1 columns
\n", "\n", " | battle_deaths | \n", "
---|---|
date | \n", "\n", " |
2014-05-03 18:47:05.332662 | \n", "26 | \n", "
2014-05-03 18:47:05.385109 | \n", "25 | \n", "
2014-05-04 18:47:05.436523 | \n", "62 | \n", "
2014-05-04 18:47:05.486877 | \n", "41 | \n", "
4 rows \u00d7 1 columns
\n", "\n", " | battle_deaths | \n", "
---|---|
date | \n", "\n", " |
2014-05-03 18:47:05.332662 | \n", "26 | \n", "
2014-05-03 18:47:05.385109 | \n", "25 | \n", "
2014-05-04 18:47:05.436523 | \n", "62 | \n", "
2014-05-04 18:47:05.486877 | \n", "41 | \n", "
4 rows \u00d7 1 columns
\n", "\n", " | battle_deaths | \n", "
---|---|
date | \n", "\n", " |
2014-05-01 18:47:05.069722 | \n", "34 | \n", "
2014-05-01 18:47:05.119994 | \n", "25 | \n", "
2014-05-02 18:47:05.178768 | \n", "26 | \n", "
2014-05-02 18:47:05.230071 | \n", "15 | \n", "
2014-05-02 18:47:05.230071 | \n", "15 | \n", "
2014-05-02 18:47:05.280592 | \n", "14 | \n", "
6 rows \u00d7 1 columns
\n", "\n", " | battle_deaths | \n", "
---|---|
date | \n", "\n", " |
2014-05-01 18:47:05.069722 | \n", "34 | \n", "
2014-05-01 18:47:05.119994 | \n", "25 | \n", "
2014-05-02 18:47:05.178768 | \n", "26 | \n", "
2014-05-02 18:47:05.230071 | \n", "15 | \n", "
2014-05-02 18:47:05.230071 | \n", "15 | \n", "
2014-05-02 18:47:05.280592 | \n", "14 | \n", "
2014-05-03 18:47:05.332662 | \n", "26 | \n", "
2014-05-03 18:47:05.385109 | \n", "25 | \n", "
2014-05-04 18:47:05.436523 | \n", "62 | \n", "
2014-05-04 18:47:05.486877 | \n", "41 | \n", "
10 rows \u00d7 1 columns
\n", "\n", " | battle_deaths | \n", "
---|---|
date | \n", "\n", " |
2014-05-01 18:47:05.069722 | \n", "1 | \n", "
2014-05-01 18:47:05.119994 | \n", "1 | \n", "
2014-05-02 18:47:05.178768 | \n", "1 | \n", "
2014-05-02 18:47:05.230071 | \n", "2 | \n", "
2014-05-02 18:47:05.280592 | \n", "1 | \n", "
2014-05-03 18:47:05.332662 | \n", "1 | \n", "
2014-05-03 18:47:05.385109 | \n", "1 | \n", "
2014-05-04 18:47:05.436523 | \n", "1 | \n", "
2014-05-04 18:47:05.486877 | \n", "1 | \n", "
9 rows \u00d7 1 columns
\n", "\n", " | battle_deaths | \n", "
---|---|
date | \n", "\n", " |
2014-05-01 | \n", "29.5 | \n", "
2014-05-02 | \n", "17.5 | \n", "
2014-05-03 | \n", "25.5 | \n", "
2014-05-04 | \n", "51.5 | \n", "
4 rows \u00d7 1 columns
\n", "\n", " | battle_deaths | \n", "
---|---|
date | \n", "\n", " |
2014-05-01 | \n", "59 | \n", "
2014-05-02 | \n", "70 | \n", "
2014-05-03 | \n", "51 | \n", "
2014-05-04 | \n", "103 | \n", "
4 rows \u00d7 1 columns
\n", "