text_plain_output_1.png
import pandas as pd

import time

train = pd.read_csv('../input/tabular-playground-series-sep-2021/train.csv', index_col='id')
test = pd.read_csv('../input/tabular-playground-series-sep-2021/test.csv', index_col='id')
train_df = pd.read_csv('../input/tabular-playground-series-sep-2021/train.csv', index_col='id')

training_missing_val_count_by_column = train.isnull().values.sum()
test_missing_val_count_by_column = test.isnull().values.sum()

pd.set_option('display.max_rows', None)
train.describe().T

train2 = train.dropna(axis='rows')
print('rows ; ', train.shape[0], '\nrows with missing data : ', train.shape[0] - train2.shape[0])
train3 = train.dropna(axis='columns')
print('\ncolumns ; ', train.shape[1], '\ncolumns with missing data : ', train.shape[1] - train3.shape[1])
print('\n', time.time())