annotate V3/dParse.py @ 8:11dee9cbaacc

creation of V3

#!/usr/bin/env python

import csv
import time
import unicodedata
from geopy.geocoders import Nominatim
from geopy.exc import GeocoderTimedOut
import random
import pdb

DEFAULT_TIME_H = 12
DEFAULT_TIME_M = 00
DEAULT_LOCATION = 'USA'

def parseCSV(filename):
	stream = csv.DictReader(open(filename,'rb'))
	dictList = []
	for line in stream:
		dictList.append(regulateData(line))
	return dictList

def regulateData(dataDict):
	print("Parse %s"%(str(dataDict['ID'])))
	p_DOBQ = "What is your partner's date of birth? Please use the format DD/MM/YYYY (for example, 29/03/1981)."
	p_TOBQ = "At what exact time were your partner born? Please use the format HHMM (for example, 2204)."
	DOB_DQ = "Which day (numeric) have you been born?"
	DOB_MQ = "Which month have you been born?"
	DOB_YQ = "Year Of Birth"
	TOB_Q = "At what exact time were you born? Please use the format HHMM (for example, 2204)."
	COB = "What is your place of birth? Please specify city and country (for example, San Francisco, USA)."
	p_COB = "What is your partner's place of birth? Please specify city and country (for example, San Francisco, USA)."
	dataDict['DOB'] = parseDOB(dataDict[DOB_DQ],dataDict[DOB_MQ],dataDict[DOB_YQ])
	# print (dataDict[DOB_DQ],dataDict[DOB_MQ],dataDict[DOB_YQ])
	# print dataDict['DOB']
	dataDict['TOB'] = parseTOB(dataDict[TOB_Q])
	dataDict['pDOB'] = parsePartnerDOB(dataDict[p_DOBQ])
	dataDict['pTOB'] = parseTOB(dataDict[p_TOBQ])
	# MAKE RANDOM PLACE
	# dataDict['COB'] = (random.uniform(-90, 90),random.uniform(-90, 90))
	# dataDict['pCOB'] = (random.uniform(-90, 90),random.uniform(-90, 90))
	dataDict['COB'] = parseBirthTown(dataDict[COB])
	dataDict['pCOB'] = parseBirthTown(dataDict[p_COB])
	return dataDict


def parseBirthTown(s):
	try:
		s = s.encode('ascii')
	except UnicodeDecodeError:
		# pdb.set_trace()
		s = s.decode('latin-1')
		# s = unicodedata.normalize('NFKD',s.decode('utf-8')).encode('ascii','ignore')
	timeoutTime = 2
	geolocator = Nominatim(timeout=timeoutTime)
	while s is not [] and timeoutTime < 60:
		try:
			location = geolocator.geocode(s)
			if location is not None:
				# print(location.raw)
				# print (location.latitude, location.longitude)
				return (location.latitude, location.longitude, location.raw)
			else:
				s = s.split(' ',1)
				if len(s) == 2:
					s = s[1]
					# print s
				else:
					s = DEAULT_LOCATION
		except:
			timeoutTime += 1
			print("Error: geocode failed on input %s, incrementing timeout time to %d"%(s,timeoutTime))
			time.sleep(5)
			geolocator = Nominatim(timeout=timeoutTime)
	# places = geograpy.get_place_context(text=s)

