Awesome GitHub RepositoriesPivot Table Aggregators

Ramda is a functional JavaScript standard library and toolset for immutable data transformation and composition. It provides a comprehensive suite of pure utility functions designed to enable declarative data processing pipelines. The library is distinguished by its use of automatic function currying and a data-last argument order. These design patterns allow multi-argument functions to be partially applied, simplifying the construction of processing chains where data is passed through a sequence of operations. The toolkit covers broad data manipulation capabilities, including list processin

Excelize is a library for reading and writing spreadsheet files in the Office Open XML format. It provides a comprehensive suite of tools for programmatically creating, modifying, and analyzing workbooks, worksheets, and cell data, ensuring compatibility across various office software suites through structured XML serialization. The library distinguishes itself with a built-in formula calculation engine that evaluates complex mathematical and logical expressions directly against workbook data. It also features a memory-mapped streaming architecture, which allows for the efficient processing o

Cube is a semantic data layer that provides a unified framework for defining business metrics, dimensions, and relationships across diverse data sources. By acting as a headless business intelligence engine, it transforms raw data into a governed model that can be queried via SQL, REST, and GraphQL interfaces. This architecture ensures consistent data definitions and logic across all downstream analytical applications and reporting tools. The platform distinguishes itself through its integrated conversational AI capabilities, which allow users to explore data using natural language. It orches

Luckysheet upgraded to Univer

This project is an educational resource and a collection of instructional materials for performing data manipulation and statistical analysis using Python. It provides a comprehensive set of guides and code examples for using the Pandas, NumPy, and Matplotlib libraries to analyze structured data. The resource includes a dedicated guide for reshaping, cleaning, and aggregating tabular data and time series via Pandas, alongside a reference for high-performance vectorized operations and linear algebra using NumPy. It also features tutorials for creating publication-quality charts, distribution p

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

vxe-table is a high-performance data table component and UI library for Vue, designed for building data-heavy applications. It functions as a virtualized data grid and spreadsheet UI framework capable of rendering millions of rows by mounting only the visible elements of a dataset. The project distinguishes itself through spreadsheet-like functionality, including cell selection, copy-paste support, and the generation of cross-tabulated pivot tables. It also provides specialized tools for managing complex data hierarchies using virtual trees, row grouping, and cell merging. The library covers

OfficeCLI 是一个无头（headless）办公套件和自动化工具，专为程序化读取、编辑和生成 Microsoft Office 文档而设计。它充当 OOXML 操作库和文档模板引擎，提供了一个独立的二进制文件，允许在无需本地安装办公软件的情况下管理 Word、Excel 和 PowerPoint 文件。 该项目通过将文档操作作为 AI 代理的工具（通过 JSON-RPC 服务器和模型上下文协议）公开而脱颖而出。它通过使用 XPath 进行原始 XML 操作实现了高级自定义，并提供了一个将文档子树转储为可重放 JSON 批处理的序列化系统。 该工具涵盖了广泛的功能，包括具有公式评估和数据透视表生成的程序化电子表格工程，以及全面的文字处理任务（如样式管理、修订跟踪和多语言文本格式化）。它还包括用于数据可视化、将内容提取为结构化 JSON 或高保真 HTML 的工具，以及将 JSON 数据合并到预定义模板中以进行自动化报告生成的实用程序。

Davinci 是一个商业智能和数据可视化平台，用于构建交互式仪表板和报告。它作为一个基于 SQL 的仪表板构建器和多租户分析服务，通过 JDBC 和 CSV 文件连接到数据库，将原始数据转换为可视化组件。 该平台以其细粒度的安全模型而著称，包括与 LDAP 和 OAuth2 身份验证集成的行级和列级权限。它还提供了一个嵌入式可视化工具，允许通过 URL 和框架将安全的、参数化的图表和仪表板插入到外部应用程序中。 该系统涵盖了广泛的能力，包括使用 SQL 模板进行数据建模、用于响应式仪表板的拖放式布局引擎，以及多种可视化类型，如桑基图、雷达图和地理地图。它还包括用于调度基于电子邮件的报告的自动化功能，并利用键值缓存来优化查询性能。

