Advertisement
Guest User

Untitled

a guest
Jun 23rd, 2017
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.03 KB | None | 0 0
  1. {
  2. "cells": [
  3. {
  4. "cell_type": "code",
  5. "execution_count": 1,
  6. "metadata": {},
  7. "outputs": [
  8. {
  9. "name": "stderr",
  10. "output_type": "stream",
  11. "text": [
  12. "/Users/seanmcowen/anaconda/lib/python3.6/site-packages/IPython/core/interactiveshell.py:2821: DtypeWarning: Columns (1,50,54,55) have mixed types. Specify dtype option on import or set low_memory=False.\n",
  13. " if self.run_code(code, result):\n"
  14. ]
  15. }
  16. ],
  17. "source": [
  18. "import pandas as pd\n",
  19. "import numpy as np\n",
  20. "import gmplot\n",
  21. "Assess_Combined = pd.DataFrame.from_csv(\"Assess_Combined.csv\",encoding=\"UTF-8\")"
  22. ]
  23. },
  24. {
  25. "cell_type": "code",
  26. "execution_count": 2,
  27. "metadata": {},
  28. "outputs": [
  29. {
  30. "name": "stdout",
  31. "output_type": "stream",
  32. "text": [
  33. "0100001000_ 89-59\n",
  34. "0100002000_ 89-59\n",
  35. "0100003000_ 89-59\n",
  36. "0100004000_ 89-59\n",
  37. "0100005000_ 89-59\n",
  38. "0100006000_ 89-59\n",
  39. "0100007000_ 89-59\n",
  40. "0100008000_ 89-59\n",
  41. "0100009000_ 89-59\n",
  42. "0100010000_ 89-59\n",
  43. "0100011000_ 89-59\n",
  44. "0100012000_ 89-59\n",
  45. "0100013000_ 90-59\n",
  46. "0100014000_ 90-59\n",
  47. "0100015000_ 90-59\n",
  48. "0100016000_ 90-59\n",
  49. "0100017000_ 90-59\n",
  50. "0100018000_ 90-59\n",
  51. "0100019000_ 90-59\n",
  52. "0100020000_ 90-59\n",
  53. "0100021000_ 90-59\n",
  54. "0100022000_ 90-59\n",
  55. "0100023000_ 90-59\n",
  56. "0100024000_ 90-59\n",
  57. "0100025000_ 90-59\n",
  58. "0100026000_ 90-59\n",
  59. "0100027000_ 90-59\n",
  60. "0100028000_ 90-59\n",
  61. "0100029000_ 90-60\n",
  62. "0100030000_ 90-59\n",
  63. " ... \n",
  64. "2205647000_ 69-8\n",
  65. "2205648000_ 69-8\n",
  66. "2205649000_ 69-8\n",
  67. "2205650000_ 69-8\n",
  68. "2205651000_ 69-7\n",
  69. "2205652002_ 67-6\n",
  70. "2205652003_ 67-6\n",
  71. "2205652005_ 67-6\n",
  72. "2205652007_ 67-6\n",
  73. "2205652008_ 66-6\n",
  74. "2205652009_ 66-6\n",
  75. "2205652010_ 66-6\n",
  76. "2205653000_ 66-7\n",
  77. "2205654000_ 66-7\n",
  78. "2205655000_ 66-7\n",
  79. "2205656000_ 66-7\n",
  80. "2205657000_ 67-7\n",
  81. "2205658000_ 67-7\n",
  82. "2205659000_ 67-7\n",
  83. "2205660000_ 66-7\n",
  84. "2205662010_ 66-7\n",
  85. "2205662020_ 66-7\n",
  86. "2205663000_ 66-7\n",
  87. "2205663001_ 66-7\n",
  88. "2205664000_ 66-7\n",
  89. "2205666000_ 66-7\n",
  90. "2205667000_ 66-7\n",
  91. "2205668000_ 66-7\n",
  92. "2205669000_ 66-7\n",
  93. "2205670000_ 66-6\n",
  94. "Length: 90332, dtype: object\n"
  95. ]
  96. }
  97. ],
  98. "source": [
  99. "print(Assess_Combined[\"Lat Group\"].astype(str)+\"-\"+Assess_Combined[\"Lon Group\"].astype(str))"
  100. ]
  101. },
  102. {
  103. "cell_type": "code",
  104. "execution_count": 3,
  105. "metadata": {
  106. "collapsed": true
  107. },
  108. "outputs": [],
  109. "source": [
  110. "Assess_Combined[\"LocCode\"] = Assess_Combined[\"Lat Group\"].astype(str)+\"-\"+Assess_Combined[\"Lon Group\"].astype(str)"
  111. ]
  112. },
  113. {
  114. "cell_type": "code",
  115. "execution_count": 4,
  116. "metadata": {
  117. "collapsed": true
  118. },
  119. "outputs": [],
  120. "source": [
  121. "Assess_Combined = Assess_Combined.groupby(\"LocCode\").mean()"
  122. ]
  123. },
  124. {
  125. "cell_type": "code",
  126. "execution_count": 5,
  127. "metadata": {
  128. "collapsed": true
  129. },
  130. "outputs": [],
  131. "source": [
  132. "latMax = 42.39615117\n",
  133. "latMin = 42.23108386\n",
  134. "lonMax = -70.92757284\n",
  135. "lonMin = -71.18485204\n",
  136. "slice_constant = 100\n",
  137. "latIncrement = (latMax-latMin)/slice_constant\n",
  138. "lonIncrement = (lonMax-lonMin)/slice_constant"
  139. ]
  140. },
  141. {
  142. "cell_type": "code",
  143. "execution_count": 6,
  144. "metadata": {
  145. "collapsed": true
  146. },
  147. "outputs": [],
  148. "source": [
  149. "Assess_Combined[\"Lat 0\"] = latMin+Assess_Combined[\"Lat Group\"]*latIncrement\n",
  150. "Assess_Combined[\"Lat 1\"] = latMin+(Assess_Combined[\"Lat Group\"]+.5)*latIncrement\n",
  151. "Assess_Combined[\"Lat 2\"] = latMin+(Assess_Combined[\"Lat Group\"]+1)*latIncrement\n",
  152. "Assess_Combined[\"Lon 0\"] = lonMin+Assess_Combined[\"Lon Group\"]*lonIncrement\n",
  153. "Assess_Combined[\"Lon 1\"] = lonMin+(Assess_Combined[\"Lon Group\"]+.5)*lonIncrement\n",
  154. "Assess_Combined[\"Lon 2\"] = lonMin+(Assess_Combined[\"Lon Group\"]+1)*lonIncrement"
  155. ]
  156. },
  157. {
  158. "cell_type": "code",
  159. "execution_count": 7,
  160. "metadata": {
  161. "collapsed": true
  162. },
  163. "outputs": [],
  164. "source": [
  165. "Assess_Combined.to_csv(\"MapData.csv\",encoding=\"UTF-8\")"
  166. ]
  167. }
  168. ],
  169. "metadata": {
  170. "kernelspec": {
  171. "display_name": "Python 3",
  172. "language": "python",
  173. "name": "python3"
  174. },
  175. "language_info": {
  176. "codemirror_mode": {
  177. "name": "ipython",
  178. "version": 3
  179. },
  180. "file_extension": ".py",
  181. "mimetype": "text/x-python",
  182. "name": "python",
  183. "nbconvert_exporter": "python",
  184. "pygments_lexer": "ipython3",
  185. "version": "3.6.1"
  186. }
  187. },
  188. "nbformat": 4,
  189. "nbformat_minor": 2
  190. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement