ROWS(1)

📦 version 0.5.0~dev0~1~1d5a326, in debian bookworm, debian trixie, ubuntu jammy, ubuntu noble, ubuntu questing, ubuntu resolute, ubuntu stonking

✨ NAME ✨

okay so bestie, welcome to rows — the common, beautiful interface to tabular data, no matter the format 💖 (and yeah, this is the rows(1) manual page, section 1, general commands, we're fancy like that)

🌸 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. periodt 💅

🎀 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...

🍓 convert

✨ SYNOPSIS ✨

rows convert [OPTIONS] SOURCE DESTINATION

💜 DESCRIPTION 💜

Convert table on source URI to destination. literally just glow-up your data into a whole new format, no cap 🌈

🌸 OPTIONS 🌸

  • --input-encoding TEXT
  • --output-encoding TEXT
  • --input-locale TEXT
  • --output-locale TEXT
  • --help — Show this message and exit.

🧚 join

✨ SYNOPSIS ✨

rows join [OPTIONS] KEYS SOURCES ... DESTINATION

💜 DESCRIPTION 💜

Join tables from source URIs using key(s) to group rows and save into destination. it's giving main character energy for your datasets fr fr 🫶

🌸 OPTIONS 🌸

  • --input-encoding TEXT
  • --output-encoding TEXT
  • --input-locale TEXT
  • --output-locale TEXT
  • --help — Show this message and exit.

🦋 sort

✨ SYNOPSIS ✨

rows sort [OPTIONS] KEY SOURCE DESTINATION

💜 DESCRIPTION 💜

Sort from source by key(s) and save into destination. putting everything in its right place, iconic behaviour honestly ⭐

🌸 OPTIONS 🌸

  • --input-encoding TEXT
  • --output-encoding TEXT
  • --input-locale TEXT
  • --output-locale TEXT
  • --help — Show this message and exit.

🔥 sum

✨ SYNOPSIS ✨

rows sum [OPTIONS] SOURCES ... DESTINATION

💜 DESCRIPTION 💜

Sum tables from source URIs and save into destination. math but make it cute 🎀

🌸 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 💀

found a lil gremlin in the code? 🐛 not me being dramatic but pls tell the devs — 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). we love a collaborative moment 🫶

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. (yes bestie, that's in all caps for a reason 😭)

okay that's the whole page, you're officially educated ✨ this was ROWS 0.1.0, dated Sep 2015, living in section 1 of the manual — slay, go convert something, mwah 💅🎀🦋

📦 where this page comes from