Acme-CPANModules-BrowsingTableInteractively
view release on metacpan or search on metacpan
is still a great glue to help make those tools work together better for
you.
1) Visidata, <https://www.visidata.org>
This is currently my favorite. It's terminal-based, written in Python,
and has more features than any other tools currently written in Perl, by
far. vd has support for many formats, including CSV, TSV, Excel, JSON,
and SQLite. It makes it particularly easy to create summary for your
table like histogram or sum/average/max/min/etc, or add new columns, or
edit some cells. It also has visualization features like XY-plots.
It has the concept of "sheets" like sheets in a spreadsheet workbook so
anytime you filter rows/columns or create summary or do some other
derivation from your data, you create a new sheet which you can edit,
save, and destroy later as needed and go back to your original table. It
even presents settings and metadata as sheets so you can edit them as a
normal sheet.
It has plugins, and I guess it should be simple enough to create a
plugin so you can filter rows or add columns using Perl expression
instead of the default Python, if needed.
My CLI framework Perinci::CmdLine (Perinci::CmdLine::Lite, v1.918+) has
support for Visidata. You can specify command-line option "--format=vd"
to browse the output of your CLI program in Visidata.
lib/Acme/CPANModules/BrowsingTableInteractively.pm view on Meta::CPAN
a favorite choice for writing tools these days. That said, Perl is still a great
glue to help make those tools work together better for you.
1) **Visidata**, <https://www.visidata.org>
This is currently my favorite. It's terminal-based, written in Python, and has
more features than any other tools currently written in Perl, by far. vd has
support for many formats, including CSV, TSV, Excel, JSON, and SQLite. It makes
it particularly easy to create summary for your table like histogram or
sum/average/max/min/etc, or add new columns, or edit some cells. It also has
visualization features like XY-plots.
It has the concept of "sheets" like sheets in a spreadsheet workbook so anytime
you filter rows/columns or create summary or do some other derivation from your
data, you create a new sheet which you can edit, save, and destroy later as
needed and go back to your original table. It even presents settings and
metadata as sheets so you can edit them as a normal sheet.
It has plugins, and I guess it should be simple enough to create a plugin so you
can filter rows or add columns using Perl expression instead of the default
Python, if needed.
My CLI framework <pm:Perinci::CmdLine> (<pm:Perinci::CmdLine::Lite>, v1.918+)
has support for Visidata. You can specify command-line option `--format=vd` to
browse the output of your CLI program in Visidata.
lib/Acme/CPANModules/BrowsingTableInteractively.pm view on Meta::CPAN
Let me say first that the best tools are not Perl-based since sadly Perl is not
a favorite choice for writing tools these days. That said, Perl is still a great
glue to help make those tools work together better for you.
1) B<Visidata>, L<https://www.visidata.org>
This is currently my favorite. It's terminal-based, written in Python, and has
more features than any other tools currently written in Perl, by far. vd has
support for many formats, including CSV, TSV, Excel, JSON, and SQLite. It makes
it particularly easy to create summary for your table like histogram or
sum/average/max/min/etc, or add new columns, or edit some cells. It also has
visualization features like XY-plots.
It has the concept of "sheets" like sheets in a spreadsheet workbook so anytime
you filter rows/columns or create summary or do some other derivation from your
data, you create a new sheet which you can edit, save, and destroy later as
needed and go back to your original table. It even presents settings and
metadata as sheets so you can edit them as a normal sheet.
It has plugins, and I guess it should be simple enough to create a plugin so you
can filter rows or add columns using Perl expression instead of the default
Python, if needed.
My CLI framework L<Perinci::CmdLine> (L<Perinci::CmdLine::Lite>, v1.918+)
has support for Visidata. You can specify command-line option C<--format=vd> to
browse the output of your CLI program in Visidata.
2) B<DataTables>, L<https://datatables.net>
( run in 0.440 second using v1.01-cache-2.11-cpan-de7293f3b23 )