Aws Sdk Pandas

---
name: aws-sdk-pandas
description: "Routes AWS SDK for pandas (awswrangler) workflows across S3
  lakehouse data, Athena/Glue catalogs, SQL connectors, runtime configuration,
  and AWS service integrations."
disable-model-invocation: true
metadata:
  disco-role: operating
license: Apache 2.0
---

# AWS SDK for pandas

Use this skill when a request names `awswrangler`, `aws-sdk-pandas`, `Pandas on AWS`, or a `wr.*` API from the repository.

This repo is a Python API package, not a CLI tool. The first questions are usually:
- how to install the right extras,
- how to import and verify the runtime,
- which AWS service family the user is working with,
- and which AWS credentials, region, or optional backend are required.

Read `references/runtime-overview.md` first for install, extras, and runtime facts.
Read `references/troubleshooting.md` when import errors, missing extras, region issues, or AWS service prerequisites are blocking you.
Read `references/repo-provenance.md` before deciding whether this skill is current for the checkout.
Run `scripts/check_runtime.py` after installation to confirm importability and optional dependency availability.

## Route map

| If the user asks about... | Read this sub-skill |
| --- | --- |
| Installing, importing, setting `WR_*` env vars, switching `wr.engine` / `wr.memory_format`, or debugging missing extras | `sub-skills/runtime-and-config/SKILL.md` |
| `wr.s3.*` object, file-format, dataset, S3 Tables, or S3 Vectors workflows | `sub-skills/s3-lakehouse/SKILL.md` |
| `wr.catalog.*`, `wr.athena.*`, `wr.data_quality.*`, or `wr.cleanrooms.*` workflows | `sub-skills/catalog-and-query/SKILL.md` |
| `wr.redshift.*`, `wr.data_api.*`, `wr.mysql.*`, `wr.postgresql.*`, `wr.sqlserver.*`, or `wr.oracle.*` workflows | `sub-skills/sql-connectors/SKILL.md` |
| `wr.dynamodb.*`, `wr.timestream.*`, `wr.opensearch.*`, `wr.neptune.*`, `wr.quicksight.*`, `wr.cloudwatch.*`, `wr.emr.*`, `wr.emr_serverless.*`, `wr.sts.*`, `wr.secretsmanager.*`, or `wr.chime.*` workflows | `sub-skills/service-integrations/SKILL.md` |

## Shared operating pattern

1. Confirm the runtime with `scripts/check_runtime.py` when the package was just installed or the environment changed.
2. Pick the service-family sub-skill that matches the `wr.*` API surface.
3. Use `wr.config` and `boto3.Session` for defaults, region, and credentials.
4. Install only the extras needed for the chosen workflow family.
5. Keep live AWS operations separate from local smoke checks; if a workflow needs credentials or managed AWS resources, say so early.

## Common signals

- `NoCredentialsError` or `NoRegionError` usually means the AWS session is not configured.
- `Missing optional dependency ...` usually means the relevant extra was not installed.
- Ray/Modin questions belong in `runtime-and-config` even when they affect `wr.s3` or `wr.athena` calls.
- Live AWS service prerequisites and IAM needs belong in the nearest service sub-skill, not here.

## Shared references and scripts

- `references/runtime-overview.md` for install commands, supported versions, and optional extras.
- `references/troubleshooting.md` for cross-cutting import, dependency, and credential failures.
- `scripts/check_runtime.py` for a safe import/config/extra check.