Sorting a table values based on index and non-indexed columns using python
<p>How can I sort values in a dataframe based on an index and non-indexed columns?</p>

<p>Dataframe:</p>

<pre><code>ID  Colour  A   B   C
45356   Green   1   34  4
34455   Yellow  23  0   1
53443   Brown   3   4   3
45555   Green   5   5   2
</code></pre>

<p>Table has two index columns (ID and Colour). I will like to sort the table based on ID(ascending), A (Descending) and C (ascending).</p>

<p>Required output is :</p>

<pre><code>ID  Colour  A   B   C
34455   Yellow  23  0   1
45356   Green   1   34  4
45555   Green   5   5   2
53443   Brown   3   4   3
</code></pre>

<p>I have tried this:</p>

<pre><code>df.set_index(inplace=True)
df.sort_values(['ID', 'A', 'C'], ascending=['True','False','True'])
</code></pre>

<p>This didn't work as "ID" as a column was not recognized.</p>