Skip to main content

Connect Jupyter Notebook Pandas to Postgres



First install Python library Psycopg2 to connect to PostgreSQL:

!pip install psycopg2

Now import the necessary libraries:

import pandas as pd
import psycopg2 as pg
import pandas.io.sql as psql

Connect to the DB Server:

conn = pg.connect("postgres://username:password@server:port/dbname")

Execute a Query:
df = pd.read_sql('select* from table_name', conn)
df.head()
Labels:

Comments

Post a Comment

Popular posts from this blog

Error: Write to Disk Access Denied - Troubleshooting - BitTorrent

I have downloaded Bit Torrent software and when trying to download I got an error after few seconds saying:

Error: Write to Disk Access Denied
Solving this problem is so simple:
Shut down BitTorrent program.
Go to Start and in the small search box on top of windows start button start typing Bittorrent and the program will show, right click with the mouse on the icon and Run as Administrator.
All ur problems are sorted out now and you can enjoy downloading...
Good Luck.
12 comments
Read more

Importing SSL certs to Coldfusion Railo OR Lucee keystore

If you are having the below error:
Railo 3.3.4.003 Error (javax.net.ssl.SSLHandshakeException)Messagesun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested targetCausejavax.net.ssl.SSLHandshakeException

This means you are trying to invoke an https webservice. to invoke an SSL webserver you need to import the certificate into Railo by using keytool command. Below are the steps on how to do this:

1- use fire fox to open the webservice and click on the padlock as shown on the below image:

2-Click on more information as below:
 3- Click on View Certificate as below:
4-Click on details as below:
 5- Now export the certificate and save it to your computer with .cer extension.

6- Search in railo folder for the keytool command location, in my case it was under railo\jdk\bin

7-  Search in railo folder for the cacerts location, in my case it was under railo\lib\railo-s…
2 comments
Read more

Datatables Server Side Processing using Coldfusion

Datatables Server Side Processing using Coldfusion

Code: Coldfusion Server Side For Datatables

Environment: Datatables 1.10.16, Lucee 5.x, Postgres 9.6

Issue Date: 04/10/2017

Notes:
There is no warranty that the code will work on a different environment or different version.
You may create the DB table using the postgres.sql script included.
This project was tested and fully functioning.

Features:
Datatables query paging
Case Insensitive search filter to all query results.
Sort by all fields including date.
This repository does not include all Datatables features. In the code I'm only using datatables.js, but you may extend the features.

 Repository is available on github.
1 comment
Read more