title: Clean up excel data with python using pandas package
body: <p>I have read an xls file into Python with pandas using pd.read_excel</p>
  
  <p>I am trying to cleanup my data but I'm way out of my league.</p>
  
  <p>There is a blank line between every record. In the example pic it's excel row 4, 9 and 11.</p>
  
  <p>There is a comments column, designated in the example (see link) as "col_F". Every record has at least one cell that contains text. The person that created this xls file split longer comments into multiple cells. </p>
  
  <p>I would like to concatenate all of the data in col_F for a particular record into one cell.</p>
  
  <p>I will also trim out blank records once I figure out how to properly concatenate col_F. </p>
  
  <p>I am using Python version 3.5.0, numpy 1.12.0 and pandas 0.19.2</p>
  
  <p>Here is what I have so far:</p>
  
  <pre><code>import numpy as np
  import pandas as pd
  
  data = pd.read_excel("C:/blah/blahblah/file.xls", header=0, nrows=10000)
  df = pd.DataFrame(data)
  </code></pre>
  
  <p>I appreciate any suggestion or insight!!</p>
  
  <p>Thanks! </p>
  
  <p>How the raw data looks:
  <a href="https://i.stack.imgur.com/wErpN.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/wErpN.jpg" alt="enter image description here"></a></p>
  
  <p>Update:
  This is how my data looks when I load into Python
  <a href="https://i.stack.imgur.com/YixST.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/YixST.jpg" alt="raw data read into python"></a></p>
  
  <p>This is what my desired outcome would look like:
  <a href="https://i.stack.imgur.com/4guGG.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/4guGG.jpg" alt="what I would like dataframe to look like when finished"></a></p>