CSV Data Importer is a web application that allows users to upload CSV files containing financial data and import the data into a PostgreSQL database using Django Rest Framework (DRF) on the backend and React on the frontend. The application provides an easy-to-use interface for users to upload their CSV files, view the data in tabular format, and import it into the database for further analysis.

• Backend: Django Rest Framework (DRF), PostgreSQL, psycopg2, pandas, and pytz.
• Frontend: React, Axios, and react-toastify.

• File Upload: Users can upload CSV files containing financial data using a user-friendly interface.

• Database Import: Validated CSV data is imported into a PostgreSQL database using Django models.

• Data Display: Users can view the imported data in a tabular format, making it easy to review and analyze.

Clone the project

  git clone https://github.com/pnaskardev/CSV-Data-Importer

Go to the project directory

  cd CSV-Data-Importer

Install venv

  pip install venv

Create a python virtual environement

  python -m venv venv

Start the virtual environement

  venv\Scripts\activate

install required packages

  pip install -r requirements.txt

Create and migrate the database:

    python manage.py makemigrations
    python manage.py migrate

Start the Server

  python manage.py runserver

In a seperate terminal Go to the frontend directory

cd frontend
npm install

Start the React development server:

npm start

Access the App at

  http://127.0.0.1:3000/

  GET /get/

  POST /upload/

• @pnaskardev