本项目是一个基于 JSON 的表单渲染框架和可视化创建器，专为动态数据采集而设计。它提供了一个 JavaScript 表单构建器库，将 JSON 模式转换为功能性 Web 表单和多步向导，并配有专门的可视化调查创建器，无需编写代码即可设计布局和分支逻辑。 该库的特色在于其双向 PDF 集成，允许将 JSON 模式转换为可填写的 PDF 文档，并从现有 PDF 中提取结构化数据。它还具备创建评分评估和计算器的高级功能，可处理数字输入以提供实时加权结果。 系统涵盖了广泛的功能，包括条件分支和多阶段输入验证、多语言本地化，以及适用于 React、Angular 和 Vue.js 的框架无关渲染。此外，还包括响应数据可视化、基于 CSS 变量的主题化以及 WCAG 无障碍合规性工具。

Zombodb 是一个将 PostgreSQL 与 Elasticsearch 集成的数据库扩展和关系数据索引器。它提供了一个 SQL 搜索接口，允许用户使用标准 SQL 函数和语法（而非原生 JSON API）执行复杂的搜索查询和聚合。该项目将关系数据从 PostgreSQL 同步到远程搜索引擎，以实现高性能的全文本搜索和分析。 该系统通过将关系结构与搜索引擎能力桥接而脱颖而出，特别是通过针对几何和地理类型的地理空间搜索集成。它实现了一个 SQL 转 JSON 的查询映射层，支持在关系环境中直接进行高级文本分析，包括模糊匹配、邻近搜索和相关性评分。 该项目涵盖了广泛的能力领域，包括索引生命周期管理、自动化关系数据同步和复杂的分析聚合。它支持用于基于位置查询的空间索引、自定义文本分析管道，以及用于审计索引统计和集群健康的监控工具。安全性通过使用 TLS 在数据库和搜索引擎之间进行加密连接来处理。

This project is a JavaScript pivot table library and client-side data processor. It provides an interactive interface for transforming raw datasets into summarized tables, heatmaps, and charts, allowing for browser-based data analysis without a backend server. The library distinguishes itself through a drag-and-drop interface for dynamic data exploration and the ability to derive new attributes via date binning or custom logic. It supports flexible data rendering by converting analyzed results into HTML tables or graphical representations using integrated or third-party charting libraries. T

这是一个模型上下文协议 (Model Context Protocol) 服务器，为 AI 智能体提供以编程方式创建、读取和修改 Excel 工作簿的接口。它充当桥梁，使大语言模型能够执行电子表格自动化和数据可视化。 该服务器允许 AI 智能体从原始数据生成原生 Excel 图表和数据透视表，将结构化信息转换为可视化摘要。它提供了一种通过基于协议的连接层进行远程电子表格管理的机制。 该系统涵盖了广泛的电子表格操作功能，包括用于公式和数据验证的单元格级操作、范围的视觉格式化以及布局修改。它还处理工作簿级管理，例如元数据提取、工作表组织和结构化表的创建。

qsv is a high-performance command line toolkit for querying, transforming, and analyzing comma-separated value files. It functions as a data wrangling interface and a tabular data profiler, featuring a query engine capable of executing SQL statements and joins directly on flat files without requiring a database. The project is distinguished by its ability to process massive datasets that exceed available system memory. This is achieved through disk-based external memory processing, including multithreaded merge sorting, on-disk hash tables for deduplication, and lightweight file indexing for

This project is an interactive, web-based notebook environment designed for distributed data science and large-scale computing. It serves as a development tool for executing code and performing data analysis specifically within the Apache Spark framework, providing a browser-based interface that combines code execution with reactive data visualization. The platform distinguishes itself through its deep integration with distributed infrastructure, allowing users to manage cluster resources, configure runtime dependencies, and isolate execution processes for individual notebooks. It supports co