{
"metadata": {
"name": "",
"signature": "sha256:582acd4f604de48957e594c4d3d97947e49fe64c63fe18bb8b3b200edebaa0d2"
},
"nbformat": 3,
"nbformat_minor": 0,
"worksheets": [
{
"cells": [
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# Lower Case Column Names In Pandas Dataframe\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": [
"## Preliminaries"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"# Import modules\n",
"import pandas as pd\n",
"\n",
"# Set ipython's max row display\n",
"pd.set_option('display.max_row', 1000)\n",
"\n",
"# Set iPython's max column width to 50\n",
"pd.set_option('display.max_columns', 50)"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 1
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Create an example dataframe"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"# Create an example dataframe\n",
"data = {'NAME': ['Jason', 'Molly', 'Tina', 'Jake', 'Amy'], \n",
" 'YEAR': [2012, 2012, 2013, 2014, 2014], \n",
" 'REPORTS': [4, 24, 31, 2, 3]}\n",
"df = pd.DataFrame(data, index = ['Cochice', 'Pima', 'Santa Cruz', 'Maricopa', 'Yuma'])\n",
"df"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"
\n",
"
\n",
" \n",
" \n",
" | \n",
" NAME | \n",
" REPORTS | \n",
" YEAR | \n",
"
\n",
" \n",
" \n",
" \n",
" Cochice | \n",
" Jason | \n",
" 4 | \n",
" 2012 | \n",
"
\n",
" \n",
" Pima | \n",
" Molly | \n",
" 24 | \n",
" 2012 | \n",
"
\n",
" \n",
" Santa Cruz | \n",
" Tina | \n",
" 31 | \n",
" 2013 | \n",
"
\n",
" \n",
" Maricopa | \n",
" Jake | \n",
" 2 | \n",
" 2014 | \n",
"
\n",
" \n",
" Yuma | \n",
" Amy | \n",
" 3 | \n",
" 2014 | \n",
"
\n",
" \n",
"
\n",
"
"
],
"metadata": {},
"output_type": "pyout",
"prompt_number": 5,
"text": [
" NAME REPORTS YEAR\n",
"Cochice Jason 4 2012\n",
"Pima Molly 24 2012\n",
"Santa Cruz Tina 31 2013\n",
"Maricopa Jake 2 2014\n",
"Yuma Amy 3 2014"
]
}
],
"prompt_number": 5
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Lowercase column values"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"# Map the lowering function to all column names\n",
"df.columns = map(str.lower, df.columns)"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 6
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"df"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"\n",
"
\n",
" \n",
" \n",
" | \n",
" name | \n",
" reports | \n",
" year | \n",
"
\n",
" \n",
" \n",
" \n",
" Cochice | \n",
" Jason | \n",
" 4 | \n",
" 2012 | \n",
"
\n",
" \n",
" Pima | \n",
" Molly | \n",
" 24 | \n",
" 2012 | \n",
"
\n",
" \n",
" Santa Cruz | \n",
" Tina | \n",
" 31 | \n",
" 2013 | \n",
"
\n",
" \n",
" Maricopa | \n",
" Jake | \n",
" 2 | \n",
" 2014 | \n",
"
\n",
" \n",
" Yuma | \n",
" Amy | \n",
" 3 | \n",
" 2014 | \n",
"
\n",
" \n",
"
\n",
"
"
],
"metadata": {},
"output_type": "pyout",
"prompt_number": 7,
"text": [
" name reports year\n",
"Cochice Jason 4 2012\n",
"Pima Molly 24 2012\n",
"Santa Cruz Tina 31 2013\n",
"Maricopa Jake 2 2014\n",
"Yuma Amy 3 2014"
]
}
],
"prompt_number": 7
}
],
"metadata": {}
}
]
}