Канал: Learn Data with Mark

DuckDB dynamic column selection gets even better

DuckDB dynamic column selection gets even better

Ollama and LanceDB: The best combination for Local RAG?

Ollama and LanceDB: The best combination for Local RAG?

Searching images on my laptop with LanceDB

Searching images on my laptop with LanceDB

Rewriting RAG Queries with OpenAI Structured Outputs

Rewriting RAG Queries with OpenAI Structured Outputs

DuckDB function chaining: The simpler SQL you didn't know you needed

DuckDB function chaining: The simpler SQL you didn't know you needed

Why OpenAI's new Structured Outputs feature is awesome!

Why OpenAI's new Structured Outputs feature is awesome!

What Are Matryoshka Embeddings?

What Are Matryoshka Embeddings?

How to evaluate retrieval in RAG pipelines

How to evaluate retrieval in RAG pipelines

Hybrid Search for RAG in DuckDB (Reciprocal Rank Fusion)

Hybrid Search for RAG in DuckDB (Reciprocal Rank Fusion)

Full-Text Search vs Vector Search (RAG with DuckDB)

Full-Text Search vs Vector Search (RAG with DuckDB)

Search-Based RAG with DuckDB and GLiNER

Search-Based RAG with DuckDB and GLiNER

Local RAG with llama.cpp

Local RAG with llama.cpp

A UI to quantize Hugging Face LLMs

A UI to quantize Hugging Face LLMs

Mistral 7B Function Calling with llama.cpp

Mistral 7B Function Calling with llama.cpp

Does Mistral 7B function calling ACTUALLY work?

Does Mistral 7B function calling ACTUALLY work?

Mistral 7B Function Calling with Ollama

Mistral 7B Function Calling with Ollama

Hugging Face SafeTensors LLMs in Ollama

Hugging Face SafeTensors LLMs in Ollama

Are LLaVA variants better than original?

Are LLaVA variants better than original?

An Ollama Chatbot Arena (with Streamlit)

An Ollama Chatbot Arena (with Streamlit)

Ollama can run LLMs in parallel!

Ollama can run LLMs in parallel!

Serverless GenAI with Beam (GPU as a service)

Serverless GenAI with Beam (GPU as a service)

Voice to Text on a Mac with insanely-fast-whisper

Voice to Text on a Mac with insanely-fast-whisper

How does OpenAI Function Calling work?

How does OpenAI Function Calling work?

Semantic Router: No more rogue LLM chatbots?

Semantic Router: No more rogue LLM chatbots?

Running LLMs on a Mac with llama.cpp

Running LLMs on a Mac with llama.cpp

GLiNER: Easiest way to do Entity Extraction in 2024?

GLiNER: Easiest way to do Entity Extraction in 2024?

Visualising embeddings with t-SNE

Visualising embeddings with t-SNE

Exploring the comments of AI YouTube channels

Exploring the comments of AI YouTube channels

Google Gemma 2B vs 7B with Ollama

Google Gemma 2B vs 7B with Ollama

SLIM: Small models for specific tasks by LLMWare

SLIM: Small models for specific tasks by LLMWare

Ollama adds OpenAI API support

Ollama adds OpenAI API support

Content Discovery with Embeddings (ft. Qdrant/FastEmbed)

Content Discovery with Embeddings (ft. Qdrant/FastEmbed)

LLaVA 1.6 is here...but is it any good? (via Ollama)

LLaVA 1.6 is here...but is it any good? (via Ollama)

Ollama has a Python library!

Ollama has a Python library!

Langroid: Chat to a CSV file using Mixtral (via Ollama)

Langroid: Chat to a CSV file using Mixtral (via Ollama)

User-Selected metadata in RAG Applications with Qdrant

User-Selected metadata in RAG Applications with Qdrant

Building a local ChatGPT with Chainlit, Mixtral, and Ollama

Building a local ChatGPT with Chainlit, Mixtral, and Ollama

Constraining LLMs with Guidance AI

Constraining LLMs with Guidance AI

Running Mixtral on your machine with Ollama

Running Mixtral on your machine with Ollama

LLaVA: A large multi-modal language model

LLaVA: A large multi-modal language model

Perplexity AI: An Online LLM

Perplexity AI: An Online LLM

Image search with OpenAI CLIP and Streamlit

Image search with OpenAI CLIP and Streamlit

LangChain Parent-Child Retriever for better RAG

LangChain Parent-Child Retriever for better RAG

LLMs on your own machine using CTransformers

LLMs on your own machine using CTransformers

FastEmbed: Text Embeddings on the CPU

FastEmbed: Text Embeddings on the CPU

Hugging Face's Text Embeddings Inference Library

Hugging Face's Text Embeddings Inference Library

Hugging Face GGUF Models locally with Ollama

Hugging Face GGUF Models locally with Ollama

Few Shot Prompting with Llama2 and Ollama

Few Shot Prompting with Llama2 and Ollama

Running Mistral AI on your machine with Ollama

Running Mistral AI on your machine with Ollama

GPT 3.5 Chat vs Instruct

GPT 3.5 Chat vs Instruct

Summarizing Emails with OpenAI

Summarizing Emails with OpenAI

Approximate Nearest Neighbours in FAISS: Cell Probe 101

Approximate Nearest Neighbours in FAISS: Cell Probe 101

An introduction to vector search

An introduction to vector search

Retrieval Augmented Generation with OpenAI/GPT and Chroma

Retrieval Augmented Generation with OpenAI/GPT and Chroma

