{ "metadata": { "name": "", "signature": "sha256:5822ff5a28d4b248ed0b4e19e85616950ff014eb8db7a8c356c0499462573616" }, "nbformat": 3, "nbformat_minor": 0, "worksheets": [ { "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# Map External Values To Dataframe Values in Pandas\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": [ "import pandas as pd" ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 2 }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Create dataframe" ] }, { "cell_type": "code", "collapsed": false, "input": [ "raw_data = {'first_name': ['Jason', 'Molly', 'Tina', 'Jake', 'Amy'], \n", " 'last_name': ['Miller', 'Jacobson', 'Ali', 'Milner', 'Cooze'], \n", " 'age': [42, 52, 36, 24, 73], \n", " 'city': ['San Francisco', 'Baltimore', 'Miami', 'Douglas', 'Boston']}\n", "df = pd.DataFrame(raw_data, columns = ['first_name', 'last_name', 'age', 'city'])\n", "df" ], "language": "python", "metadata": {}, "outputs": [ { "html": [ "
\n", " | first_name | \n", "last_name | \n", "age | \n", "city | \n", "
---|---|---|---|---|
0 | \n", "Jason | \n", "Miller | \n", "42 | \n", "San Francisco | \n", "
1 | \n", "Molly | \n", "Jacobson | \n", "52 | \n", "Baltimore | \n", "
2 | \n", "Tina | \n", "Ali | \n", "36 | \n", "Miami | \n", "
3 | \n", "Jake | \n", "Milner | \n", "24 | \n", "Douglas | \n", "
4 | \n", "Amy | \n", "Cooze | \n", "73 | \n", "Boston | \n", "
5 rows \u00d7 4 columns
\n", "\n", " | first_name | \n", "last_name | \n", "age | \n", "city | \n", "state | \n", "
---|---|---|---|---|---|
0 | \n", "Jason | \n", "Miller | \n", "42 | \n", "San Francisco | \n", "California | \n", "
1 | \n", "Molly | \n", "Jacobson | \n", "52 | \n", "Baltimore | \n", "Maryland | \n", "
2 | \n", "Tina | \n", "Ali | \n", "36 | \n", "Miami | \n", "Florida | \n", "
3 | \n", "Jake | \n", "Milner | \n", "24 | \n", "Douglas | \n", "Arizona | \n", "
4 | \n", "Amy | \n", "Cooze | \n", "73 | \n", "Boston | \n", "Massachusetts | \n", "
5 rows \u00d7 5 columns
\n", "