import pandas as pd

tabela1 = pd.read_csv('C:scriptspasta 1pasta 2pasta 3cadmun_simple.csv')
tabela2 = pd.read_csv('C:scriptspasta 1pasta 2pasta 3BP-2010.csv')

import matplotlib as mt
import matplotlib.pyplot as plt
import matplotlib_venn
from matplotlib_venn import venn2

tabela=tabela1.merge(tabela2, how='outer', left_on='MUNCODDV', right_on='geocode')
tabela.to_csv('C:scriptspasta 1pasta 2pasta 3/tabela.csv')
b = tabela.loc[138:152, :]
b.to_csv('C:scriptspasta 1pasta 2pasta 3/tabela_final.csv')

latitude = b.LATITUDE.median()
longitude = b.LONGITUDE.median()
quantis = b.population.quantile([.25,.50,.75])
pop_t = b.population.sum()

b['LATITUDE'] == latitude
b['LONGITUDE']== longitude
b.index[b.LATITUDE == latitude, b.LONGITUDE ==longitude]