Natalie Huang — UC Davis undergraduate with self-reported beginner Python skills, assigned a 2-week (~26 hour) internship building a drug-comparison agent.
Primary deliverable: A working Gemini AI agent that accepts two drug names and produces comparison outputs.
Specific outputs required:
Agent functionality: The system must autonomously call 2 database tools per submitted drug and assemble results into a structured table.
Database integrations (2 mandatory):
Technical stack: Python, Streamlit, google-generativeai, requests library
Programming paradigm: “Computation Engine — Streamlit form (paste drug names) → side-by-side comparison table”
| Week | Duration | Focus |
|---|---|---|
| 1 | ~12h | Learn PubChem + FAERS APIs and Gemini basics; pair programming to build skeleton from starter template |
| 2 | ~14h | Wire up Streamlit table + AI summary, test with 2 example runs, write README |
The plan explicitly depends on: (a) a shared starter template existing before week 1, and (b) Shucheng (PhD mentor) paired as technical guide through week 2.
BindingDB, LiverTox, toxicity classifiers, 50-drug calibration, withdrawn-drug validation, and 200+ drug pathways analysis—deliberately excluded to fit beginner timeline.