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
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
xleda-0.9.24.tar.gz
(434.7 kB
view details)
Built Distribution
Filter files by name, interpreter, ABI, and platform.
If you're not sure about the file name format, learn more about wheel file names.
Copy a direct link to the current filters
xleda-0.9.24-py3-none-any.whl
(434.6 kB
view details)
File details
Details for the file xleda-0.9.24.tar.gz.
File metadata
- Download URL: xleda-0.9.24.tar.gz
- Upload date:
- Size: 434.7 kB
- Tags: Source
- Uploaded using Trusted Publishing? Yes
- Uploaded via:
uv/0.12.0 {"installer":{"name":"uv","version":"0.12.0","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}
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
a1b6276acd9e692078d27874d04c7a0b2e8158d0702eddc2b48e2fe2db50dae1
|
|
| MD5 |
ac8eee230feef462ceb6d84da18cf113
|
|
| BLAKE2b-256 |
1c7c28d8fdee4df663bef0a0ab1e28cf4f80df707b6c74d8f866976bd707c489
|
File details
Details for the file xleda-0.9.24-py3-none-any.whl.
File metadata
- Download URL: xleda-0.9.24-py3-none-any.whl
- Upload date:
- Size: 434.6 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? Yes
- Uploaded via:
uv/0.12.0 {"installer":{"name":"uv","version":"0.12.0","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}
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
b1e949c0d3213002937dec222c3a3fc0b391a41adcda763897e81503687531fa
|
|
| MD5 |
855d304b2251214b78438eaf60b5140d
|
|
| BLAKE2b-256 |
0e6c08b10307bf143e3c6aa64cfc3f93a7bba38b97079cbb747fe958382c5960
|
