Anatomy of a Field Analysis Worksheet
xleda is a Python/Excel powered EDA tool that creates workbooks from dataframes or data files that are highly optimized to explore, define, and document data sets.
-
Works on Windows or MacOS as a Python package, a CLI, or as a service that lets you create workbooks by right-clicking supported files.
-
There are some amazing EDA tools available to data professionals. You shouldn't have to start from scratch to include Microsoft Excel among them.
Docs |
Sample Workbooks |
Basic Usage |
Configuration |
Usage Notes |
Examples |
Quick-Start Guide for Non-Developers
Top view of a Field Analysis worksheet.
xleda Components
Basic Usage
Use wb() to quickly create an xleda workbook from a dataframe, a dictionary of dataframes, or a supported data file.
From a Dataframe
from xleda import wb
import seaborn as sns
# < your dataframe goes here >
df = sns.load_dataset("titanic")
# Creates xleda.xlsm in the current directory
wb(df)
From a Dictionary of Dataframes
from xleda import wb
import seaborn as sns
# < your dataframes go here >
df1 = sns.load_dataset("titanic")
df2 = sns.load_dataset("penguins")
# Creates Titanic.xlsm in the current directory
wb({"Titanic": df1,
"Penguins": df2})
From a File
from xleda import wb
from pathlib import Path
# < your data file goes here >
duckdb_file = "https://github.com/InfoDesigner/xleda/raw/refs/heads/main/examples/data/duckdb.duckdb"
# Creates duckdb.xlsm in the current directory
# Includes data from all tables in the db file
wb(duckdb_file)
From the CLI
# Creates 'userdata.xlsm' in the current directory
xleda wb 'https://github.com/InfoDesigner/xleda/raw/refs/heads/main/examples/data/userdata.parquet'
# Shows the help command
xleda --help
# Shows the wb help command
xleda wb --help
From Right-Clicking | After running xleda install
Windows |
MacOS |
|
|
Compatibility
| Desktop Excel |
Requires the full version of Microsoft Excel (2016+) on either MacOS or Windows to create workbooks
|
| Supported Data |
Supports pandas dataframes, CSV, DuckDB, SQLite, Feather, Parquet, Pickle, Excel, RData, JSON, and XML |
1 maintainer
Metadata
1 maintainer
Release files for xleda 0.9.27
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | Provenance | Actions |
|---|---|---|---|---|
| xleda-0.9.27.tar.gz | 434.7 kB | Without provenance | Details for xleda-0.9.27.tar.gz |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Actions Reset |
|---|---|---|---|---|
| xleda-0.9.27-py3-none-any.whl | Python 3 | none | any | Details for xleda-0.9.27-py3-none-any.whl |
Total release size: 869.3 kB
Release files / xleda-0.9.27.tar.gz
| Download URL | xleda-0.9.27.tar.gz |
|---|---|
| Size | 434.7 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
8844d82fcaf3fcd106e3e82c528d56a928f33aae6ef5ca9e4a50f15a443c5f13
|
|
BLAKE2b-256 checksum How to use checksums |
43b88d90112f76130cf93c297da02457995920e237183a438bbf874eaf08b917
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
Yes |
| Uploaded via |
uv/0.12.15 {"installer":{"name":"uv","version":"0.12.15","subcommand":["publish"]},"python":null,"implementation":{"name":null,"version":null},"distro":{"name":"Ubuntu","version":"24.04","id":"noble","libc":null},"system":{"name":null,"release":null},"cpu":null,"openssl_version":null,"setuptools_version":null,"rustc_version":null,"ci":true}
|
Release files / xleda-0.9.27-py3-none-any.whl
| Download URL | xleda-0.9.27-py3-none-any.whl |
|---|---|
| Size | 434.6 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
bdc8650db2c42097ac6b33da2d833e94b5ef9621c8305c5f3d286e17d966d1ad
|
|
BLAKE2b-256 checksum How to use checksums |
e9bb97780d9e902cb5787416e83fdf695c9e5e50216713804ecaf127cd796f6c
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
Yes |
| Uploaded via |
uv/0.12.15 {"installer":{"name":"uv","version":"0.12.15","subcommand":["publish"]},"python":null,"implementation":{"name":null,"version":null},"distro":{"name":"Ubuntu","version":"24.04","id":"noble","libc":null},"system":{"name":null,"release":null},"cpu":null,"openssl_version":null,"setuptools_version":null,"rustc_version":null,"ci":true}
|
Security for xleda 0.9.27
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
No provenance found
None of the files in this release were uploaded with provenance metadata.
A note on package security
PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.
To learn more about protecting yourself from malicious actors, visit our package security documentation.
