Skip to content

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.

Notifications You must be signed in to change notification settings

pmutua/drf_csv_xlsx_file_upload

Repository files navigation

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