/Python-Postgres-Project

This repo contains the code and snapshots of the small project i have created using python and postgresql. I have used Python library named psycopg2 and through that i have transferred the data from an excel file to a database in PostgreSQL.

Primary LanguageJupyter Notebook

Python-PostgreSQL-Project

Description

I have tried to transfer data from csv files that i took from kaggle.com, into Postgres database. For connecting with the psql server i have used a python library named psycopg2. With the help of that i have made connection and cursor which were used throughout the script to access database objects and perform queries.

All the data from the three tables was completely transferred to the database and ERD of the sample database was also made using PgAdmin ERD tool. The snasphsots of the data being shown in three different platforms has been provided below.

Queries Data through cursor

Screenshot from 2023-12-31 21-25-42

Queries Data through psql (command line)

Screenshot from 2023-12-31 21-24-43

Queries Data through PgAdmin

Screenshot from 2023-12-31 21-22-20

Data model of the sample Database

Screenshot from 2023-12-31 21-26-39