Display values that does not end with ".0" Python Pandas
<p>I have a float column that contains <code>NaN</code> values and float values. How do i filter out those values that does not end with <code>.0</code>?</p>

<p>For example:</p>

<pre><code>Col1
0.7
1.0
1.1
9.0
9.5
NaN
</code></pre>

<p>Desire result will be:</p>

<pre><code>Col1
0.7
1.1 
9.2
</code></pre>

<p>Another method is to use <a href="http://pandas.pydata.org/pandas-docs/stable/generated/pandas.Series.mod.html#pandas.Series.mod" rel="nofollow"><code>mod(1)</code></a> to calculate the modulo with 1:</p>

<pre><code>In [60]:
df[df['Col1'].mod(1) &gt; 0].dropna()

Out[60]:
   Col1
0   0.7
2   1.1
4   9.5
</code></pre>

<p>here we see the effect of <code>mod</code>, whole numbers become <code>0</code> whilst fractional portions will remain:</p>

<pre><code>In [62]:
df['Col1'].mod(1)

Out[62]:
0    0.7
1    0.0
2    0.1
3    0.0
4    0.5
5    NaN
Name: Col1, dtype: float64
</code></pre>

python pandas indexing condition