-
Notifications
You must be signed in to change notification settings - Fork 134
/
rows.1.txt
121 lines (77 loc) · 2.82 KB
/
rows.1.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
.TH ROWS "1" "Sep 2015" "ROWS 0.1.0" "common, beautiful interface to tabular data, no matter the format"
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 <[email protected]>.
This manual page was written by Paulo Roberto Alves de Oliveira (aka kretcheu)
<[email protected]> for the Debian project (but may be used by others).
COPYRIGHT
Copyright © 2014-2019 Álvaro Justen.
License LGPLv3+: GNU LGPL version 3 or later <http://gnu.org/licenses/lgpl.html>.
This is free software: you are free to change and redistribute it. There is NO
WARRANTY, to the extent permitted by law.