{ "metadata": { "name": "" }, "nbformat": 3, "nbformat_minor": 0, "worksheets": [ { "cells": [ { "cell_type": "code", "collapsed": false, "input": [ "import pandas as pd\n", "import numpy as np" ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 31 }, { "cell_type": "code", "collapsed": false, "input": [ "# Sample Data about student test scores from two classes\n", "class_data = [{ 'student': 'AJ',\n", " 'class': 'A',\n", " 'score': 9\n", " },\n", " { 'student': 'Paul',\n", " 'class': 'A',\n", " 'score': 8\n", " },\n", " { 'student': 'Raymond',\n", " 'class': 'A',\n", " 'score': 7\n", " },\n", " { 'student': 'Jenny',\n", " 'class': 'B',\n", " 'score': 5\n", " },\n", " { 'student': 'Pete',\n", " 'class': 'B',\n", " 'score': 4\n", " },\n", " { 'student': 'Colin',\n", " 'class': 'B',\n", " 'score': 6\n", " },\n", " { 'student': 'Sarah',\n", " 'class': 'B',\n", " 'score': 4\n", " }]" ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 1 }, { "cell_type": "code", "collapsed": false, "input": [ "df = pd.DataFrame(class_data)" ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 3 }, { "cell_type": "code", "collapsed": false, "input": [ "# What does the dataframe look like?\n", "df" ], "language": "python", "metadata": {}, "outputs": [ { "html": [ "
\n", " | class | \n", "score | \n", "student | \n", "
---|---|---|---|
0 | \n", "A | \n", "9 | \n", "AJ | \n", "
1 | \n", "A | \n", "8 | \n", "Paul | \n", "
2 | \n", "A | \n", "7 | \n", "Raymond | \n", "
3 | \n", "B | \n", "5 | \n", "Jenny | \n", "
4 | \n", "B | \n", "4 | \n", "Pete | \n", "
5 | \n", "B | \n", "6 | \n", "Colin | \n", "
6 | \n", "B | \n", "4 | \n", "Sarah | \n", "
7 rows \u00d7 3 columns
\n", "\n", " | class | \n", "score | \n", "student | \n", "
---|---|---|---|
0 | \n", "A | \n", "9 | \n", "AJ | \n", "
1 | \n", "A | \n", "8 | \n", "Paul | \n", "
2 | \n", "A | \n", "7 | \n", "Raymond | \n", "
3 rows \u00d7 3 columns
\n", "\n", " | score | \n", "
---|---|
class | \n", "\n", " |
A | \n", "8.00 | \n", "
B | \n", "4.75 | \n", "
2 rows \u00d7 1 columns
\n", "\n", " | std | \n", "sum | \n", "mean | \n", "
---|---|---|---|
class | \n", "\n", " | \n", " | \n", " |
A | \n", "1.000000 | \n", "24 | \n", "8.00 | \n", "
B | \n", "0.957427 | \n", "19 | \n", "4.75 | \n", "
2 rows \u00d7 3 columns
\n", "