text_plain_output_1.png
import pandas as pd

train = pd.read_excel('../input/Data_Train.xlsx')
test = pd.read_excel('../input/Data_Test.xlsx')

(train.shape, test.shape)

train.profile_report()

train.sample(5)

test.sample(5)

list(train.Fuel_Type[~train.Fuel_Type.isin(test.Fuel_Type)].unique())

train = train[train.Fuel_Type != 'Electric']

train['Full_name'] = train.Name.copy()
test['Full_name'] = test.Name.copy()
train.Name.sample(20)

temp1 = list(train.Name.str.split(' ').str[0].unique())
temp2 = list(test.Name.str.split(' ').str[0].unique())
temp3 = [item for item in temp1 if item not in temp2]
temp3