text_html_output_1.png text_plain_output_1.png
import pandas as pd

def summary(df):
    result = pd.DataFrame(df.dtypes, columns=['data type'])
    result['#duplicate'] = df.duplicated().sum()
    result['#missing'] = df.isnull().sum().values
    result['#unique'] = df.nunique().values
    return result

train_df = pd.read_csv('/kaggle/input/playground-series-s3e14/train.csv')
test_df = pd.read_csv('/kaggle/input/playground-series-s3e14/test.csv')

train_df.drop(['id'], axis=1, inplace=True)
test_df.drop(['id'], axis=1, inplace=True)

test_df.describe().T