In [1]:

    

import pandas as pd
import json


    

In [2]:

    

df = pd.read_csv('story_links.csv')


    

In [6]:

    

for name, group in df.groupby('name'):
    output = '<div class="stories stories_{}">\n'.format(name.lower())
    output += '<h4>Lire des articles sur les «ennemis» qu’affronte {}:</h4>\n'.format(group['fn'].values[0])
    for i, row in group.iterrows():
        imgstr = '<div><div class="enemylink" style="width: {}px;"><a target="_blank" href="{}"><img src="images/monster_{}.png" style="margin-left: {}px; margin-right: {}px" /></a></div><p>{}</p></div>\n'

        output += imgstr.format(row['width'], row['tdg'], row['name'].lower(), -row['clip_x1'], -row['clip_x2'], row['enemy'])
    output += '</div>'
    print(output)


    

    




<div class="stories stories_cassis">
<h4>Lire des articles sur les «ennemis» qu’affronte Ignazio Cassis:</h4>
<div><div class="enemylink" style="width: 50px;"><a target="_blank" href="https://www.tdg.ch/suisse/Le-Tessin-et-plus-de-femmes-au-gouvernement/story/30730019"><img src="images/monster_cassis.png" style="margin-left: 0px; margin-right: -50px" /></a></div><p>Parité</p></div>
<div><div class="enemylink" style="width: 76px;"><a target="_blank" href="https://www.tdg.ch/suisse/plan-secret-elire-isabelle-moret/story/11809943"><img src="images/monster_cassis.png" style="margin-left: -100px; margin-right: -176px" /></a></div><p>«Filippo»</p></div>
<div><div class="enemylink" style="width: 50px;"><a target="_blank" href="https://www.tdg.ch/geneve/actu-genevoise/google-isabelle-moret-double-pierre-maudet/story/31791964"><img src="images/monster_cassis.png" style="margin-left: -404px; margin-right: -454px" /></a></div><p>Vaud</p></div>
<div><div class="enemylink" style="width: 58px;"><a target="_blank" href="https://www.tdg.ch/suisse/ignazio-cassis-renonce-passeport-italien/story/15875312"><img src="images/monster_cassis.png" style="margin-left: -604px; margin-right: -662px" /></a></div><p>Passeport</p></div>
</div>
<div class="stories stories_maudet">
<h4>Lire des articles sur les «ennemis» qu’affronte Pierre Maudet:</h4>
<div><div class="enemylink" style="width: 50px;"><a target="_blank" href="https://www.tdg.ch/suisse/Le-Tessin-et-plus-de-femmes-au-gouvernement/story/30730019"><img src="images/monster_maudet.png" style="margin-left: 0px; margin-right: -50px" /></a></div><p>Parité</p></div>
<div><div class="enemylink" style="width: 76px;"><a target="_blank" href="https://www.tdg.ch/suisse/plan-secret-elire-isabelle-moret/story/11809943"><img src="images/monster_maudet.png" style="margin-left: -100px; margin-right: -176px" /></a></div><p>«Filippo»</p></div>
<div><div class="enemylink" style="width: 50px;"><a target="_blank" href="https://www.tdg.ch/suisse/Le-Tessin-et-plus-de-femmes-au-gouvernement/story/30730019"><img src="images/monster_maudet.png" style="margin-left: -404px; margin-right: -454px" /></a></div><p>Tessin</p></div>
<div><div class="enemylink" style="width: 58px;"><a target="_blank" href="https://www.tdg.ch/geneve/actu-genevoise/pierre-maudet-candidat-conseil-federal-berne-parler-sujets-fond/story/22241312"><img src="images/monster_maudet.png" style="margin-left: -604px; margin-right: -662px" /></a></div><p>UE</p></div>
</div>
<div class="stories stories_moret">
<h4>Lire des articles sur les «ennemis» qu’affronte Isabelle Moret:</h4>
<div><div class="enemylink" style="width: 50px;"><a target="_blank" href="https://www.tdg.ch/suisse/louvoiements-moret-liens-interets/story/24816582"><img src="images/monster_moret.png" style="margin-left: 0px; margin-right: -50px" /></a></div><p>Hôpitaux</p></div>
<div><div class="enemylink" style="width: 76px;"><a target="_blank" href="https://www.tdg.ch/suisse/conseil-federal-femmes-droite-marche/story/29375081"><img src="images/monster_moret.png" style="margin-left: -100px; margin-right: -176px" /></a></div><p>Karin Keller-Sutter</p></div>
<div><div class="enemylink" style="width: 50px;"><a target="_blank" href="https://www.tdg.ch/suisse/heure-verite-isabelle-moret-pierre-maudet/story/26753980"><img src="images/monster_moret.png" style="margin-left: -404px; margin-right: -454px" /></a></div><p>Tessin</p></div>
<div><div class="enemylink" style="width: 58px;"><a target="_blank" href="https://www.tdg.ch/suisse/L-heure-de-verite-pour-Isabelle-Moret-et-Pierre-Maudet/story/26753980"><img src="images/monster_moret.png" style="margin-left: -604px; margin-right: -662px" /></a></div><p>Genève</p></div>
</div>

