title: l have NaN which are not NaN in my CSV file due to comma in a column considered as delimiter which is not
body: <p>l have a strange scenario where <code>non NaN</code> values are represented by <code>#####</code>  but when l click on the cell of <code>####</code> l get the value. However when l manipulate my data l got the following error :</p>
  
  <pre><code>  img_charac=img[int(coords[2]):int(coords[3]),int(coords[0]):int(coords[1])]
  ValueError: cannot convert float NaN to integer
  </code></pre>
  
  <p>Because it reads some cell as <code>NaN</code></p>
  
  <p>how can l avoid that ?
  Here is my csv file </p>
  
  <p><a href="https://i.stack.imgur.com/tAzK7.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/tAzK7.png" alt="enter image description here"></a></p>
  
  <p>in the following picture look at te line <code>139 cell C</code> when l click on that cell l get the real value on the top right corner </p>
  
  <p><a href="https://i.stack.imgur.com/YUgkF.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/YUgkF.png" alt="enter image description here"></a></p>
  
  <p>l increased the width of the column l don't have any <code>####</code> in my csv file.
  However when l read my csv file as follow :</p>
  
  <pre><code>npa=np.genfromtxt(path_csv+"char.csv", delimiter=',',skip_header=1,usecols=(2,3,4,5))
  
  npa[:280]
  array([[   38.,   104.,  2456.,  2492.],
         [   40.,   102.,  2442.,  2448.],
         [   40.,   100.,  2402.,  2410.],
         ..., 
         [ 1473.,  1482.,   153.,   177.],
         [   nan,  1491.,  1494.,   172.],
         [ 1508.,  1517.,   159.,   177.]])
  </code></pre>
  
  <p>l get strangely one <code>NaN</code> value <code>(npa[278])</code></p>
  
  <pre><code>[   nan,  1491.,  1494.,   172.]
  </code></pre>
  
  <p>l noticed  in this value it is not reading the correct column.
  the entire line is as follow  : </p>
  
  <pre><code>',' 1491    1494    172 181
  </code></pre>
  
  <p>rather writing :
   [ 1491.,  1494.,   172., 181.]
  it writes :</p>
  
  <pre><code>[   nan,  1491.,  1494.,   172.]
  </code></pre>
  
  <p>which means it reads the first column which is a char <code>(',')</code> and left the last column.
  l noticed that for each row with a char <code>','</code> for the rest it's ok </p>
  
  <p>here how l read my csv :</p>
  
  <pre><code>npa=np.genfromtxt(path_csv+"char.csv", delimiter=',',skip_header=1,usecols=(2,3,4,5))
  </code></pre>
  
  <p>l have  <code>delimiter=','</code> and in the first column l have some char which are <code>','</code>
  the question is updated to </p>
  
  <pre><code>http://stackoverflow.com/questions/43093100/considering-comma-in-a-cell-column-as-delimiter-but-its-not-how-to-differentia
  </code></pre>
  
  <p>thank you</p>