{ "cells": [ { "cell_type": "markdown", "metadata": { "slideshow": { "slide_type": "slide" } }, "source": [ "# Importing Data" ] }, { "cell_type": "code", "execution_count": 1, "metadata": { "collapsed": false, "slideshow": { "slide_type": "fragment" } }, "outputs": [ { "data": { "text/plain": [ "'0.17.0'" ] }, "execution_count": 1, "metadata": {}, "output_type": "execute_result" } ], "source": [ "import numpy as np\n", "import pandas as pd\n", "pd.options.display.max_rows = 6\n", "pd.options.display.max_columns = 8\n", "pd.__version__ " ] }, { "cell_type": "markdown", "metadata": { "slideshow": { "slide_type": "slide" } }, "source": [ "We often times have a variety of input data.\n", "\n", "- CSV\n", "- Excel\n", "- SQL\n", "- JSON\n", "- HDF5\n", "- pickle\n", "- msgpack\n", "- Stata\n", "- BigQuery" ] }, { "cell_type": "markdown", "metadata": { "slideshow": { "slide_type": "subslide" } }, "source": [ "This is subset of the data from beeradvocate.com, via [Standford](https://snap.stanford.edu/data/web-RateBeer.html). It's strangely formatted.\n", "\n", "This dataset is no longer available!\n", "\n", "
\n",
"beer/name: Sausa Weizen
\n",
"beer/beerI: 47986
\n",
"beer/brewerId: 10325
\n",
"beer/ABV: 5.00
\n",
"beer/style: Hefeweizen
\n",
"review/appearance: 2.5
\n",
"review/aroma: 2
\n",
"review/time: 1234817823
\n",
"review/profileName: stcules
\n",
"review/text: A lot of foam. But a lot.\tIn the smell some banana, and then lactic and tart. Not a good start.\tQuite dark orange in color, with a lively carbonation (now visible, under the foam).\tAgain tending to lactic sourness.\tSame for the taste. With some yeast and banana.
\n",
"
\n",
"beer/name: Red Moon
\n",
"beer/beerId: 48213
\n",
"beer/brewerId: 10325
\n",
"beer/ABV: 6.20
\n",
" ...
\n",
"
\n", " | abv | \n", "beer_id | \n", "brewer_id | \n", "beer_name | \n", "... | \n", "profile_name | \n", "review_taste | \n", "text | \n", "time | \n", "
---|---|---|---|---|---|---|---|---|---|
0 | \n", "7.0 | \n", "2511 | \n", "287 | \n", "Bell's Cherry Stout | \n", "... | \n", "blaheath | \n", "4.5 | \n", "Batch 8144\\tPitch black in color with a 1/2 f... | \n", "2009-10-05 21:31:48 | \n", "
1 | \n", "5.7 | \n", "19736 | \n", "9790 | \n", "Duck-Rabbit Porter | \n", "... | \n", "GJ40 | \n", "4.0 | \n", "Sampled from a 12oz bottle in a standard pint... | \n", "2009-10-05 21:32:09 | \n", "
2 | \n", "4.8 | \n", "11098 | \n", "3182 | \n", "Fürstenberg Premium Pilsener | \n", "... | \n", "biegaman | \n", "3.5 | \n", "Haystack yellow with an energetic group of bu... | \n", "2009-10-05 21:32:13 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
49997 | \n", "8.1 | \n", "21950 | \n", "2372 | \n", "Terrapin Coffee Oatmeal Imperial Stout | \n", "... | \n", "ugaterrapin | \n", "4.5 | \n", "Poured a light sucking crude oil beckoning bl... | \n", "2009-12-25 17:23:52 | \n", "
49998 | \n", "4.6 | \n", "5453 | \n", "1306 | \n", "Badger Original Ale | \n", "... | \n", "MrHurmateeowish | \n", "3.5 | \n", "500ml brown bottle, 4.0% ABV. Pours a crystal... | \n", "2009-12-25 17:25:06 | \n", "
49999 | \n", "9.4 | \n", "47695 | \n", "14879 | \n", "Barrel Aged B.O.R.I.S. Oatmeal Imperial Stout | \n", "... | \n", "strictly4DK | \n", "4.5 | \n", "22 oz bottle poured into a flute glass, share... | \n", "2009-12-25 17:26:06 | \n", "
50000 rows × 13 columns
\n", "\n", " | abv | \n", "beer_id | \n", "brewer_id | \n", "beer_name | \n", "... | \n", "profile_name | \n", "review_taste | \n", "text | \n", "time | \n", "
---|---|---|---|---|---|---|---|---|---|
6663 | \n", "4.5 | \n", "47562 | \n", "13307 | \n", "It's Alright! | \n", "... | \n", "Frogzilla | \n", "1.0 | \n", "NaN | \n", "2009-10-16 00:51:28 | \n", "
13012 | \n", "8.0 | \n", "2508 | \n", "222 | \n", "Maredsous 8 - Dubbel | \n", "... | \n", "Flightoficarus | \n", "4.0 | \n", "NaN | \n", "2009-10-28 08:09:25 | \n", "
21034 | \n", "6.5 | \n", "14378 | \n", "2593 | \n", "Cherry Porter | \n", "... | \n", "CurtisFagan | \n", "4.5 | \n", "NaN | \n", "2009-11-09 23:57:11 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
40357 | \n", "9.5 | \n", "47785 | \n", "35 | \n", "Samuel Adams Double Bock (Imperial Series) | \n", "... | \n", "zeapo | \n", "4.0 | \n", "NaN | \n", "2009-12-10 01:42:08 | \n", "
40968 | \n", "9.2 | \n", "47360 | \n", "35 | \n", "Samuel Adams Imperial Stout | \n", "... | \n", "zeapo | \n", "3.0 | \n", "NaN | \n", "2009-12-11 02:14:19 | \n", "
48669 | \n", "5.0 | \n", "924 | \n", "142 | \n", "Franziskaner Hefe-Weisse Dunkel | \n", "... | \n", "VTBobcat | \n", "5.0 | \n", "NaN | \n", "2009-12-23 13:54:37 | \n", "
9 rows × 13 columns
\n", "