Pandas dataframes doesn't sort properly
<p>I have a Pandas Dataframe like this <a href="http://i.stack.imgur.com/RJpkB.png" rel="nofollow">one</a></p>

<p>It was obtained froma sqlite3 query. which included</p>

<pre><code>'ORDER BY Total DESC'
</code></pre>

<p>But as you can see it the dataframe is not sorted by total. I tried <code>df=df.sort_values('Total',ascending=False)</code> without any success.</p>

<p>If I use the following workaround</p>

<pre><code>df.to_csv("merged/Report_Merged_History.csv",index=False)
df=pd.read_csv("merged/Report_Merged_History.csv")
df=df.sort_values('Total',ascending=False)
</code></pre>

<p>I have a properly sorted dataframe. (I don't have reputation to post it)</p>

<p>But if I try to save <code>to_hdf</code> I can't sort the dataframe.</p>

<p>Here is the dataframe <a href="https://dl.dropboxusercontent.com/u/60128827/Report_Merged_History.csv" rel="nofollow">df.csv</a></p>