home.social

#csvkit — Public Fediverse posts

Live and recent posts from across the Fediverse tagged #csvkit, aggregated by home.social.

  1. scy @[email protected] ·
    CW: shell script in post

    YAML to XLSX pipeline 🙈

    This was fun, but I don't want to do it again.

    curl -s raw.githubusercontent.com/AKVo \
    | uvx yq '(.l10n.strings + .l10n.frontend_strings) | to_entries | map(select(.value | type == "object")) | map({id: .key} + .value)' \
    | uvx --from csvkit in2csv -f json > strings.csv \
    && libreoffice --headless --infilter=CSV:44,34,76,1 --convert-to xlsx strings.csv

    #YAML #CSV #XSLX #jq #yq #CSVKit #LibreOffice #CLI #ShellScript #bash

    #yaml #csv #xslx #jq #yq #csvkit
  2. Thor Galle @[email protected] ·

    @hamatti I'm also appreciating #csvkit! Its csvstat summarization tool recently helped me solve a problem where I had to find duplicate values in a csv, and it did so very quickly!

    #csvkit
  3. Juhis @[email protected] ·

    Wanna query your CSV data with SQL? You don't need to build a database for that.

    csvsql is one of the tools in the brilliant csvkit toolbox.

    With it, you can query your CSV files with SQL queries directly from your command line.

    hamatti.org/posts/use-sql-to-q

    #csv #sql #csvkit #data #query #CommandLine #cli

    #csv #sql #csvkit #data #query #commandline
  4. Seve_py :vim: :python: @seve_py ·

    and

    tessarinseve.pythonanywhere.co

    #sqlite #csvkit
  5. alexanderadam @[email protected] ·

    RT @[email protected]

    I have the feeling that especially #datascientists who used to work with #python tools are moving to @[email protected].

    Current artefact: @[email protected]'s csvzip which was inspired by #csvkit:

    github.com/PopulateTools/csvzi

    🐦🔗: twitter.com/alexanderadam__/st

    #datascientists #python #csvkit
  6. skunksarebetter @skunksarebetter ·

    is a suite of processing tools.

    csvkit is a collection of utilities which modify and translate data in the comma separated values (CSV) format. csvkit includes tools to translate to CSV (including from , , spreadsheets), for modifying CSV (cleaning, joining, sorting), and for output/analysis (SQL searching, JSON output, Markdown).

    Website 🔗️: github.com/wireservice/csvkit

    apt 📦️: csvkit

    #csv #json #opensource #fossmendations #csvkit #sql