text_plain_output_1.png image_output_1.png
import pandas as pd # data processing, CSV file I/O (e.g. pd.read_csv)

import numpy as np
import pandas as pd
from subprocess import check_output
frame = pd.read_csv('../input/HR_comma_sep.csv').rename(columns={'sales': 'position'})

pd.DataFrame({'dtypes': frame.dtypes, 'isnull': pd.isnull(frame).any(), 'count distinct': [len(frame[name].unique()) for name in frame.columns], 'max': frame.select_dtypes(exclude=['object']).max(), 'min': frame.select_dtypes(exclude=['object']).min(), 'std': frame.select_dtypes(exclude=['object']).std()}, index=frame.columns).sort_values('count distinct', ascending=False)