Verification Checklist

Use this checklist to verify your development environment is correctly set up.

Command Line Verification

Open Command Prompt and run these commands:

1. Python Version

python --version

Expected output: Python 3.x.x (3.10 or higher recommended)

2. Pip Version

pip --version

Expected output: pip 2x.x.x from ...

3. Package Verification

pip list | findstr pandas
pip list | findstr xlsxwriter

Expected output: Should show pandas and xlsxwriter with version numbers

VS Code Verification

1. Extensions Installed

Open VS Code and go to Extensions (Ctrl+Shift+X). Verify these are installed:

Extension	How to Check
Python	Search "Python" - should show "Installed"
Jupyter	Search "Jupyter" - should show "Installed"

2. Python Interpreter

1. Press Ctrl+Shift+P
2. Type "Python: Select Interpreter"
3. You should see at least one Python installation listed

Jupyter Notebook Test

Create a new notebook and run this complete verification:

# Cell 1: Import Test
import sys
import pandas as pd
import numpy as np
import xlsxwriter
import json
import io

print("=" * 50)
print("ENVIRONMENT VERIFICATION")
print("=" * 50)
print(f"Python Version: {sys.version}")
print(f"Pandas Version: {pd.__version__}")
print(f"NumPy Version: {np.__version__}")
print(f"XlsxWriter Version: {xlsxwriter.__version__}")
print("All imports successful!")

# Cell 2: DataFrame Test
data = [
    {"name": "Customer A", "currency": "IDR", "amount": 1000000},
    {"name": "Customer B", "currency": "USD", "amount": 5000},
    {"name": "Customer C", "currency": "IDR", "amount": 2000000}
]

df = pd.DataFrame(data)
print("DataFrame created successfully!")
print(f"Shape: {df.shape}")
print(f"Columns: {list(df.columns)}")
df

# Cell 3: Excel Creation Test
bio = io.BytesIO()

with pd.ExcelWriter(bio, engine='xlsxwriter') as writer:
    df.to_excel(writer, sheet_name='Test', index=False)

    # Access workbook for formatting test
    workbook = writer.book
    worksheet = writer.sheets['Test']

    # Add a format
    header_format = workbook.add_format({
        'bold': True,
        'bg_color': '#4472C4',
        'font_color': 'white'
    })

    # Apply format to header row
    for col_num, value in enumerate(df.columns):
        worksheet.write(0, col_num, value, header_format)

    # Set column widths
    worksheet.set_column('A:A', 15)
    worksheet.set_column('B:B', 10)
    worksheet.set_column('C:C', 15)

print("Excel file created successfully!")
print(f"File size: {len(bio.getvalue())} bytes")
print("XlsxWriter formatting applied!")

# Cell 4: Data Processing Test
# Filter test
idr_only = df[df['currency'] == 'IDR']
print(f"Filtered to IDR: {len(idr_only)} records")

# Aggregation test
total = df['amount'].sum()
print(f"Total amount: {total:,.0f}")

# Group by test
by_currency = df.groupby('currency')['amount'].sum()
print("\nAmount by currency:")
print(by_currency)

print("\nAll data processing operations successful!")

Expected Results

All four cells should run without errors and display:

1. Cell 1: Python and package versions
2. Cell 2: A DataFrame with 3 rows
3. Cell 3: "Excel file created successfully!" message
4. Cell 4: Filtered results and aggregations

Checklist Summary

• python --version shows Python 3.10+
• pip --version shows pip version
• VS Code Python extension installed
• VS Code Jupyter extension installed
• Notebook Cell 1 runs (imports work)
• Notebook Cell 2 runs (DataFrame works)
• Notebook Cell 3 runs (Excel creation works)
• Notebook Cell 4 runs (Data processing works)

Troubleshooting

"ModuleNotFoundError: No module named 'pandas'"

pip install pandas xlsxwriter numpy openpyxl

Kernel keeps crashing

1. Close VS Code
2. Open Command Prompt
3. Run: pip install --upgrade ipykernel
4. Restart VS Code

"No kernel" error in notebook

1. Click "Select Kernel" in top-right
2. Choose "Python Environments"
3. Select your Python installation

Wrong Python version

1. Press Ctrl+Shift+P
2. Type "Python: Select Interpreter"
3. Choose the correct Python version