Why my favourite API is a zipfile on the European Central Bank's website

Re:Why my favourite API is a zipfile on the European Central... by llimllib on Friday September 15, 2023 @03:42PM (#37528202)

nushell does too:

    /tmp/> "Name,Department,Salary
    ::: John Doe,IT,60000
    ::: Jane Smith,Finance,75000
    ::: Alice Johnson,HR,65000
    ::: Bob Anderson,IT,71000" |
    :::     from csv | 
    :::     select Name Salary | 
    :::     sort-by -r Salary
    ╭───┬───────────────┬────────╮
    │ # │     Name      │ Salary │
    ├───┼───────────────┼────────┤
    │ 0 │ Jane Smith    │  75000 │
    │ 1 │ Bob Anderson  │  71000 │
    │ 2 │ Alice Johnson │  65000 │
    │ 3 │ John Doe      │  60000 │
    ╰───┴───────────────┴────────╯

[ Parent | on HN ]

Re:Why my favourite API is a zipfile on the European Central... by shortrounddev2 on Friday September 15, 2023 @03:57PM (#37528393)

Crazy how similar the commands are.

[ Parent | on HN ]

Re:Why my favourite API is a zipfile on the European Central... by marzell on Friday September 15, 2023 @05:13PM (#37529194)

for something a bit more robust, check out DuckDB. It's a library you can embed, use it to run SQL on local files as well as connect to databases, do joins, analytics, etc.

[ Parent | on HN ]

Re:Why my favourite API is a zipfile on the European Central... by scumola on Friday September 15, 2023 @05:31PM (#37529374)

Agreed. The article mentioned duckdb and I'm her to thumbs-up the use of DuckDB wholeheartedly. If you like the world of public CSV files as data sources that you can query or cross-query, duckdb is the tool for you. Just follow the demo on the duckdb website and you'll be wow'd for sure.

[ Parent | on HN ]

Re:Why my favourite API is a zipfile on the European Central... by llimllib on Friday September 15, 2023 @08:37PM (#37530812)

I use both, and I have found it helpful to have nushell around when munging csv and parquet files, even when working with duckdb - I find it quicker to ask for the first few rows of a thing or do simple stuff with it, then deeper analysis with duckdb.

They're a powerful pairing

[ Parent | on HN ]