{
"metadata": {
"name": "",
"signature": "sha256:5251f3960b0e6c43b2d44db80416713d6cbe8c9f5d6119e13a079b7e75fab20c"
},
"nbformat": 3,
"nbformat_minor": 0,
"worksheets": [
{
"cells": [
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# Select Rows With Multiple Filters\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\n",
"import pandas as pd"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 10
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"# Create an example dataframe\n",
"data = {'name': ['A', 'B', 'C', 'D', 'E'], \n",
" 'score': [1,2,3,4,5]}\n",
"df = pd.DataFrame(data)\n",
"df"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"
\n",
"
\n",
" \n",
" \n",
" | \n",
" name | \n",
" score | \n",
"
\n",
" \n",
" \n",
" \n",
" 0 | \n",
" A | \n",
" 1 | \n",
"
\n",
" \n",
" 1 | \n",
" B | \n",
" 2 | \n",
"
\n",
" \n",
" 2 | \n",
" C | \n",
" 3 | \n",
"
\n",
" \n",
" 3 | \n",
" D | \n",
" 4 | \n",
"
\n",
" \n",
" 4 | \n",
" E | \n",
" 5 | \n",
"
\n",
" \n",
"
\n",
"
"
],
"metadata": {},
"output_type": "pyout",
"prompt_number": 7,
"text": [
" name score\n",
"0 A 1\n",
"1 B 2\n",
"2 C 3\n",
"3 D 4\n",
"4 E 5"
]
}
],
"prompt_number": 7
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"# Select rows of the dataframe where df.score is greater than 1 and less and 5\n",
"df[(df['score'] > 1) & (df['score'] < 5)]"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"\n",
"
\n",
" \n",
" \n",
" | \n",
" name | \n",
" score | \n",
"
\n",
" \n",
" \n",
" \n",
" 1 | \n",
" B | \n",
" 2 | \n",
"
\n",
" \n",
" 2 | \n",
" C | \n",
" 3 | \n",
"
\n",
" \n",
" 3 | \n",
" D | \n",
" 4 | \n",
"
\n",
" \n",
"
\n",
"
"
],
"metadata": {},
"output_type": "pyout",
"prompt_number": 11,
"text": [
" name score\n",
"1 B 2\n",
"2 C 3\n",
"3 D 4"
]
}
],
"prompt_number": 11
}
],
"metadata": {}
}
]
}