title: How to import a csv with multiple data into different dataframes?
body: <p>Here is the csv that i have as an input:</p>
  <p><a href="https://i.stack.imgur.com/Exsrk.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Exsrk.png" alt="enter image description here" /></a></p>
  <p>I would like to create 3 dataframes for each variable: <code>BEL AIR - feeder_30 - MANGUIER</code>, <code>BEL_TC_30_TR3_MW</code> and <code>BEL AIR - feeder_30 - MTOA</code>.
  It will have <code>Date</code> value as an index and <code>Valeur</code> as values.</p>
  <p>I tried this :</p>
  <pre class="lang-py prettyprint-override"><code>data_adms = pd.read_csv(full_path,sep=';',index_col=False, header=6)
  </code></pre>
  <p>But it gets rid of the name of <code>nom du point distant</code>.
  And the timestamp is not the same between rows.</p>
  <p>Does somebody have an idea how can I properly proceed?</p>