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

df_train = pd.read_csv('../input/spaceship-titanic/train.csv')
df_train

df_test = pd.read_csv('../input/spaceship-titanic/test.csv')
df_test

df_train.isnull().sum()

df_train.isnull().mean() * 100

df_test.isnull().mean() * 100

tt = pd.concat([df_train.drop('Transported', axis=1), df_test])
tt

tt['mean_exp_'] = tt['sum_exp_'] / tt['Pid2_']
tt