AttributeError: module 'pandas.io.sql' has no attribute 'frame_query'

Question

I am trying to read a posgresql table into a python data frame using following code.

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

connection = pg.connect("dbname=BeaconDB user=admin password=root")
dataframe = psql.frame_query("SELECT * from encounters", connection)

But I get AttributeError: module 'pandas.io.sql' has no attribute 'frame_query' How can I fix this?

which version of pandas are you using.

shivsn
– shivsn

2016-07-20 18:26:49 +00:00
Commented Jul 20, 2016 at 18:26 — shivsn
– shivsn, Commented Jul 20, 2016 at 18:26
I checked using print(pd.__version__), it's 0.18.1

SaikiHanee
– SaikiHanee

2016-07-21 08:17:10 +00:00
Commented Jul 21, 2016 at 8:17 — SaikiHanee
– SaikiHanee, Commented Jul 21, 2016 at 8:17

Community · Accepted Answer · 2017-05-23 12:22:32Z

2

Looking at the pandas.io.sql source, there is no frame_query.

https://github.com/pydata/pandas/blob/master/pandas/io/sql.py

Documentation for pandas.io.sql is here: http://pandas.pydata.org/pandas-docs/stable/io.html#sql-queries

I've looked at pandas documentation from 0.12.0 to latest and the only references to frame_query I've found has been to its deprecation.

I found this SO answer which may address your concerns: https://stackoverflow.com/a/14511960/1703772

However, if you are using pandas version ~ 0.10 when 0.18.1 is available, I have to ask why.

edited May 23, 2017 at 12:22

CommunityBot

11 silver badge

answered Jul 20, 2016 at 18:16

NuclearPeon

6,1175 gold badges51 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

shivsn Over a year ago

In older version of pandas frame_query() is there.

NuclearPeon Over a year ago

@SaikiHanee You are very welcome. I apologize if I sounded rude to you. I thought the documentation would have been more clear as well.

cardamom Over a year ago

frame_query and read_frame have been deprecated now there is only read_frame

Vasin Yuriy · Accepted Answer · 2019-10-16 07:08:29Z

1

Such approach is deprecated,

https://pandas.pydata.org/pandas-docs/version/0.15.2/generated/pandas.io.sql.write_frame.html

use instead: https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.to_sql.html

edited Oct 16, 2019 at 7:08

Vasin Yuriy

5596 silver badges18 bronze badges

answered Jul 16, 2019 at 10:40

Michel Kluger

1731 silver badge6 bronze badges

Collectives™ on Stack Overflow

AttributeError: module 'pandas.io.sql' has no attribute 'frame_query'

2 Answers 2

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related