Skip to content

Instantly share code, notes, and snippets.

@epifanio

epifanio/Trawl_Fall_2011_abundance_biomass.ipynb

Created February 19, 2014 06:37
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save epifanio/9087115 to your computer and use it in GitHub Desktop.
Save epifanio/9087115 to your computer and use it in GitHub Desktop.
Download ZIP
Display the source blob
Display the rendered blob
Raw
fall_abundance_biomass-Copy0-Copy0.ipynb
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
Display the source blob
Display the rendered blob
Raw
fall_abundance_biomass.ipynb
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
Display the source blob
Display the rendered blob
Raw
Trawl_Fall_2011_abundance_biomass.ipynb
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
Display the source blob
Display the rendered blob
Raw
Untitled0.ipynb
{
"worksheets": [
{
"cells": [
{
"metadata": {},
"cell_type": "code",
"input": "import pandas as pd\nimport numpy as np",
"prompt_number": 1,
"outputs": [],
"language": "python",
"trusted": true,
"collapsed": false
},
{
"metadata": {},
"cell_type": "code",
"input": "dataset = pd.read_csv('test.csv')",
"prompt_number": 2,
"outputs": [],
"language": "python",
"trusted": true,
"collapsed": false
},
{
"metadata": {},
"cell_type": "code",
"input": "#dataset = dataset.drop(['SEASON','CRUISE6','LATITUDE','LONGITUDE'], axis=1)",
"prompt_number": 3,
"outputs": [],
"language": "python",
"trusted": true,
"collapsed": false
},
{
"metadata": {},
"cell_type": "code",
"input": "newcol = []\nfor i in dataset['SVSPP'].unique():\n abundance = str(i)+'-ABUNDANCE'\n biomass = str(i)+'-BIOMASS'\n newcol.append(abundance)\n newcol.append(biomass)\n dataset[abundance] = pd.Series(np.zeros(len(dataset)), index=dataset.index)\n dataset[biomass] = pd.Series(np.zeros(len(dataset)), index=dataset.index)",
"prompt_number": 4,
"outputs": [],
"language": "python",
"trusted": true,
"collapsed": false
},
{
"metadata": {},
"cell_type": "code",
"input": "for i, v in enumerate(dataset.index):\n abundance=str(dataset['SVSPP'][i])+'-ABUNDANCE'\n biomass=str(dataset['SVSPP'][i])+'-BIOMASS'\n dataset[biomass][i] = dataset['BIOMASS'][i]\n dataset[abundance][i] = dataset['ABUNDANCE'][i]",
"prompt_number": 5,
"outputs": [],
"language": "python",
"trusted": true,
"collapsed": false
},
{
"metadata": {},
"cell_type": "code",
"input": "dataset",
"prompt_number": 6,
"outputs": [
{
"text": " SEASON CRUISE6 STATION SVSPP LATITUDE LONGITUDE ABUNDANCE BIOMASS \\\n0 FALL 201105 6 14 36.977443 -74.630740 228 5.785 \n1 FALL 201105 6 15 36.977443 -74.630740 2 0.262 \n2 FALL 201105 6 25 36.977443 -74.630740 2 0.518 \n3 FALL 201105 6 63 36.977443 -74.630740 6 0.813 \n4 FALL 201105 6 72 36.977443 -74.630740 3 0.345 \n5 FALL 201105 6 78 36.977443 -74.630740 190 19.103 \n6 FALL 201105 6 104 36.977443 -74.630740 6 0.662 \n7 FALL 201105 6 112 36.977443 -74.630740 7 0.175 \n8 FALL 201105 6 156 36.977443 -74.630740 1 0.001 \n9 FALL 201105 6 158 36.977443 -74.630740 2 0.021 \n10 FALL 201105 6 197 36.977443 -74.630740 1 0.454 \n11 FALL 201105 6 263 36.977443 -74.630740 272 6.619 \n12 FALL 201105 6 313 36.977443 -74.630740 1 0.011 \n13 FALL 201105 6 318 36.977443 -74.630740 1 2.443 \n14 FALL 201105 6 502 36.977443 -74.630740 524 38.470 \n15 FALL 201105 6 503 36.977443 -74.630740 580 26.957 \n16 FALL 201105 7 72 36.955818 -74.920427 13 1.552 \n17 FALL 201105 7 78 36.955818 -74.920427 412 24.329 \n18 FALL 201105 7 104 36.955818 -74.920427 62 5.666 \n19 FALL 201105 7 108 36.955818 -74.920427 10 3.023 \n20 FALL 201105 7 109 36.955818 -74.920427 14 0.073 \n21 FALL 201105 7 131 36.955818 -74.920427 38 1.312 \n22 FALL 201105 7 181 36.955818 -74.920427 19 0.246 \n23 FALL 201105 7 313 36.955818 -74.920427 1 0.035 \n24 FALL 201105 7 321 36.955818 -74.920427 1 0.024 \n25 FALL 201105 7 401 36.955818 -74.920427 195 7.234 \n26 FALL 201105 7 502 36.955818 -74.920427 7 0.335 \n27 FALL 201105 7 503 36.955818 -74.920427 77 6.642 \n28 FALL 201105 7 998 36.955818 -74.920427 0 0.468 \n\n 14-ABUNDANCE 14-BIOMASS 15-ABUNDANCE 15-BIOMASS 25-ABUNDANCE \\\n0 228 5.785 0 0.000 0 \n1 0 0.000 2 0.262 0 \n2 0 0.000 0 0.000 2 \n3 0 0.000 0 0.000 0 \n4 0 0.000 0 0.000 0 \n5 0 0.000 0 0.000 0 \n6 0 0.000 0 0.000 0 \n7 0 0.000 0 0.000 0 \n8 0 0.000 0 0.000 0 \n9 0 0.000 0 0.000 0 \n10 0 0.000 0 0.000 0 \n11 0 0.000 0 0.000 0 \n12 0 0.000 0 0.000 0 \n13 0 0.000 0 0.000 0 \n14 0 0.000 0 0.000 0 \n15 0 0.000 0 0.000 0 \n16 0 0.000 0 0.000 0 \n17 0 0.000 0 0.000 0 \n18 0 0.000 0 0.000 0 \n19 0 0.000 0 0.000 0 \n20 0 0.000 0 0.000 0 \n21 0 0.000 0 0.000 0 \n22 0 0.000 0 0.000 0 \n23 0 0.000 0 0.000 0 \n24 0 0.000 0 0.000 0 \n25 0 0.000 0 0.000 0 \n26 0 0.000 0 0.000 0 \n27 0 0.000 0 0.000 0 \n28 0 0.000 0 0.000 0 \n\n 25-BIOMASS 63-ABUNDANCE 63-BIOMASS 72-ABUNDANCE 72-BIOMASS \\\n0 0.000 0 0.000 0 0.000 \n1 0.000 0 0.000 0 0.000 \n2 0.518 0 0.000 0 0.000 \n3 0.000 6 0.813 0 0.000 \n4 0.000 0 0.000 3 0.345 \n5 0.000 0 0.000 0 0.000 \n6 0.000 0 0.000 0 0.000 \n7 0.000 0 0.000 0 0.000 \n8 0.000 0 0.000 0 0.000 \n9 0.000 0 0.000 0 0.000 \n10 0.000 0 0.000 0 0.000 \n11 0.000 0 0.000 0 0.000 \n12 0.000 0 0.000 0 0.000 \n13 0.000 0 0.000 0 0.000 \n14 0.000 0 0.000 0 0.000 \n15 0.000 0 0.000 0 0.000 \n16 0.000 0 0.000 13 1.552 \n17 0.000 0 0.000 0 0.000 \n18 0.000 0 0.000 0 0.000 \n19 0.000 0 0.000 0 0.000 \n20 0.000 0 0.000 0 0.000 \n21 0.000 0 0.000 0 0.000 \n22 0.000 0 0.000 0 0.000 \n23 0.000 0 0.000 0 0.000 \n24 0.000 0 0.000 0 0.000 \n25 0.000 0 0.000 0 0.000 \n26 0.000 0 0.000 0 0.000 \n27 0.000 0 0.000 0 0.000 \n28 0.000 0 0.000 0 0.000 \n\n 78-ABUNDANCE 78-BIOMASS \n0 0 0.000 ... \n1 0 0.000 ... \n2 0 0.000 ... \n3 0 0.000 ... \n4 0 0.000 ... \n5 190 19.103 ... \n6 0 0.000 ... \n7 0 0.000 ... \n8 0 0.000 ... \n9 0 0.000 ... \n10 0 0.000 ... \n11 0 0.000 ... \n12 0 0.000 ... \n13 0 0.000 ... \n14 0 0.000 ... \n15 0 0.000 ... \n16 0 0.000 ... \n17 412 24.329 ... \n18 0 0.000 ... \n19 0 0.000 ... \n20 0 0.000 ... \n21 0 0.000 ... \n22 0 0.000 ... \n23 0 0.000 ... \n24 0 0.000 ... \n25 0 0.000 ... \n26 0 0.000 ... \n27 0 0.000 ... \n28 0 0.000 ... \n\n[29 rows x 54 columns]",
"html": "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n<table border=\"1\" class=\"dataframe\">\n <thead>\n <tr style=\"text-align: right;\">\n <th></th>\n <th>SEASON</th>\n <th>CRUISE6</th>\n <th>STATION</th>\n <th>SVSPP</th>\n <th>LATITUDE</th>\n <th>LONGITUDE</th>\n <th>ABUNDANCE</th>\n <th>BIOMASS</th>\n <th>14-ABUNDANCE</th>\n <th>14-BIOMASS</th>\n <th>15-ABUNDANCE</th>\n <th>15-BIOMASS</th>\n <th>25-ABUNDANCE</th>\n <th>25-BIOMASS</th>\n <th>63-ABUNDANCE</th>\n <th>63-BIOMASS</th>\n <th>72-ABUNDANCE</th>\n <th>72-BIOMASS</th>\n <th>78-ABUNDANCE</th>\n <th>78-BIOMASS</th>\n <th></th>\n </tr>\n </thead>\n <tbody>\n <tr>\n <th>0 </th>\n <td> FALL</td>\n <td> 201105</td>\n <td> 6</td>\n <td> 14</td>\n <td> 36.977443</td>\n <td>-74.630740</td>\n <td> 228</td>\n <td> 5.785</td>\n <td> 228</td>\n <td> 5.785</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td>...</td>\n </tr>\n <tr>\n <th>1 </th>\n <td> FALL</td>\n <td> 201105</td>\n <td> 6</td>\n <td> 15</td>\n <td> 36.977443</td>\n <td>-74.630740</td>\n <td> 2</td>\n <td> 0.262</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 2</td>\n <td> 0.262</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td>...</td>\n </tr>\n <tr>\n <th>2 </th>\n <td> FALL</td>\n <td> 201105</td>\n <td> 6</td>\n <td> 25</td>\n <td> 36.977443</td>\n <td>-74.630740</td>\n <td> 2</td>\n <td> 0.518</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 2</td>\n <td> 0.518</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td>...</td>\n </tr>\n <tr>\n <th>3 </th>\n <td> FALL</td>\n <td> 201105</td>\n <td> 6</td>\n <td> 63</td>\n <td> 36.977443</td>\n <td>-74.630740</td>\n <td> 6</td>\n <td> 0.813</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 6</td>\n <td> 0.813</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td>...</td>\n </tr>\n <tr>\n <th>4 </th>\n <td> FALL</td>\n <td> 201105</td>\n <td> 6</td>\n <td> 72</td>\n <td> 36.977443</td>\n <td>-74.630740</td>\n <td> 3</td>\n <td> 0.345</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 3</td>\n <td> 0.345</td>\n <td> 0</td>\n <td> 0.000</td>\n <td>...</td>\n </tr>\n <tr>\n <th>5 </th>\n <td> FALL</td>\n <td> 201105</td>\n <td> 6</td>\n <td> 78</td>\n <td> 36.977443</td>\n <td>-74.630740</td>\n <td> 190</td>\n <td> 19.103</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 190</td>\n <td> 19.103</td>\n <td>...</td>\n </tr>\n <tr>\n <th>6 </th>\n <td> FALL</td>\n <td> 201105</td>\n <td> 6</td>\n <td> 104</td>\n <td> 36.977443</td>\n <td>-74.630740</td>\n <td> 6</td>\n <td> 0.662</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td>...</td>\n </tr>\n <tr>\n <th>7 </th>\n <td> FALL</td>\n <td> 201105</td>\n <td> 6</td>\n <td> 112</td>\n <td> 36.977443</td>\n <td>-74.630740</td>\n <td> 7</td>\n <td> 0.175</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td>...</td>\n </tr>\n <tr>\n <th>8 </th>\n <td> FALL</td>\n <td> 201105</td>\n <td> 6</td>\n <td> 156</td>\n <td> 36.977443</td>\n <td>-74.630740</td>\n <td> 1</td>\n <td> 0.001</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td>...</td>\n </tr>\n <tr>\n <th>9 </th>\n <td> FALL</td>\n <td> 201105</td>\n <td> 6</td>\n <td> 158</td>\n <td> 36.977443</td>\n <td>-74.630740</td>\n <td> 2</td>\n <td> 0.021</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td>...</td>\n </tr>\n <tr>\n <th>10</th>\n <td> FALL</td>\n <td> 201105</td>\n <td> 6</td>\n <td> 197</td>\n <td> 36.977443</td>\n <td>-74.630740</td>\n <td> 1</td>\n <td> 0.454</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td>...</td>\n </tr>\n <tr>\n <th>11</th>\n <td> FALL</td>\n <td> 201105</td>\n <td> 6</td>\n <td> 263</td>\n <td> 36.977443</td>\n <td>-74.630740</td>\n <td> 272</td>\n <td> 6.619</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td>...</td>\n </tr>\n <tr>\n <th>12</th>\n <td> FALL</td>\n <td> 201105</td>\n <td> 6</td>\n <td> 313</td>\n <td> 36.977443</td>\n <td>-74.630740</td>\n <td> 1</td>\n <td> 0.011</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td>...</td>\n </tr>\n <tr>\n <th>13</th>\n <td> FALL</td>\n <td> 201105</td>\n <td> 6</td>\n <td> 318</td>\n <td> 36.977443</td>\n <td>-74.630740</td>\n <td> 1</td>\n <td> 2.443</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td>...</td>\n </tr>\n <tr>\n <th>14</th>\n <td> FALL</td>\n <td> 201105</td>\n <td> 6</td>\n <td> 502</td>\n <td> 36.977443</td>\n <td>-74.630740</td>\n <td> 524</td>\n <td> 38.470</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td>...</td>\n </tr>\n <tr>\n <th>15</th>\n <td> FALL</td>\n <td> 201105</td>\n <td> 6</td>\n <td> 503</td>\n <td> 36.977443</td>\n <td>-74.630740</td>\n <td> 580</td>\n <td> 26.957</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td>...</td>\n </tr>\n <tr>\n <th>16</th>\n <td> FALL</td>\n <td> 201105</td>\n <td> 7</td>\n <td> 72</td>\n <td> 36.955818</td>\n <td>-74.920427</td>\n <td> 13</td>\n <td> 1.552</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 13</td>\n <td> 1.552</td>\n <td> 0</td>\n <td> 0.000</td>\n <td>...</td>\n </tr>\n <tr>\n <th>17</th>\n <td> FALL</td>\n <td> 201105</td>\n <td> 7</td>\n <td> 78</td>\n <td> 36.955818</td>\n <td>-74.920427</td>\n <td> 412</td>\n <td> 24.329</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 412</td>\n <td> 24.329</td>\n <td>...</td>\n </tr>\n <tr>\n <th>18</th>\n <td> FALL</td>\n <td> 201105</td>\n <td> 7</td>\n <td> 104</td>\n <td> 36.955818</td>\n <td>-74.920427</td>\n <td> 62</td>\n <td> 5.666</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td>...</td>\n </tr>\n <tr>\n <th>19</th>\n <td> FALL</td>\n <td> 201105</td>\n <td> 7</td>\n <td> 108</td>\n <td> 36.955818</td>\n <td>-74.920427</td>\n <td> 10</td>\n <td> 3.023</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td>...</td>\n </tr>\n <tr>\n <th>20</th>\n <td> FALL</td>\n <td> 201105</td>\n <td> 7</td>\n <td> 109</td>\n <td> 36.955818</td>\n <td>-74.920427</td>\n <td> 14</td>\n <td> 0.073</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td>...</td>\n </tr>\n <tr>\n <th>21</th>\n <td> FALL</td>\n <td> 201105</td>\n <td> 7</td>\n <td> 131</td>\n <td> 36.955818</td>\n <td>-74.920427</td>\n <td> 38</td>\n <td> 1.312</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td>...</td>\n </tr>\n <tr>\n <th>22</th>\n <td> FALL</td>\n <td> 201105</td>\n <td> 7</td>\n <td> 181</td>\n <td> 36.955818</td>\n <td>-74.920427</td>\n <td> 19</td>\n <td> 0.246</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td>...</td>\n </tr>\n <tr>\n <th>23</th>\n <td> FALL</td>\n <td> 201105</td>\n <td> 7</td>\n <td> 313</td>\n <td> 36.955818</td>\n <td>-74.920427</td>\n <td> 1</td>\n <td> 0.035</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td>...</td>\n </tr>\n <tr>\n <th>24</th>\n <td> FALL</td>\n <td> 201105</td>\n <td> 7</td>\n <td> 321</td>\n <td> 36.955818</td>\n <td>-74.920427</td>\n <td> 1</td>\n <td> 0.024</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td>...</td>\n </tr>\n <tr>\n <th>25</th>\n <td> FALL</td>\n <td> 201105</td>\n <td> 7</td>\n <td> 401</td>\n <td> 36.955818</td>\n <td>-74.920427</td>\n <td> 195</td>\n <td> 7.234</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td>...</td>\n </tr>\n <tr>\n <th>26</th>\n <td> FALL</td>\n <td> 201105</td>\n <td> 7</td>\n <td> 502</td>\n <td> 36.955818</td>\n <td>-74.920427</td>\n <td> 7</td>\n <td> 0.335</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td>...</td>\n </tr>\n <tr>\n <th>27</th>\n <td> FALL</td>\n <td> 201105</td>\n <td> 7</td>\n <td> 503</td>\n <td> 36.955818</td>\n <td>-74.920427</td>\n <td> 77</td>\n <td> 6.642</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td>...</td>\n </tr>\n <tr>\n <th>28</th>\n <td> FALL</td>\n <td> 201105</td>\n <td> 7</td>\n <td> 998</td>\n <td> 36.955818</td>\n <td>-74.920427</td>\n <td> 0</td>\n <td> 0.468</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td>...</td>\n </tr>\n </tbody>\n</table>\n<p>29 rows × 54 columns</p>\n</div>",
"output_type": "pyout",
"metadata": {},
"prompt_number": 6
}
],
"language": "python",
"trusted": true,
"collapsed": false
},
{
"metadata": {},
"cell_type": "code",
"input": "df = dataset.groupby(['STATION'])[newcol].sum()",
"prompt_number": 8,
"outputs": [],
"language": "python",
"trusted": true,
"collapsed": false
},
{
"metadata": {},
"cell_type": "code",
"input": "df",
"prompt_number": 9,
"outputs": [
{
"text": " 14-ABUNDANCE 14-BIOMASS 15-ABUNDANCE 15-BIOMASS 25-ABUNDANCE \\\nSTATION \n6 228 5.785 2 0.262 2 \n7 0 0.000 0 0.000 0 \n\n 25-BIOMASS 63-ABUNDANCE 63-BIOMASS 72-ABUNDANCE 72-BIOMASS \\\nSTATION \n6 0.518 6 0.813 3 0.345 \n7 0.000 0 0.000 13 1.552 \n\n 78-ABUNDANCE 78-BIOMASS 104-ABUNDANCE 104-BIOMASS 112-ABUNDANCE \\\nSTATION \n6 190 19.103 6 0.662 7 \n7 412 24.329 62 5.666 0 \n\n 112-BIOMASS 156-ABUNDANCE 156-BIOMASS 158-ABUNDANCE 158-BIOMASS \\\nSTATION \n6 0.175 1 0.001 2 0.021 \n7 0.000 0 0.000 0 0.000 \n\n \nSTATION \n6 ... \n7 ... \n\n[2 rows x 46 columns]",
"html": "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n<table border=\"1\" class=\"dataframe\">\n <thead>\n <tr style=\"text-align: right;\">\n <th></th>\n <th>14-ABUNDANCE</th>\n <th>14-BIOMASS</th>\n <th>15-ABUNDANCE</th>\n <th>15-BIOMASS</th>\n <th>25-ABUNDANCE</th>\n <th>25-BIOMASS</th>\n <th>63-ABUNDANCE</th>\n <th>63-BIOMASS</th>\n <th>72-ABUNDANCE</th>\n <th>72-BIOMASS</th>\n <th>78-ABUNDANCE</th>\n <th>78-BIOMASS</th>\n <th>104-ABUNDANCE</th>\n <th>104-BIOMASS</th>\n <th>112-ABUNDANCE</th>\n <th>112-BIOMASS</th>\n <th>156-ABUNDANCE</th>\n <th>156-BIOMASS</th>\n <th>158-ABUNDANCE</th>\n <th>158-BIOMASS</th>\n <th></th>\n </tr>\n <tr>\n <th>STATION</th>\n <th></th>\n <th></th>\n <th></th>\n <th></th>\n <th></th>\n <th></th>\n <th></th>\n <th></th>\n <th></th>\n <th></th>\n <th></th>\n <th></th>\n <th></th>\n <th></th>\n <th></th>\n <th></th>\n <th></th>\n <th></th>\n <th></th>\n <th></th>\n </tr>\n </thead>\n <tbody>\n <tr>\n <th>6</th>\n <td> 228</td>\n <td> 5.785</td>\n <td> 2</td>\n <td> 0.262</td>\n <td> 2</td>\n <td> 0.518</td>\n <td> 6</td>\n <td> 0.813</td>\n <td> 3</td>\n <td> 0.345</td>\n <td> 190</td>\n <td> 19.103</td>\n <td> 6</td>\n <td> 0.662</td>\n <td> 7</td>\n <td> 0.175</td>\n <td> 1</td>\n <td> 0.001</td>\n <td> 2</td>\n <td> 0.021</td>\n <td>...</td>\n </tr>\n <tr>\n <th>7</th>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 13</td>\n <td> 1.552</td>\n <td> 412</td>\n <td> 24.329</td>\n <td> 62</td>\n <td> 5.666</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td> 0</td>\n <td> 0.000</td>\n <td>...</td>\n </tr>\n </tbody>\n</table>\n<p>2 rows × 46 columns</p>\n</div>",
"output_type": "pyout",
"metadata": {},
"prompt_number": 9
}
],
"language": "python",
"trusted": true,
"collapsed": false
},
{
"metadata": {},
"cell_type": "code",
"input": "",
"outputs": [],
"language": "python",
"trusted": true,
"collapsed": false
}
],
"metadata": {}
}
],
"metadata": {
"name": "",
"signature": "sha256:88817da47c1516dd5aff9608411e5a010bd8352e9a58b386462354e3bfcbcce1",
"gist_id": "9087115"
},
"nbformat": 3
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment