Azure Openai Python Chatbot using excel data to identify classification search for sourcing manager

Question

I want develop an conversational Azure-OpenAI chatbot seamlessly integrated with multiple Excel data for precise classification and efficient sourcing manager searches. This chatbot will leverage the power of Azure and OpenAI technologies to enhance user interactions, ensuring accurate identification of classifications and providing targeted information about different managers.

Answer 1

Hi Dash, Debabrata, Thanks for the wonderful question. Here are few steps as below which can help you with the solution! There are services which are available in the Azure OpenAI called bring your own data using Azure OpenAI inside the Python. There are few prerequisites that are available for the enabling the connection:

• An Azure subscription - Create one for free.
• Access granted to Azure OpenAI in the desired Azure subscription. Azure OpenAI requires registration and is currently only available to approved enterprise customers and partners. See Limited access to Azure OpenAI Service for more information. You can apply for access to Azure OpenAI by completing the form at https://aka.ms/oai/access. Open an issue on this repo to contact us if you have an issue.
• An Azure OpenAI resource with a chat model deployed (for example, GPT-3 or GPT-4). For more information about model deployment, see the resource deployment guide.
  • Your chat model can use version gpt-35-turbo (0301), gpt-35-turbo-16k, gpt-4, and gpt-4-32k. You can view or change your model version in Azure OpenAI Studio.
• Be sure that you are assigned at least the Cognitive Services Contributor role for the Azure OpenAI resource.

Navigate to Azure OpenAI Studio and sign-in with credentials that have access to your Azure OpenAI resource. During or after the sign-in workflow, select the appropriate directory, Azure subscription, and Azure OpenAI resource. To bring your data, Select the Chat playground tile. On the Assistant setup tile, select Add your data (preview) > + Add a data source.
Once you had connected, Create a new folder named openai-python for your project and a new Python code file named main.py and connect the data over there. For more details: https://learn.microsoft.com/en-us/azure/ai-services/openai/use-your-data-quickstart?tabs=command-line%2Cpython&pivots=programming-language-python Hope this answer helps you with solution! Please comment below if you need any assistance on the same. Happy to help! Regards,

Chakravarthi Rangarajan Bhargavi

• Please kindly accept the answer and vote 'Yes' if you feel helpful to support the community, thanks a lot.