text_plain_output_1.png
import pandas as pd

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

df_train = pd.read_csv('/kaggle/input/house-prices-advanced-regression-techniques/train.csv')
df_test = pd.read_csv('/kaggle/input/house-prices-advanced-regression-techniques/test.csv')

dataframe = pd.DataFrame(df_train.isnull().sum().sort_values(ascending=False))

dataframe = pd.DataFrame(df_test.isnull().sum().sort_values(ascending=False))

null = df_train.isnull().sum() / df_train.shape[0] * 100
null

dataframe_null = pd.DataFrame(null.sort_values(ascending=False))

col_to_drop = null[null > 50].keys()
train_df = df_train.drop(col_to_drop, axis=1)

len(train_df.columns)

len(train_df.columns[train_df.isnull().any()])

train_df.isnull().values.sum()