a technical notebook
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

35 lines
1.0 KiB

  1. tools & toolchains for data munging & analysis
  2. ==============================================
  3. csvkit
  4. ------
  5. This is super handy. Wish I'd started using it sooner:
  6. > csvkit is a suite of utilities for converting to and working with CSV, the
  7. > king of tabular file formats.
  8. >
  9. > ...
  10. >
  11. > csvkit is to tabular data what the standard Unix text processing suite (grep,
  12. > sed, cut, sort) is to text. As such, csvkit adheres to the Unix philosophy.
  13. >
  14. > 1. Small is beautiful.
  15. > 2. Make each program do one thing well.
  16. > 3. Build a prototype as soon as possible.
  17. > 4. Choose portability over efficiency.
  18. > 5. Store data in flat text files.
  19. > 6. Use software leverage to your advantage.
  20. > 7. Use shell scripts to increase leverage and portability.
  21. > 8. Avoid captive user interfaces.
  22. > 9. Make every program a filter.
  23. -- [csvkit 0.9.0](https://csvkit.readthedocs.org/en/0.9.0)
  24. jq
  25. --
  26. Also super handy, if a notch less intuitive. Powerful DSL / pretty-printer /
  27. filter for working with JSON records at the command line.
  28. - http://stedolan.github.io/jq/