class CrimeModel:
def __init__(self):
self.dr = DataReader()
def hook_process(self):
print('-------------1. CCTV 파일로 DF 생성 ------------')
self.get_crime()
def get_crime(self):
self.dr.context = './data/'
self.dr.fname = 'crime_in_seoul.csv'
crime = self.dr.csv_to_dframe()
station_names = []
for name in crime['관서명']:
station_names.append('서울' + str(name[:-1] + '경찰서'))
station_addrs = []
station_lats = [] # 위도
station_lngs = [] # 경도
gmaps = self.dr.create_gmap()
for name in station_names:
t = gmaps.geocode(name, language='ko')
station_addrs.append(t[0].get('formatted_address'))
t_loc = t[0].get('geometry')
station_lats.append(t_loc['location']['lat'])
station_lngs.append(t_loc['location']['lng'])
print(name + '---------->' + t[0].get('formatted_address'))
class CrimeModel:
def __init__(self):
self.dr = DataReader()
def hook_process(self):
print('--------- 1. CCTV 파일 DF 생성 -------------')
self.get_crime()
def get_crime(self):
self.dr.context = './data/'
self.dr.fname = 'crime_in_seoul.csv'
crime = self.dr.csv_to_dframe()
print(crime)
station_names = []
for name in crime['관서명']:
station_names.append('서울' + str(name[:-1] + '경찰서'))
station_addrs = []
station_lats = []
station_lngs = []
gmaps = self.dr.create_gmap()
for name in station_names:
t = gmaps.geocode(name, language='ko')
station_addrs.append(t[0].get('formatted_address'))
t_loc = t[0].get('geometry')
station_lats.append(t_loc['location']['lat'])
station_lngs.append(t_loc['location']['lng'])
print(name + '---------->' + t[0].get('formatted_address'))
gu_names = []
for name in station_addrs:
t = name.split()
gu_name = [gu for gu in t if gu[-1] == '구'][0]
gu_names.append(gu_name)
crime['구별'] = gu_names
crime.loc[crime['관서명'] == '해화서', ['구별']] == '종로구'
crime.loc[crime['관서명'] == '서부서', ['구별']] == '은평구'
crime.loc[crime['관서명'] == '강서서', ['구별']] == '양천구'
crime.loc[crime['관서명'] == '종암서', ['구별']] == '성북구'
crime.loc[crime['관서명'] == '방배서', ['구별']] == '서초구'
crime.loc[crime['관서명'] == '수서서', ['구별']] == '강남구'
print(crime)
crime.to_csv('./saved_data/crime_police.csv')
