使用百度地图接口分别依据注册地和办公地详细地址解析详细经度和纬度
包含变量说明:
序号 | 变量 | 变量说明 |
1 | id | 证券代码 |
2 | id_org | 证券代码-字符串 |
3 | year | 年份 |
4 | Stknme | 证券简称(补全) |
5 | regaddress | 注册地址-补全 |
6 | offaddress | 办公地址-补全 |
7 | Isaddsm | 注册地办公地是否相同 |
8 | reglng | 经度-注册地详细(BD-90坐标系) |
9 | reglat | 纬度-注册地详细(BD-90坐标系) |
10 | offlng | 经度-办公地地详细(BD-90坐标系) |
11 | offlat | 纬度-办公地地详细(BD-90坐标系) |
各年度观测值数量:
年份 | 观测值 |
1990 | 12 |
1991 | 18 |
1992 | 78 |
1993 | 236 |
1994 | 362 |
1995 | 397 |
1996 | 618 |
1997 | 839 |
1998 | 947 |
1999 | 1,055 |
2000 | 1,203 |
2001 | 1,264 |
2002 | 1,328 |
2003 | 1,388 |
2004 | 1,482 |
2005 | 1,484 |
2006 | 1,561 |
2007 | 1,674 |
2008 | 1,719 |
2009 | 1,876 |
2010 | 2,227 |
2011 | 2,459 |
2012 | 2,587 |
2013 | 2,634 |
2014 | 2,848 |
2015 | 3,006 |
2016 | 3,339 |
2017 | 3,629 |
2018 | 3,722 |
2019 | 3,964 |
2020 | 4,384 |
缺失值情况:
Variable | Missing | Total | Percent Missing |
id | 0 | 54,340 | 0 |
id_org | 0 | 54,340 | 0 |
year | 0 | 54,340 | 0 |
Stknme | 6 | 54,340 | 0.01 |
regaddress | 2,242 | 54,340 | 4.13 |
offaddress | 2,242 | 54,340 | 4.13 |
Isaddsm | 2,242 | 54,340 | 4.13 |
reglng | 2,259 | 54,340 | 4.16 |
reglat | 2,259 | 54,340 | 4.16 |
offlng | 2,265 | 54,340 | 4.17 |
offlat | 2,265 | 54,340 | 4.17 |
数据截图:
