KASA VLAB · ADVANCED PYTHON PROGRAMMING

Data Preparation — Excel & SQL Database

Real binary file → Python → Dataset in Memory
GOLDEN CELL · 2 TABS
📥 Sample Files:Download ExcelDownload SQLite DBDownload → Browse the same file → Run Python.
TAB 1 · EXCEL FILE

Excel → Python → Data in Memory

Browse a real .xlsx workbook. VLAB mounts the binary file into the Python virtual filesystem, then Python reads the Sales sheet.

XLSX

Excel File

Click to Browse .xlsx
→
Py

Python

openpyxl reads workbook + worksheet
→
▦

Data in Memory

Run Python to create dataset

Python Console / Code Editor

No Excel file selected.
Try modifying the code: choose columns, filter Paid rows, calculate totals, or inspect another sheet.

Console / Memory Inspector

PYTHON CONSOLE
Waiting for an Excel file...
Memory: dataset not created yet.
TAB 2 · SQL DATABASE

SQLite DB → Python SQL → Data in Memory

Browse a real .db/.sqlite database. Python connects with sqlite3, executes SQL, and converts query rows into Python dictionaries.

DB

SQLite Database

Click to Browse .db / .sqlite
→
Py

Python + SQL

sqlite3 connects and executes SELECT
→
▦

Data in Memory

Run query to create dataset

Python Console / Code Editor

No database selected.
Try changing WHERE, ORDER BY, selected columns, or calculate aggregates such as AVG(score).

Console / Memory Inspector

PYTHON CONSOLE
Waiting for a SQLite database...
Memory: query dataset not created yet.