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

Top Google Adsense Alternatives

Google Adsense is a web tool that allows publishers in the Google Network of content sites to automatically serve text, image, video, and rich media adverts that are targeted to site content and audience. These adverts are administered, sorted, and maintained by Google, and they can generate revenue on either a per-click or per-impression basis.  Google servers advertisers using google adwords platform, while adsense is the publishers platform. Google Adsense is the top Ad Publishers platform over the web ranking number one in web advertising industry. Adsense offers contextual advertisements that covers web sites, blogs, games, videos, mobile browsing etc. What made Google Adsense no. 1 is the reliability, stability, variety of services and large number of publishers including google it self. Also google has a fair platform that detects invalid clicks so google successfully protects its advertisers and also offers its best publishers top CPC. Two reasons are behind people think
11 comments
Read more

CFLDAP Add Active Directory User to a Group

I was trying to add a user to a group and had lots of code formatting etc. I was unable to find a straightforward code to help me. I have prepared the below code to help you using CFLDAP and also I will give you an alternative way using the dsmod command line. Lets start first with the CFLDAP: Now lets add an active directory user to a group using command line: When I wrote the above code I added a bulk list of users to a certain Active Directory group. Sometimes the CFLDAP failed so in the cfcatch I called the dsmode using the cfexecute. Why? Some of the user CN names contained special characters like 'bracket (' this caused an error when using the cfldap to add users to the groups so I had to use the cfexcute which succeeded.
Post a Comment
Read more