jsonxplode 1.0.1

Efficient JSON flattening for complex nested structures

jsonxplode

Efficient JSON flattening for complex nested structures

jsonxplode converts nested JSON structures into flat tabular format while preserving all data, including complex nested arrays and objects with arbitrary depth.

Installation

pip install jsonxplode

Usage

from jsonxplode import flatten

# Handles any JSON structure
data = {
    "users": [
        {"profile": {"name": "John", "settings": {"theme": "dark"}, "location": ["city1", "city2"]}},
        {"profile": {"name": "Jane", "settings": {"theme": "light"}}}
    ]
}

flattened_data = flatten(data)

Returns:

[
    {'users.profile.name': 'John', 'users.profile.settings.theme': 'dark', 'user.profile.location': 'city1'},
    {'users.profile.name': 'John', 'users.profile.settings.theme': 'dark', 'user.profile.location': 'city2'},
    {'users.profile.name': 'Jane', 'users.profile.settings.theme': 'light'}
]

DataFrame Output (Optional)

from jsonxplode import to_dataframe

# Requires pandas to be installed separately
df = to_dataframe(data)

Note: to_dataframe requires pandas (pip install pandas) but the core flatten function has zero dependencies.

Features

• Arbitrary nesting depth - handles deeply nested objects and arrays
• Conflict resolution - automatically manages key path conflicts
• Memory efficient - processes large datasets with minimal overhead
• Zero dependencies - pure Python implementation (core function)
• Array expansion - properly handles nested arrays with row duplication

Performance

• 7,900 rows with 23 columns processed in 0.146 seconds
• Memory usage: ~16MB for above mentioned worload
• Consistent performance across varying data structures