def parsePartnerDOB(dob):
	# print dob
	# pdb.set_trace()
	dob = dob.strip()
	if(dob.count('-') == 2):
		dob = dob.replace('-','/')
	if(dob.count(' ') == 2):
		dob = dob.replace(' ','/')
	dob_ = dob.split('/')
	if(len(dob_) != 3):
		dob = dob.replace('/','').strip()
		dob_ = []
		# print dob
		if len(dob) == 8: # ddmmyyyy
			dob_.append(dob[:2])
			dob_.append(dob[2:4])
			dob_.append(dob[4:])
		elif len(dob) == 7 and dob[1] == '1' and (dob[2] == '0' or dob[2] == '1' or dob[2] == '2'): # dmmyyyy
			dob_.append(dob[0])
			dob_.append(dob[1:3])
			dob_.append(dob[3:])
		elif(len(dob) == 7):
			if int(dob[:2]) > 31:# dmmyyyy
				dob_.append(dob[0])
				dob_.append(dob[1:3])
				dob_.append(dob[3:])
		elif len(dob) == 7: # ddmyyyy
			dob_.append(dob[0:2])
			dob_.append(dob[2])
			dob_.append(dob[3:])
		elif len(dob) == 6 and dob[3:4] != '19': # ddmmyy
			dob_.append(dob[:2])
			dob_.append(dob[2:4])
			dob_.append(dob[4:])
		elif len(dob) == 5 and dob[1] == '1' and (dob[2] == '0' or dob[2] == '1' or dob[2] == '2'): # dmmyy
			dob_.append(dob[0])
			dob_.append(dob[1:3])
			dob_.append(dob[3:])
		elif len(dob) == 5: # ddmyy
			dob_.append(dob[:2])
			dob_.append(dob[2])
			dob_.append(dob[3:])
		elif len(dob) == 4: # dmyy
			dob_.append(dob[0])
			dob_.append(dob[1])
			dob_.append(dob[2:])
		else:
			if(len(dob) < 4):
				return None
			# print dob
			# print filter(lambda x: x.isdigit(),dob)
			print 'no / partnerDOB issue'
		# deal with no /'s
	try:
		d = int(filter(lambda x: x.isdigit(),dob_[0]))
		m = int(filter(lambda x: x.isdigit(),dob_[1]))
		y = int(filter(lambda x: x.isdigit(),dob_[2]))
		if y < 100:
			y = y + 1900
		if (m > 12 and d <= 12):
			temp = d
			d = m
			m = temp 
		if(d > 31 or d < 1 or m > 12 or m < 1 or y > 2017 or y < 1900):
			print 'error with DOB '+d+'/'+m+'/'+y
			pdb.set_trace()
	except TypeError:
		return None
	# print  (d,m,y)
	return (d,m,y)

def monthStringToNum(s):
	# print 'inMonthStringToNum'
	m = {'jan':1,'feb':2,'mar':3,
	'apr':4,'may':5,'jun':6,'jul':7,'aug':8,
	'sep':9,'oct':10,'nov':11,'dec':12}
	s_ = s.strip()[:3].lower()
	try:
		out = m[s_]
		return out
	except:
		raise ValueError('Not a month')

def checkMonthDay(d,m):
	if d > 31: # take first two digits of day
		d = int(str(d)[:2])
		if d > 31:
			d = int(str(d)[1])
	if m > 12 and d < 12: # Day and month wrong way round - American
		temp = m
		m = d
		d = temp
	if(m == 2):
		if d <= 29:
			return (True,d,m)
		else:
			return (False,d,m)
	elif m in [4,6,9,11]:
		if d <= 30:
			return (True,d,m)
		else:
			return (False,d,m)
	elif m <= 12 and d <= 31:
		return (True,d,m)
	else:
		return (False,d,m)

def parseDOB(d,m,y):
	d = int(filter(lambda x: x.isdigit(),d))
	y = int(filter(lambda x: x.isdigit(),y))
	try:
		# print m
		m = monthStringToNum(m.strip())
	except ValueError:
		m = int(m.strip())
	if(y < 100):
		y = y + 1900
	(r,d,m) = checkMonthDay(d,m)
	if not r:
		print 'error with day month'
		print (r,d,m)
	return (d,m,y)

def parseTOB(T):
	# pdb.set_trace()
	timeFlag = None
	T_ = T.replace('.','').lower().strip()
	if 'am' in T_:
		timeFlag = 0
		T = T_.replace('am','')
	if 'pm' in T_:
		timeFlag = 1
		T = T_.replace('pm','')
	T = T.strip()
	if T.count('.') == 1:
		T = T.replace('.',':')
	try:
		if ':' in T:
			T_ = T.split(':')
			
			H = int(T_[0])
			M = int(T_[1])
		else:
			if len(T) == 4:
				H = int(T[:2])
				M = int(T[2:])
			elif int(T) <= 24 :
				H = int(T)
				M = 0
			elif int(T) > 100:
				H = int(T)/100
				M = int(T)%100
		if timeFlag is not None:
			if timeFlag == 0:
				H = H%12
			else:
				H = H%12 + 12
	except ValueError:
		H = DEFAULT_TIME_H
		M = DEFAULT_TIME_M
	return (H,M)

