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'))