This is the command rows that can be run in the OnWorks free hosting provider using one of our multiple free online workstations such as Ubuntu Online, Fedora Online, Windows online emulator or MAC OS online emulator
PROGRAM:
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>.
Use rows online using onworks.net services
