def electro1(df, sector, tram):
    df1 = df[(df['Sector_Economic'] == sector) & (df['Tram_Horari'] == tram)]
    pos = df1['Valor'].idxmin()
    return df1.loc[pos]['Data'], df1.loc[pos]['Codi_Postal'],  df1.loc[pos]['Valor']

def electro2_1(df, mes):
    smes = '-{:02d}-'.format(mes)
    df1 = df[df['Data'].str.contains(smes)]
    gb = df1.groupby('Sector_Economic')
    s1 = gb['Valor'].sum()
    total = s1.sum()
    s1 = s1/total*100
    s1 = s1.sort_values(ascending = False)
    return s1
    
def electro2_2(df, mes):
    mes = str(mes).zfill(2)
    d1, d2 = '2022-'+mes+'-01', '2022-'+mes+'-32'
    df1 = df[(df['Data']>=d1)&(df['Data']<d2)    ] 
    gb = df1.groupby('Sector_Economic')
    s1 = gb['Valor'].sum()
    total = s1.sum()
    s1 = s1/total*100
    s1 = s1.sort_values(ascending = False)
    return s1
    
electro2 = electro2_1