Er, OK, not such a big goal. Even with zero Pandas experience, it took about five minutes of skimming the first page of documentation to figure out:
In : %load_ext sql In : data = %sql postgresql://will:longliveliz@localhost/shakes select * from work In : import pandas as pd In : s = pd.DataFrame.from_records(data, columns=data.keys)
This is not the only way to move data from an RDBMS to Pandas (there's pandas.io.sql, for example), and I don't know enough about Pandas to know if it's the best way. But I bet it's the easiest way.