DCC_Assignment_4

To clone this repo

sudo apt install git
git clone https://github.com/Naveen-Pal/DCC_Assignment_4
cd DCC_Assignment_4

1. Convert The PDF to CSV file

To convert PDF to CSV file I make the python file using the given reference link
The python file is named as pdf_to_csv.py in this repo.

2. Import to mysql

To import I use mysql command line interface

1. Create a new databases name "dcc_4"
2. Create Two table with name individual and political.
3. import csv file in this tables

create database dcc_4;
create table individual;
LOAD DATA INFILE '/var/lib/mysql-files/individual.csv'
INTO TABLE Individual
FIELDS TERMINATED BY ',' 
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 LINES

3. Create required frontend and backend code

I write a php code to handle the backend because I was facing issue with Flask.

4. Start the server

I am using linux so I am confortable with the apache2 server. Use below command to start the server

sudo systemctl apache2 start

Below are some screenshots: