如何在AWS Lambda中导入pandas？Windows打包层结构错误求助

Got it, let's break down how to solve this — AWS Lambda runs on a Linux-based runtime, so Python packages compiled on Windows (like pandas, which relies heavily on C extensions) will fail because of incompatible binaries and directory structure mismatches. Here are actionable solutions that work directly from Windows, no Mac/Linux machine required:

Option 1: Use Docker to Simulate Lambda's Linux Environment (Most Reliable) #

This is the go-to method because Docker lets you replicate Lambda's exact environment on Windows:

• First, install Docker Desktop for Windows and make sure it's running (enable WSL 2 integration if prompted, it's required for Linux containers).
• Create a new folder (e.g., lambda-pandas-layer) on your Windows machine. Inside it, make a requirements.txt file with just this line:

  pandas
  

  (Add any other dependencies you need here, like numpy or openpyxl.)
• Open PowerShell or Command Prompt, navigate to your new folder, and run this Docker command (replace 3.9 with your Lambda's Python version, e.g., 3.10):

  docker run --rm -v "$(pwd):/var/task" public.ecr.aws/lambda/python:3.9 pip install -r requirements.txt -t python/lib/python3.9/site-packages/
  

  This command mounts your local folder into the Lambda Linux container, installs pandas into the exact directory structure Lambda expects, and copies the files back to your Windows machine.
• Once the install finishes, you'll have a python folder in your directory. Zip this folder directly (make sure the zip root contains the python folder, not a parent folder).
• Upload this zip as your Lambda layer, and it should work perfectly with your Lambda function.

Option 2: Use AWS CloudShell (No Local Tools Needed) #

If you don't want to mess with Docker, use AWS's built-in Linux terminal:

• Log into the AWS Console, click the CloudShell icon (top-right corner, looks like a terminal window).
• Run these commands in CloudShell (replace 3.9 with your Lambda Python version):

  mkdir lambda-layer && cd lambda-layer
  echo "pandas" > requirements.txt
  pip install -r requirements.txt -t python/lib/python3.9/site-packages/
  zip -r pandas-layer.zip python/
  

• After the zip is created, click the "Actions" button in CloudShell, select "Download file", and enter lambda-layer/pandas-layer.zip to save it to your Windows machine.
• Upload this zip to your Lambda layer as usual.

Option 3: Manual Fix (Not Recommended) #

If you already have a Windows-built pandas package, you could try adjusting it, but this is error-prone:

• First, restructure your files to match Lambda's required format: zip -> python/lib/pythonX.X/site-packages/[all dependency files] (X.X is your Python version).
• Delete all Windows-specific files like .pyd, .exe, and any __pycache__ folders.
• Warning: Pandas and its dependencies (like numpy) have compiled C binaries that are Windows-specific. Even after restructuring, these won't run on Lambda's Linux environment, so this method will almost certainly fail. Stick to the first two options instead.

Key Notes #

• Always match your Lambda's Python version when building the layer — a 3.9 layer won't work with a 3.10 Lambda function.
• Avoid including extra files in your zip (like Windows system files or .git folders) to prevent loading errors.

内容的提问来源于stack exchange，提问作者Corentin Moreau