In [ ]:

    




    

In [5]:

    

for name, group in df.groupby('name'):
    output = '<div class="stories stories_{}">\n'.format(name.lower())
    output += '<h4>Lire des articles sur les «ennemis» qu’affronte {}:</h4>\n'.format(group['fn'].values[0])
    for i, row in group.iterrows():
        imgstr = '<div><div class="enemylink" style="width: {}px;"><a target="_blank" href="{}"><img src="images/monster_{}.png" style="margin-left: {}px; margin-right: {}px" /></a></div><p>{}</p></div>\n'

        output += imgstr.format(row['width'], row['vqh'], row['name'].lower(), -row['clip_x1'], -row['clip_x2'], row['enemy'])
    output += '</div>'
    print(output)


    

    




<div class="stories stories_cassis">
<h4>Lire des articles sur les «ennemis» qu’affronte Ignazio Cassis:</h4>
<div><div class="enemylink" style="width: 50px;"><a target="_blank" href="https://www.24heures.ch/suisse/destin-maudit-candidates-plr-conseil-federal/story/14296426"><img src="images/monster_cassis.png" style="margin-left: 0px; margin-right: -50px" /></a></div><p>Parité</p></div>
<div><div class="enemylink" style="width: 76px;"><a target="_blank" href="https://www.24heures.ch/suisse/plan-secret-elire-isabelle-moret/story/11809943"><img src="images/monster_cassis.png" style="margin-left: -100px; margin-right: -176px" /></a></div><p>«Filippo»</p></div>
<div><div class="enemylink" style="width: 50px;"><a target="_blank" href="https://www.24heures.ch/suisse/vaudois-pratiquent-souvent-conseil-federal/story/30329465"><img src="images/monster_cassis.png" style="margin-left: -404px; margin-right: -454px" /></a></div><p>Vaud</p></div>
<div><div class="enemylink" style="width: 58px;"><a target="_blank" href="https://www.24heures.ch/suisse/ignazio-cassis-renonce-passeport-italien/story/15875312"><img src="images/monster_cassis.png" style="margin-left: -604px; margin-right: -662px" /></a></div><p>Passeport</p></div>
</div>
<div class="stories stories_maudet">
<h4>Lire des articles sur les «ennemis» qu’affronte Pierre Maudet:</h4>
<div><div class="enemylink" style="width: 50px;"><a target="_blank" href="https://www.24heures.ch/suisse/destin-maudit-candidates-plr-conseil-federal/story/14296426"><img src="images/monster_maudet.png" style="margin-left: 0px; margin-right: -50px" /></a></div><p>Parité</p></div>
<div><div class="enemylink" style="width: 76px;"><a target="_blank" href="https://www.24heures.ch/suisse/plan-secret-elire-isabelle-moret/story/11809943"><img src="images/monster_maudet.png" style="margin-left: -100px; margin-right: -176px" /></a></div><p>«Filippo»</p></div>
<div><div class="enemylink" style="width: 50px;"><a target="_blank" href="https://www.24heures.ch/suisse/heure-verite-isabelle-moret-pierre-maudet/story/19475092"><img src="images/monster_maudet.png" style="margin-left: -404px; margin-right: -454px" /></a></div><p>Tessin</p></div>
<div><div class="enemylink" style="width: 58px;"><a target="_blank" href="https://www.24heures.ch/news/news/pierre-maudet-candidat-conseil-federal-berne-parler-sujets-fond/story/13980975"><img src="images/monster_maudet.png" style="margin-left: -604px; margin-right: -662px" /></a></div><p>UE</p></div>
</div>
<div class="stories stories_moret">
<h4>Lire des articles sur les «ennemis» qu’affronte Isabelle Moret:</h4>
<div><div class="enemylink" style="width: 50px;"><a target="_blank" href="https://www.24heures.ch/suisse/Les-louvoiements-de-Moret-sur-ses-liens-d-interets/story/27752222"><img src="images/monster_moret.png" style="margin-left: 0px; margin-right: -50px" /></a></div><p>Hôpitaux</p></div>
<div><div class="enemylink" style="width: 76px;"><a target="_blank" href="https://www.24heures.ch/suisse/politique/Conseil-federal-femmes-de-droite-en-marche/story/22718219"><img src="images/monster_moret.png" style="margin-left: -100px; margin-right: -176px" /></a></div><p>Karin Keller-Sutter</p></div>
<div><div class="enemylink" style="width: 50px;"><a target="_blank" href="https://www.24heures.ch/suisse/heure-verite-isabelle-moret-pierre-maudet/story/19475092"><img src="images/monster_moret.png" style="margin-left: -404px; margin-right: -454px" /></a></div><p>Tessin</p></div>
<div><div class="enemylink" style="width: 58px;"><a target="_blank" href="https://www.24heures.ch/suisse/heure-verite-isabelle-moret-pierre-maudet/story/19475092"><img src="images/monster_moret.png" style="margin-left: -604px; margin-right: -662px" /></a></div><p>Genève</p></div>
</div>

