1ROWS(1)common, beautiful interface to tabular data, no matter the formatROWS(1)
2
3
4
5NAME
6 rows - common, beautiful interface to tabular data, no matter the format
7
8SYNOPSIS
9 rows [OPTIONS] COMMAND [ARGS] ...
10
11DESCRIPTION
12 No matter in which format your tabular data is: rows will import it,
13 automatically detect types and give you high-level Python objects so you can
14 start working with the data instead of trying to parse it.
15 It is also locale-and-unicode aware.
16
17OPTIONS
18 --help Show this message and exit
19
20COMMANDS
21
22 convert - Convert table on `source` URI to...
23 join - Join tables from `source` URIs using `key(s)`...
24 sort - Sort from `source` by `key(s)` and save into...
25 sum - Sum tables from `source` URIs and save into...
26
27 SYNOPSIS
28 rows convert [OPTIONS] SOURCE DESTINATION
29
30 DESCRIPTION
31 Convert table on `source` URI to `destination`
32
33 OPTIONS
34 --input-encoding TEXT
35
36 --output-encoding TEXT
37
38 --input-locale TEXT
39
40 --output-locale TEXT
41
42 --help Show this message and exit.
43
44 SYNOPSIS
45 rows join [OPTIONS] KEYS SOURCES ... DESTINATION
46
47 DESCRIPTION
48 Join tables from `source` URIs using `key(s)` to group rows and save into
49destination`
50
51 OPTIONS
52 --input-encoding TEXT
53
54 --output-encoding TEXT
55
56 --input-locale TEXT
57
58 --output-locale TEXT
59
60 --help Show this message and exit.
61
62 SYNOPSIS
63 rows sort [OPTIONS] KEY SOURCE DESTINATION
64
65 DESCRIPTION
66 Sort from `source` by `key(s)` and save into `destination`
67
68 OPTIONS
69 --input-encoding TEXT
70
71 --output-encoding TEXT
72
73 --input-locale TEXT
74
75 --output-locale TEXT
76
77 --help Show this message and exit.
78
79 SYNOPSIS
80 rows sum [OPTIONS] SOURCES ... DESTINATION
81
82 DESCRIPTION
83 Sum tables from `source` URIs and save into `destination`
84
85 OPTIONS
86 --input-encoding TEXT
87
88 --output-encoding TEXT
89
90 --input-locale TEXT
91
92 --output-locale TEXT
93
94 --help Show this message and exit.
95
96EXAMPLES
97 - To export csv from site and converting locales from pt_BR to en both UTF-8
98
99 rows convert --input-locale pt_BR.UTF-8 --output-locale en.UTF-8 "<URL>"
100data.csv
101
102 - To export xls from site and no changes locales
103
104 rows convert "<URL>" data.xls
105
106 - To convert csv to xls
107
108 rows convert file.csv file.xls
109
110REPORTING BUGS
111 To report a bug please visit rows' issue tracking system at
112 <https://github.com/turicas/rows/issues>.
113
114AUTHOR
115 Written by Álvaro Justen <alvarojusten@gmail.com>.
116
117 This manual page was written by Paulo Roberto Alves de Oliveira (aka
118kretcheu)
119 <kretcheu@gmail.com> for the Debian project (but may be used by others).
120
121COPYRIGHT
122 Copyright © 2014-2015 Álvaro Justen.
123 License GPLv3+: GNU GPL version 3 or later
124<http://gnu.org/licenses/gpl.html>.
125 This is free software: you are free to change and redistribute it. There is
126NO
127 WARRANTY, to the extent permitted by law.
128
129
130
131ROWS 0.1.0 Sep 2015 ROWS(1)