text_plain_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['sum_exp_'] = tt['RoomService'] + tt['FoodCourt'] + tt['ShoppingMall'] + tt['Spa'] + tt['VRDeck']
tt