Adding prompts, examples and memory to Python agent

Short Course Q&A LangChain for LLM Application Development
1

How can we add prompts, examples and memory to Python agent (create_pandas_dataframe_agent) for querying database (e.g. sql db)?