In [4]:

    

for name, group in df.groupby('name'):
    output = '<div class="stories stories_{}">\n'.format(name.lower())
    output += '<h4>En savoir plus sur les obstacles de {}</h4>\n'.format(name)
    for i, row in group.iterrows():
        imgstr = '<div class="enemylink" style="width: {}px;"><a target="_blank" href="{}"><img src="images/monster_{}.png" style="margin-left: {}px; margin-right: {}px" /></a></div>\n'

        output += imgstr.format(row['width'], row['vqh'], row['name'].lower(), -row['clip_x1'], -row['clip_x2'])
    output += '</div>'
    print(output)


    

    




<div class="stories stories_cassis">
<h4>En savoir plus sur les obstacles de Cassis</h4>
<div class="enemylink" style="width: 50px;"><a target="_blank" href="https://www.24heures.ch/suisse/destin-maudit-candidates-plr-conseil-federal/story/14296426"><img src="images/monster_cassis.png" style="margin-left: 0px; margin-right: -50px" /></a></div>
<div class="enemylink" style="width: 76px;"><a target="_blank" href="https://www.24heures.ch/suisse/plan-secret-elire-isabelle-moret/story/11809943"><img src="images/monster_cassis.png" style="margin-left: -100px; margin-right: -176px" /></a></div>
<div class="enemylink" style="width: 50px;"><a target="_blank" href="https://www.24heures.ch/suisse/vaudois-pratiquent-souvent-conseil-federal/story/30329465"><img src="images/monster_cassis.png" style="margin-left: -404px; margin-right: -454px" /></a></div>
<div class="enemylink" style="width: 58px;"><a target="_blank" href="https://www.24heures.ch/suisse/ignazio-cassis-renonce-passeport-italien/story/15875312"><img src="images/monster_cassis.png" style="margin-left: -604px; margin-right: -662px" /></a></div>
</div>
<div class="stories stories_maudet">
<h4>En savoir plus sur les obstacles de Maudet</h4>
<div class="enemylink" style="width: 50px;"><a target="_blank" href="https://www.24heures.ch/suisse/destin-maudit-candidates-plr-conseil-federal/story/14296426"><img src="images/monster_maudet.png" style="margin-left: 0px; margin-right: -50px" /></a></div>
<div class="enemylink" style="width: 76px;"><a target="_blank" href="https://www.24heures.ch/suisse/plan-secret-elire-isabelle-moret/story/11809943"><img src="images/monster_maudet.png" style="margin-left: -100px; margin-right: -176px" /></a></div>
<div class="enemylink" style="width: 50px;"><a target="_blank" href="https://www.24heures.ch/suisse/heure-verite-isabelle-moret-pierre-maudet/story/19475092"><img src="images/monster_maudet.png" style="margin-left: -404px; margin-right: -454px" /></a></div>
<div class="enemylink" style="width: 58px;"><a target="_blank" href="https://www.24heures.ch/news/news/pierre-maudet-candidat-conseil-federal-berne-parler-sujets-fond/story/13980975"><img src="images/monster_maudet.png" style="margin-left: -604px; margin-right: -662px" /></a></div>
</div>
<div class="stories stories_moret">
<h4>En savoir plus sur les obstacles de Moret</h4>
<div class="enemylink" style="width: 50px;"><a target="_blank" href="https://www.24heures.ch/suisse/Les-louvoiements-de-Moret-sur-ses-liens-d-interets/story/27752222"><img src="images/monster_moret.png" style="margin-left: 0px; margin-right: -50px" /></a></div>
<div class="enemylink" style="width: 76px;"><a target="_blank" href="https://www.24heures.ch/suisse/politique/Conseil-federal-femmes-de-droite-en-marche/story/22718219"><img src="images/monster_moret.png" style="margin-left: -100px; margin-right: -176px" /></a></div>
<div class="enemylink" style="width: 50px;"><a target="_blank" href="https://www.24heures.ch/suisse/heure-verite-isabelle-moret-pierre-maudet/story/19475092"><img src="images/monster_moret.png" style="margin-left: -404px; margin-right: -454px" /></a></div>
<div class="enemylink" style="width: 58px;"><a target="_blank" href="https://www.24heures.ch/suisse/heure-verite-isabelle-moret-pierre-maudet/story/19475092"><img src="images/monster_moret.png" style="margin-left: -604px; margin-right: -662px" /></a></div>
</div>

In [ ]: