/drf_csv_xlsx_file_upload

API uploads .csv/.xlsx for bulk data, queries via text for accurate results. Integrated with OpenAI using Langchain library. Watch full implementation via this video below.

Primary LanguageJavaScript

Drf File Upload

API allows a user to upload .csv & xlsx files containing patient names and emails then load the data into the database. Query Database and csv data with langchain.

Requirements:

Python >=3.0
Django==3.0
djangorestframework==3.14.0
pandas==2.0.3
langchain==0.0.229
openai
tabulate

Features

  • Uploading a file.

  • Import works only for *.csv or *.xlsx files.

  • Show error message if one tries to upload files in other formats.

  • Show response when the import is done

  • Show response if import wasn't done and the reason why.

  • List all patients after the file has been uploaded.

  • Query Database with LLM

  • Query CSV with LLM

Usage

Run:

python manage.py makemigrations

python manage.py migrate

Create User

python manage.py createsuperuser follow prompt

Making a POST request

    alt text

View the new data seeded

    alt text

TODO

  • Show error message if the file is corrupted.

Author

Philip Mutua