Awesome GitHub RepositoriesColumn Expression Modifiers

EasyExcel is a Java processing library designed for reading and writing XLS, XLSX, and CSV files. It functions as a memory-efficient spreadsheet parser, an object-relational mapper that binds spreadsheet columns to Java class fields, and a stream-based exporter for handling high-volume data. The library distinguishes itself through a streaming model that processes large files row-by-row via listeners to prevent heap memory overflow. It also operates as a template engine, allowing the population of predefined spreadsheet files with dynamic data while preserving original layouts and styles. Br

SQLAlchemy is a comprehensive Python SQL toolkit and object-relational mapper that provides a full suite of tools for interacting with relational databases. It serves as a foundational layer for database connectivity, offering both a high-level object-oriented interface for data persistence and a programmatic SQL expression language for constructing complex, dialect-agnostic queries. The project distinguishes itself through its sophisticated unit of work persistence, which coordinates atomic transactions and tracks object state changes to minimize redundant database operations. It provides a

VisiData is a terminal-based interactive data analysis tool and browser designed for exploring, filtering, and sorting large tabular datasets. It functions as a structured data inspector that loads and flattens complex formats like JSON, XML, and PCAP into interactive sheets, as well as a terminal file manager for navigating directories and performing staged filesystem operations. The project distinguishes itself by rendering data visualizations, such as scatter plots and histograms, directly in the terminal using Unicode Braille characters. It provides a Python-based data wrangling environme

Tabulator is an interactive data table library and virtual DOM data grid used to create high-performance tables from JSON or arrays. It functions as a hierarchical data viewer and a spreadsheet interface component, capable of rendering thousands of records efficiently through viewport-based virtualization and progressive loading. The library distinguishes itself by providing a full spreadsheet interface mode with multi-sheet management, cell range selection, and bulk copy-paste capabilities. It supports complex data architectures, including nested data field mapping, expandable tree structure

Ce projet est une couche d'accès aux données SQL et un générateur de schéma qui permet de lire et d'écrire des enregistrements dans des bases de données relationnelles en traitant les tables comme de simples structures de données. Il fonctionne comme un générateur de schéma automatique qui crée des tables et des colonnes de base de données à la volée en fonction de la structure des données entrantes. L'outil fournit un chargeur en masse haute performance qui importe de grands jeux de données en utilisant des transactions atomiques groupées pour garantir la cohérence des données. Il inclut également un mécanisme d'upsert d'enregistrement qui détermine s'il faut mettre à jour une ligne existante ou en insérer une nouvelle en fonction d'identifiants uniques. Le système couvre la gestion dynamique des schémas, incluant la résolution implicite des colonnes et le provisionnement des tables. Il fournit en outre une interface de requête basée sur des collections pour récupérer des enregistrements ou extraire des valeurs uniques sans écrire de requêtes manuelles.

ExcelDataReader is a C# library used to extract data and metadata from Microsoft Excel spreadsheets and CSV files. It functions as a workbook parser that converts spreadsheet content into structured data sets for programmatic access and iteration. The project includes a specialized metadata extractor for retrieving cell-level details, such as number formats, styles, row heights, column widths, and merged cell ranges. It also provides a stream processor for parsing plain text CSV files with customizable encoding and separator detection. The library supports the OpenXML standard for modern spr