ROWS

NAME

rows - common, beautiful interface to tabular data, no matter the format

SYNOPSIS

rows [OPTIONS] COMMAND [ARGS] ...

DESCRIPTION

No matter in which format your tabular data is: rows will import it, automatically detect types and give you high-level Python objects so you can start working with the data instead of trying to parse it. It is also locale-and-unicode aware.

OPTIONS

--help Show this message and exit

COMMANDS

convert - Convert table on ‘source‘ URI to...
join - Join tables from ‘source‘ URIs using ‘key(s)‘...
sort - Sort from ‘source‘ by ‘key(s)‘ and save into...
sum - Sum tables from ‘source‘ URIs and save into...

SYNOPSIS
rows convert [OPTIONS] SOURCE DESTINATION

DESCRIPTION
Convert table on ‘source‘ URI to ‘destination‘

OPTIONS
--input-encoding TEXT

--output-encoding TEXT

--input-locale TEXT

--output-locale TEXT

--help Show this message and exit.

SYNOPSIS
rows join [OPTIONS] KEYS SOURCES ... DESTINATION

DESCRIPTION
Join tables from ‘source‘ URIs using ‘key(s)‘ to group rows and save into destination‘

OPTIONS
--input-encoding TEXT

--output-encoding TEXT

--input-locale TEXT

--output-locale TEXT

--help Show this message and exit.

SYNOPSIS
rows sort [OPTIONS] KEY SOURCE DESTINATION

DESCRIPTION
Sort from ‘source‘ by ‘key(s)‘ and save into ‘destination‘

OPTIONS
--input-encoding TEXT

--output-encoding TEXT

--input-locale TEXT

--output-locale TEXT

--help Show this message and exit.

SYNOPSIS
rows sum [OPTIONS] SOURCES ... DESTINATION

DESCRIPTION
Sum tables from ‘source‘ URIs and save into ‘destination‘

OPTIONS
--input-encoding TEXT

--output-encoding TEXT

--input-locale TEXT

--output-locale TEXT

--help Show this message and exit.

EXAMPLES

•

To export csv from site and converting locales from pt_BR to en both UTF-8

rows convert --input-locale pt_BR.UTF-8 --output-locale en.UTF-8 "<URL>" data.csv

•

To export xls from site and no changes locales

rows convert "<URL>" data.xls

•

To convert csv to xls

rows convert file.csv file.xls

REPORTING BUGS

To report a bug please visit rows’ issue tracking system at <https://github.com/turicas/rows/issues>.

AUTHOR

Written by Ãlvaro Justen <alvarojusten@gmail.com>.

This manual page was written by Paulo Roberto Alves de Oliveira (aka kretcheu) <kretcheu@gmail.com> for the Debian project (but may be used by others).

COPYRIGHT

Copyright © 2014-2015 Ãlvaro Justen. License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>. This is free software: you are free to change and redistribute it. There is NO WARRANTY, to the extent permitted by law.