Skip to content

Instantly share code, notes, and snippets.

@tdhopper

tdhopper/gist:3711204

Created September 13, 2012 01:22
Show Gist options
  • Save tdhopper/3711204 to your computer and use it in GitHub Desktop.
Save tdhopper/3711204 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
{
"metadata": {
"name": "Merging Data Frames"
},
"nbformat": 3,
"nbformat_minor": 0,
"worksheets": [
{
"cells": [
{
"cell_type": "code",
"collapsed": false,
"input": "numpy.savetxt(\"file1.csv\", numpy.random.normal(size=(7,3)), delimiter=\",\")\nnumpy.savetxt(\"file2.csv\", numpy.random.normal(size=(7,3)), delimiter=\",\")",
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 14
},
{
"cell_type": "code",
"collapsed": false,
"input": "import pandas",
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 11
},
{
"cell_type": "code",
"collapsed": false,
"input": "f1 = pandas.read_csv(\"file1.csv\", header = None)\nf2 = pandas.read_csv(\"file2.csv\", header = None)",
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 23
},
{
"cell_type": "code",
"collapsed": false,
"input": "f1",
"language": "python",
"metadata": {},
"outputs": [
{
"html": "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n<table border=\"1\">\n <thead>\n <tr>\n <th></th>\n <th>X.1</th>\n <th>X.2</th>\n <th>X.3</th>\n </tr>\n </thead>\n <tbody>\n <tr>\n <td><strong>0</strong></td>\n <td>-0.398747</td>\n <td> 0.498443</td>\n <td> 0.553908</td>\n </tr>\n <tr>\n <td><strong>1</strong></td>\n <td>-1.371074</td>\n <td>-0.346257</td>\n <td>-0.268270</td>\n </tr>\n <tr>\n <td><strong>2</strong></td>\n <td>-0.042595</td>\n <td> 0.661341</td>\n <td>-0.640765</td>\n </tr>\n <tr>\n <td><strong>3</strong></td>\n <td> 1.931924</td>\n <td>-3.453337</td>\n <td> 1.207765</td>\n </tr>\n <tr>\n <td><strong>4</strong></td>\n <td>-0.715127</td>\n <td>-0.800099</td>\n <td> 0.605309</td>\n </tr>\n <tr>\n <td><strong>5</strong></td>\n <td>-1.005760</td>\n <td>-0.447523</td>\n <td> 0.551159</td>\n </tr>\n <tr>\n <td><strong>6</strong></td>\n <td>-0.716301</td>\n <td> 1.166535</td>\n <td> 0.728681</td>\n </tr>\n </tbody>\n</table>\n</div>",
"output_type": "pyout",
"prompt_number": 19,
"text": " X.1 X.2 X.3\n0 -0.398747 0.498443 0.553908\n1 -1.371074 -0.346257 -0.268270\n2 -0.042595 0.661341 -0.640765\n3 1.931924 -3.453337 1.207765\n4 -0.715127 -0.800099 0.605309\n5 -1.005760 -0.447523 0.551159\n6 -0.716301 1.166535 0.728681"
}
],
"prompt_number": 19
},
{
"cell_type": "code",
"collapsed": false,
"input": "f2",
"language": "python",
"metadata": {},
"outputs": [
{
"html": "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n<table border=\"1\">\n <thead>\n <tr>\n <th></th>\n <th>X.1</th>\n <th>X.2</th>\n <th>X.3</th>\n </tr>\n </thead>\n <tbody>\n <tr>\n <td><strong>0</strong></td>\n <td> 0.147528</td>\n <td>-1.607256</td>\n <td> 0.033917</td>\n </tr>\n <tr>\n <td><strong>1</strong></td>\n <td> 0.449321</td>\n <td>-1.579790</td>\n <td>-0.589327</td>\n </tr>\n <tr>\n <td><strong>2</strong></td>\n <td> 0.581571</td>\n <td>-1.317813</td>\n <td>-1.579735</td>\n </tr>\n <tr>\n <td><strong>3</strong></td>\n <td> 0.446966</td>\n <td> 0.064398</td>\n <td> 0.749430</td>\n </tr>\n <tr>\n <td><strong>4</strong></td>\n <td>-1.037817</td>\n <td> 1.026397</td>\n <td> 0.553983</td>\n </tr>\n <tr>\n <td><strong>5</strong></td>\n <td> 1.177842</td>\n <td>-0.532528</td>\n <td>-0.644432</td>\n </tr>\n <tr>\n <td><strong>6</strong></td>\n <td>-0.442669</td>\n <td>-0.247462</td>\n <td> 0.725477</td>\n </tr>\n </tbody>\n</table>\n</div>",
"output_type": "pyout",
"prompt_number": 24,
"text": " X.1 X.2 X.3\n0 0.147528 -1.607256 0.033917\n1 0.449321 -1.579790 -0.589327\n2 0.581571 -1.317813 -1.579735\n3 0.446966 0.064398 0.749430\n4 -1.037817 1.026397 0.553983\n5 1.177842 -0.532528 -0.644432\n6 -0.442669 -0.247462 0.725477"
}
],
"prompt_number": 24
},
{
"cell_type": "code",
"collapsed": false,
"input": "pandas.concat([f1, f2], axis=1)",
"language": "python",
"metadata": {},
"outputs": [
{
"html": "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n<table border=\"1\">\n <thead>\n <tr>\n <th></th>\n <th>X.1</th>\n <th>X.2</th>\n <th>X.3</th>\n <th>X.1</th>\n <th>X.2</th>\n <th>X.3</th>\n </tr>\n </thead>\n <tbody>\n <tr>\n <td><strong>0</strong></td>\n <td>-0.398747</td>\n <td> 0.498443</td>\n <td> 0.553908</td>\n <td> 0.147528</td>\n <td>-1.607256</td>\n <td> 0.033917</td>\n </tr>\n <tr>\n <td><strong>1</strong></td>\n <td>-1.371074</td>\n <td>-0.346257</td>\n <td>-0.268270</td>\n <td> 0.449321</td>\n <td>-1.579790</td>\n <td>-0.589327</td>\n </tr>\n <tr>\n <td><strong>2</strong></td>\n <td>-0.042595</td>\n <td> 0.661341</td>\n <td>-0.640765</td>\n <td> 0.581571</td>\n <td>-1.317813</td>\n <td>-1.579735</td>\n </tr>\n <tr>\n <td><strong>3</strong></td>\n <td> 1.931924</td>\n <td>-3.453337</td>\n <td> 1.207765</td>\n <td> 0.446966</td>\n <td> 0.064398</td>\n <td> 0.749430</td>\n </tr>\n <tr>\n <td><strong>4</strong></td>\n <td>-0.715127</td>\n <td>-0.800099</td>\n <td> 0.605309</td>\n <td>-1.037817</td>\n <td> 1.026397</td>\n <td> 0.553983</td>\n </tr>\n <tr>\n <td><strong>5</strong></td>\n <td>-1.005760</td>\n <td>-0.447523</td>\n <td> 0.551159</td>\n <td> 1.177842</td>\n <td>-0.532528</td>\n <td>-0.644432</td>\n </tr>\n <tr>\n <td><strong>6</strong></td>\n <td>-0.716301</td>\n <td> 1.166535</td>\n <td> 0.728681</td>\n <td>-0.442669</td>\n <td>-0.247462</td>\n <td> 0.725477</td>\n </tr>\n </tbody>\n</table>\n</div>",
"output_type": "pyout",
"prompt_number": 31,
"text": " X.1 X.2 X.3 X.1 X.2 X.3\n0 -0.398747 0.498443 0.553908 0.147528 -1.607256 0.033917\n1 -1.371074 -0.346257 -0.268270 0.449321 -1.579790 -0.589327\n2 -0.042595 0.661341 -0.640765 0.581571 -1.317813 -1.579735\n3 1.931924 -3.453337 1.207765 0.446966 0.064398 0.749430\n4 -0.715127 -0.800099 0.605309 -1.037817 1.026397 0.553983\n5 -1.005760 -0.447523 0.551159 1.177842 -0.532528 -0.644432\n6 -0.716301 1.166535 0.728681 -0.442669 -0.247462 0.725477"
}
],
"prompt_number": 31
}
],
"metadata": {}
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment