def q06_battles_on_each_region(battles):
'write your solution here'
battles1, character_predictions1 = q01_feature_engineering(
battles, character_predictions)
df = battles1.groupby('region').sum()[['major_death', 'major_capture']]
df1 = battles1.region.value_counts()
df1 = df1.to_frame()
df1 = df1.sort_values('region', ascending=False)
df1.columns = ['No.of battles']
df2 = pd.concat([df, df1], axis=1)
c = df2.plot.bar()
c.set(xlabel='region', ylabel='No.of events')
return df
# %load q08_preprocessing/build.py
import pandas as pd
import numpy as np
import sys, os
sys.path.append(os.path.join(os.path.dirname(os.curdir)))
from greyatomlib.game_of_thrones.q01_feature_engineering.build import q01_feature_engineering
from greyatomlib.game_of_thrones.q07_culture_survival.build import q07_culture_survival
battles = pd.read_csv('data/battles.csv')
character_predictions = pd.read_csv('data/character-predictions.csv')
battle, character_pred = q01_feature_engineering(battles,
character_predictions)
def q08_preprocessing(data):
#'write your solution here'
colu = ['title', 'culture', 'mother', 'father', 'house', 'heir', 'spouse']
for col in colu:
data[col] = pd.factorize(data[col])[0]
col_1 = ['name', 'alive', 'pred', 'plod', 'isAlive', 'dateOfBirth']
data = data.drop(col_1, 1)
col = data.columns
for c in col:
data[c] = data[c].replace(['.', '_'], ' ')
for c in col:
data[c] = data[c].replace(np.nan, -1)
return (data)
def q03_eda_major_houses_on_attacking_side(battle):
'write your solution here'
battles1,character_predictions1 = q01_feature_engineering(battles,character_predictions)
a = battles1.attacker_count.value_counts().sort_index().plot.bar()
a.set(xlabel = 'No. of Major Attacker Houses', ylabel = 'Count')
