How to get table.colname dataframe results using SQL Achemy / Pandas?

Question

I have a join SQL Request where the output of 2 tables is produced :

 ss= 'Select t.*, p.* from table1 t, table1 p where t.table2_id=p.table1_id'
 df = pd.read_sql_query(ss, self.db_con)

However, some columns have same name since the table is stripped. (ex: id, id ...)

How to get table.colname in the dataframe ?

Thanks

IMO it doesn't make much sense to join table with itself using the same id column... What are you trying to achieve? — MaxU - stand with Ukraine
– MaxU - stand with Ukraine, Commented Nov 17, 2016 at 21:01

Brian Malehorn · Accepted Answer · 2016-11-18 01:50:24Z

1

You have to rename the conflicting columns with AS:

SELECT t.id AS t_id, p.id AS p_id, FROM table1 t, table2 p WHERE t.id = p.id

answered Nov 18, 2016 at 1:50

Brian Malehorn

2,69518 silver badges17 bronze badges

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

2 Comments

tensor Over a year ago

Do I need to explicitely rename it ? (sometimes, I dont know the elements in advance , using *).

Brian Malehorn Over a year ago

Basically yes. Similar question with better answer here: stackoverflow.com/questions/329931/sql-select-join-is-it-possible-to-prefix-all-columns-as-prefix

Collectives™ on Stack Overflow

How to get table.colname dataframe results using SQL Achemy / Pandas?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related