Finding the right block data out from a data frame was not elegant: one has to use different functions: like query, selection, loc, iloc, or directly use something like "df['x'] > df['y']", which is totally not chain-able.

Here is a few new features under Pandas 0.18.1 to simplify the flow of doing data frame selection.

Regardless of how difficult the selection logic is, because of the newly improved .loc, things start look neat!

Data cleaning is a key part in Pandas. Usually it requires functions such as:
- drop columns
- fill/drop missing data
- drop duplicate rows
- replace data value

Doing this in Pandas is quite straightforward (based on Pandas 0.18.1)

Here are the functions used:
drop, dropna, fillna, drop_duplicates, replace

Simple, but powerful  :)