SELECT column in pandas

Posted by Kevin

Selecting one, multiple, or all columns from a table in SQL translated to Python's pandas.

Selecting a single column

In SQL:

SELECT
  column_1
FROM 
  table;

In pandas:

table['column_1']

Selecting multiple columns

In SQL:

SELECT 
  column_1,
  column_2
FROM 
  table;

In pandas:

table[['column_1', 'column_2']]

Selecting all columns

In SQL:

SELECT
  *
FROM 
  table;

In pandas:

table

References