Import CSV in Postgress using Python Panda , compare two csv files and compare two db table using python
import pandas as pd from sqlalchemy import create_engine import psycopg2 import csv def importCSV(): engine = create_engine('postgresql://credr:credr@localhost/credr_db1') df = pd.read_csv('/Users/ranvijay/Desktop/data_sanity_21082015/Katta_data.csv') df.to_sql('data_anlytics', engine, if_exists='replace') df = pd.read_csv('/Users/ranvijay/Desktop/data_sanity_21082015/Data_sanity_21082015.csv') df.to_sql('data_bd', engine, if_exists='replace') # df = pd.read_csv('/Users/ranvijay/Downloads/BikeSheet.csv') # df.to_sql('bikesheet_dump', engine, if_exists='replace') def comapre_two_table(): # execute our Query conn_string = "host='localhost' dbname='credr_db1' user='credr' password='credr'" # print the connection string we will use to connect print "Connecting to database\n ->%s" % (conn_string) # get