import geocoder
import csv
import sys
import numpy as np
from collections import Counter
import re
import time
from datetime import date
import matplotlib.pyplot as plt


#file paths
filepath1 = "filtered_bios.csv"
filepath2 = "dachau_with_geolocations_separate_columns.csv"
filepath3 = "full_bios_with_info.csv"


with open(filepath1, 'rU') as f1:

        reader1 = csv.reader(f1)

	i = 0

	saved_row = 0

        with open(filepath3, 'w') as outfile:


		for row in reader1:

			index = int(row[0]) + 2

			with open(filepath2, 'rU') as f2:
				reader2 = csv.reader(f2)

				writer = csv.writer(outfile)

				j = 0

				for info_row in reader2:
				
					if j == index:

						row.insert(0, info_row[0])
						row.insert(1, info_row[1])
						row.insert(2, info_row[13])
						row.insert(3, info_row[30])


						print info_row[30]

						writer.writerow(row)

					j = j + 1


		i = i + 1


	sys.exit()