datadock

Datadock

Datadock is a Python library built on top of PySpark, designed to simplify data interoperability between files of different formats and schemas in modern data engineering pipelines.

It automatically detects schemas from CSV, JSON and Parquet files, groups structurally similar files, and allows standardized reading of all grouped files into a single Spark DataFrame — even in highly heterogeneous datasets.

✨ Key Features

• 🚀 Automatic parsing of multiple file formats: .csv, .json, .parquet
• 🧠 Schema-based file grouping by structural similarity
• 📊 Auto-selection of dominant schemas
• 🛠️ Unified read across similar files into a single PySpark DataFrame
• 🔍 Schema insight for diagnostics and inspection

🔧 Installation

pip install datadock

🗂️ Expected Input Structure

Place your data files (CSV, JSON or Parquet) inside a single folder. The library will automatically detect supported files and organize them by schema similarity.

/data/input/
├── sales_2020.csv
├── sales_2021.csv
├── products.json
├── archive.parquet
├── log.parquet

🧪 Usage Example

from datadock import scan_schema, get_schema_info, read_data

path = "/path/to/your/data"

# Logs schema groups detected
scan_schema(path)

# Retrieves schema metadata
info = get_schema_info(path)
print(info)

# Loads all files from schema group 1
df = read_data(path, schema_id=1, logs=True)
df.show()

📌 Public API

scan_schema

Logs the identified schema groups found in the specified folder.

get_schema_info

Returns a list of dictionaries containing:

• schema_id: ID of the schema group
• file_count: number of files in the group
• column_count: number of columns in the schema
• files: list of file names in the group

read_data

Reads and merges all files that share the same schema.
If schema_id is not specified, the group with the most columns will be selected.

✅ Requirements

• Python 3.10+
• PySpark

📚 Motivation

In real-world data engineering workflows, it's common to deal with files that represent the same data domain but have slight structural variations — such as missing columns, different orders, or evolving schemas.
Datadock automates the process of grouping, inspecting, and reading these files reliably, allowing you to build pipelines that are schema-aware, scalable, and format-agnostic.

📄 License

This project is licensed under the MIT License.