title: Reformat a single column dataset in python to a standard long format dataset
body: <p>I have a dataset like this, with unformatted dates and some events happened in that date, I would like to tidy it up from this:</p>
  <pre><code>              date                           event
  0   giovedì, 18 novembre 2010       giovedì, 18 novembre 2010
  1       
  2   MELA Mela Sciences FDA Panel    MELA Mela Sciences FDA Panel
  3   martedì, 7 dicembre 2010        martedì, 7 dicembre 2010
  4       
  5   OREX Orexigen Therapeutics      OREX Orexigen Therapeutics
  6       
  7   SLXP SALIX PHARMACEUTICALS      SLXP SALIX PHARMACEUTICALS
  8   giovedì, 9 dicembre 2010        giovedì, 9 dicembre 2010
  </code></pre>
  <p>to this:</p>
  <p><a href="https://i.stack.imgur.com/CgBq8.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/CgBq8.png" alt="enter image description here" /></a></p>
  <p>any idea?</p>
  <p>First I tryed to get rid of empy lines, but I can't, i used this:</p>
  <pre><code>nan_value = float(&quot;NaN&quot;)
  fda.replace(&quot;&quot;, nan_value, inplace=True)
  fda.dropna(subset = [&quot;date&quot;], inplace=True)
  </code></pre>
  <p>Then I want to iterate over row to see if they contain a date or not, but I can't see how select subsequent rows before the next date and assigning it to the event column</p>
  <pre><code>days=['lunedì','martedì','mercoledì','giovedì','venerdì','sabato','domenica']
  for index, row in fda.iterrows():
    string = row['date']
    if any(ext in string for ext in days):
      eventdate = row['date']
      event= ????
  
  
  </code></pre>