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

titanic = pd.read_csv('../input/train.csv')
test = pd.read_csv('../input/test.csv')
full = pd.concat([titanic, test])

full.Embarked.value_counts()

titanic.Embarked.fillna(value='S', inplace=True)
full.Embarked.fillna(value='S', inplace=True)

test.loc[test['PassengerId'] == 1044, 'Fare'] = full[(full['Embarked'] == 'S') & (full['Pclass'] == 3)].Fare.median()
test.loc[test['PassengerId'] == 1044, :]

test.loc[test['Name'].str.contains('Bowen,'), 'Cabin'] = 'B68'

test.loc[test.Cabin.str.len() == 5, :]