Skip to content

Instantly share code, notes, and snippets.

@Raahul-Singh

Raahul-Singh/3.ipynb

Created June 28, 2020 23:09
Show Gist options
  • Save Raahul-Singh/3280346b54e8346d1d9c2b57f1803789 to your computer and use it in GitHub Desktop.
Save Raahul-Singh/3280346b54e8346d1d9c2b57f1803789 to your computer and use it in GitHub Desktop.
Download ZIP
Display the source blob
Display the rendered blob
Raw
3.ipynb
{
"cells": [
{
"cell_type": "code",
"execution_count": 3,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>filename</th>\n",
" <th>zooniverse_id</th>\n",
" <th>angle</th>\n",
" <th>area</th>\n",
" <th>areafrac</th>\n",
" <th>areathesh</th>\n",
" <th>bipolesep</th>\n",
" <th>c1flr24hr</th>\n",
" <th>id_filename</th>\n",
" <th>flux</th>\n",
" <th>...</th>\n",
" <th>hcpos_x</th>\n",
" <th>hcpos_y</th>\n",
" <th>m1flr12hr</th>\n",
" <th>m5flr12hr</th>\n",
" <th>n_nar</th>\n",
" <th>noaa</th>\n",
" <th>pxpos_x</th>\n",
" <th>pxpos_y</th>\n",
" <th>sszn</th>\n",
" <th>zurich</th>\n",
" </tr>\n",
" <tr>\n",
" <th>#id</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",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>530be1183ae74079c300000d.jpg</td>\n",
" <td>ASZ000090y</td>\n",
" <td>37.8021</td>\n",
" <td>34400.0</td>\n",
" <td>0.12</td>\n",
" <td>2890.0</td>\n",
" <td>3.72</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>2.180000e+22</td>\n",
" <td>...</td>\n",
" <td>452.26991</td>\n",
" <td>443.92976</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>8809</td>\n",
" <td>229.19344</td>\n",
" <td>166.87700</td>\n",
" <td>1</td>\n",
" <td>bxo</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>530be1183ae74079c300000f.jpg</td>\n",
" <td>ASZ000090o</td>\n",
" <td>37.3590</td>\n",
" <td>78700.0</td>\n",
" <td>-0.00</td>\n",
" <td>6170.0</td>\n",
" <td>7.28</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>5.760000e+22</td>\n",
" <td>...</td>\n",
" <td>149.64301</td>\n",
" <td>621.53865</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>8810</td>\n",
" <td>200.41511</td>\n",
" <td>154.54088</td>\n",
" <td>2</td>\n",
" <td>fao</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>530be1183ae74079c3000011.jpg</td>\n",
" <td>ASZ0000946</td>\n",
" <td>58.6197</td>\n",
" <td>37900.0</td>\n",
" <td>0.08</td>\n",
" <td>937.0</td>\n",
" <td>3.88</td>\n",
" <td>0</td>\n",
" <td>3</td>\n",
" <td>2.150000e+22</td>\n",
" <td>...</td>\n",
" <td>704.04967</td>\n",
" <td>-436.33152</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>8812</td>\n",
" <td>205.30165</td>\n",
" <td>154.98689</td>\n",
" <td>3</td>\n",
" <td>axx</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>530be1183ae74079c3000013.jpg</td>\n",
" <td>ASZ000090v</td>\n",
" <td>32.3099</td>\n",
" <td>31200.0</td>\n",
" <td>0.12</td>\n",
" <td>1720.0</td>\n",
" <td>4.90</td>\n",
" <td>0</td>\n",
" <td>4</td>\n",
" <td>1.660000e+22</td>\n",
" <td>...</td>\n",
" <td>-449.47446</td>\n",
" <td>-234.01929</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>8813</td>\n",
" <td>207.95782</td>\n",
" <td>169.12196</td>\n",
" <td>4</td>\n",
" <td>dro</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>530be1183ae74079c3000015.jpg</td>\n",
" <td>ASZ000090x</td>\n",
" <td>49.9221</td>\n",
" <td>88400.0</td>\n",
" <td>0.05</td>\n",
" <td>6480.0</td>\n",
" <td>12.48</td>\n",
" <td>0</td>\n",
" <td>5</td>\n",
" <td>6.130000e+22</td>\n",
" <td>...</td>\n",
" <td>-735.40990</td>\n",
" <td>208.46232</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>8814</td>\n",
" <td>183.10649</td>\n",
" <td>165.00398</td>\n",
" <td>5</td>\n",
" <td>hax</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>530be1183ae74079c3000017.jpg</td>\n",
" <td>ASZ000090q</td>\n",
" <td>41.7276</td>\n",
" <td>66500.0</td>\n",
" <td>-0.04</td>\n",
" <td>5450.0</td>\n",
" <td>7.45</td>\n",
" <td>0</td>\n",
" <td>6</td>\n",
" <td>4.510000e+22</td>\n",
" <td>...</td>\n",
" <td>307.16437</td>\n",
" <td>621.26440</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>8810</td>\n",
" <td>200.89942</td>\n",
" <td>158.90942</td>\n",
" <td>6</td>\n",
" <td>fao</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>530be1183ae74079c3000019.jpg</td>\n",
" <td>ASZ000090w</td>\n",
" <td>21.4421</td>\n",
" <td>31300.0</td>\n",
" <td>0.05</td>\n",
" <td>1930.0</td>\n",
" <td>5.32</td>\n",
" <td>1</td>\n",
" <td>7</td>\n",
" <td>1.580000e+22</td>\n",
" <td>...</td>\n",
" <td>-232.85591</td>\n",
" <td>-226.07368</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>8813</td>\n",
" <td>202.77628</td>\n",
" <td>166.14022</td>\n",
" <td>7</td>\n",
" <td>dso</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>530be1183ae74079c300001b.jpg</td>\n",
" <td>ASZ000090p</td>\n",
" <td>30.3312</td>\n",
" <td>49700.0</td>\n",
" <td>0.28</td>\n",
" <td>2670.0</td>\n",
" <td>1.86</td>\n",
" <td>0</td>\n",
" <td>8</td>\n",
" <td>2.430000e+22</td>\n",
" <td>...</td>\n",
" <td>-464.25581</td>\n",
" <td>230.57762</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>8814</td>\n",
" <td>191.95662</td>\n",
" <td>171.67525</td>\n",
" <td>8</td>\n",
" <td>hhx</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>530be1183ae74079c300001d.jpg</td>\n",
" <td>ASZ00008tg</td>\n",
" <td>42.8451</td>\n",
" <td>33600.0</td>\n",
" <td>-0.20</td>\n",
" <td>3850.0</td>\n",
" <td>6.03</td>\n",
" <td>1</td>\n",
" <td>9</td>\n",
" <td>2.840000e+22</td>\n",
" <td>...</td>\n",
" <td>-649.56237</td>\n",
" <td>212.13884</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>8815</td>\n",
" <td>197.90666</td>\n",
" <td>174.86663</td>\n",
" <td>9</td>\n",
" <td>cro</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>530be1183ae74079c300001f.jpg</td>\n",
" <td>ASZ00008sz</td>\n",
" <td>48.1351</td>\n",
" <td>51300.0</td>\n",
" <td>0.06</td>\n",
" <td>4750.0</td>\n",
" <td>7.52</td>\n",
" <td>1</td>\n",
" <td>10</td>\n",
" <td>4.060000e+22</td>\n",
" <td>...</td>\n",
" <td>452.20395</td>\n",
" <td>616.94779</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>8810</td>\n",
" <td>203.09814</td>\n",
" <td>158.22423</td>\n",
" <td>10</td>\n",
" <td>eao</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>10 rows × 22 columns</p>\n",
"</div>"
],
"text/plain": [
" filename zooniverse_id angle area areafrac \\\n",
"#id \n",
"1 530be1183ae74079c300000d.jpg ASZ000090y 37.8021 34400.0 0.12 \n",
"2 530be1183ae74079c300000f.jpg ASZ000090o 37.3590 78700.0 -0.00 \n",
"3 530be1183ae74079c3000011.jpg ASZ0000946 58.6197 37900.0 0.08 \n",
"4 530be1183ae74079c3000013.jpg ASZ000090v 32.3099 31200.0 0.12 \n",
"5 530be1183ae74079c3000015.jpg ASZ000090x 49.9221 88400.0 0.05 \n",
"6 530be1183ae74079c3000017.jpg ASZ000090q 41.7276 66500.0 -0.04 \n",
"7 530be1183ae74079c3000019.jpg ASZ000090w 21.4421 31300.0 0.05 \n",
"8 530be1183ae74079c300001b.jpg ASZ000090p 30.3312 49700.0 0.28 \n",
"9 530be1183ae74079c300001d.jpg ASZ00008tg 42.8451 33600.0 -0.20 \n",
"10 530be1183ae74079c300001f.jpg ASZ00008sz 48.1351 51300.0 0.06 \n",
"\n",
" areathesh bipolesep c1flr24hr id_filename flux ... \\\n",
"#id ... \n",
"1 2890.0 3.72 0 1 2.180000e+22 ... \n",
"2 6170.0 7.28 0 2 5.760000e+22 ... \n",
"3 937.0 3.88 0 3 2.150000e+22 ... \n",
"4 1720.0 4.90 0 4 1.660000e+22 ... \n",
"5 6480.0 12.48 0 5 6.130000e+22 ... \n",
"6 5450.0 7.45 0 6 4.510000e+22 ... \n",
"7 1930.0 5.32 1 7 1.580000e+22 ... \n",
"8 2670.0 1.86 0 8 2.430000e+22 ... \n",
"9 3850.0 6.03 1 9 2.840000e+22 ... \n",
"10 4750.0 7.52 1 10 4.060000e+22 ... \n",
"\n",
" hcpos_x hcpos_y m1flr12hr m5flr12hr n_nar noaa pxpos_x \\\n",
"#id \n",
"1 452.26991 443.92976 0 0 1 8809 229.19344 \n",
"2 149.64301 621.53865 0 0 1 8810 200.41511 \n",
"3 704.04967 -436.33152 0 0 1 8812 205.30165 \n",
"4 -449.47446 -234.01929 0 0 1 8813 207.95782 \n",
"5 -735.40990 208.46232 0 0 2 8814 183.10649 \n",
"6 307.16437 621.26440 0 0 1 8810 200.89942 \n",
"7 -232.85591 -226.07368 0 0 1 8813 202.77628 \n",
"8 -464.25581 230.57762 0 0 1 8814 191.95662 \n",
"9 -649.56237 212.13884 0 0 1 8815 197.90666 \n",
"10 452.20395 616.94779 0 0 1 8810 203.09814 \n",
"\n",
" pxpos_y sszn zurich \n",
"#id \n",
"1 166.87700 1 bxo \n",
"2 154.54088 2 fao \n",
"3 154.98689 3 axx \n",
"4 169.12196 4 dro \n",
"5 165.00398 5 hax \n",
"6 158.90942 6 fao \n",
"7 166.14022 7 dso \n",
"8 171.67525 8 hhx \n",
"9 174.86663 9 cro \n",
"10 158.22423 10 eao \n",
"\n",
"[10 rows x 22 columns]"
]
},
"execution_count": 3,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"properties.head(10)"
]
},
{
"cell_type": "code",
"execution_count": 4,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>#id</th>\n",
" <th>count</th>\n",
" <th>k_value</th>\n",
" <th>score</th>\n",
" <th>std_dev</th>\n",
" </tr>\n",
" <tr>\n",
" <th>image_id</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>1</th>\n",
" <td>2779</td>\n",
" <td>50</td>\n",
" <td>8</td>\n",
" <td>1126.778324</td>\n",
" <td>1.707604</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>10010</td>\n",
" <td>50</td>\n",
" <td>8</td>\n",
" <td>1312.434736</td>\n",
" <td>2.397493</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>10</td>\n",
" <td>50</td>\n",
" <td>8</td>\n",
" <td>962.280235</td>\n",
" <td>1.945574</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>5718</td>\n",
" <td>50</td>\n",
" <td>8</td>\n",
" <td>1199.623395</td>\n",
" <td>1.894883</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>8599</td>\n",
" <td>50</td>\n",
" <td>8</td>\n",
" <td>1270.270911</td>\n",
" <td>1.207558</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>9385</td>\n",
" <td>50</td>\n",
" <td>8</td>\n",
" <td>1293.377418</td>\n",
" <td>1.454489</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>7288</td>\n",
" <td>50</td>\n",
" <td>8</td>\n",
" <td>1236.575624</td>\n",
" <td>2.318417</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>6152</td>\n",
" <td>50</td>\n",
" <td>8</td>\n",
" <td>1209.593634</td>\n",
" <td>1.790289</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>9607</td>\n",
" <td>50</td>\n",
" <td>8</td>\n",
" <td>1299.871029</td>\n",
" <td>3.015982</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>9828</td>\n",
" <td>50</td>\n",
" <td>8</td>\n",
" <td>1306.593595</td>\n",
" <td>1.143226</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" #id count k_value score std_dev\n",
"image_id \n",
"1 2779 50 8 1126.778324 1.707604\n",
"2 10010 50 8 1312.434736 2.397493\n",
"3 10 50 8 962.280235 1.945574\n",
"4 5718 50 8 1199.623395 1.894883\n",
"5 8599 50 8 1270.270911 1.207558\n",
"6 9385 50 8 1293.377418 1.454489\n",
"7 7288 50 8 1236.575624 2.318417\n",
"8 6152 50 8 1209.593634 1.790289\n",
"9 9607 50 8 1299.871029 3.015982\n",
"10 9828 50 8 1306.593595 1.143226"
]
},
"execution_count": 4,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"rankings.head(10)"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {},
"outputs": [],
"source": []
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 3",
"language": "python",
"name": "python3"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 3
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython3",
"version": "3.6.10"
}
},
"nbformat": 4,
"nbformat_minor": 4
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment