Farshid/Ashouri

data-analysis

6 posts tagged “data-analysis”.

  1. 2025

  2. Generated a summary of nested JSON data

    I was trying to figure out the shape of the JSON object from https://github.com/simonw/coronavirus-data-gov-archive/blob/master/data latest.json?raw=true - which is 3.2MB and heavily nested, so it's…

    python json data-analysis data-structures recursion
    1 min read

  3. Embedding paragraphs from my blog with E5-large-v2

    Xeophon suggested that E5-large-v2 as an embedding model that was worth a closer look. It's an interesting model. It's trained to match queries against passages of text.

    llm embeddings ai nlp python
    6 min read
  4. 2024

  5. Cumulative total over time in SQL

    This is a quick trick for creating a cumulative chart of the total number of items created over time based just on their creation date.

    sql database data-analysis cumulative-sum github
    1 min read

  6. Comparing database rows before and after with SQLite JSON functions

    Here's a trick I've been using to compare the rows in a table before and after I perform an operation against it. It works well for a few hundred (and maybe a few thousand) rows.

    sqlite sql json database data-analysis
    1 min read
  7. 2023

  8. Consecutive groups in SQL using window functions

    I have a database table with all of my Swarm checkins since 2011, created using my swarm-to-sqlite tool.

    sql window-functions database data-analysis sqlite
    3 min read

  9. Comparing two training datasets using sqlite-utils

    WizardLM is "an Instruction-following LLM Using Evol-Instruct". It's a fine-tuned model on top of Meta's LLaMA.

    llm ai data-analysis sqlite sqlite-utils
    3 min read