Display french RTE data to matplotlib with pandas

rte2plot.py

#!/usr/bin/env python3
# -*- coding: utf-8 -*-

import dateutil.parser
import requests
import pandas as pd
import matplotlib.pyplot as plt
import time


rte_raw_d = requests.get('https://opendata.reseaux-energies.fr/api/records/1.0/search/'
                         '?dataset=consommation-production-electricite-temps-reel&rows=96&sort=-date'
                         '&facet=date_heure&refine.date_heure=%s' % time.strftime('%Y-%m-%d')).json()

rte_df = pd.DataFrame([], columns=['conso', 'eolien', 'solaire'])

for record in rte_raw_d['records']:
    if 'fields' in record:
        dt = dateutil.parser.parse(record['fields']['date_heure'])
        rte_df.loc[dt] = dict(conso=record['fields'].get('conso'),
                              eolien=record['fields'].get('eolien'),
                              solaire=record['fields'].get('solaire'))
rte_df.sort_index(inplace=True)

# print(rte_df.to_string())

rte_df.plot()
plt.show()