import pandas as pd

import numpy as np

from pandas import Series, DataFrame

df = DataFrame(np.random.randn(1000, 5))

print(df)

#basic observations

print(df.head())

print(df.tail())

print(df.describe())

column = df[0]

print(column.head())

print(column[np.abs(column) > 3])

#any -> aleast one element in the row

print(df[(np.abs(df) > 3).any(1)])

df[(np.abs(df) > 3)] = np.sign(df) * 5

print(df.describe())