---
title: "011"
description: "Load _ from database into **"
date: 2020-06-07
published: false
tags:
  - data
  - python
template: hot-tip
---

Load _data_ from database into **pandas**

``` python
import pandas as pd
from sqlalchemy import create engine

engine = create_engine('postgresql://scott:tiger@localhost:5432/mydatabase')

sql = 'select * from inventory'

with engine.connect() as connection:
    inventory = pd.read_sql(sql, con)
engine.dispose()

```