def get_df_simple():
df20 = ebu.get_dataframe_2020()
df19 = ebu.open_combine_2019()
df = pd.merge(df19,
df20,
left_index=True,
right_index=True,
suffixes=['_19', '_20'],
how='inner')
return df
# %%
# import
from elec_bol20 import *
import elec_bol20.util as ebu
import bokeh.layouts
from bokeh.models import ColumnDataSource, CustomJS, Slider
from bokeh.plotting import Figure, output_file, show
import bokeh.tile_providers
# %% [markdown]
# ###### abrir los datos
# abrimos los datos del padrón de votación del 2019
# %%
df = ebu.open_combine_2019()
_mean = [
'X',
'Y',
'LAT',
'LON',
'DEN',
]
_sum = ['HAB', 'CC', 'MAS', 'PDC', 'VV']
_first = ['PAIS', 'REC', 'MUN', 'BOL']
#agrupamos por recinto
_gr = df.groupby('ID_RECI')
rec_df = _gr[_mean].mean()
rec_df[_sum] = _gr[_sum].sum()
rec_df[_first] = _gr[_first].first()
#%%
import elec_bol20.util as ebu
from elec_bol20 import *
df20 = ebu.get_dataframe_2020()
df19 = ebu.open_combine_2019()
df = pd.merge(df19,
df20,
left_on='ID_MESA',
right_on='ID_MESA',
suffixes=['_19', '_20'],
how='outer')
print(len(df))
print(len(df20))
print(len(df19))
df.to_csv(os.path.join(ebu.DATA_PATH1_2020, 'z110_concat_19_20.csv'))
