Revert (rows)

[s-celles]

Hello Yuri,

when you have a table you may be more interested by latest values (last rows) than first ones.
It will be nice to provide a --revert (rows) flag to gtabview.
(revert is not sort descending)

Reverting columns might be also useful but personally I'm not very interested by such a feature.

Kind regards

[wavexx]

Maybe there should be a quick(er) way to focus the last item as well?

[s-celles]

I think you might consider the console version. When you will have Blaze support to browse large table.
You will be able to do:

$ gtabview dialect+driver://user:password@locahost:port/database:table --revert

It will be a nice feature to see last rows first

[wavexx]

I was also thinking to add negative positions support in start_pos.
start_pos=(-1, 0) would move to the last row.

[s-celles]

It can also be a nice feature.

Anyway Blaze doesn't like dat[::-1].

Is there a SQL syntax to get last rows first (without sorting a given column descending) ?

[wavexx]

Flip Y/X+transposition would allow to "rotate" the dataset without other extras, which I had some uses for in the past.

[wavexx]

So I'm thinking to put this in, and allow the user/constructor to take flip_x/y/transpose as arguments, and maybe some shortcuts as well, such as rotate_90/180/270.

However, what about row/column numbers?

When viewing a DataFrame, there's no issue: the index will be transposed/shown as-is, meaning that the original index is always visible.

But imagine flipping a plain vector. Do you expect line numbers to scroll in reverse as well?

I was thinking about this, but I cannot make up my mind on the behavior.

[s-celles]

Hi Yuri,

I will revert index but not row numbers

Kind regards