{ "metadata": { "name": "", "signature": "sha256:4b6279f8f8c98c91277cd35efba1b9942d245a8def2c68055f42c09fe015939d" }, "nbformat": 3, "nbformat_minor": 0, "worksheets": [ { "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# Join And Merge 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": [ "### import modules" ] }, { "cell_type": "code", "collapsed": false, "input": [ "import pandas as pd\n", "from IPython.display import display\n", "from IPython.display import Image" ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 2 }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Create a dataframe" ] }, { "cell_type": "code", "collapsed": false, "input": [ "raw_data = {\n", " 'subject_id': ['1', '2', '3', '4', '5'],\n", " 'first_name': ['Alex', 'Amy', 'Allen', 'Alice', 'Ayoung'], \n", " 'last_name': ['Anderson', 'Ackerman', 'Ali', 'Aoni', 'Atiches']}\n", "df_a = pd.DataFrame(raw_data, columns = ['subject_id', 'first_name', 'last_name'])\n", "df_a" ], "language": "python", "metadata": {}, "outputs": [ { "html": [ "
\n", " | subject_id | \n", "first_name | \n", "last_name | \n", "
---|---|---|---|
0 | \n", "1 | \n", "Alex | \n", "Anderson | \n", "
1 | \n", "2 | \n", "Amy | \n", "Ackerman | \n", "
2 | \n", "3 | \n", "Allen | \n", "Ali | \n", "
3 | \n", "4 | \n", "Alice | \n", "Aoni | \n", "
4 | \n", "5 | \n", "Ayoung | \n", "Atiches | \n", "
5 rows \u00d7 3 columns
\n", "\n", " | subject_id | \n", "first_name | \n", "last_name | \n", "
---|---|---|---|
0 | \n", "4 | \n", "Billy | \n", "Bonder | \n", "
1 | \n", "5 | \n", "Brian | \n", "Black | \n", "
2 | \n", "6 | \n", "Bran | \n", "Balwner | \n", "
3 | \n", "7 | \n", "Bryce | \n", "Brice | \n", "
4 | \n", "8 | \n", "Betty | \n", "Btisan | \n", "
5 rows \u00d7 3 columns
\n", "\n", " | subject_id | \n", "test_id | \n", "
---|---|---|
0 | \n", "1 | \n", "51 | \n", "
1 | \n", "2 | \n", "15 | \n", "
2 | \n", "3 | \n", "15 | \n", "
3 | \n", "4 | \n", "61 | \n", "
4 | \n", "5 | \n", "16 | \n", "
5 | \n", "7 | \n", "14 | \n", "
6 | \n", "8 | \n", "15 | \n", "
7 | \n", "9 | \n", "1 | \n", "
8 | \n", "10 | \n", "61 | \n", "
9 | \n", "11 | \n", "16 | \n", "
10 rows \u00d7 2 columns
\n", "\n", " | subject_id | \n", "first_name | \n", "last_name | \n", "
---|---|---|---|
0 | \n", "1 | \n", "Alex | \n", "Anderson | \n", "
1 | \n", "2 | \n", "Amy | \n", "Ackerman | \n", "
2 | \n", "3 | \n", "Allen | \n", "Ali | \n", "
3 | \n", "4 | \n", "Alice | \n", "Aoni | \n", "
4 | \n", "5 | \n", "Ayoung | \n", "Atiches | \n", "
0 | \n", "4 | \n", "Billy | \n", "Bonder | \n", "
1 | \n", "5 | \n", "Brian | \n", "Black | \n", "
2 | \n", "6 | \n", "Bran | \n", "Balwner | \n", "
3 | \n", "7 | \n", "Bryce | \n", "Brice | \n", "
4 | \n", "8 | \n", "Betty | \n", "Btisan | \n", "
10 rows \u00d7 3 columns
\n", "\n", " | subject_id | \n", "first_name | \n", "last_name | \n", "subject_id | \n", "first_name | \n", "last_name | \n", "
---|---|---|---|---|---|---|
0 | \n", "1 | \n", "Alex | \n", "Anderson | \n", "4 | \n", "Billy | \n", "Bonder | \n", "
1 | \n", "2 | \n", "Amy | \n", "Ackerman | \n", "5 | \n", "Brian | \n", "Black | \n", "
2 | \n", "3 | \n", "Allen | \n", "Ali | \n", "6 | \n", "Bran | \n", "Balwner | \n", "
3 | \n", "4 | \n", "Alice | \n", "Aoni | \n", "7 | \n", "Bryce | \n", "Brice | \n", "
4 | \n", "5 | \n", "Ayoung | \n", "Atiches | \n", "8 | \n", "Betty | \n", "Btisan | \n", "
5 rows \u00d7 6 columns
\n", "