{
"metadata": {
"name": "",
"signature": "sha256:97417e41196e2c4663067edbc30cf6ff7e90880fbdd105091c612f38a09297b8"
},
"nbformat": 3,
"nbformat_minor": 0,
"worksheets": [
{
"cells": [
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# Select Rows That Have A Certain Value\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": "code",
"collapsed": false,
"input": [
"import pandas as pd"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 1
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"# Create an example dataframe\n",
"data = {'name': ['Jason', 'Molly'], \n",
" 'country': [['Syria', 'Lebanon'],['Spain', 'Morocco']]}\n",
"df = pd.DataFrame(data)\n",
"df"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"
\n",
"
\n",
" \n",
" \n",
" | \n",
" country | \n",
" name | \n",
"
\n",
" \n",
" \n",
" \n",
" 0 | \n",
" [Syria, Lebanon] | \n",
" Jason | \n",
"
\n",
" \n",
" 1 | \n",
" [Spain, Morocco] | \n",
" Molly | \n",
"
\n",
" \n",
"
\n",
"
"
],
"metadata": {},
"output_type": "pyout",
"prompt_number": 5,
"text": [
" country name\n",
"0 [Syria, Lebanon] Jason\n",
"1 [Spain, Morocco] Molly"
]
}
],
"prompt_number": 5
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"df[df['country'].map(lambda country: 'Syria' in country)]"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"\n",
"
\n",
" \n",
" \n",
" | \n",
" country | \n",
" name | \n",
"
\n",
" \n",
" \n",
" \n",
" 0 | \n",
" [Syria, Lebanon] | \n",
" Jason | \n",
"
\n",
" \n",
"
\n",
"
"
],
"metadata": {},
"output_type": "pyout",
"prompt_number": 11,
"text": [
" country name\n",
"0 [Syria, Lebanon] Jason"
]
}
],
"prompt_number": 11
}
],
"metadata": {}
}
]
}