title: There are values in rows but dataframe returns Nan
body: <p>When i read a dataframe in panda, it returns Nan when there is values in there. Also how do i delete rows where the value is really N/A or blank. </p>
  
  <pre><code># File to read
  Exoticoutput=pd.read_excel(Exotic Deltas - SIGN OFF SHEET"+yesterday+".xlsx",sheetname="Exotic deltas (output to Curo)")
  
  Exoticoutput.to_csv(Output\Exotic Deltas"+' '+ yesterday +' '+".csv", columns=["Hiport Code","ISIN","External Code 1","JSE code","Delta"], index=False)# Output file to create. 
  </code></pre>
  
  <p>There are values in the Delta column with decimals in the actual excel file, however when i create an output file by reading into a dataframe and exporting gives Nan</p>
  
  <p>First file</p>
  
  <p>Input file 
  Option ISIN        Delta </p>
  
  <p>ZADA000            0.60972
  ZADA               0.292603</p>
  
  <p>Output file </p>
  
  <p>Option Isin       Delta 
  No data           No Data
  Nan</p>
  
  <p>The input file has the data but on output file it either reads Nan or blank</p>
  
  <p>is it because the number i am looking for is floating</p>
  
  <p>Sorry for the lack of information, i am new to SE and python programming </p>