Running a Hugging Face LLM on your laptop

Running a Hugging Face LLM on your laptop

Returning consistent/valid JSON with OpenAI/GPT

Returning consistent/valid JSON with OpenAI/GPT

TrueSkill - Xbox Live's Rating Algorithm

TrueSkill - Xbox Live's Rating Algorithm

Enums in DuckDB

Enums in DuckDB

5 ways that DuckDB makes SQL better

5 ways that DuckDB makes SQL better

Transposing columns to rows with UNPIVOT in DuckDB

Transposing columns to rows with UNPIVOT in DuckDB

Let's talk about PIVOT in DuckDB

Let's talk about PIVOT in DuckDB

Swap nulls for 0s with PIVOT #duckdb

Swap nulls for 0s with PIVOT #duckdb

Creating dummy data with DuckDB's user defined functions (UDFs)

Creating dummy data with DuckDB's user defined functions (UDFs)

Ingesting #csv files from #github into #duckdb

Ingesting #csv files from #github into #duckdb

You can now PIVOT in #duckdb!?

You can now PIVOT in #duckdb!?

Python's match/case statement will simplify your code

Python's match/case statement will simplify your code

Upserts in Apache Pinot

Upserts in Apache Pinot

Controlling the segment size with desired segment size in Apache Pinot

Controlling the segment size with desired segment size in Apache Pinot

Controlling the segment size with row threshold in Apache Pinot

Controlling the segment size with row threshold in Apache Pinot

What is the segment threshold in Apache Pinot?

What is the segment threshold in Apache Pinot?

DuckDB made JSON processing even easier

DuckDB made JSON processing even easier

I installed JupySQL to see if it really improves Jupyter Notebooks

I installed JupySQL to see if it really improves Jupyter Notebooks

SQL Aggregate vs Aggregate Window Functions

SQL Aggregate vs Aggregate Window Functions

SQL Window Functions for Beginners

SQL Window Functions for Beginners

DuckDB and Streamlit: Building a Tennis Head2Head App

DuckDB and Streamlit: Building a Tennis Head2Head App

Composable Queries with DuckDB

Composable Queries with DuckDB

Querying DuckDB with PRQL

Querying DuckDB with PRQL

How are integers encoded in Apache Parquet?

How are integers encoded in Apache Parquet?

How are strings encoded in Apache Parquet?

How are strings encoded in Apache Parquet?

Row Group Size in Parquet: Not too big, not too small

Row Group Size in Parquet: Not too big, not too small

Projection and Predicate pushdown in Apache Parquet

Projection and Predicate pushdown in Apache Parquet

Row Groups in Apache Parquet

Row Groups in Apache Parquet

Querying JSON Documents with DuckDB

Querying JSON Documents with DuckDB

Command Line Data Visualization with DuckDB and YouPlot

Command Line Data Visualization with DuckDB and YouPlot

Querying SQLite databases with DuckDB

Querying SQLite databases with DuckDB

Streaming data into Apache Kafka with kcat and jq

Streaming data into Apache Kafka with kcat and jq

Exporting CSV files to Parquet with Pandas, Polars, and DuckDB

Exporting CSV files to Parquet with Pandas, Polars, and DuckDB

Error rendering in Python 3.10 and 3.11 with tea.xyz

Error rendering in Python 3.10 and 3.11 with tea.xyz

tea.xyz - A multi language package manager to tame the language zoo

tea.xyz - A multi language package manager to tame the language zoo

Parsing ISO8601 DateTime Strings in Python 3.11

Parsing ISO8601 DateTime Strings in Python 3.11

Null arrays with the jq JSON processor

Null arrays with the jq JSON processor

Sorting lists of dictionaries in Python

Sorting lists of dictionaries in Python

Querying Parquet files on S3 with DuckDB

Querying Parquet files on S3 with DuckDB

Using DuckDB to diff Apache Parquet schemas

Using DuckDB to diff Apache Parquet schemas

Formatting numbers in Pandas DataFrames

Formatting numbers in Pandas DataFrames

Joining CSV files on the fly with DuckDB

Joining CSV files on the fly with DuckDB

How does DuckDB deal with dirty data in CSV files?

How does DuckDB deal with dirty data in CSV files?

Using DuckDB to analyze the data quality of Apache Parquet files

Using DuckDB to analyze the data quality of Apache Parquet files

An introduction to Apache Parquet

An introduction to Apache Parquet

Converting a Jupyter Notebook to Streamlit

Converting a Jupyter Notebook to Streamlit

Creating headline numbers with Streamlit Metrics

Creating headline numbers with Streamlit Metrics

Querying Apache Pinot from Python

Querying Apache Pinot from Python

Importing the enriched stream into Apache Pinot | Building a Real-Time Analytics Application

Importing the enriched stream into Apache Pinot | Building a Real-Time Analytics Application

JSONPath Aggregation Functions

JSONPath Aggregation Functions

The Unix Fold Command: Limiting the column width of text

The Unix Fold Command: Limiting the column width of text

Massaging events in Kafka with Faust stream processor | Building a Real-Time Analytics Application

Massaging events in Kafka with Faust stream processor | Building a Real-Time Analytics Application

Parsing access log entries in Python | Building a Real-Time Analytics Application

Parsing access log entries in Python | Building a Real-Time Analytics Application

Importing log entries into Apache Kafka | Building a Real-Time Analytics Application

Importing log entries into Apache Kafka | Building a Real-Time Analytics Application