def makePayload(dataDict):
	if type(dataDict['COB']) is str:
		cob_0 = float(dataDict['COB'].split(',')[0][1:])
		cob_1 = float(dataDict['COB'].split(',')[1])
		dataDict['COB'] = (cob_0,cob_1)
	if type(dataDict['pCOB']) is str:
		pcob_0 = float(dataDict['pCOB'].split(',')[0][1:])
		pcob_1 = float(dataDict['pCOB'].split(',')[1])
		dataDict['pCOB'] = (pcob_0,pcob_1)
	if type(dataDict['DOB']) is str:
		dataDict['DOB'] = dataDict['DOB'][1:-1].split(',')
	if type(dataDict['pDOB']) is str:
		dataDict['pDOB'] = dataDict['pDOB'][1:-1].split(',')
	if type(dataDict['TOB']) is str:
		dataDict['TOB'] = dataDict['TOB'][1:-1].split(',')
	if type(dataDict['pTOB']) is str:
		dataDict['pTOB'] = dataDict['pTOB'][1:-1].split(',')
	# pdb.set_trace()

	print dataDict['pDOB']

	R = {'send_calculation':'1', #Req
		'muz_narozeni_den':dataDict['DOB'][0],
		'muz_narozeni_mesic':dataDict['DOB'][1],
		'muz_narozeni_rok':dataDict['DOB'][2],
		'muz_narozeni_hodina':dataDict['TOB'][0],
		'muz_narozeni_minuta':dataDict['TOB'][1],
		'muz_narozeni_city':'',
		'muz_narozeni_mesto_hidden':'Manually+place%3A+%C2%B0%27N%2C+%C2%B0%27E',#auto
		'muz_narozeni_stat_hidden':'XX',
		'muz_narozeni_podstat_kratky_hidden':'',
		'muz_narozeni_podstat_hidden':'',
		'muz_narozeni_podstat2_kratky_hidden':'',
		'muz_narozeni_podstat3_kratky_hidden':'',
		'muz_narozeni_input_hidden':'',
		'muz_narozeni_sirka_stupne':str(abs(dataDict['COB'][0])).split('.')[0],
		'muz_narozeni_sirka_minuty':str(float('0.'+str(dataDict['COB'][0]).split('.')[1])*60).split('.')[0],
		'muz_narozeni_sirka_smer': '1' if dataDict['COB'][0]<0 else '0', #address N Dir (0':'N',1':'S)
		'muz_narozeni_delka_stupne':str(abs(dataDict['COB'][1])).split('.')[0], #address E - Main
		'muz_narozeni_delka_minuty':str(float('0.'+str(dataDict['COB'][1]).split('.')[1])*60).split('.')[0],
		'muz_narozeni_delka_smer': '1' if dataDict['COB'][1]<0 else '0', #address E Dir (0':'E',1':'W)
		'muz_narozeni_timezone_form':'auto',
		'muz_narozeni_timezone_dst_form':'auto',
		'send_calculation':'1',
		'zena_narozeni_den':dataDict['pDOB'][0],
		'zena_narozeni_mesic':dataDict['pDOB'][1],
		'zena_narozeni_rok':dataDict['pDOB'][2],
		'zena_narozeni_hodina':dataDict['pTOB'][0],
		'zena_narozeni_minuta':dataDict['pTOB'][1],
		'zena_narozeni_city':'',
		'zena_narozeni_mesto_hidden':'Manually+place%3A+%C2%B0%27N%2C+%C2%B0%27E',
		'zena_narozeni_stat_hidden':'XX',
		'zena_narozeni_podstat_kratky_hidden':'',
		'zena_narozeni_podstat_hidden':'',
		'zena_narozeni_podstat2_kratky_hidden':'',
		'zena_narozeni_podstat3_kratky_hidden':'',
		'zena_narozeni_input_hidden':'',
		'zena_narozeni_sirka_stupne':str(abs(dataDict['pCOB'][0])).split('.')[0],
		'zena_narozeni_sirka_minuty':str(float('0.'+str(dataDict['pCOB'][0]).split('.')[1])*60).split('.')[0],
		'zena_narozeni_sirka_smer': '1' if dataDict['pCOB'][0]<0 else '0',
		'zena_narozeni_delka_stupne':str(abs(dataDict['pCOB'][1])).split('.')[0],
		'zena_narozeni_delka_minuty':str(float('0.'+str(dataDict['pCOB'][1]).split('.')[1])*60).split('.')[0],
		'zena_narozeni_delka_smer': '1' if dataDict['pCOB'][1]<0 else '0',
		'zena_narozeni_timezone_form':'auto',
		'zena_narozeni_timezone_dst_form':'auto',
		'switch_interpretations':'0',
		'house_system':'placidus',
		'uhel_orbis':'#tabs_redraw'}
	return R