{ "metadata": { "name": "" }, "nbformat": 3, "nbformat_minor": 0, "worksheets": [ { "cells": [ { "cell_type": "code", "collapsed": false, "input": [ "from IPython.display import HTML\n", "import requests\n", "import pandas as pd\n", "import MySQLdb\n", "import pandas.io.sql as psql\n", "import datetime\n", "import time\n", "import pytz\n", "import time\n", "import matplotlib.dates as mdates\n", "import matplotlib.pyplot as plt\n", "import matplotlib\n", "styles = requests.get(\"https://raw.github.com/CamDavidsonPilon/Probabilistic-Programming-and-Bayesian-Methods-for-Hackers/master/styles/custom.css\")\n", "HTML(styles.text)\n", "import json\n", "s = requests.get(\"https://raw.github.com/CamDavidsonPilon/Probabilistic-Programming-and-Bayesian-Methods-for-Hackers/master/styles/bmh_matplotlibrc.json\").json()\n", "matplotlib.rcParams.update(s)" ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 1 }, { "cell_type": "markdown", "metadata": {}, "source": [ "This is a test" ] }, { "cell_type": "code", "collapsed": false, "input": [ "pd.read_csv(" ], "language": "python", "metadata": {}, "outputs": [] }, { "cell_type": "code", "collapsed": false, "input": [ "df=pd.read_csv(\"/home/nipun/study/datasets/UMASS/homeA-all/homeA-phase/2012-Jul-1-p1.csv\",names=['timestamp','frequency','voltage'])" ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 2 }, { "cell_type": "code", "collapsed": false, "input": [ "df" ], "language": "python", "metadata": {}, "outputs": [ { "html": [ "
\n", "<class 'pandas.core.frame.DataFrame'>\n", "Int64Index: 85386 entries, 0 to 85385\n", "Data columns (total 3 columns):\n", "timestamp 85386 non-null values\n", "frequency 85386 non-null values\n", "voltage 85386 non-null values\n", "dtypes: float64(2), int64(1)\n", "" ], "metadata": {}, "output_type": "pyout", "prompt_number": 8, "text": [ "
\n", " | timestamp | \n", "frequency | \n", "voltage | \n", "
---|---|---|---|
count | \n", "8.538600e+04 | \n", "85386.000000 | \n", "85386.000000 | \n", "
mean | \n", "1.341091e+09 | \n", "59.993085 | \n", "120.571565 | \n", "
std | \n", "2.490415e+04 | \n", "0.018714 | \n", "1.057214 | \n", "
min | \n", "1.341048e+09 | \n", "59.930000 | \n", "116.851000 | \n", "
25% | \n", "1.341069e+09 | \n", "59.978000 | \n", "119.959000 | \n", "
50% | \n", "1.341091e+09 | \n", "59.988000 | \n", "120.644000 | \n", "
75% | \n", "1.341113e+09 | \n", "60.008000 | \n", "121.242000 | \n", "
max | \n", "1.341134e+09 | \n", "60.072000 | \n", "150.831000 | \n", "
\n", "<class 'pandas.core.frame.DataFrame'>\n", "DatetimeIndex: 85386 entries, 2012-06-30 09:17:42 to 2012-07-01 09:15:31\n", "Data columns (total 2 columns):\n", "frequency 85386 non-null values\n", "voltage 85386 non-null values\n", "dtypes: float64(2)\n", "" ], "metadata": {}, "output_type": "pyout", "prompt_number": 4, "text": [ "