geohash解码.ipynb · 张毅/手机信令数据

加入 Gitee

与超过 1200万开发者一起发现、参与优秀开源项目，私有仓库也完全免费：）

文件

该仓库未声明开源许可证文件（LICENSE），使用请关注具体项目描述及其代码上游依赖。

克隆/下载

geohash解码.ipynb 9.23 KB

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-04-21T08:03:05.183268Z",
     "start_time": "2022-04-21T08:03:05.165534Z"
    }
   },
   "outputs": [],
   "source": [
    "import  pandas as pd\n",
    "import numpy as np\n",
    "import geohash"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-04-21T08:03:10.474018Z",
     "start_time": "2022-04-21T08:03:10.299546Z"
    }
   },
   "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>geohash</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>wttf12e</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>wttf0mr</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>wttccpz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>wttf11j</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>wttf1pz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1657</th>\n",
       "      <td>wttf18f</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1658</th>\n",
       "      <td>wttf16q</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1659</th>\n",
       "      <td>wttf14y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1660</th>\n",
       "      <td>wttccrw</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1661</th>\n",
       "      <td>wttf13y</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1662 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      geohash\n",
       "0     wttf12e\n",
       "1     wttf0mr\n",
       "2     wttccpz\n",
       "3     wttf11j\n",
       "4     wttf1pz\n",
       "...       ...\n",
       "1657  wttf18f\n",
       "1658  wttf16q\n",
       "1659  wttf14y\n",
       "1660  wttccrw\n",
       "1661  wttf13y\n",
       "\n",
       "[1662 rows x 1 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 读取含基站编码字段的数据\n",
    "base_station = pd.read_csv(r\"ancient_buffer.csv\", header = None)\n",
    "base_station.columns = ['geohash']\n",
    "base_station"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-04-21T08:03:48.924473Z",
     "start_time": "2022-04-21T08:03:48.913179Z"
    }
   },
   "outputs": [],
   "source": [
    "## geohash解码函数，需要提前导入geohash包\n",
    "def geohash_decode(df):\n",
    "    try:\n",
    "        df['lat'],df['lon'] = zip(*df['geohash'].apply(lambda x: geohash.decode(x)))\n",
    "        return df\n",
    "    except ValueError:\n",
    "        raise QueryObjectValidationError(_(\"Invalid geohash string\"))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-04-21T08:04:10.265235Z",
     "start_time": "2022-04-21T08:04:10.208668Z"
    }
   },
   "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>geohash</th>\n",
       "      <th>lat</th>\n",
       "      <th>lon</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>wttf12e</td>\n",
       "      <td>31.292496</td>\n",
       "      <td>120.645676</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>wttf0mr</td>\n",
       "      <td>31.318588</td>\n",
       "      <td>120.607224</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>wttccpz</td>\n",
       "      <td>31.288376</td>\n",
       "      <td>120.640182</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>wttf11j</td>\n",
       "      <td>31.295242</td>\n",
       "      <td>120.637436</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>wttf1pz</td>\n",
       "      <td>31.332321</td>\n",
       "      <td>120.640182</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1657</th>\n",
       "      <td>wttf18f</td>\n",
       "      <td>31.293869</td>\n",
       "      <td>120.655289</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1658</th>\n",
       "      <td>wttf16q</td>\n",
       "      <td>31.302109</td>\n",
       "      <td>120.649796</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1659</th>\n",
       "      <td>wttf14y</td>\n",
       "      <td>31.304855</td>\n",
       "      <td>120.638809</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1660</th>\n",
       "      <td>wttccrw</td>\n",
       "      <td>31.287003</td>\n",
       "      <td>120.649796</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1661</th>\n",
       "      <td>wttf13y</td>\n",
       "      <td>31.299362</td>\n",
       "      <td>120.649796</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1662 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      geohash        lat         lon\n",
       "0     wttf12e  31.292496  120.645676\n",
       "1     wttf0mr  31.318588  120.607224\n",
       "2     wttccpz  31.288376  120.640182\n",
       "3     wttf11j  31.295242  120.637436\n",
       "4     wttf1pz  31.332321  120.640182\n",
       "...       ...        ...         ...\n",
       "1657  wttf18f  31.293869  120.655289\n",
       "1658  wttf16q  31.302109  120.649796\n",
       "1659  wttf14y  31.304855  120.638809\n",
       "1660  wttccrw  31.287003  120.649796\n",
       "1661  wttf13y  31.299362  120.649796\n",
       "\n",
       "[1662 rows x 3 columns]"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 解码结果\n",
    "geohash_decode(base_station)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-04-21T08:04:22.962799Z",
     "start_time": "2022-04-21T08:04:22.948693Z"
    }
   },
   "outputs": [],
   "source": [
    "# 保存结果\n",
    "base_station.to_csv(r\"base_station.csv\")"
   ]
  }
 ],
 "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.8.3"
  },
  "toc": {
   "base_numbering": 1,
   "nav_menu": {},
   "number_sections": true,
   "sideBar": true,
   "skip_h1_title": false,
   "title_cell": "Table of Contents",
   "title_sidebar": "Contents",
   "toc_cell": false,
   "toc_position": {},
   "toc_section_display": true,
   "toc_window_display": false
  },
  "varInspector": {
   "cols": {
    "lenName": 16,
    "lenType": 16,
    "lenVar": 40
   },
   "kernels_config": {
    "python": {
     "delete_cmd_postfix": "",
     "delete_cmd_prefix": "del ",
     "library": "var_list.py",
     "varRefreshCmd": "print(var_dic_list())"
    },
    "r": {
     "delete_cmd_postfix": ") ",
     "delete_cmd_prefix": "rm(",
     "library": "var_list.r",
     "varRefreshCmd": "cat(var_dic_list()) "
    }
   },
   "types_to_exclude": [
    "module",
    "function",
    "builtin_function_or_method",
    "instance",
    "_Feature"
   ],
   "window_display": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}

一键复制编辑原始数据按行查看历史

提交于 2022-04-21 08:06 . 手机基站genhash解码

马建仓 AI 助手

尝试更多

代码解读

代码找茬

代码优化

张毅/手机信令数据

简介

发行版

贡献者

近期动态