Select rows from a DataFrame based on values in a column in pandas?

Question

How to select rows from a DataFrame based on values in some column in pandas? In SQL I would use: select * from table where colume_name = some_value. *I tried to look at pandas documentation but did not immediately find the answer.*

Answer 1

import pandas as pd

import numpy as np

df = pd.DataFrame(np.random.randn(8, 4), columns=['A', 'B', 'C', 'D'])

print(df[df['A']>1])