How to select column and rows in pandas without column or row names?
<p>I have a pandas dataframe(df) like this</p>

<pre><code>                         Close      Close     Close Close       Close
Date                                                                 
2000-01-03 00:00:00        NaN        NaN       NaN   NaN   -0.033944
2000-01-04 00:00:00        NaN        NaN       NaN   NaN   0.0351366
2000-01-05 00:00:00  -0.033944        NaN       NaN   NaN  -0.0172414
2000-01-06 00:00:00  0.0351366  -0.033944       NaN   NaN -0.00438596
2000-01-07 00:00:00 -0.0172414  0.0351366 -0.033944   NaN   0.0396476
</code></pre>

<p>in <code>R</code> If I want to select fifth column</p>

<pre><code>five=df[,5]
</code></pre>

<p>and without 5th column</p>

<pre><code>rest=df[,-5]
</code></pre>

<p>How can I do similar operations with pandas dataframe</p>

<p>I tried this in pandas</p>

<pre><code>five=df.ix[,5]
</code></pre>

<p>but its giving this error</p>

<pre><code> File "", line 1
    df.ix[,5]
           ^
SyntaxError: invalid syntax
</code></pre>

<p>If you want the fifth column:</p>

<pre><code>df.ix[:,4]
</code></pre>

<p>Stick the colon in there to take all the rows for that column.</p>

<p>To exclude a fifth column you could try:</p>

<pre><code>df.ix[:, (x for x in range(0, len(df.columns)) if x != 4)]
</code></pre>

python pandas