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/
Parameter | Type | Description |
---|---|---|
file |
file |
Required CSV file that you want to upload. |