harolducon-omc/categorizaromc ? reverse-engineered prompt

Build me a web app for local survey categorization and insights, with login, a React front end, a Python API, and PostgreSQL for saved studies and results. I want users to upload CSV or XLSX files, pick the sheet if there are several, then choose which columns to classify, review the categories, and process questions one by one without losing work. It should support brand, sentiment, themes, awareness, and manual correction, and save drafts and final results so they stay after restart.

Please also include a separate Awareness screen that can run on its own, load files directly, let the user set entities and aliases, and export the report. Add Excel export with separate sheets for data, categorized questions, and the category dictionary. Support API keys per user for AI providers, store them securely, and make it easy to change them in settings. If you need current docs for any libraries or providers, look them up online.